[Home] [Help]
353: END IF;
354:
355: SELECT DATA_LEVEL_ID
356: INTO l_data_level_id
357: FROM EGO_DATA_LEVEL_B
358: WHERE APPLICATION_ID = p_application_id
359: AND ATTR_GROUP_TYPE = p_attr_group_type
360: AND DATA_LEVEL_NAME = p_data_level_name;
361:
401: -- new code will have p_data_level and must return only one record
402: --
403: BEGIN
404: l_dynamic_sql := 'SELECT DISTINCT(assoc.data_level_id) ' ||
405: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||
406: ' WHERE ag.attr_group_id = '||p_attr_group_id ||
407: ' AND dl.attr_group_type = ag.descriptive_flexfield_name '||
408: ' AND dl.application_id = ag.application_id ';
409: IF p_data_level_name IS NOT NULL THEN
10927: END IF;
10928:
10929: Debug_msg('add_datalevel_predicate: ' || 'Adding ext table prediacate');
10930: -- we are passing old data level meta data for backward compatibility.
10931: -- R12.C onwards we use data level meta data only from ego_data_level_b.
10932: add_nameval_predicate(p_col_metadata => p_ext_data_level_metadata,
10933: p_nameval_pairs => p_data_level_value_pairs,
10934: p_add_and => l_ret OR p_add_and,
10935: x_predicate_added => l_predicate_added);
10976:
10977: CURSOR c IS
10978: SELECT agdl.defaulting
10979: FROM ego_attr_group_dl agdl,
10980: ego_data_level_b dl
10981: WHERE agdl.attr_group_id = p_attr_group_id
10982: AND agdl.data_level_id = dl.data_level_id
10983: AND dl.data_level_name = p_data_level;
10984:
13770: ' FROM EGO_TEMPL_ATTRIBUTES ETA_OUTER'
13771: );
13772: IF p_data_level IS NOT NULL THEN
13773: FND_DSQL.Add_Text(
13774: ' , EGO_DATA_LEVEL_B DL ' ||
13775: ' WHERE DL.data_level_name = '
13776: );
13777: Add_Bind(p_value => p_data_level);
13778: FND_DSQL.Add_Text(
17518: p_dl3_column VARCHAR2(20);
17519: iter_col_name VARCHAR2(150);
17520: iter_value VARCHAR2(150);
17521:
17522: CURSOR get_data_levek_col_names (cp_data_level_name EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE)
17523: IS
17524: SELECT pk1_column_name, pk2_column_name, pk3_column_name
17525: FROM ego_data_level_vl
17526: WHERE data_level_name = cp_data_level_name;
17996: p_api_version IN NUMBER
17997: ,p_object_name IN VARCHAR2
17998: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17999: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18000: ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
18001: ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
18002: ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
18003: ,p_entity_id IN NUMBER DEFAULT NULL
18004: ,p_entity_index IN NUMBER DEFAULT NULL
18425:
18426: IF l_has_data_level_id THEN
18427: SELECT data_level_id
18428: INTO l_data_level_id
18429: FROM ego_data_level_b
18430: WHERE application_id = p_application_id
18431: AND attr_group_type = p_attr_group_type
18432: AND data_level_name = p_data_level;
18433: END IF;
18507: -----------------------------------------------
18508: SELECT data_level_name
18509: INTO l_base_data_level
18510: FROM ( SELECT MIN(data_level_id) data_level_id
18511: FROM ego_data_level_b
18512: WHERE application_id = p_application_id
18513: AND attr_group_type = p_attr_group_type
18514: ) min_dl, ego_data_level_b dl
18515: WHERE dl.data_level_id = min_dl.data_level_id;
18510: FROM ( SELECT MIN(data_level_id) data_level_id
18511: FROM ego_data_level_b
18512: WHERE application_id = p_application_id
18513: AND attr_group_type = p_attr_group_type
18514: ) min_dl, ego_data_level_b dl
18515: WHERE dl.data_level_id = min_dl.data_level_id;
18516: END IF;
18517:
18518: IF p_data_level_values IS NOT NULL THEN