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_ROLLUP dependencies on PJI_SYSTEM_PRC_STATUS

Line 229: update PJI_SYSTEM_PRC_STATUS

225: where c.worker_id = p_worker_id and c.project_id = a.sup_project_id );
226:
227: while (lv_level > 0) loop
228:
229: update PJI_SYSTEM_PRC_STATUS
230: set START_DATE = sysdate
231: where PROCESS_NAME = l_process and
232: STEP_SEQ = lv_level_seq;
233:

Line 1571: update PJI_SYSTEM_PRC_STATUS

1567: (pjp1_i.SUP_ID is not null and
1568: (sup_fin_ver.PROJECT_ID is not null or
1569: sup_wpa.PROJ_ELEMENT_ID is not null)));
1570:
1571: update PJI_SYSTEM_PRC_STATUS
1572: set STEP_STATUS = 'C',
1573: END_DATE = sysdate
1574: where PROCESS_NAME = l_process and
1575: STEP_SEQ = lv_level_seq;

Line 1584: PJI_SYSTEM_PRC_STATUS

1580: nvl(to_number(min(STEP_SEQ)), 0)
1581: into
1582: lv_level_seq
1583: from
1584: PJI_SYSTEM_PRC_STATUS
1585: where
1586: PROCESS_NAME = l_process and
1587: STEP_NAME like 'ROLLUP_FPR_WBS%' and
1588: STEP_STATUS is null;

Line 1622: update PJI_SYSTEM_PRC_STATUS

1618: begin
1619:
1620: while (lv_level > 0) loop
1621:
1622: update PJI_SYSTEM_PRC_STATUS
1623: set START_DATE = sysdate
1624: where PROCESS_NAME = l_process and
1625: STEP_SEQ = lv_level_seq;
1626:

Line 2945: update PJI_SYSTEM_PRC_STATUS

2941: (pjp1_i.SUP_ID is not null and
2942: (sup_fin_ver.PROJECT_ID is not null or
2943: sup_wpa.PROJ_ELEMENT_ID is not null)));
2944:
2945: update PJI_SYSTEM_PRC_STATUS
2946: set STEP_STATUS = 'C',
2947: END_DATE = sysdate
2948: where PROCESS_NAME = l_process and
2949: STEP_SEQ = lv_level_seq;

Line 2958: PJI_SYSTEM_PRC_STATUS

2954: nvl(to_number(min(STEP_SEQ)), 0)
2955: into
2956: lv_level_seq
2957: from
2958: PJI_SYSTEM_PRC_STATUS
2959: where
2960: PROCESS_NAME = l_process and
2961: STEP_NAME like 'ROLLUP_FPR_WBS%' and
2962: STEP_STATUS is null;

Line 11023: PJI_SYSTEM_PRC_STATUS

11019: STEP_SEQ
11020: into
11021: l_step_seq
11022: from
11023: PJI_SYSTEM_PRC_STATUS
11024: where
11025: PROCESS_NAME = l_process and
11026: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);';
11027:

Line 11033: PJI_SYSTEM_PRC_STATUS

11029: count(*)
11030: into
11031: l_count
11032: from
11033: PJI_SYSTEM_PRC_STATUS
11034: where
11035: PROCESS_NAME = l_process and
11036: STEP_NAME like 'ROLLUP_FPR_WBS%';
11037:

Line 11059: insert into PJI_SYSTEM_PRC_STATUS

11055: l_level);
11056:
11057: for x in 1 .. l_level loop
11058:
11059: insert into PJI_SYSTEM_PRC_STATUS
11060: (
11061: PROCESS_NAME,
11062: STEP_SEQ,
11063: STEP_STATUS,

Line 11090: PJI_SYSTEM_PRC_STATUS

11086: nvl(to_number(min(STEP_SEQ)), 0)
11087: into
11088: l_level_seq
11089: from
11090: PJI_SYSTEM_PRC_STATUS
11091: where
11092: PROCESS_NAME = l_process and
11093: STEP_NAME like 'ROLLUP_FPR_WBS%' and
11094: STEP_STATUS is null;

Line 14181: PJI_SYSTEM_PRC_STATUS

14177: STEP_SEQ
14178: into
14179: l_step_seq
14180: from
14181: PJI_SYSTEM_PRC_STATUS
14182: where
14183: PROCESS_NAME = l_process and
14184: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);';
14185:

Line 14191: PJI_SYSTEM_PRC_STATUS

14187: count(*)
14188: into
14189: l_count
14190: from
14191: PJI_SYSTEM_PRC_STATUS
14192: where
14193: PROCESS_NAME = l_process and
14194: STEP_NAME like 'ROLLUP_ACR_WBS%';
14195:

Line 14217: insert into PJI_SYSTEM_PRC_STATUS

14213: l_level);
14214:
14215: for x in 1 .. l_level loop
14216:
14217: insert into PJI_SYSTEM_PRC_STATUS
14218: (
14219: PROCESS_NAME,
14220: STEP_SEQ,
14221: STEP_STATUS,

Line 14248: PJI_SYSTEM_PRC_STATUS

14244: nvl(to_number(min(STEP_SEQ)), 0)
14245: into
14246: l_level_seq
14247: from
14248: PJI_SYSTEM_PRC_STATUS
14249: where
14250: PROCESS_NAME = l_process and
14251: STEP_NAME like 'ROLLUP_ACR_WBS%' and
14252: STEP_STATUS is null;

Line 14262: update PJI_SYSTEM_PRC_STATUS

14258: end if;
14259:
14260: while (l_level > 0) loop
14261:
14262: update PJI_SYSTEM_PRC_STATUS
14263: set START_DATE = sysdate
14264: where PROCESS_NAME = l_process and
14265: STEP_SEQ = l_level_seq;
14266:

Line 14852: update PJI_SYSTEM_PRC_STATUS

14848: (pjp1_i.SUP_ID is not null and
14849: (sup_fin_ver.PROJECT_ID is not null or
14850: sup_wpa.PROJ_ELEMENT_ID is not null)));*/
14851:
14852: update PJI_SYSTEM_PRC_STATUS
14853: set STEP_STATUS = 'C',
14854: END_DATE = sysdate
14855: where PROCESS_NAME = l_process and
14856: STEP_SEQ = l_level_seq;

Line 14865: PJI_SYSTEM_PRC_STATUS

14861: nvl(to_number(min(STEP_SEQ)), 0)
14862: into
14863: l_level_seq
14864: from
14865: PJI_SYSTEM_PRC_STATUS
14866: where
14867: PROCESS_NAME = l_process and
14868: STEP_NAME like 'ROLLUP_ACR_WBS%' and
14869: STEP_STATUS is null;

Line 15530: PJI_SYSTEM_PRC_STATUS

15526: STEP_SEQ
15527: into
15528: l_step_seq
15529: from
15530: PJI_SYSTEM_PRC_STATUS
15531: where
15532: PROCESS_NAME = l_process and
15533: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);';
15534:

Line 15540: PJI_SYSTEM_PRC_STATUS

15536: count(*)
15537: into
15538: l_count
15539: from
15540: PJI_SYSTEM_PRC_STATUS
15541: where
15542: PROCESS_NAME = l_process and
15543: STEP_NAME like 'ROLLUP_FPR_PRG%';
15544:

Line 15561: insert into PJI_SYSTEM_PRC_STATUS

15557: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
15558: 'MAX_PROGRAM_LEVEL',
15559: l_level);
15560:
15561: insert into PJI_SYSTEM_PRC_STATUS
15562: (
15563: PROCESS_NAME,
15564: STEP_SEQ,
15565: STEP_STATUS,

Line 15624: PJI_SYSTEM_PRC_STATUS

15620: nvl(to_number(min(STEP_SEQ)), 0)
15621: into
15622: l_level_seq
15623: from
15624: PJI_SYSTEM_PRC_STATUS
15625: where
15626: PROCESS_NAME = l_process and
15627: STEP_NAME like 'ROLLUP_FPR_PRG%' and
15628: STEP_STATUS is null;

Line 15638: update PJI_SYSTEM_PRC_STATUS

15634: end if;
15635:
15636: while (l_level > 0) loop
15637:
15638: update PJI_SYSTEM_PRC_STATUS
15639: set START_DATE = sysdate
15640: where PROCESS_NAME = l_process and
15641: STEP_SEQ = l_level_seq;
15642:

Line 16691: update PJI_SYSTEM_PRC_STATUS

16687: pjp.PLAN_VERSION_ID,
16688: pjp.PLAN_TYPE_ID,
16689: pjp.PLAN_TYPE_CODE;*/
16690:
16691: update PJI_SYSTEM_PRC_STATUS
16692: set STEP_STATUS = 'C',
16693: END_DATE = sysdate
16694: where PROCESS_NAME = l_process and
16695: STEP_SEQ = l_level_seq;

Line 16704: PJI_SYSTEM_PRC_STATUS

16700: nvl(to_number(min(STEP_SEQ)), 0)
16701: into
16702: l_level_seq
16703: from
16704: PJI_SYSTEM_PRC_STATUS
16705: where
16706: PROCESS_NAME = l_process and
16707: STEP_NAME like 'ROLLUP_FPR_PRG%' and
16708: STEP_STATUS is null;

Line 16772: PJI_SYSTEM_PRC_STATUS

16768: STEP_SEQ
16769: into
16770: l_step_seq
16771: from
16772: PJI_SYSTEM_PRC_STATUS
16773: where
16774: PROCESS_NAME = l_process and
16775: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);';
16776:

Line 16782: PJI_SYSTEM_PRC_STATUS

16778: count(*)
16779: into
16780: l_count
16781: from
16782: PJI_SYSTEM_PRC_STATUS
16783: where
16784: PROCESS_NAME = l_process and
16785: STEP_NAME like 'ROLLUP_ACR_PRG%';
16786:

Line 16803: insert into PJI_SYSTEM_PRC_STATUS

16799: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
16800: 'MAX_PROGRAM_LEVEL',
16801: l_level);
16802:
16803: insert into PJI_SYSTEM_PRC_STATUS
16804: (
16805: PROCESS_NAME,
16806: STEP_SEQ,
16807: STEP_STATUS,

Line 16866: PJI_SYSTEM_PRC_STATUS

16862: nvl(to_number(min(STEP_SEQ)), 0)
16863: into
16864: l_level_seq
16865: from
16866: PJI_SYSTEM_PRC_STATUS
16867: where
16868: PROCESS_NAME = l_process and
16869: STEP_NAME like 'ROLLUP_ACR_PRG%' and
16870: STEP_STATUS is null;

Line 16880: update PJI_SYSTEM_PRC_STATUS

16876: end if;
16877:
16878: while (l_level > 0) loop
16879:
16880: update PJI_SYSTEM_PRC_STATUS
16881: set START_DATE = sysdate
16882: where PROCESS_NAME = l_process and
16883: STEP_SEQ = l_level_seq;
16884:

Line 17231: update PJI_SYSTEM_PRC_STATUS

17227: 'N', 'Y')),
17228: pjp.CURR_RECORD_TYPE_ID,
17229: pjp.CURRENCY_CODE;*/
17230:
17231: update PJI_SYSTEM_PRC_STATUS
17232: set STEP_STATUS = 'C',
17233: END_DATE = sysdate
17234: where PROCESS_NAME = l_process and
17235: STEP_SEQ = l_level_seq;

Line 17244: PJI_SYSTEM_PRC_STATUS

17240: nvl(to_number(min(STEP_SEQ)), 0)
17241: into
17242: l_level_seq
17243: from
17244: PJI_SYSTEM_PRC_STATUS
17245: where
17246: PROCESS_NAME = l_process and
17247: STEP_NAME like 'ROLLUP_ACR_PRG%' and
17248: STEP_STATUS is null;