eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_RULE_SETS_PKG dependencies on EGO_ONDEMAND_RULES_BATCHS_B

Line 907: l_selected_business_entity EGO_ONDEMAND_RULES_BATCHS_B.business_entity%type;

903: --UT bug 16611182: add default value for the user defined attribute group
904: PROCEDURE INSERT_UDA_DEFAULT_VALUES(p_batch_id IN NUMBER) IS
905: l_ext_id number;
906: l_top_ruleset_id NUMBER;
907: l_selected_business_entity EGO_ONDEMAND_RULES_BATCHS_B.business_entity%type;
908: l_datalevel_id NUMBER;
909: l_ag_id ego_attr_groups_v.attr_group_id%TYPE;
910: l_multi_row_code ego_attr_groups_v.multi_row_code%type;
911:

Line 928: SELECT top_ruleset_id INTO l_top_ruleset_id FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;

924: WHERE user_rules.severity IS NULL AND user_rules.attr_group_type = 'EGO_ITEMMGMT_GROUP' AND rule_set.composite = 'NO' AND EXISTS (SELECT '1' FROM ego_included_businessentities WHERE ruleset_id = user_rules.ruleset_id AND business_entity = p_data_level)
925: AND (rule_set.ruleset_id IN (SELECT included_ruleset FROM EGO_INCLUDED_RULESETS START WITH ruleset_id = p_top_ruleset_id CONNECT BY PRIOR included_ruleset = ruleset_id) OR rule_set.ruleset_id = p_top_ruleset_id)))
926: and not exists (select 'x' from ego_mtl_sy_items_ext_b where organization_id = p_org_id and inventory_item_id = p_inventory_item_id and item_catalog_group_id = p_icc_id and attr_group_id = assoc.attr_group_id and data_level_id = p_datalevel_id);
927: BEGIN
928: SELECT top_ruleset_id INTO l_top_ruleset_id FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;
929: SELECT business_entity INTO l_selected_business_entity FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;
930: SELECT decode(l_selected_business_entity, 'ITEM_LEVEL', 43101, 'ITEM_ORG', 43102, 'ITEM_SUP', 43103, 'ITEM_SUP_SITE', 43104, 'ITEM_SUP_SITE_ORG', 43105, 'ITEM_REVISION_LEVEL', 43106, -1) INTO l_datalevel_id FROM dual;
931: IF l_datalevel_id > 0 THEN
932: OPEN l_cursor_batch_items(p_batch_id);

Line 929: SELECT business_entity INTO l_selected_business_entity FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;

925: AND (rule_set.ruleset_id IN (SELECT included_ruleset FROM EGO_INCLUDED_RULESETS START WITH ruleset_id = p_top_ruleset_id CONNECT BY PRIOR included_ruleset = ruleset_id) OR rule_set.ruleset_id = p_top_ruleset_id)))
926: and not exists (select 'x' from ego_mtl_sy_items_ext_b where organization_id = p_org_id and inventory_item_id = p_inventory_item_id and item_catalog_group_id = p_icc_id and attr_group_id = assoc.attr_group_id and data_level_id = p_datalevel_id);
927: BEGIN
928: SELECT top_ruleset_id INTO l_top_ruleset_id FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;
929: SELECT business_entity INTO l_selected_business_entity FROM EGO_ONDEMAND_RULES_BATCHS_B WHERE batch_id = p_batch_id;
930: SELECT decode(l_selected_business_entity, 'ITEM_LEVEL', 43101, 'ITEM_ORG', 43102, 'ITEM_SUP', 43103, 'ITEM_SUP_SITE', 43104, 'ITEM_SUP_SITE_ORG', 43105, 'ITEM_REVISION_LEVEL', 43106, -1) INTO l_datalevel_id FROM dual;
931: IF l_datalevel_id > 0 THEN
932: OPEN l_cursor_batch_items(p_batch_id);
933: loop