APPS.EGO_RULE_SETS_PKG dependencies on EGO_RULE_SETS_B

Line 387: update EGO_RULE_SETS_B set

383: CLOSE C_RULESET_EXISTS;
384:
385: if (X_RULESET_ID is not null and (NVL(X_CUSTOM_MODE, '*NULL*') = 'FORCE' or l_last_update_date < X_LAST_UPDATE_DATE)) then
386:
387: update EGO_RULE_SETS_B set
388: RULESET_NAME = X_RULESET_NAME,
389: RULESET_TYPE = X_RULESET_TYPE,
390: COMPOSITE = X_COMPOSITE,
391: ITEM_CATALOG_CATEGORY = X_ITEM_CATALOG_CATEGORY,

Line 414: insert into EGO_RULE_SETS_B (

410: elsif (X_RULESET_ID is null) then
411:
412: select EGO_RULE_SETS_S.nextval into X_RULESET_ID from dual;
413:
414: insert into EGO_RULE_SETS_B (
415: RULESET_ID,
416: RULESET_NAME,
417: RULESET_TYPE,
418: COMPOSITE,

Line 543: cursor C is select ROWID from EGO_RULE_SETS_B

539: X_LAST_UPDATE_DATE in DATE,
540: X_LAST_UPDATED_BY in NUMBER,
541: X_LAST_UPDATE_LOGIN in NUMBER
542: ) is
543: cursor C is select ROWID from EGO_RULE_SETS_B
544: where RULESET_ID = X_RULESET_ID
545: ;
546: begin
547: insert into EGO_RULE_SETS_B (

Line 547: insert into EGO_RULE_SETS_B (

543: cursor C is select ROWID from EGO_RULE_SETS_B
544: where RULESET_ID = X_RULESET_ID
545: ;
546: begin
547: insert into EGO_RULE_SETS_B (
548: ATTR_GROUP_TYPE,
549: RULESET_ID,
550: RULESET_NAME,
551: RULESET_TYPE,

Line 633: from EGO_RULE_SETS_B

629: RULESET_TYPE,
630: COMPOSITE,
631: ITEM_CATALOG_CATEGORY,
632: ATTR_GROUP_NAME
633: from EGO_RULE_SETS_B
634: where RULESET_ID = X_RULESET_ID
635: for update of RULESET_ID nowait;
636: recinfo c%rowtype;
637:

Line 703: update EGO_RULE_SETS_B set

699: X_LAST_UPDATED_BY in NUMBER,
700: X_LAST_UPDATE_LOGIN in NUMBER
701: ) is
702: begin
703: update EGO_RULE_SETS_B set
704: ATTR_GROUP_TYPE = X_ATTR_GROUP_TYPE,
705: RULESET_NAME = X_RULESET_NAME,
706: RULESET_TYPE = X_RULESET_TYPE,
707: COMPOSITE = X_COMPOSITE,

Line 745: delete from EGO_RULE_SETS_B

741: if (sql%notfound) then
742: raise no_data_found;
743: end if;
744:
745: delete from EGO_RULE_SETS_B
746: where RULESET_ID = X_RULESET_ID;
747:
748: if (sql%notfound) then
749: raise no_data_found;

Line 759: from EGO_RULE_SETS_B B

755: begin
756: delete from EGO_RULE_SETS_TL T
757: where not exists
758: (select NULL
759: from EGO_RULE_SETS_B B
760: where B.RULESET_ID = T.RULESET_ID
761: );
762:
763: update EGO_RULE_SETS_TL T set (

Line 861: from EGO_RULE_SETS_B

857: l_ruleset_id number := 0;
858:
859: begin
860: select RULESET_ID into l_ruleset_id
861: from EGO_RULE_SETS_B
862: where RULESET_NAME = X_RULESET_NAME;
863:
864: EGO_RULE_SETS_PKG.UPDATE_ROW(
865: X_RULESET_ID => l_ruleset_id,

Line 923: LEFT OUTER JOIN ego_rule_sets_b rule_set ON user_rules.ruleset_id = rule_set.ruleset_id

919:
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