APPS.EGO_USER_ATTRS_BULK_PVT dependencies on EGO_ATTR_GROUP_DL

Line 1589: ' FROM EGO_ATTR_GROUP_DL '||

1585: -------------------------------------------------------
1586: EXECUTE IMMEDIATE
1587: 'UPDATE '||p_interface_table_name||' UAI1 '||
1588: ' SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID '||
1589: ' FROM EGO_ATTR_GROUP_DL '||
1590: ' WHERE ATTR_GROUP_ID = UAI1.ATTR_GROUP_ID '||
1591: ' ) '||
1592: ' WHERE UAI1.DATA_SET_ID = :data_set_id '||
1593: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||' '||

Line 1595: ' AND (SELECT COUNT(*) FROM EGO_ATTR_GROUP_DL '||

1591: ' ) '||
1592: ' WHERE UAI1.DATA_SET_ID = :data_set_id '||
1593: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||' '||
1594: ' AND UAI1.ATTR_GROUP_TYPE = :attr_group_type '||
1595: ' AND (SELECT COUNT(*) FROM EGO_ATTR_GROUP_DL '||
1596: ' WHERE ATTR_GROUP_ID = UAI1.ATTR_GROUP_ID) < 2 '||
1597: ' AND DATA_LEVEL_ID IS NULL '||
1598: ' AND DATA_LEVEL_NAME IS NULL '||
1599: ' AND USER_DATA_LEVEL_NAME IS NULL '

Line 1631: ' FROM EGO_ATTR_GROUP_DL '||

1627: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||' '||
1628: ' AND UAI1.ATTR_GROUP_TYPE = :attr_group_type '||
1629: ' AND ( DATA_LEVEL_ID IS NULL '||
1630: ' OR NOT EXISTS(SELECT NULL '||
1631: ' FROM EGO_ATTR_GROUP_DL '||
1632: ' WHERE ATTR_GROUP_ID = UAI1.ATTR_GROUP_ID '||
1633: ' AND DATA_LEVEL_ID = UAI1.DATA_LEVEL_ID) )'
1634: USING p_data_set_id, p_attr_group_type;
1635: END IF;

Line 2634: EGO_ATTR_GROUP_DL AG_DL,

2630: AND PROCESS_STATUS = '||G_PS_IN_PROCESS||') DISTINCT_ATTRS,
2631: EGO_FND_DSC_FLX_CTX_EXT FLX_EXT,
2632: FND_DESCR_FLEX_COLUMN_USAGES A,
2633: EGO_FND_DF_COL_USGS_EXT EXT,
2634: EGO_ATTR_GROUP_DL AG_DL,
2635: FND_FLEX_VALUE_SETS VS,
2636: MTL_UNITS_OF_MEASURE UOM,
2637: FND_FORM_FUNCTIONS FNV,
2638: FND_FORM_FUNCTIONS FNE

Line 4964: FROM EGO_ATTR_GROUP_DL

4960: END;
4961:
4962: SELECT COUNT(*)
4963: INTO l_dummy
4964: FROM EGO_ATTR_GROUP_DL
4965: WHERE ATTR_GROUP_ID = l_attr_group_metadata_obj.ATTR_GROUP_ID
4966: AND RAISE_PRE_EVENT = 'Y';
4967:
4968: IF (l_dummy > 0) THEN

Line 6773: FROM EGO_ATTR_GROUP_DL

6769: l_dummy := 0;
6770:
6771: SELECT COUNT(*)
6772: INTO l_dummy
6773: FROM EGO_ATTR_GROUP_DL
6774: WHERE ATTR_GROUP_ID = l_attr_group_metadata_obj.ATTR_GROUP_ID
6775: AND RAISE_POST_EVENT = 'Y';
6776:
6777: IF(l_dummy > 0)THEN

Line 7948: l_rows_to_insert_sql := l_rows_to_insert_sql ||' AND EXISTS (SELECT 1 FROM ego_attr_group_dl WHERE attr_group_id = :ag_id2 AND data_level_id = TEMPLRTCQ.data_level_id) ';

7944: ' AND '||l_uk_tmpl_intf_rtcq_where||' '||--for unique key joi in intf and templ
7945: ' AND ATTRSV.ATTR_ID = TEMPL.ATTRIBUTE_ID '||
7946: l_attr_null_chk_decode||' ';
7947: IF l_has_data_level_id THEN
7948: l_rows_to_insert_sql := l_rows_to_insert_sql ||' AND EXISTS (SELECT 1 FROM ego_attr_group_dl WHERE attr_group_id = :ag_id2 AND data_level_id = TEMPLRTCQ.data_level_id) ';
7949: END IF;
7950: l_rows_to_insert_sql := l_rows_to_insert_sql || ')';
7951:
7952: IF l_has_data_level_id THEN