Behind the Oracle WMS Rule
Whenever you create and save a rule in Oracle WMS; the
system creates a package in the background. The name will be WMS_RULE_ruleid.
To find the rule ID you can use below SQL:
Select RULE_ID, NAME From apps.WMS_RULES_TL Where NAME like
'%Seeded Default%' and LANGUAGE = 'US';
Select * From ALL_OBJECTS Where OBJECT_TYPE ='PACKAGE' and
OBJECT_NAME = 'WMS_RULE_10';
Select text From all_source Where name = 'WMS_RULE_10'
and type = 'PACKAGE BODY'
order by line;
PACKAGE WMS_RULE_XXX have considered 3 procedure:
- PROCEDURE open_curs : Open the record based on SQL inside it
- PROCEDURE fetch_one_row : It fetches records multiple time and performs the action
- PROCEDURE close_curs: For a normal rule, it used to close the cursor. But in case of customization, it holds and performs an action.
Once you run Generate All Rules concurrent program it will
compile the procedure and your changes are activated.
