APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_DATA_LEVEL_B

Line 585: FROM EGO_DATA_LEVEL_B

581: -- For validations related to pk1_value and pk2_value --
582: --------------------------------------------------------
583: CURSOR c_data_levels IS
584: SELECT DATA_LEVEL_ID, DATA_LEVEL_NAME
585: FROM EGO_DATA_LEVEL_B
586: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
587: AND APPLICATION_ID = 431
588: AND DATA_LEVEL_NAME IN ('ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG');
589:

Line 595: FROM EGO_DATA_LEVEL_B

591: -- For sending default privilege names for each data level --
592: -------------------------------------------------------------
593: CURSOR c_data_levels_for_sec IS
594: SELECT DATA_LEVEL_ID, DATA_LEVEL_NAME, ATTR_GROUP_TYPE
595: FROM EGO_DATA_LEVEL_B
596: WHERE APPLICATION_ID = 431
597: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
598:
599: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 1279: FROM EGO_DATA_LEVEL_B edlb

1275: -- where data_level_id is not populated --
1276: ----------------------------------------------------
1277: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1278: SET uai.DATA_LEVEL_ID = (SELECT edlb.DATA_LEVEL_ID
1279: FROM EGO_DATA_LEVEL_B edlb
1280: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
1281: AND edlb.APPLICATION_ID = 431
1282: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1283: )

Line 1343: FROM EGO_DATA_LEVEL_B edlb

1339: FROM EGO_ITM_USR_ATTR_INTRFC uai2
1340: WHERE uai2.DATA_SET_ID = p_data_set_id
1341: AND uai2.PROCESS_STATUS = G_PS_IN_PROCESS
1342: AND NOT EXISTS (SELECT NULL
1343: FROM EGO_DATA_LEVEL_B edlb
1344: WHERE edlb.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID
1345: )
1346: );
1347:

Line 1772: ' AND DATA_LEVEL_ID IN ( SELECT DATA_LEVEL_ID FROM EGO_DATA_LEVEL_B '||

1768: ' AND ECP.ATTRIBUTE_NUMBER_VALUE = UAI2.ATTR_GROUP_ID '||
1769: ' AND ECP.POLICY_OBJECT_PK1_VALUE = TO_CHAR(UAI2.PROG_INT_NUM1) '||
1770: ' AND ECP.POLICY_OBJECT_PK2_VALUE = TO_CHAR(UAI2.PROG_INT_NUM2) '||
1771: ' AND ECP.POLICY_OBJECT_PK3_VALUE = TO_CHAR(UAI2.PROG_INT_NUM3) '||
1772: ' AND DATA_LEVEL_ID IN ( SELECT DATA_LEVEL_ID FROM EGO_DATA_LEVEL_B '||
1773: ' WHERE APPLICATION_ID = ''431'' '||
1774: ' AND DATA_LEVEL_NAME IN ( ''ITEM_LEVEL'', ''ITEM_REVISION_LEVEL'', ''ITEM_ORG'')) '||
1775: ' )';
1776: