DBA Data[Home] [Help]

APPS.PJI_FM_CMT_EXTR dependencies on PJI_FM_CMT_EXTR

Line 1: package body PJI_FM_CMT_EXTR as

1: package body PJI_FM_CMT_EXTR as
2: /* $Header: PJISF14B.pls 120.13.12020000.7 2013/05/20 07:35:26 krkondur ship $ */
3:
4: -- Procedure to accumulate the commitment txns.
5: -- This procedure is mainly used in PPR for customers using

Line 564: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);')) then

560:
561: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
562:
563: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
564: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);')) then
565: return;
566: end if;
567:
568: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 576: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);');

572: select psi_ppr_flag into l_psi_ppr_flag from pji_system_settings; -- Added for bug 13889383
573:
574: if (l_extract_commitments = 'N' or (l_extract_commitments = 'Y' and l_psi_ppr_flag = 'Y')) then -- Changes for bug 13889383
575: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
576: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);');
577: commit;
578: return;
579: end if;
580:

Line 735: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);');

731: PJI_FM_EXTR_DREVN -- overload of draft revenues table for cmt
732: );
733:
734: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
735: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);');
736:
737: commit;
738:
739: end REFRESH_PROJPERF_CMT_PRE;

Line 770: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);')) then

766:
767: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
768:
769: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
770: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);')) then
771: return;
772: end if;
773:
774: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 791: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and

787: update PJI_SYSTEM_PRC_STATUS
788: set STEP_STATUS = 'C'
789: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
790: STEP_NAME =
791: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and
792: START_DATE is null;
793:
794: commit;
795:

Line 799: (l_process, 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);');

795:
796: end loop;
797:
798: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
799: (l_process, 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);');
800:
801: commit;
802:
803: return;

Line 968: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and

964: update PJI_SYSTEM_PRC_STATUS
965: set STEP_STATUS = 'C'
966: where PROCESS_NAME like PJI_FM_SUM_MAIN.g_process || x and
967: STEP_NAME =
968: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);' and
969: START_DATE is null;
970:
971: commit;
972:

Line 1000: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);');

996:
997: if (l_helper_batch_id <> -2) then
998:
999: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
1000: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT(p_worker_id);');
1001:
1002: end if;
1003:
1004: commit;

Line 1024: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);')) then

1020:
1021: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1022:
1023: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
1024: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);')) then
1025: return;
1026: end if;
1027:
1028: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 1036: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);');

1032: select psi_ppr_flag into l_psi_ppr_flag from pji_system_settings; -- Added for bug 13889383
1033:
1034: if (l_extract_commitments = 'N' or (l_extract_commitments = 'Y' and l_psi_ppr_flag = 'Y')) then -- Changes for bug 13889383
1035: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
1036: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);');
1037: commit;
1038: return;
1039: end if;
1040:

Line 1054: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);');

1050: 'NORMAL',
1051: null);
1052:
1053: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
1054: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);');
1055:
1056: commit;
1057:
1058: end REFRESH_PROJPERF_CMT_POST;

Line 1079: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);')) then

1075:
1076: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1077:
1078: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
1079: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);')) then
1080: return;
1081: end if;
1082:
1083: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 1089: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);');

1085: 'EXTRACT_COMMITMENTS');
1086:
1087: if (l_extract_commitments = 'N') then
1088: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
1089: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);');
1090: commit;
1091: return;
1092: end if;
1093:

Line 1584: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);');

1580:
1581: pji_utils.write2log('Leaving FIN_CMT_SUMMARY');
1582:
1583: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
1584: 'PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);');
1585:
1586: commit;
1587:
1588: end FIN_CMT_SUMMARY;

Line 1590: end PJI_FM_CMT_EXTR;

1586: commit;
1587:
1588: end FIN_CMT_SUMMARY;
1589:
1590: end PJI_FM_CMT_EXTR;