APPS.EGO_EXT_FWK_PUB dependencies on EGO_DATA_LEVEL_B

Line 4362: FROM ego_data_level_b

4358:
4359: IF p_transaction_type = 'CREATE' THEN
4360: SELECT max(data_level_id)
4361: INTO l_data_level_id
4362: FROM ego_data_level_b
4363: WHERE application_id = p_application_id;
4364:
4365: IF l_data_level_id IS NULL THEN
4366: l_data_level_id := p_application_id * 100 + 1;

Line 4379: INSERT INTO EGO_DATA_LEVEL_B

4375: END IF;
4376:
4377: code_debug(l_api_name ||' Data level id being used in insert: '||l_data_level_id);
4378:
4379: INSERT INTO EGO_DATA_LEVEL_B
4380: (data_level_id
4381: ,application_id
4382: ,attr_group_type
4383: ,data_level_name

Line 4459: FROM ego_data_level_b

4455:
4456: ELSIF p_transaction_type = 'UPDATE' THEN
4457: SELECT data_level_id
4458: INTO l_data_level_id
4459: FROM ego_data_level_b
4460: WHERE application_id = p_application_id
4461: AND attr_group_type = p_attr_group_type
4462: AND data_level_name = p_data_level_name;
4463: code_debug(l_api_name ||' Data level id being used in update: '||l_data_level_id);

Line 4480: UPDATE EGO_DATA_LEVEL_B

4476: WHERE data_level_id = l_data_level_id
4477: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);
4478:
4479: IF NOT FND_API.to_boolean(p_is_nls_mode) THEN
4480: UPDATE EGO_DATA_LEVEL_B
4481: SET pk1_column_name = p_pk1_column_name
4482: ,pk1_column_type = p_pk1_column_type
4483: ,pk2_column_name = p_pk2_column_name
4484: ,pk2_column_type = p_pk2_column_type

Line 4573: l_data_level_rec ego_data_level_b%ROWTYPE;

4569: l_view_priv_id NUMBER;
4570: l_edit_priv_id NUMBER;
4571: l_raise_pre_event VARCHAR2(1);
4572: l_raise_post_event VARCHAR2(1);
4573: l_data_level_rec ego_data_level_b%ROWTYPE;
4574: l_msg_name VARCHAR2(30);
4575: BEGIN
4576:
4577: l_api_version := 1.0;

Line 4668: FROM ego_data_level_b

4664: BEGIN
4665: IF p_data_level_id IS NULL THEN
4666: SELECT *
4667: INTO l_data_level_rec
4668: FROM ego_data_level_b
4669: WHERE data_level_name = p_data_level_name
4670: AND attr_group_type = p_attr_group_type
4671: AND application_id = p_application_id;
4672: ELSE

Line 4675: FROM ego_data_level_b

4671: AND application_id = p_application_id;
4672: ELSE
4673: SELECT *
4674: INTO l_data_level_rec
4675: FROM ego_data_level_b
4676: WHERE 1=1 --data_level_name = p_data_level_id;
4677: AND data_level_id = p_data_level_id; --Changed for bug 9574826
4678: END IF;
4679: code_debug(l_api_name ||' Data Level Id '||l_data_level_rec.data_level_id);

Line 9295: FROM ego_data_level_b dl_meta, ego_attr_group_dl attr_grp_dl

9291:
9292: CURSOR data_level_merge (cp_attr_group_id IN NUMBER
9293: ,cp_classification_code IN VARCHAR2) IS
9294: SELECT attr_grp_dl.data_level_id data_level_id, dl_meta.data_level_name data_level_name
9295: FROM ego_data_level_b dl_meta, ego_attr_group_dl attr_grp_dl
9296: WHERE attr_grp_dl.data_level_id = dl_meta.data_level_id
9297: AND attr_grp_dl.attr_group_id = cp_attr_group_id
9298: AND NOT EXISTS
9299: (SELECT 1

Line 14584: FROM EGO_DATA_LEVEL_B B

14580:
14581: DELETE FROM EGO_DATA_LEVEL_TL T
14582: WHERE NOT EXISTS
14583: (SELECT NULL
14584: FROM EGO_DATA_LEVEL_B B
14585: WHERE B.DATA_LEVEL_ID = T.DATA_LEVEL_ID
14586: );
14587:
14588: UPDATE EGO_DATA_LEVEL_TL T

Line 15449: FROM EGO_ATTR_GROUP_DL AG_DL, EGO_DATA_LEVEL_B DL_B, EGO_DATA_LEVEL_TL DL_TL

15445: RETURN VARCHAR2 IS
15446:
15447: CURSOR c_data_levels(p_attr_grp_id IN NUMBER) IS
15448: SELECT DL_TL.user_data_level_name data_level_name
15449: FROM EGO_ATTR_GROUP_DL AG_DL, EGO_DATA_LEVEL_B DL_B, EGO_DATA_LEVEL_TL DL_TL
15450: WHERE AG_DL.data_level_id = DL_B.data_level_id
15451: AND DL_B.data_level_id = DL_TL.data_level_id
15452: AND UserEnv('LANG')=LANGUAGE
15453: AND AG_DL.attr_group_id = p_attr_grp_id;