APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_DATA_LEVEL_B

Line 657: FROM EGO_DATA_LEVEL_B

653: -- For validations related to pk1_value and pk2_value --
654: --------------------------------------------------------
655: CURSOR c_data_levels IS
656: SELECT DATA_LEVEL_ID, DATA_LEVEL_NAME
657: FROM EGO_DATA_LEVEL_B
658: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
659: AND APPLICATION_ID = 431
660: AND DATA_LEVEL_NAME IN ('ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG');
661:

Line 667: FROM EGO_DATA_LEVEL_B

663: -- For sending default privilege names for each data level --
664: -------------------------------------------------------------
665: CURSOR c_data_levels_for_sec IS
666: SELECT DATA_LEVEL_ID, DATA_LEVEL_NAME, ATTR_GROUP_TYPE
667: FROM EGO_DATA_LEVEL_B
668: WHERE APPLICATION_ID = 431
669: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP';
670:
671: l_default_dl_view_priv_list EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 1504: FROM EGO_DATA_LEVEL_B

1500: */
1501: --Bug 9325678 begin
1502: l_item_data_level_id_str := '';
1503: for x in (SELECT DATA_LEVEL_ID
1504: FROM EGO_DATA_LEVEL_B
1505: WHERE DATA_LEVEL_NAME = 'ITEM_LEVEL')
1506: loop
1507: if length(l_item_data_level_id_str) > 0 then
1508: l_item_data_level_id_str := l_item_data_level_id_str || ',';

Line 1574: FROM EGO_DATA_LEVEL_B edlb

1570: -- Bug 13434831 : Start (Performance Change)
1571: /*
1572: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1573: SET uai.DATA_LEVEL_ID = (SELECT edlb.DATA_LEVEL_ID
1574: FROM EGO_DATA_LEVEL_B edlb
1575: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
1576: AND edlb.APPLICATION_ID = 431
1577: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1578: )

Line 1608: FROM EGO_DATA_LEVEL_B edlb

1604:
1605: -- Consolidating above two queries into single query as below.
1606: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1607: SET uai.DATA_LEVEL_ID = Nvl ((SELECT edlb.DATA_LEVEL_ID
1608: FROM EGO_DATA_LEVEL_B edlb
1609: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
1610: AND edlb.APPLICATION_ID = 431
1611: AND edlb.ATTR_GROUP_TYPE = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
1612: ),

Line 1660: FROM EGO_DATA_LEVEL_B edlb

1656: FROM EGO_ITM_USR_ATTR_INTRFC uai2
1657: WHERE uai2.DATA_SET_ID = p_data_set_id
1658: AND uai2.PROCESS_STATUS = G_PS_IN_PROCESS
1659: AND NOT EXISTS (SELECT NULL
1660: FROM EGO_DATA_LEVEL_B edlb
1661: WHERE edlb.DATA_LEVEL_ID = uai2.DATA_LEVEL_ID
1662: )
1663: );
1664:

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

2198: ' AND ECP.ATTRIBUTE_NUMBER_VALUE = UAI2.ATTR_GROUP_ID '||
2199: ' AND ECP.POLICY_OBJECT_PK1_VALUE = TO_CHAR(UAI2.PROG_INT_NUM1) '||
2200: ' AND ECP.POLICY_OBJECT_PK2_VALUE = TO_CHAR(UAI2.PROG_INT_NUM2) '||
2201: ' AND ECP.POLICY_OBJECT_PK3_VALUE = TO_CHAR(UAI2.PROG_INT_NUM3) '||
2202: ' AND DATA_LEVEL_ID IN ( SELECT DATA_LEVEL_ID FROM EGO_DATA_LEVEL_B '||
2203: ' WHERE APPLICATION_ID = ''431'' '||
2204: ' AND DATA_LEVEL_NAME IN ( ''ITEM_LEVEL'', ''ITEM_REVISION_LEVEL'', ''ITEM_ORG'')) '||
2205: ' )';
2206: