DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_COMMON_PVT dependencies on EGO_COL_METADATA_OBJ

Line 1385: l_pk1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

1381: IS
1382:
1383: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1384: l_obj_name FND_OBJECTS.OBJ_NAME%TYPE;-- 4105308 OBJ_NAME IN FND_OBJECTS LENGTH HAS BEEN INCREASED
1385: l_pk1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1386: l_pk2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1387: l_pk3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1388: l_pk4_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1389: l_pk5_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

Line 1386: l_pk2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

1382:
1383: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1384: l_obj_name FND_OBJECTS.OBJ_NAME%TYPE;-- 4105308 OBJ_NAME IN FND_OBJECTS LENGTH HAS BEEN INCREASED
1385: l_pk1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1386: l_pk2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1387: l_pk3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1388: l_pk4_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1389: l_pk5_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1390: l_class_code_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

Line 1387: l_pk3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

1383: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1384: l_obj_name FND_OBJECTS.OBJ_NAME%TYPE;-- 4105308 OBJ_NAME IN FND_OBJECTS LENGTH HAS BEEN INCREASED
1385: l_pk1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1386: l_pk2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1387: l_pk3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1388: l_pk4_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1389: l_pk5_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1390: l_class_code_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1391: l_num_data_level_cols NUMBER;

Line 1388: l_pk4_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

1384: l_obj_name FND_OBJECTS.OBJ_NAME%TYPE;-- 4105308 OBJ_NAME IN FND_OBJECTS LENGTH HAS BEEN INCREASED
1385: l_pk1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1386: l_pk2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1387: l_pk3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1388: l_pk4_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1389: l_pk5_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1390: l_class_code_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1391: l_num_data_level_cols NUMBER;
1392: l_data_level1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

Line 1389: l_pk5_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

1385: l_pk1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1386: l_pk2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1387: l_pk3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1388: l_pk4_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1389: l_pk5_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1390: l_class_code_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1391: l_num_data_level_cols NUMBER;
1392: l_data_level1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1393: l_data_level2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

Line 1390: l_class_code_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

1386: l_pk2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1387: l_pk3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1388: l_pk4_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1389: l_pk5_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1390: l_class_code_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1391: l_num_data_level_cols NUMBER;
1392: l_data_level1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1393: l_data_level2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1394: l_data_level3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

Line 1392: l_data_level1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

1388: l_pk4_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1389: l_pk5_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1390: l_class_code_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1391: l_num_data_level_cols NUMBER;
1392: l_data_level1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1393: l_data_level2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1394: l_data_level3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1395:
1396: CURSOR data_level_meanings_cursor (cp_obj_name VARCHAR2)

Line 1393: l_data_level2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

1389: l_pk5_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1390: l_class_code_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1391: l_num_data_level_cols NUMBER;
1392: l_data_level1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1393: l_data_level2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1394: l_data_level3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1395:
1396: CURSOR data_level_meanings_cursor (cp_obj_name VARCHAR2)
1397: IS

Line 1394: l_data_level3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

1390: l_class_code_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1391: l_num_data_level_cols NUMBER;
1392: l_data_level1_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1393: l_data_level2_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1394: l_data_level3_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
1395:
1396: CURSOR data_level_meanings_cursor (cp_obj_name VARCHAR2)
1397: IS
1398: SELECT MEANING

Line 2174: l_data_level_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);

2170: AND ATTR_GROUP_TYPE = p_ag_type;
2171:
2172: l_data_level_id NUMBER;
2173: l_dl_mdata_obj EGO_DATA_LEVEL_METADATA_OBJ;
2174: l_data_level_obj EGO_COL_METADATA_OBJ := EGO_COL_METADATA_OBJ(null, null);
2175: l_dl_col_list VARCHAR2(2000);
2176: l_dl_col_array EGO_COL_METADATA_ARRAY;
2177:
2178: BEGIN

Line 2195: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME5, l_dl_mdata_obj.PK_COLUMN_TYPE5);

2191: l_data_level_obj.COL_NAME := l_dl_mdata_obj.PK_COLUMN_NAME5;
2192: l_data_level_obj.DATA_TYPE := l_dl_mdata_obj.PK_COLUMN_TYPE5;
2193: l_dl_col_list := l_dl_col_list||' '||l_dl_mdata_obj.PK_COLUMN_NAME5||' ';
2194: l_dl_col_array.EXTEND();
2195: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME5, l_dl_mdata_obj.PK_COLUMN_TYPE5);
2196: END IF;
2197: IF(l_dl_mdata_obj.PK_COLUMN_NAME4 IS NOT NULL AND INSTR(l_dl_col_list,l_dl_mdata_obj.PK_COLUMN_NAME4) = 0) THEN
2198: l_data_level_obj.COL_NAME := l_dl_mdata_obj.PK_COLUMN_NAME4;
2199: l_data_level_obj.DATA_TYPE := l_dl_mdata_obj.PK_COLUMN_TYPE4;

Line 2202: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME4, l_dl_mdata_obj.PK_COLUMN_TYPE4);

2198: l_data_level_obj.COL_NAME := l_dl_mdata_obj.PK_COLUMN_NAME4;
2199: l_data_level_obj.DATA_TYPE := l_dl_mdata_obj.PK_COLUMN_TYPE4;
2200: l_dl_col_list := l_dl_col_list||' '||l_dl_mdata_obj.PK_COLUMN_NAME4||' ';
2201: l_dl_col_array.EXTEND();
2202: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME4, l_dl_mdata_obj.PK_COLUMN_TYPE4);
2203: END IF;
2204: IF(l_dl_mdata_obj.PK_COLUMN_NAME3 IS NOT NULL AND INSTR(l_dl_col_list,l_dl_mdata_obj.PK_COLUMN_NAME3) = 0) THEN
2205: l_data_level_obj.COL_NAME := l_dl_mdata_obj.PK_COLUMN_NAME3;
2206: l_data_level_obj.DATA_TYPE := l_dl_mdata_obj.PK_COLUMN_TYPE3;

Line 2209: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME3, l_dl_mdata_obj.PK_COLUMN_TYPE3);

2205: l_data_level_obj.COL_NAME := l_dl_mdata_obj.PK_COLUMN_NAME3;
2206: l_data_level_obj.DATA_TYPE := l_dl_mdata_obj.PK_COLUMN_TYPE3;
2207: l_dl_col_list := l_dl_col_list||' '||l_dl_mdata_obj.PK_COLUMN_NAME3||' ';
2208: l_dl_col_array.EXTEND();
2209: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME3, l_dl_mdata_obj.PK_COLUMN_TYPE3);
2210: END IF;
2211: IF(l_dl_mdata_obj.PK_COLUMN_NAME2 IS NOT NULL AND INSTR(l_dl_col_list,l_dl_mdata_obj.PK_COLUMN_NAME2) = 0) THEN
2212: l_data_level_obj.COL_NAME := l_dl_mdata_obj.PK_COLUMN_NAME2;
2213: l_data_level_obj.DATA_TYPE := l_dl_mdata_obj.PK_COLUMN_TYPE2;

Line 2216: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME2, l_dl_mdata_obj.PK_COLUMN_TYPE2);

2212: l_data_level_obj.COL_NAME := l_dl_mdata_obj.PK_COLUMN_NAME2;
2213: l_data_level_obj.DATA_TYPE := l_dl_mdata_obj.PK_COLUMN_TYPE2;
2214: l_dl_col_list := l_dl_col_list||' '||l_dl_mdata_obj.PK_COLUMN_NAME2||' ';
2215: l_dl_col_array.EXTEND();
2216: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME2, l_dl_mdata_obj.PK_COLUMN_TYPE2);
2217: END IF;
2218: IF(l_dl_mdata_obj.PK_COLUMN_NAME1 IS NOT NULL AND INSTR(l_dl_col_list,l_dl_mdata_obj.PK_COLUMN_NAME1) = 0) THEN
2219: l_data_level_obj.COL_NAME := l_dl_mdata_obj.PK_COLUMN_NAME1;
2220: l_data_level_obj.DATA_TYPE := l_dl_mdata_obj.PK_COLUMN_TYPE1;

Line 2223: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME1, l_dl_mdata_obj.PK_COLUMN_TYPE1);

2219: l_data_level_obj.COL_NAME := l_dl_mdata_obj.PK_COLUMN_NAME1;
2220: l_data_level_obj.DATA_TYPE := l_dl_mdata_obj.PK_COLUMN_TYPE1;
2221: l_dl_col_list := l_dl_col_list||' '||l_dl_mdata_obj.PK_COLUMN_NAME1||' ';
2222: l_dl_col_array.EXTEND();
2223: l_dl_col_array(l_dl_col_array.LAST) := EGO_COL_METADATA_OBJ(l_dl_mdata_obj.PK_COLUMN_NAME1, l_dl_mdata_obj.PK_COLUMN_TYPE1);
2224: END IF;
2225: code_debug('In Get_Data_Level_Col_Array ... for '||l_data_level_obj.COL_NAME||' l_dl_col_list-'||l_dl_col_list);
2226: END LOOP;
2227: code_debug('In Get_Data_Level_Col_Array l_dl_col_array.COUNT:'||l_dl_col_array.COUNT);