APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on EGO_DATA_LEVEL_B

Line 75: TYPE EGO_DATA_LEVEL_BATCH_REC IS RECORD

71: -- metadata record has gone unused for the longest amount of time, --
72: -- which is how we decide which Extension Table to replace when --
73: -- adding a new record to a full cache --
74: ---------------------------------------------------------------------
75: TYPE EGO_DATA_LEVEL_BATCH_REC IS RECORD
76: (
77: CACHED_DATA_LEVEL_METADATA_1 EGO_DATA_LEVEL_METADATA_OBJ
78: ,CACHED_DATA_LEVEL_METADATA_2 EGO_DATA_LEVEL_METADATA_OBJ
79: ,CACHED_DATA_LEVEL_METADATA_3 EGO_DATA_LEVEL_METADATA_OBJ

Line 106: G_DATA_LEVEL_METADATA_BATCH_1 EGO_DATA_LEVEL_BATCH_REC;

102: G_AG_METADATA_BATCH_5 EGO_ATTR_GROUP_BATCH_REC;
103:
104: G_EXT_TABLE_METADATA_BATCH_1 EGO_EXT_TABLE_BATCH_REC;
105:
106: G_DATA_LEVEL_METADATA_BATCH_1 EGO_DATA_LEVEL_BATCH_REC;
107:
108: --
109: -- Bug 12998006. Added caching logic for has_column_in_table()
110: -- function. Global PLSQL collection for the cache.

Line 239: l_null_data_level_batch EGO_DATA_LEVEL_BATCH_REC;

235: IS
236:
237: l_null_ag_metadata_batch EGO_ATTR_GROUP_BATCH_REC;
238: l_null_ext_table_batch EGO_EXT_TABLE_BATCH_REC;
239: l_null_data_level_batch EGO_DATA_LEVEL_BATCH_REC;
240:
241: BEGIN
242:
243: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;

Line 321: p_data_level_batch_rec IN EGO_DATA_LEVEL_BATCH_REC

317:
318: ----------------------------------------------------------------------
319:
320: FUNCTION Is_Room_In_DL_Batch (
321: p_data_level_batch_rec IN EGO_DATA_LEVEL_BATCH_REC
322: )
323: RETURN BOOLEAN
324: IS
325:

Line 2324: FROM EGO_DATA_LEVEL_B

2320:
2321: CURSOR associated_dl_cursor(p_app_id IN NUMBER, p_ag_type IN VARCHAR2)
2322: IS
2323: SELECT DATA_LEVEL_ID
2324: FROM EGO_DATA_LEVEL_B
2325: WHERE APPLICATION_ID = p_app_id
2326: AND ATTR_GROUP_TYPE = p_ag_type;
2327:
2328: l_data_level_id NUMBER;

Line 2437: FROM ego_data_level_b

2433: CURSOR get_all_pk_names (cp_application_id IN NUMBER
2434: ,cp_attr_group_type IN VARCHAR2)
2435: IS
2436: SELECT DISTINCT pk1_column_name column_name
2437: FROM ego_data_level_b
2438: WHERE application_id=cp_application_id
2439: AND attr_group_type = cp_attr_group_type
2440: AND pk1_column_name IS NOT NULL
2441: UNION

Line 2443: FROM ego_data_level_b

2439: AND attr_group_type = cp_attr_group_type
2440: AND pk1_column_name IS NOT NULL
2441: UNION
2442: SELECT DISTINCT pk2_column_name column_name
2443: FROM ego_data_level_b
2444: WHERE application_id=cp_application_id
2445: AND attr_group_type = cp_attr_group_type
2446: AND pk2_column_name IS NOT NULL
2447: UNION

Line 2449: FROM ego_data_level_b

2445: AND attr_group_type = cp_attr_group_type
2446: AND pk2_column_name IS NOT NULL
2447: UNION
2448: SELECT DISTINCT pk3_column_name column_name
2449: FROM ego_data_level_b
2450: WHERE application_id=cp_application_id
2451: AND attr_group_type = cp_attr_group_type
2452: AND pk3_column_name IS NOT NULL
2453: UNION

Line 2455: FROM ego_data_level_b

2451: AND attr_group_type = cp_attr_group_type
2452: AND pk3_column_name IS NOT NULL
2453: UNION
2454: SELECT DISTINCT pk4_column_name column_name
2455: FROM ego_data_level_b
2456: WHERE application_id=cp_application_id
2457: AND attr_group_type = cp_attr_group_type
2458: AND pk4_column_name IS NOT NULL
2459: UNION

Line 2461: FROM ego_data_level_b

2457: AND attr_group_type = cp_attr_group_type
2458: AND pk4_column_name IS NOT NULL
2459: UNION
2460: SELECT DISTINCT pk5_column_name column_name
2461: FROM ego_data_level_b
2462: WHERE application_id=cp_application_id
2463: AND attr_group_type = cp_attr_group_type
2464: AND pk5_column_name IS NOT NULL;
2465: