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:
110: --------------------------------------

Line 131: l_null_data_level_batch EGO_DATA_LEVEL_BATCH_REC;

127: IS
128:
129: l_null_ag_metadata_batch EGO_ATTR_GROUP_BATCH_REC;
130: l_null_ext_table_batch EGO_EXT_TABLE_BATCH_REC;
131: l_null_data_level_batch EGO_DATA_LEVEL_BATCH_REC;
132:
133: BEGIN
134:
135: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;

Line 213: p_data_level_batch_rec IN EGO_DATA_LEVEL_BATCH_REC

209:
210: ----------------------------------------------------------------------
211:
212: FUNCTION Is_Room_In_DL_Batch (
213: p_data_level_batch_rec IN EGO_DATA_LEVEL_BATCH_REC
214: )
215: RETURN BOOLEAN
216: IS
217:

Line 2168: FROM EGO_DATA_LEVEL_B

2164:
2165: CURSOR associated_dl_cursor(p_app_id IN NUMBER, p_ag_type IN VARCHAR2)
2166: IS
2167: SELECT DATA_LEVEL_ID
2168: FROM EGO_DATA_LEVEL_B
2169: WHERE APPLICATION_ID = p_app_id
2170: AND ATTR_GROUP_TYPE = p_ag_type;
2171:
2172: l_data_level_id NUMBER;

Line 2281: FROM ego_data_level_b

2277: CURSOR get_all_pk_names (cp_application_id IN NUMBER
2278: ,cp_attr_group_type IN VARCHAR2)
2279: IS
2280: SELECT DISTINCT pk1_column_name column_name
2281: FROM ego_data_level_b
2282: WHERE application_id=cp_application_id
2283: AND attr_group_type = cp_attr_group_type
2284: AND pk1_column_name IS NOT NULL
2285: UNION

Line 2287: FROM ego_data_level_b

2283: AND attr_group_type = cp_attr_group_type
2284: AND pk1_column_name IS NOT NULL
2285: UNION
2286: SELECT DISTINCT pk2_column_name column_name
2287: FROM ego_data_level_b
2288: WHERE application_id=cp_application_id
2289: AND attr_group_type = cp_attr_group_type
2290: AND pk2_column_name IS NOT NULL
2291: UNION

Line 2293: FROM ego_data_level_b

2289: AND attr_group_type = cp_attr_group_type
2290: AND pk2_column_name IS NOT NULL
2291: UNION
2292: SELECT DISTINCT pk3_column_name column_name
2293: FROM ego_data_level_b
2294: WHERE application_id=cp_application_id
2295: AND attr_group_type = cp_attr_group_type
2296: AND pk3_column_name IS NOT NULL
2297: UNION

Line 2299: FROM ego_data_level_b

2295: AND attr_group_type = cp_attr_group_type
2296: AND pk3_column_name IS NOT NULL
2297: UNION
2298: SELECT DISTINCT pk4_column_name column_name
2299: FROM ego_data_level_b
2300: WHERE application_id=cp_application_id
2301: AND attr_group_type = cp_attr_group_type
2302: AND pk4_column_name IS NOT NULL
2303: UNION

Line 2305: FROM ego_data_level_b

2301: AND attr_group_type = cp_attr_group_type
2302: AND pk4_column_name IS NOT NULL
2303: UNION
2304: SELECT DISTINCT pk5_column_name column_name
2305: FROM ego_data_level_b
2306: WHERE application_id=cp_application_id
2307: AND attr_group_type = cp_attr_group_type
2308: AND pk5_column_name IS NOT NULL;
2309: