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_FM_CMT_EXTR dependencies on PJI_PROCESS_UTIL

Line 563: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

559: begin
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:

Line 568: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
569: (PJI_FM_SUM_MAIN.g_process,
570: 'EXTRACT_COMMITMENTS');
571:
572: select psi_ppr_flag into l_psi_ppr_flag from pji_system_settings; -- Added for bug 13889383

Line 575: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

571:
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;

Line 581: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

577: commit;
578: return;
579: end if;
580:
581: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
582: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');
583:
584: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
585: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');

Line 584: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

580:
581: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
582: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');
583:
584: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
585: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');
586:
587: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
588: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');

Line 587: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

583:
584: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
585: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');
586:
587: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
588: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');
589:
590: if (l_from_project is null) then
591:

Line 601: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

597: l_from_project
598: from
599: PA_PROJECTS_ALL prj
600: where
601: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
602: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT_ID');
603:
604: exception when no_data_found then null;
605:

Line 621: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

617: l_to_project
618: from
619: PA_PROJECTS_ALL prj
620: where
621: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
622: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT_ID');
623:
624: exception when no_data_found then null;
625:

Line 734: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

730: from
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:

Line 769: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

765: begin
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:

Line 774: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
775: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
776:
777: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
778: (PJI_FM_SUM_MAIN.g_process,

Line 777: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

773:
774: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
775: (PJI_FM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
776:
777: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
778: (PJI_FM_SUM_MAIN.g_process,
779: 'EXTRACT_COMMITMENTS');
780:
781: select psi_ppr_flag into l_psi_ppr_flag from pji_system_settings; -- Added for bug 13889383

Line 798: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

794: commit;
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:

Line 979: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded

975: l_helper_batch_id := -1;
976:
977: else
978:
979: PJI_PROCESS_UTIL.SLEEP(1); -- so the CPU is not bombarded
980:
981: end if;
982:
983: end if;

Line 999: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

995: end loop;
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:

Line 1023: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

1019: begin
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:

Line 1028: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
1029: (PJI_FM_SUM_MAIN.g_process,
1030: 'EXTRACT_COMMITMENTS');
1031:
1032: select psi_ppr_flag into l_psi_ppr_flag from pji_system_settings; -- Added for bug 13889383

Line 1035: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

1031:
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;

Line 1043: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

1039: end if;
1040:
1041: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1042:
1043: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1044: 'PJI_FM_EXTR_DREVN',
1045: 'NORMAL',
1046: null);
1047:

Line 1048: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

1044: 'PJI_FM_EXTR_DREVN',
1045: 'NORMAL',
1046: null);
1047:
1048: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1049: 'PJI_HELPER_BATCH_MAP',
1050: 'NORMAL',
1051: null);
1052:

Line 1053: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

1049: 'PJI_HELPER_BATCH_MAP',
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:

Line 1078: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,

1074: begin
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:

Line 1083: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
1084: (PJI_FM_SUM_MAIN.g_process,
1085: 'EXTRACT_COMMITMENTS');
1086:
1087: if (l_extract_commitments = 'N') then

Line 1088: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

1084: (PJI_FM_SUM_MAIN.g_process,
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;

Line 1095: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process, 'TRANSITION');

1091: return;
1092: end if;
1093:
1094: pji_utils.write2log('Entering FIN_CMT_SUMMARY');
1095: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
1096:
1097: if (l_transition_flag = 'Y') then
1098: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');
1099: else -- l_transition is null or 'N'

Line 1098: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');

1094: pji_utils.write2log('Entering FIN_CMT_SUMMARY');
1095: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
1096:
1097: if (l_transition_flag = 'Y') then
1098: l_params_cost_flag := nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_process,'CONFIG_COST_FLAG'), 'N');
1099: else -- l_transition is null or 'N'
1100: l_params_cost_flag := nvl(PJI_UTILS.GET_PARAMETER('CONFIG_COST_FLAG'), 'N');
1101: end if;
1102:

Line 1583: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,

1579: tmp1.EXPENDITURE_TYPE = et.EXPENDITURE_TYPE;
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: