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 7598: PJI_SYSTEM_PRC_STATUS

7594: STEP_SEQ
7595: into
7596: l_step_seq
7597: from
7598: PJI_SYSTEM_PRC_STATUS
7599: where
7600: PROCESS_NAME = l_process and
7601: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);';
7602:

Line 7608: PJI_SYSTEM_PRC_STATUS

7604: count(*)
7605: into
7606: l_count
7607: from
7608: PJI_SYSTEM_PRC_STATUS
7609: where
7610: PROCESS_NAME = l_process and
7611: STEP_NAME like 'ROLLUP_FPR_WBS%';
7612:

Line 7634: insert into PJI_SYSTEM_PRC_STATUS

7630: l_level);
7631:
7632: for x in 1 .. l_level loop
7633:
7634: insert into PJI_SYSTEM_PRC_STATUS
7635: (
7636: PROCESS_NAME,
7637: STEP_SEQ,
7638: STEP_STATUS,

Line 7665: PJI_SYSTEM_PRC_STATUS

7661: nvl(to_number(min(STEP_SEQ)), 0)
7662: into
7663: l_level_seq
7664: from
7665: PJI_SYSTEM_PRC_STATUS
7666: where
7667: PROCESS_NAME = l_process and
7668: STEP_NAME like 'ROLLUP_FPR_WBS%' and
7669: STEP_STATUS is null;

Line 7679: update PJI_SYSTEM_PRC_STATUS

7675: end if;
7676:
7677: while (l_level > 0) loop
7678:
7679: update PJI_SYSTEM_PRC_STATUS
7680: set START_DATE = sysdate
7681: where PROCESS_NAME = l_process and
7682: STEP_SEQ = l_level_seq;
7683:

Line 9001: update PJI_SYSTEM_PRC_STATUS

8997: (pjp1_i.SUP_ID is not null and
8998: (sup_fin_ver.PROJECT_ID is not null or
8999: sup_wpa.PROJ_ELEMENT_ID is not null)));
9000:
9001: update PJI_SYSTEM_PRC_STATUS
9002: set STEP_STATUS = 'C',
9003: END_DATE = sysdate
9004: where PROCESS_NAME = l_process and
9005: STEP_SEQ = l_level_seq;

Line 9014: PJI_SYSTEM_PRC_STATUS

9010: nvl(to_number(min(STEP_SEQ)), 0)
9011: into
9012: l_level_seq
9013: from
9014: PJI_SYSTEM_PRC_STATUS
9015: where
9016: PROCESS_NAME = l_process and
9017: STEP_NAME like 'ROLLUP_FPR_WBS%' and
9018: STEP_STATUS is null;

Line 12065: PJI_SYSTEM_PRC_STATUS

12061: STEP_SEQ
12062: into
12063: l_step_seq
12064: from
12065: PJI_SYSTEM_PRC_STATUS
12066: where
12067: PROCESS_NAME = l_process and
12068: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);';
12069:

Line 12075: PJI_SYSTEM_PRC_STATUS

12071: count(*)
12072: into
12073: l_count
12074: from
12075: PJI_SYSTEM_PRC_STATUS
12076: where
12077: PROCESS_NAME = l_process and
12078: STEP_NAME like 'ROLLUP_ACR_WBS%';
12079:

Line 12101: insert into PJI_SYSTEM_PRC_STATUS

12097: l_level);
12098:
12099: for x in 1 .. l_level loop
12100:
12101: insert into PJI_SYSTEM_PRC_STATUS
12102: (
12103: PROCESS_NAME,
12104: STEP_SEQ,
12105: STEP_STATUS,

Line 12132: PJI_SYSTEM_PRC_STATUS

12128: nvl(to_number(min(STEP_SEQ)), 0)
12129: into
12130: l_level_seq
12131: from
12132: PJI_SYSTEM_PRC_STATUS
12133: where
12134: PROCESS_NAME = l_process and
12135: STEP_NAME like 'ROLLUP_ACR_WBS%' and
12136: STEP_STATUS is null;

Line 12146: update PJI_SYSTEM_PRC_STATUS

12142: end if;
12143:
12144: while (l_level > 0) loop
12145:
12146: update PJI_SYSTEM_PRC_STATUS
12147: set START_DATE = sysdate
12148: where PROCESS_NAME = l_process and
12149: STEP_SEQ = l_level_seq;
12150:

Line 12732: update PJI_SYSTEM_PRC_STATUS

12728: (pjp1_i.SUP_ID is not null and
12729: (sup_fin_ver.PROJECT_ID is not null or
12730: sup_wpa.PROJ_ELEMENT_ID is not null)));
12731:
12732: update PJI_SYSTEM_PRC_STATUS
12733: set STEP_STATUS = 'C',
12734: END_DATE = sysdate
12735: where PROCESS_NAME = l_process and
12736: STEP_SEQ = l_level_seq;

Line 12745: PJI_SYSTEM_PRC_STATUS

12741: nvl(to_number(min(STEP_SEQ)), 0)
12742: into
12743: l_level_seq
12744: from
12745: PJI_SYSTEM_PRC_STATUS
12746: where
12747: PROCESS_NAME = l_process and
12748: STEP_NAME like 'ROLLUP_ACR_WBS%' and
12749: STEP_STATUS is null;

Line 13410: PJI_SYSTEM_PRC_STATUS

13406: STEP_SEQ
13407: into
13408: l_step_seq
13409: from
13410: PJI_SYSTEM_PRC_STATUS
13411: where
13412: PROCESS_NAME = l_process and
13413: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);';
13414:

Line 13420: PJI_SYSTEM_PRC_STATUS

13416: count(*)
13417: into
13418: l_count
13419: from
13420: PJI_SYSTEM_PRC_STATUS
13421: where
13422: PROCESS_NAME = l_process and
13423: STEP_NAME like 'ROLLUP_FPR_PRG%';
13424:

Line 13441: insert into PJI_SYSTEM_PRC_STATUS

13437: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
13438: 'MAX_PROGRAM_LEVEL',
13439: l_level);
13440:
13441: insert into PJI_SYSTEM_PRC_STATUS
13442: (
13443: PROCESS_NAME,
13444: STEP_SEQ,
13445: STEP_STATUS,

Line 13504: PJI_SYSTEM_PRC_STATUS

13500: nvl(to_number(min(STEP_SEQ)), 0)
13501: into
13502: l_level_seq
13503: from
13504: PJI_SYSTEM_PRC_STATUS
13505: where
13506: PROCESS_NAME = l_process and
13507: STEP_NAME like 'ROLLUP_FPR_PRG%' and
13508: STEP_STATUS is null;

Line 13518: update PJI_SYSTEM_PRC_STATUS

13514: end if;
13515:
13516: while (l_level > 0) loop
13517:
13518: update PJI_SYSTEM_PRC_STATUS
13519: set START_DATE = sysdate
13520: where PROCESS_NAME = l_process and
13521: STEP_SEQ = l_level_seq;
13522:

Line 14567: update PJI_SYSTEM_PRC_STATUS

14563: pjp.PLAN_VERSION_ID,
14564: pjp.PLAN_TYPE_ID,
14565: pjp.PLAN_TYPE_CODE;
14566:
14567: update PJI_SYSTEM_PRC_STATUS
14568: set STEP_STATUS = 'C',
14569: END_DATE = sysdate
14570: where PROCESS_NAME = l_process and
14571: STEP_SEQ = l_level_seq;

Line 14580: PJI_SYSTEM_PRC_STATUS

14576: nvl(to_number(min(STEP_SEQ)), 0)
14577: into
14578: l_level_seq
14579: from
14580: PJI_SYSTEM_PRC_STATUS
14581: where
14582: PROCESS_NAME = l_process and
14583: STEP_NAME like 'ROLLUP_FPR_PRG%' and
14584: STEP_STATUS is null;

Line 14648: PJI_SYSTEM_PRC_STATUS

14644: STEP_SEQ
14645: into
14646: l_step_seq
14647: from
14648: PJI_SYSTEM_PRC_STATUS
14649: where
14650: PROCESS_NAME = l_process and
14651: STEP_NAME = 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);';
14652:

Line 14658: PJI_SYSTEM_PRC_STATUS

14654: count(*)
14655: into
14656: l_count
14657: from
14658: PJI_SYSTEM_PRC_STATUS
14659: where
14660: PROCESS_NAME = l_process and
14661: STEP_NAME like 'ROLLUP_ACR_PRG%';
14662:

Line 14679: insert into PJI_SYSTEM_PRC_STATUS

14675: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
14676: 'MAX_PROGRAM_LEVEL',
14677: l_level);
14678:
14679: insert into PJI_SYSTEM_PRC_STATUS
14680: (
14681: PROCESS_NAME,
14682: STEP_SEQ,
14683: STEP_STATUS,

Line 14742: PJI_SYSTEM_PRC_STATUS

14738: nvl(to_number(min(STEP_SEQ)), 0)
14739: into
14740: l_level_seq
14741: from
14742: PJI_SYSTEM_PRC_STATUS
14743: where
14744: PROCESS_NAME = l_process and
14745: STEP_NAME like 'ROLLUP_ACR_PRG%' and
14746: STEP_STATUS is null;

Line 14756: update PJI_SYSTEM_PRC_STATUS

14752: end if;
14753:
14754: while (l_level > 0) loop
14755:
14756: update PJI_SYSTEM_PRC_STATUS
14757: set START_DATE = sysdate
14758: where PROCESS_NAME = l_process and
14759: STEP_SEQ = l_level_seq;
14760:

Line 15102: update PJI_SYSTEM_PRC_STATUS

15098: 'N', 'Y')),
15099: pjp.CURR_RECORD_TYPE_ID,
15100: pjp.CURRENCY_CODE;
15101:
15102: update PJI_SYSTEM_PRC_STATUS
15103: set STEP_STATUS = 'C',
15104: END_DATE = sysdate
15105: where PROCESS_NAME = l_process and
15106: STEP_SEQ = l_level_seq;

Line 15115: PJI_SYSTEM_PRC_STATUS

15111: nvl(to_number(min(STEP_SEQ)), 0)
15112: into
15113: l_level_seq
15114: from
15115: PJI_SYSTEM_PRC_STATUS
15116: where
15117: PROCESS_NAME = l_process and
15118: STEP_NAME like 'ROLLUP_ACR_PRG%' and
15119: STEP_STATUS is null;