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_INCLUDED_BUSINESSENTITIES

Line 51: from EGO_INCLUDED_BUSINESSENTITIES

47:
48: cursor c_business_entity(c_ruleset_id in number)
49: is
50: select business_entity
51: from EGO_INCLUDED_BUSINESSENTITIES
52: where ruleset_id = c_ruleset_id;
53:
54: l_business_entities varchar2(500);
55: l_business_entity_tbl DATA_LEVEL_TBL_TYPE;

Line 481: delete from EGO_INCLUDED_BUSINESSENTITIES where RULESET_ID = X_RULESET_ID;

477:
478: -- process business entities only when ruleset be inserted/updated
479: if (l_process = true) then
480:
481: delete from EGO_INCLUDED_BUSINESSENTITIES where RULESET_ID = X_RULESET_ID;
482:
483: l_business_entity_tbl := BUSINESS_ENTITIES_TO_ARRAY(X_BUSINESS_ENTITIES);
484:
485: FOR i in 1.. l_business_entity_tbl.COUNT LOOP

Line 486: INSERT INTO EGO_INCLUDED_BUSINESSENTITIES

482:
483: l_business_entity_tbl := BUSINESS_ENTITIES_TO_ARRAY(X_BUSINESS_ENTITIES);
484:
485: FOR i in 1.. l_business_entity_tbl.COUNT LOOP
486: INSERT INTO EGO_INCLUDED_BUSINESSENTITIES
487: (
488: BUSINESSENTITY_ROW_ID
489: ,RULESET_ID
490: ,BUSINESS_ENTITY

Line 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)

920: CURSOR c_default_ag(p_data_level VARCHAR2, p_datalevel_id NUMBER, p_top_ruleset_id NUMBER, p_org_id NUMBER, p_inventory_item_id NUMBER, p_icc_id NUMBER) IS
921: SELECT DISTINCT assoc.attr_group_id FROM EGO_OBJ_ATTR_GRP_ASSOCS_V assoc WHERE assoc.application_id = 431 AND assoc.classification_code = to_char(p_icc_id) AND assoc.data_level_int_name = p_data_level AND assoc.attr_group_id IN
922: (SELECT attr_group_id FROM ego_attr_groups_v WHERE attr_group_type = 'EGO_ITEMMGMT_GROUP' AND application_id = 431 AND attr_group_name IN (SELECT DISTINCT user_rules.attr_group_name FROM ego_user_rules_b user_rules
923: LEFT OUTER JOIN ego_rule_sets_b rule_set ON user_rules.ruleset_id = rule_set.ruleset_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;