APPS.EGO_AG_BULKLOAD_PVT dependencies on EGO_DATA_LEVEL_B

Line 1009: AND eagdl.data_level_id = (SELECT data_level_id FROM ego_data_level_b

1005: FROM ego_attr_groups_dl_interface eagi
1006: WHERE EXISTS (SELECT 1
1007: FROM EGO_ATTR_GROUP_DL eagdl
1008: WHERE eagdl.attr_group_id = eagi.attr_group_id
1009: AND eagdl.data_level_id = (SELECT data_level_id FROM ego_data_level_b
1010: WHERE data_level_name=eagi.data_level_name
1011: AND attr_group_type = G_EGO_ITEMMGMT_GROUP
1012: AND application_id = G_EGO_APPLICATION_ID
1013: ))

Line 1028: AND eagdl.data_level_id = (SELECT data_level_id FROM ego_data_level_b

1024: last_update_login = G_LOGIN_ID
1025: WHERE EXISTS (SELECT 1
1026: FROM EGO_ATTR_GROUP_DL eagdl
1027: WHERE eagdl.attr_group_id = eagi.attr_group_id
1028: AND eagdl.data_level_id = (SELECT data_level_id FROM ego_data_level_b
1029: WHERE data_level_name=eagi.data_level_name
1030: AND attr_group_type = G_EGO_ITEMMGMT_GROUP
1031: AND application_id = G_EGO_APPLICATION_ID
1032: ))

Line 2444: FROM ego_data_level_b

2440:
2441: /*Set the Data Level ID when the data level is given*/
2442: UPDATE ego_attr_groups_dl_interface eagdi
2443: SET eagdi.data_level_id = (SELECT data_level_id
2444: FROM ego_data_level_b
2445: WHERE attr_group_type = eagdi.attr_group_type
2446: AND application_id = g_ego_application_id
2447: AND data_level_name = eagdi.data_level_name),
2448: last_updated_by = G_USER_ID,

Line 2830: FROM ego_data_level_b

2826:
2827: /*Set the Data Level when the data level id is given*/
2828: UPDATE ego_attr_groups_dl_interface eagdi
2829: SET eagdi.data_level_name = (SELECT data_level_name
2830: FROM ego_data_level_b
2831: WHERE attr_group_type = eagdi.attr_group_type
2832: AND application_id = g_ego_application_id
2833: AND data_level_id = eagdi.data_level_id),
2834: last_updated_by = G_USER_ID,

Line 3239: AND eagdl.data_level_id IN (SELECT data_level_id FROM ego_data_level_b

3235: BEGIN
3236: SELECT count(1) INTO lv_count
3237: FROM EGO_ATTR_GROUP_DL eagdl
3238: WHERE eagdl.attr_group_id = p_agdl_tbl(i).attr_group_id
3239: AND eagdl.data_level_id IN (SELECT data_level_id FROM ego_data_level_b
3240: WHERE data_level_name IN (G_DL_ITEM_REV_LEVEL,G_DL_ITEM_ORG)
3241: AND attr_group_type = G_EGO_ITEMMGMT_GROUP
3242: AND application_id = G_EGO_APPLICATION_ID
3243: );

Line 3267: AND eagdl.data_level_id IN (SELECT data_level_id FROM ego_data_level_b

3263: BEGIN
3264: SELECT count(1) INTO lv_count
3265: FROM EGO_ATTR_GROUP_DL eagdl
3266: WHERE eagdl.attr_group_id = p_agdl_tbl(i).attr_group_id
3267: AND eagdl.data_level_id IN (SELECT data_level_id FROM ego_data_level_b
3268: WHERE data_level_name IN (G_DL_ITEM_LEVEL,G_DL_ITEM_ORG)
3269: AND attr_group_type = G_EGO_ITEMMGMT_GROUP
3270: AND application_id = G_EGO_APPLICATION_ID
3271: );

Line 3295: AND eagdl.data_level_id IN (SELECT data_level_id FROM ego_data_level_b

3291: BEGIN
3292: SELECT count(1) INTO lv_count
3293: FROM EGO_ATTR_GROUP_DL eagdl
3294: WHERE eagdl.attr_group_id = p_agdl_tbl(i).attr_group_id
3295: AND eagdl.data_level_id IN (SELECT data_level_id FROM ego_data_level_b
3296: WHERE data_level_name IN (G_DL_ITEM_LEVEL,G_DL_ITEM_REV_LEVEL)
3297: AND attr_group_type = G_EGO_ITEMMGMT_GROUP
3298: AND application_id = G_EGO_APPLICATION_ID
3299: );

Line 4050: FROM ego_data_level_b

4046: AND P_agdl_tbl(i).data_level_name IS NOT NULL) THEN
4047: BEGIN
4048: SELECT data_level_id
4049: INTO P_agdl_tbl(i).data_level_id
4050: FROM ego_data_level_b
4051: WHERE attr_group_type = P_agdl_tbl(i).attr_group_type
4052: AND application_id = g_ego_application_id
4053: AND data_level_name = P_agdl_tbl(i).data_level_name;
4054: EXCEPTION

Line 5692: FROM ego_data_level_b

5688: AND P_agdl_tbl(i).data_level_name IS NULL) THEN
5689: BEGIN
5690: SELECT data_level_name
5691: INTO P_agdl_tbl(i).data_level_name
5692: FROM ego_data_level_b
5693: WHERE attr_group_type = P_agdl_tbl(i).attr_group_type
5694: AND application_id = g_ego_application_id
5695: AND data_level_id = P_agdl_tbl(i).data_level_id;
5696: EXCEPTION