• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3880
  • Last Modified:

When-List-Changed Trigger on an Item -> Urgent

I wanted to know, if we can write a triiger on an item.
I have few Items and they are associated with Push button, which when clicked give me a List of Values. And they are in a hierarchical order. For Eg:
Product_legal_name is at the highest point. We can select a product_legal_name.
After that there is another list call GL class which depends on the product_legal name.
Even this has push button, which when selected gives a list.
After this we have product_type which depends upon both the above i.e., product_legal_name and GL_Class.

So, I need to write a code in such a fashion that when I select product_type the bottom
option should become ALL. When I select something in the bottom and move to top that it product_legal_name then all the bottom fields should become ALL.

So, some one has advised me to put a When List Changed trigger on each of the item.

Kindly could you suggest me, hoe to get it done.
I need urgent help on this.
form2.JPG
0
vishal_singh
Asked:
vishal_singh
1 Solution
 
jwahlCommented:
if i understand your problem correctly, you only have to create a WHEN-VALIDATE-ITEM trigger on those fields, e.g.

-- Item Legal Name:
BEGIN
    IF :PRODUCT_LEGAL_NAME NOT LIKE 'All Product Brands%' THEN
       :PRODUCT_TYPE := 'Selected Product Types = 0';
       :GL_CLASS := 'All GL Classes';
       ...
   END IF;

 
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now