eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_AG_BULKLOAD_PVT dependencies on EGO_ATTR_GROUP_DL

Line 1007: FROM EGO_ATTR_GROUP_DL eagdl

1003: Nvl(program_id,G_PROGRAM_ID),
1004: Nvl(program_update_date,SYSDATE)
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

Line 1026: FROM EGO_ATTR_GROUP_DL eagdl

1022: last_updated_by = G_USER_ID,
1023: last_update_date = SYSDATE,
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

Line 2471: FROM ego_attr_group_dl eagdl

2467: WHERE eagdi.data_level_id IS NOT NULL
2468: AND eagdi.attr_group_id IS NOT NULL
2469: AND transaction_type = G_OPR_SYNC
2470: AND EXISTS (SELECT 1
2471: FROM ego_attr_group_dl eagdl
2472: WHERE eagdl.attr_group_id = eagdi.attr_group_id
2473: AND eagdl.data_level_id = eagdi.data_level_id)
2474: AND eagdi.process_status = G_PROCESS_RECORD
2475: AND ((G_SET_PROCESS_ID IS NULL)

Line 2492: FROM ego_attr_group_dl eagdl

2488: WHERE eagdi.data_level_id IS NOT NULL
2489: AND eagdi.attr_group_id IS NOT NULL
2490: AND transaction_type = G_OPR_SYNC
2491: AND NOT EXISTS (SELECT 1
2492: FROM ego_attr_group_dl eagdl
2493: WHERE eagdl.attr_group_id = eagdi.attr_group_id
2494: AND eagdl.data_level_id = eagdi.data_level_id)
2495: AND eagdi.process_status = G_PROCESS_RECORD
2496: AND ((G_SET_PROCESS_ID IS NULL)

Line 3237: FROM EGO_ATTR_GROUP_DL eagdl

3233: DECLARE
3234: lv_count NUMBER := 0;
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

Line 3265: FROM EGO_ATTR_GROUP_DL eagdl

3261: DECLARE
3262: lv_count NUMBER := 0;
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

Line 3293: FROM EGO_ATTR_GROUP_DL eagdl

3289: DECLARE
3290: lv_count NUMBER := 0;
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

Line 3321: FROM EGO_ATTR_GROUP_DL

3317:
3318:
3319: /*Check to see if the Business entity is already enabled*/
3320: SELECT count(1) INTO lv_count
3321: FROM EGO_ATTR_GROUP_DL
3322: WHERE attr_group_id = P_agdl_tbl(i).attr_group_id
3323: AND data_level_id = P_agdl_tbl(i).data_level_id;
3324:
3325: IF (lv_count > 0 AND P_agdl_tbl(i).transaction_type = G_OPR_CREATE) THEN

Line 3398: DELETE FROM EGO_ATTR_GROUP_DL

3394: END IF;
3395: END IF;
3396: ELSIF (P_agdl_tbl(i).process_status = G_PROCESS_RECORD AND P_agdl_tbl(i).transaction_type = G_OPR_DELETE) THEN
3397: BEGIN
3398: DELETE FROM EGO_ATTR_GROUP_DL
3399: WHERE attr_group_id = P_agdl_tbl(i).attr_group_id
3400: AND data_level_id = P_agdl_tbl(i).data_level_id;
3401:
3402: EXCEPTION

Line 4093: FROM ego_attr_group_dl

4089: AND P_agdl_tbl(i).transaction_type = G_OPR_SYNC) THEN
4090: BEGIN
4091: SELECT 'Y'
4092: INTO lv_flag
4093: FROM ego_attr_group_dl
4094: WHERE data_level_id = P_agdl_tbl(i).data_level_id
4095: AND attr_group_id = P_agdl_tbl(i).attr_group_id;
4096:
4097: IF lv_flag = 'Y' THEN

Line 4534: FROM EGO_ATTR_GROUP_DL

4530: lv_flag NUMBER;
4531: lv_count NUMBER;
4532: BEGIN
4533: SELECT 1 INTO lv_flag
4534: FROM EGO_ATTR_GROUP_DL
4535: WHERE attr_group_id = p_agdl_tbl(i).attr_group_id
4536: AND data_level_id = p_agdl_tbl(i).data_level_id;
4537:
4538: IF (lv_flag = 1) THEN

Line 4540: FROM EGO_ATTR_GROUP_DL

4536: AND data_level_id = p_agdl_tbl(i).data_level_id;
4537:
4538: IF (lv_flag = 1) THEN
4539: SELECT COUNT(1) INTO lv_count
4540: FROM EGO_ATTR_GROUP_DL
4541: WHERE attr_group_id = p_agdl_tbl(i).attr_group_id;
4542:
4543: IF (lv_count = 1) THEN
4544: p_agdl_tbl(i).process_status := G_ERROR_RECORD;

Line 6446: FROM EGO_ATTR_GROUP_DL

6442: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Smt 1');
6443:
6444: SELECT defaulting ,view_privilege_id,edit_privilege_id,raise_pre_event,raise_post_event
6445: INTO lv_defaulting, lv_view_privilege_id ,lv_edit_privilege_id,lv_raise_pre_event, lv_raise_post_event
6446: FROM EGO_ATTR_GROUP_DL
6447: WHERE attr_group_id = p_agdl_tbl(i).attr_group_id
6448: AND data_level_id = p_agdl_tbl(i).data_level_id;
6449:
6450: IF (p_agdl_tbl(i).defaulting IS NULL

Line 6591: FROM EGO_ATTR_GROUP_DL

6587: FROM ego_fnd_dsc_flx_ctx_ext efd
6588: WHERE application_id = G_EGO_APPLICATION_ID
6589: AND DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP
6590: AND NOT EXISTS (SELECT 1
6591: FROM EGO_ATTR_GROUP_DL
6592: WHERE attr_group_id = efd.attr_group_id);
6593:
6594: x_errorcode NUMBER;
6595: x_msg_count NUMBER;