APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_DATA_LEVEL_B

Line 257: FROM EGO_DATA_LEVEL_B

253: END IF;
254:
255: SELECT DATA_LEVEL_ID
256: INTO l_data_level_id
257: FROM EGO_DATA_LEVEL_B
258: WHERE APPLICATION_ID = p_application_id
259: AND ATTR_GROUP_TYPE = p_attr_group_type
260: AND DATA_LEVEL_NAME = p_data_level_name;
261:

Line 305: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||

301: -- new code will have p_data_level and must return only one record
302: --
303: BEGIN
304: l_dynamic_sql := 'SELECT DISTINCT(assoc.data_level_id) ' ||
305: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||
306: ' WHERE ag.attr_group_id = '||p_attr_group_id ||
307: ' AND dl.attr_group_type = ag.descriptive_flexfield_name '||
308: ' AND dl.application_id = ag.application_id ';
309: IF p_data_level_name IS NOT NULL THEN

Line 12748: ' , EGO_DATA_LEVEL_B DL ' ||

12744: ' FROM EGO_TEMPL_ATTRIBUTES ETA_OUTER'
12745: );
12746: IF p_data_level IS NOT NULL THEN
12747: FND_DSQL.Add_Text(
12748: ' , EGO_DATA_LEVEL_B DL ' ||
12749: ' WHERE DL.data_level_name = '
12750: );
12751: Add_Bind(p_value => p_data_level);
12752: FND_DSQL.Add_Text(

Line 16361: CURSOR get_data_levek_col_names (cp_data_level_name EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE)

16357: p_dl3_column VARCHAR2(20);
16358: iter_col_name VARCHAR2(150);
16359: iter_value VARCHAR2(150);
16360:
16361: CURSOR get_data_levek_col_names (cp_data_level_name EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE)
16362: IS
16363: SELECT pk1_column_name, pk2_column_name, pk3_column_name
16364: FROM ego_data_level_vl
16365: WHERE data_level_name = cp_data_level_name;

Line 16839: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL

16835: p_api_version IN NUMBER
16836: ,p_object_name IN VARCHAR2
16837: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16838: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16839: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
16840: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16841: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
16842: ,p_entity_id IN NUMBER DEFAULT NULL
16843: ,p_entity_index IN NUMBER DEFAULT NULL

Line 17268: FROM ego_data_level_b

17264:
17265: IF l_has_data_level_id THEN
17266: SELECT data_level_id
17267: INTO l_data_level_id
17268: FROM ego_data_level_b
17269: WHERE application_id = p_application_id
17270: AND attr_group_type = p_attr_group_type
17271: AND data_level_name = p_data_level;
17272: END IF;

Line 17348: FROM ego_data_level_b

17344: -----------------------------------------------
17345: SELECT data_level_name
17346: INTO l_base_data_level
17347: FROM ( SELECT MIN(data_level_id) data_level_id
17348: FROM ego_data_level_b
17349: WHERE application_id = p_application_id
17350: AND attr_group_type = p_attr_group_type
17351: ) min_dl, ego_data_level_b dl
17352: WHERE dl.data_level_id = min_dl.data_level_id;

Line 17351: ) min_dl, ego_data_level_b dl

17347: FROM ( SELECT MIN(data_level_id) data_level_id
17348: FROM ego_data_level_b
17349: WHERE application_id = p_application_id
17350: AND attr_group_type = p_attr_group_type
17351: ) min_dl, ego_data_level_b dl
17352: WHERE dl.data_level_id = min_dl.data_level_id;
17353: END IF;
17354:
17355: IF p_data_level_values IS NOT NULL THEN