APPS.EGO_EXT_FWK_PUB dependencies on EGO_DATA_LEVEL_B

Line 4237: FROM ego_data_level_b

4233:
4234: IF p_transaction_type = 'CREATE' THEN
4235: SELECT max(data_level_id)
4236: INTO l_data_level_id
4237: FROM ego_data_level_b
4238: WHERE application_id = p_application_id;
4239:
4240: IF l_data_level_id IS NULL THEN
4241: l_data_level_id := p_application_id * 100 + 1;

Line 4254: INSERT INTO EGO_DATA_LEVEL_B

4250: END IF;
4251:
4252: code_debug(l_api_name ||' Data level id being used in insert: '||l_data_level_id);
4253:
4254: INSERT INTO EGO_DATA_LEVEL_B
4255: (data_level_id
4256: ,application_id
4257: ,attr_group_type
4258: ,data_level_name

Line 4334: FROM ego_data_level_b

4330:
4331: ELSIF p_transaction_type = 'UPDATE' THEN
4332: SELECT data_level_id
4333: INTO l_data_level_id
4334: FROM ego_data_level_b
4335: WHERE application_id = p_application_id
4336: AND attr_group_type = p_attr_group_type
4337: AND data_level_name = p_data_level_name;
4338: code_debug(l_api_name ||' Data level id being used in update: '||l_data_level_id);

Line 4355: UPDATE EGO_DATA_LEVEL_B

4351: WHERE data_level_id = l_data_level_id
4352: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);
4353:
4354: IF NOT FND_API.to_boolean(p_is_nls_mode) THEN
4355: UPDATE EGO_DATA_LEVEL_B
4356: SET pk1_column_name = p_pk1_column_name
4357: ,pk1_column_type = p_pk2_column_type
4358: ,pk2_column_name = p_pk2_column_name
4359: ,pk2_column_type = p_pk2_column_type

Line 4448: l_data_level_rec ego_data_level_b%ROWTYPE;

4444: l_view_priv_id NUMBER;
4445: l_edit_priv_id NUMBER;
4446: l_raise_pre_event VARCHAR2(1);
4447: l_raise_post_event VARCHAR2(1);
4448: l_data_level_rec ego_data_level_b%ROWTYPE;
4449: l_msg_name VARCHAR2(30);
4450: BEGIN
4451:
4452: l_api_version := 1.0;

Line 4535: FROM ego_data_level_b

4531: BEGIN
4532: IF p_data_level_id IS NULL THEN
4533: SELECT *
4534: INTO l_data_level_rec
4535: FROM ego_data_level_b
4536: WHERE data_level_name = p_data_level_name
4537: AND attr_group_type = p_attr_group_type
4538: AND application_id = p_application_id;
4539: ELSE

Line 4542: FROM ego_data_level_b

4538: AND application_id = p_application_id;
4539: ELSE
4540: SELECT *
4541: INTO l_data_level_rec
4542: FROM ego_data_level_b
4543: WHERE data_level_name = p_data_level_id;
4544: END IF;
4545: code_debug(l_api_name ||' Data Level Id '||l_data_level_rec.data_level_id);
4546: EXCEPTION

Line 8336: FROM ego_data_level_b dl_meta, ego_attr_group_dl attr_grp_dl

8332:
8333: CURSOR data_level_merge (cp_attr_group_id IN NUMBER
8334: ,cp_classification_code IN VARCHAR2) IS
8335: SELECT attr_grp_dl.data_level_id data_level_id, dl_meta.data_level_name data_level_name
8336: FROM ego_data_level_b dl_meta, ego_attr_group_dl attr_grp_dl
8337: WHERE attr_grp_dl.data_level_id = dl_meta.data_level_id
8338: AND attr_grp_dl.attr_group_id = cp_attr_group_id
8339: AND NOT EXISTS
8340: (SELECT 1

Line 13612: FROM EGO_DATA_LEVEL_B B

13608:
13609: DELETE FROM EGO_DATA_LEVEL_TL T
13610: WHERE NOT EXISTS
13611: (SELECT NULL
13612: FROM EGO_DATA_LEVEL_B B
13613: WHERE B.DATA_LEVEL_ID = T.DATA_LEVEL_ID
13614: );
13615:
13616: UPDATE EGO_DATA_LEVEL_TL T

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

14375: RETURN VARCHAR2 IS
14376:
14377: CURSOR c_data_levels(p_attr_grp_id IN NUMBER) IS
14378: SELECT DL_TL.user_data_level_name data_level_name
14379: FROM EGO_ATTR_GROUP_DL AG_DL, EGO_DATA_LEVEL_B DL_B, EGO_DATA_LEVEL_TL DL_TL
14380: WHERE AG_DL.data_level_id = DL_B.data_level_id
14381: AND DL_B.data_level_id = DL_TL.data_level_id
14382: AND UserEnv('LANG')=LANGUAGE
14383: AND AG_DL.attr_group_id = p_attr_grp_id;