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.PJI_PJP_SUM_MAIN dependencies on PJI_PJP_PROJ_BATCH_MAP

Line 823: from pji_pjp_proj_batch_map map,pa_projects_all pa

819: l_rpt_excep_reason varchar2(30);
820: l_rpt_footer varchar2(60);
821: cursor c_err_report is
822: select pa.segment1,map.act_err_msg
823: from pji_pjp_proj_batch_map map,pa_projects_all pa
824: where pa.project_id=map.project_id
825: and map.worker_id=p_worker_id
826: and map.act_err_msg is not null
827: order by segment1;

Line 897: from pji_pjp_proj_batch_map map,pa_projects_all pa

893: l_rpt_footer varchar2(60);
894:
895: cursor c_err_report is
896: select pa.segment1,pa.name
897: from pji_pjp_proj_batch_map map,pa_projects_all pa
898: where pa.project_id=map.project_id
899: and map.worker_id=p_worker_id
900: and map.act_err_msg is null
901: order by segment1;

Line 986: PJI_PJP_PROJ_BATCH_MAP bmap

982: -- pji_utils.write2log('In Procedure plan type code changes');
983:
984: select count(bmap.project_id) into l_count
985: from PA_PJI_PROJ_EVENTS_LOG elog,
986: PJI_PJP_PROJ_BATCH_MAP bmap
987: where elog.event_object = to_char(bmap.project_id)
988: and elog.event_type = 'PLANTYPE_UPG'
989: and bmap.worker_id = p_worker_id;
990:

Line 1075: PJI_PJP_PROJ_BATCH_MAP bmap

1071: pa_budget_versions bv
1072: , pa_proj_fp_options fpo
1073: , (select distinct bmap.project_id,elog.ATTRIBUTE1 plan_type_id from
1074: PA_PJI_PROJ_EVENTS_LOG elog,
1075: PJI_PJP_PROJ_BATCH_MAP bmap
1076: where elog.event_object = to_char(bmap.project_id)
1077: and elog.EVENT_TYPE = 'PLANTYPE_UPG'
1078: and bmap.worker_id = p_worker_id) logmap
1079: WHERE 1=1

Line 2769: PJI_PJP_PROJ_BATCH_MAP map,

2765: cursor lock_headers (p_worker_id in number) is
2766: select
2767: wbs_hdr.ROWID HDR_ROWID
2768: from
2769: PJI_PJP_PROJ_BATCH_MAP map,
2770: PJI_PJP_WBS_HEADER wbs_hdr
2771: where
2772: map.WORKER_ID = p_worker_id and
2773: wbs_hdr.PROJECT_ID = map.PROJECT_ID and

Line 2903: lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;

2899: FND_MESSAGE.SET_NAME('PJI', 'PJI_NO_PRC_AVAILABLE');
2900: dbms_standard.raise_application_error(-20010, FND_MESSAGE.GET);
2901: end if;
2902: end if;
2903: lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
2904: end if;
2905: -- End Bug 14138486
2906:
2907:

Line 3145: insert into PJI_PJP_PROJ_BATCH_MAP

3141: end;
3142:
3143: if ( l_prg_group_flag = 'N' ) then
3144: /* Added for bug 7551819 */
3145: insert into PJI_PJP_PROJ_BATCH_MAP
3146: (
3147: WORKER_ID,
3148: PROJECT_ID,
3149: PJI_PROJECT_STATUS,

Line 3212: insert into PJI_PJP_PROJ_BATCH_MAP

3208:
3209: /* Added for bug 7551819 */
3210: else -- l_prg_group_flag = 'Y'
3211:
3212: insert into PJI_PJP_PROJ_BATCH_MAP
3213: (
3214: WORKER_ID,
3215: PROJECT_ID,
3216: PJI_PROJECT_STATUS,

Line 3254: insert into PJI_PJP_PROJ_BATCH_MAP

3250:
3251: /* Not required changed the logic of l_prg_exist Bug 5057835
3252: elsif (l_prg_exists = 'Y') then
3253:
3254: insert into PJI_PJP_PROJ_BATCH_MAP
3255: (
3256: WORKER_ID,
3257: PROJECT_ID,
3258: PJI_PROJECT_STATUS,

Line 3322: PJI_PJP_PROJ_BATCH_MAP map,

3318: 'Y'
3319: into
3320: l_prg_exists
3321: from
3322: PJI_PJP_PROJ_BATCH_MAP map,
3323: PA_PROJ_ELEMENT_VERSIONS proj
3324: where
3325: map.WORKER_ID = p_worker_id and
3326: map.PROJECT_ID = proj.PROJECT_ID and

Line 3342: insert into PJI_PJP_PROJ_BATCH_MAP

3338: -- if (l_prg_exists = 'Y') then
3339: if (l_prg_exists = 'Y' AND l_prg_group_flag = 'N' ) then
3340:
3341:
3342: insert into PJI_PJP_PROJ_BATCH_MAP
3343: (
3344: WORKER_ID,
3345: PROJECT_ID,
3346: PJI_PROJECT_STATUS,

Line 3374: PJI_PJP_PROJ_BATCH_MAP map,

3370: select /*+ ordered */
3371: distinct
3372: ver2.PROJECT_ID
3373: from
3374: PJI_PJP_PROJ_BATCH_MAP map,
3375: PA_PROJ_ELEMENT_VERSIONS ver1,
3376: PA_PROJ_ELEMENT_VERSIONS ver2
3377: where
3378: map.WORKER_ID = p_worker_id and

Line 3390: PJI_PJP_PROJ_BATCH_MAP map,

3386: index(prg2 PJI_XBS_DENORM_N3) */
3387: distinct
3388: prg2.SUP_PROJECT_ID PROJECT_ID
3389: from
3390: PJI_PJP_PROJ_BATCH_MAP map,
3391: PJI_XBS_DENORM prg1,
3392: PJI_XBS_DENORM prg2
3393: where
3394: map.WORKER_ID = p_worker_id and

Line 3402: PJI_PJP_PROJ_BATCH_MAP existing_projects,

3398: prg2.STRUCT_TYPE = 'PRG' and
3399: prg2.SUB_LEVEL = prg2.SUP_LEVEL and
3400: prg2.PRG_GROUP = prg1.PRG_GROUP
3401: ) map,
3402: PJI_PJP_PROJ_BATCH_MAP existing_projects,
3403: PJI_PJP_PROJ_EXTR_STATUS status,
3404: PA_PROJECTS_ALL prj
3405: where
3406: p_worker_id = existing_projects.WORKER_ID (+) and

Line 3421: PJI_PJP_PROJ_BATCH_MAP new_worker

3417: count(*)
3418: into
3419: l_count
3420: from
3421: PJI_PJP_PROJ_BATCH_MAP new_worker
3422: where
3423: new_worker.WORKER_ID = p_worker_id;
3424:
3425: if (l_count = 0) then

Line 3443: insert into PJI_PJP_PROJ_BATCH_MAP

3439: end if;
3440:
3441: elsif (l_extraction_type = 'RBS') then
3442:
3443: insert into PJI_PJP_PROJ_BATCH_MAP
3444: (
3445: WORKER_ID,
3446: PROJECT_ID,
3447: PJI_PROJECT_STATUS,

Line 3518: insert into PJI_PJP_PROJ_BATCH_MAP

3514: prj.PROJECT_TYPE = pt.PROJECT_TYPE ; /* and
3515: rbs_asg.PROJECT_ID = active_projects.PROJECT_ID (+); */
3516:
3517: -- CBS Change
3518: insert into PJI_PJP_PROJ_BATCH_MAP
3519: (
3520: WORKER_ID,
3521: PROJECT_ID,
3522: PJI_PROJECT_STATUS,

Line 3576: PJI_PJP_PROJ_BATCH_MAP map

3572: WHERE EXISTS
3573: (
3574: SELECT 1
3575: FROM pji_pjp_proj_extr_status extr,
3576: PJI_PJP_PROJ_BATCH_MAP map
3577: WHERE map.project_id=extr.project_id
3578: AND extr.extraction_status='F'
3579: AND WORKER_ID = p_worker_id
3580: );

Line 3620: from PJI_PJP_PROJ_BATCH_MAP existing_workers

3616: for c in
3617: (
3618: select distinct
3619: existing_workers.WORKER_ID
3620: from PJI_PJP_PROJ_BATCH_MAP existing_workers
3621: where existing_workers.WORKER_ID <> p_worker_id and
3622: exists (select 1
3623: from PJI_PJP_PROJ_BATCH_MAP new_worker
3624: where new_worker.WORKER_ID = p_worker_id and

Line 3623: from PJI_PJP_PROJ_BATCH_MAP new_worker

3619: existing_workers.WORKER_ID
3620: from PJI_PJP_PROJ_BATCH_MAP existing_workers
3621: where existing_workers.WORKER_ID <> p_worker_id and
3622: exists (select 1
3623: from PJI_PJP_PROJ_BATCH_MAP new_worker
3624: where new_worker.WORKER_ID = p_worker_id and
3625: new_worker.PROJECT_ID = existing_workers.PROJECT_ID)
3626: ) loop
3627:

Line 3647: rollback; -- unlock PJI_PJP_PROJ_BATCH_MAP

3643: end loop;
3644:
3645: if (l_count > 0) then
3646:
3647: rollback; -- unlock PJI_PJP_PROJ_BATCH_MAP
3648:
3649: for i in 1..l_count loop
3650: if request_id_table(i) <> -1 then
3651: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);

Line 3705: from PJI_PJP_PROJ_BATCH_MAP

3701: l_extraction_type = 'INCREMENTAL' or
3702: l_extraction_type = 'PARTIAL') then
3703:
3704: delete
3705: from PJI_PJP_PROJ_BATCH_MAP
3706: where WORKER_ID = p_worker_id and
3707: ((l_extraction_type = 'FULL' and
3708: EXTRACTION_STATUS <> 'F') or
3709: (l_extraction_type = 'INCREMENTAL' and

Line 3722: from PJI_PJP_PROJ_BATCH_MAP map,

3718: 'RBS_ASSOC',
3719: 'RBS_PRG' --Uncommented for bug 13800894
3720: ) and
3721: log.ATTRIBUTE1 in (select stat.PROJECT_ID
3722: from PJI_PJP_PROJ_BATCH_MAP map,
3723: PJI_PJP_PROJ_EXTR_STATUS stat
3724: where map.WORKER_ID = p_worker_id and
3725: stat.PROJECT_ID = map.PROJECT_ID and
3726: stat.EXTRACTION_STATUS = 'F');

Line 3736: from PJI_PJP_PROJ_BATCH_MAP

3732: LAST_UPDATE_DATE = sysdate
3733: where l_extraction_type = 'FULL' and
3734: EXTRACTION_STATUS = 'F' and
3735: PROJECT_ID in (select PROJECT_ID
3736: from PJI_PJP_PROJ_BATCH_MAP
3737: where WORKER_ID = p_worker_id);
3738:
3739: for c in lock_headers(p_worker_id) loop
3740: update PJI_PJP_WBS_HEADER wbs_hdr

Line 3967: tabname => 'PJI_PJP_PROJ_BATCH_MAP',

3963: degree => PJI_UTILS.
3964: GET_DEGREE_OF_PARALLELISM);
3965:
3966: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3967: tabname => 'PJI_PJP_PROJ_BATCH_MAP',
3968: percent => 10,
3969: degree => PJI_UTILS.
3970: GET_DEGREE_OF_PARALLELISM);
3971: /* Added for bug 8353629 */

Line 4099: -- lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;

4095: return;
4096: end if;
4097: -- Changes for bug 6266824
4098: /* Commented for bug 6266824
4099: -- lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
4100: if p_worker_id = 1 then
4101: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;
4102: elsif p_worker_id = 2 then
4103: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;

Line 4101: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;

4097: -- Changes for bug 6266824
4098: /* Commented for bug 6266824
4099: -- lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
4100: if p_worker_id = 1 then
4101: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;
4102: elsif p_worker_id = 2 then
4103: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;
4104: elsif p_worker_id = 3 then
4105: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;

Line 4103: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;

4099: -- lock table PJI_PJP_PROJ_BATCH_MAP in exclusive mode;
4100: if p_worker_id = 1 then
4101: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;
4102: elsif p_worker_id = 2 then
4103: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;
4104: elsif p_worker_id = 3 then
4105: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;
4106: elsif p_worker_id = 4 then
4107: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;

Line 4105: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;

4101: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P1) in exclusive mode;
4102: elsif p_worker_id = 2 then
4103: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;
4104: elsif p_worker_id = 3 then
4105: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;
4106: elsif p_worker_id = 4 then
4107: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;
4108: elsif p_worker_id = 5 then
4109: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;

Line 4107: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;

4103: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P2) in exclusive mode;
4104: elsif p_worker_id = 3 then
4105: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;
4106: elsif p_worker_id = 4 then
4107: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;
4108: elsif p_worker_id = 5 then
4109: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;
4110: elsif p_worker_id = 6 then
4111: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;

Line 4109: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;

4105: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P3) in exclusive mode;
4106: elsif p_worker_id = 4 then
4107: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;
4108: elsif p_worker_id = 5 then
4109: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;
4110: elsif p_worker_id = 6 then
4111: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;
4112: elsif p_worker_id = 7 then
4113: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;

Line 4111: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;

4107: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P4) in exclusive mode;
4108: elsif p_worker_id = 5 then
4109: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;
4110: elsif p_worker_id = 6 then
4111: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;
4112: elsif p_worker_id = 7 then
4113: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;
4114: elsif p_worker_id = 8 then
4115: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;

Line 4113: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;

4109: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P5) in exclusive mode;
4110: elsif p_worker_id = 6 then
4111: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;
4112: elsif p_worker_id = 7 then
4113: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;
4114: elsif p_worker_id = 8 then
4115: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;
4116: elsif p_worker_id = 9 then
4117: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;

Line 4115: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;

4111: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P6) in exclusive mode;
4112: elsif p_worker_id = 7 then
4113: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;
4114: elsif p_worker_id = 8 then
4115: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;
4116: elsif p_worker_id = 9 then
4117: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;
4118: elsif p_worker_id = 10 then
4119: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;

Line 4117: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;

4113: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P7) in exclusive mode;
4114: elsif p_worker_id = 8 then
4115: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;
4116: elsif p_worker_id = 9 then
4117: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;
4118: elsif p_worker_id = 10 then
4119: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;
4120: end if;
4121: */

Line 4119: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;

4115: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P8) in exclusive mode;
4116: elsif p_worker_id = 9 then
4117: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P9) in exclusive mode;
4118: elsif p_worker_id = 10 then
4119: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;
4120: end if;
4121: */
4122: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
4123:

Line 4219: from PJI_PJP_PROJ_BATCH_MAP map

4215:
4216: update PJI_PJP_PROJ_EXTR_STATUS
4217: set LAST_UPDATE_DATE = sysdate
4218: where PROJECT_ID in (select map.PROJECT_ID
4219: from PJI_PJP_PROJ_BATCH_MAP map
4220: where map.WORKER_ID = p_worker_id);
4221:
4222: delete from PJI_PJP_PROJ_BATCH_MAP where WORKER_ID = p_worker_id;
4223:

Line 4222: delete from PJI_PJP_PROJ_BATCH_MAP where WORKER_ID = p_worker_id;

4218: where PROJECT_ID in (select map.PROJECT_ID
4219: from PJI_PJP_PROJ_BATCH_MAP map
4220: where map.WORKER_ID = p_worker_id);
4221:
4222: delete from PJI_PJP_PROJ_BATCH_MAP where WORKER_ID = p_worker_id;
4223:
4224: -- mark current iteration as successful
4225:
4226: PJI_PROCESS_UTIL.WRAPUP_PROCESS(l_process);