APPS.EGO_USER_ATTRS_BULK_PVT dependencies on EGO_ATTR_GROUP_DL

Line 1721: FROM EGO_ATTR_GROUP_DL

1717: ,PK4_COLUMN_TYPE
1718: ,PK5_COLUMN_TYPE
1719: FROM EGO_DATA_LEVEL_VL
1720: WHERE DATA_LEVEL_ID IN ( SELECT DATA_LEVEL_ID
1721: FROM EGO_ATTR_GROUP_DL
1722: WHERE ATTR_GROUP_ID = p_attr_group_id);
1723:
1724: l_data_level_cols_rec enabled_data_level_cols%ROWTYPE;
1725: --bug 12397223 end

Line 1904: ' FROM EGO_ATTR_GROUP_DL '||

1900: -------------------------------------------------------
1901: EXECUTE IMMEDIATE
1902: 'UPDATE '||p_interface_table_name||' UAI1 '||
1903: ' SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID '||
1904: ' FROM EGO_ATTR_GROUP_DL '||
1905: ' WHERE ATTR_GROUP_ID = UAI1.ATTR_GROUP_ID '||
1906: ' ) '||
1907: ' WHERE UAI1.DATA_SET_ID = :data_set_id '||
1908: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||' '||

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

1906: ' ) '||
1907: ' WHERE UAI1.DATA_SET_ID = :data_set_id '||
1908: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||' '||
1909: ' AND UAI1.ATTR_GROUP_TYPE = :attr_group_type '||
1910: ' AND (SELECT COUNT(*) FROM EGO_ATTR_GROUP_DL '||
1911: ' WHERE ATTR_GROUP_ID = UAI1.ATTR_GROUP_ID) < 2 '||
1912: ' AND DATA_LEVEL_ID IS NULL '||
1913: ' AND DATA_LEVEL_NAME IS NULL '||
1914: ' AND USER_DATA_LEVEL_NAME IS NULL '

Line 1946: ' FROM EGO_ATTR_GROUP_DL '||

1942: ' AND UAI1.PROCESS_STATUS = '||G_PS_IN_PROCESS||' '||
1943: ' AND UAI1.ATTR_GROUP_TYPE = :attr_group_type '||
1944: ' AND ( DATA_LEVEL_ID IS NULL '||
1945: ' OR NOT EXISTS(SELECT NULL '||
1946: ' FROM EGO_ATTR_GROUP_DL '||
1947: ' WHERE ATTR_GROUP_ID = UAI1.ATTR_GROUP_ID '||
1948: ' AND DATA_LEVEL_ID = UAI1.DATA_LEVEL_ID) )'
1949: USING p_data_set_id, p_attr_group_type;
1950: END IF;

Line 3084: EGO_ATTR_GROUP_DL AG_DL,

3080: WHERE ''Y'' = enabled_flag
3081: AND application_id IN (SELECT DISTINCT application_id
3082: FROM ego_fnd_dsc_flx_ctx_ext)) a,
3083: EGO_FND_DF_COL_USGS_EXT EXT,
3084: EGO_ATTR_GROUP_DL AG_DL,
3085: FND_FLEX_VALUE_SETS VS,
3086: MTL_UNITS_OF_MEASURE UOM,
3087: FND_FORM_FUNCTIONS FNV,
3088: FND_FORM_FUNCTIONS FNE

Line 6007: FROM EGO_ATTR_GROUP_DL

6003: END;
6004:
6005: SELECT COUNT(*)
6006: INTO l_dummy
6007: FROM EGO_ATTR_GROUP_DL
6008: WHERE ATTR_GROUP_ID = l_attr_group_metadata_obj.ATTR_GROUP_ID
6009: AND RAISE_PRE_EVENT = 'Y';
6010:
6011: IF (l_dummy > 0) THEN

Line 6042: FROM EGO_ATTR_GROUP_DL

6038: */
6039:
6040: SELECT COUNT(*)
6041: INTO l_dummy
6042: FROM EGO_ATTR_GROUP_DL
6043: WHERE ATTR_GROUP_ID = l_attr_group_metadata_obj.ATTR_GROUP_ID
6044: AND RAISE_POST_EVENT = 'Y';
6045:
6046: IF (l_dummy > 0) THEN

Line 8379: FROM EGO_ATTR_GROUP_DL

8375: l_dummy := 0;
8376:
8377: SELECT COUNT(*)
8378: INTO l_dummy
8379: FROM EGO_ATTR_GROUP_DL
8380: WHERE ATTR_GROUP_ID = l_attr_group_metadata_obj.ATTR_GROUP_ID
8381: AND RAISE_POST_EVENT = 'Y';
8382:
8383: IF(l_dummy > 0)THEN

Line 8448: FROM EGO_ATTR_GROUP_DL

8444: */
8445:
8446: SELECT COUNT(*)
8447: INTO l_dummy
8448: FROM EGO_ATTR_GROUP_DL
8449: WHERE ATTR_GROUP_ID = l_attr_group_metadata_obj.ATTR_GROUP_ID
8450: AND RAISE_POST_EVENT = 'Y';
8451:
8452: IF (l_dummy > 0) THEN

Line 9658: 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) ';

9654: ' AND '||l_uk_tmpl_intf_rtcq_where||' '||--for unique key joi in intf and templ
9655: ' AND ATTRSV.ATTR_ID = TEMPL.ATTRIBUTE_ID '||
9656: l_attr_null_chk_decode||' ';
9657: IF l_has_data_level_id THEN
9658: 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) ';
9659: END IF;
9660: l_rows_to_insert_sql := l_rows_to_insert_sql || ')';
9661:
9662: IF l_has_data_level_id THEN