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_PROCESS_UTIL

Line 24: l_request_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

20: begin
21:
22: l_process := g_process || p_worker_id;
23:
24: l_request_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
25: l_process);
26:
27: if (PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
28: l_request_id,

Line 27: if (PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,

23:
24: l_request_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
25: l_process);
26:
27: if (PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
28: l_request_id,
29: g_full_disp_name) or
30: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
31: l_request_id,

Line 30: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,

26:
27: if (PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
28: l_request_id,
29: g_full_disp_name) or
30: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
31: l_request_id,
32: g_incr_disp_name) or
33: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
34: l_request_id,

Line 33: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,

29: g_full_disp_name) or
30: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
31: l_request_id,
32: g_incr_disp_name) or
33: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
34: l_request_id,
35: g_prtl_disp_name) or
36: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
37: l_request_id,

Line 36: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,

32: g_incr_disp_name) or
33: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
34: l_request_id,
35: g_prtl_disp_name) or
36: PJI_PROCESS_UTIL.REQUEST_STATUS(p_mode,
37: l_request_id,
38: g_rbs_disp_name)) then
39:
40: return true;

Line 104: l_e_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

100:
101: begin
102: l_e_process := g_process || p_worker_id;
103:
104: l_e_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
105: (l_e_process, 'EXTRACTION_TYPE');
106:
107: If PJI_PJP_SUM_MAIN.WORKER_STATUS(p_worker_id, 'RUNNING') then
108:

Line 111: select PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER (l_e_process,l_e_process),

107: If PJI_PJP_SUM_MAIN.WORKER_STATUS(p_worker_id, 'RUNNING') then
108:
109: -- Means its already running so get the request id and wait to complete that request
110:
111: select PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER (l_e_process,l_e_process),
112: DECODE(l_e_extraction_type,'PARTIAL',g_prtl_disp_name,'RBS',g_rbs_disp_name,NULL,NULL,g_incr_disp_name)
113: into p_request_id,p_prog_name
114: from dual;
115:

Line 120: l_e_project_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

116: else
117:
118: -- Need to submit the existing failed worker request
119:
120: l_e_project_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
121: (l_e_process, 'PROJECT_OPERATING_UNIT');
122:
123: l_e_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
124: (l_e_process, 'PROJECT_ORGANIZATION_ID');

Line 123: l_e_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

119:
120: l_e_project_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
121: (l_e_process, 'PROJECT_OPERATING_UNIT');
122:
123: l_e_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
124: (l_e_process, 'PROJECT_ORGANIZATION_ID');
125:
126: l_e_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
127: (l_e_process, 'PROJECT_TYPE');

Line 126: l_e_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

122:
123: l_e_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
124: (l_e_process, 'PROJECT_ORGANIZATION_ID');
125:
126: l_e_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
127: (l_e_process, 'PROJECT_TYPE');
128:
129: l_e_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
130: (l_e_process, 'FROM_PROJECT');

Line 129: l_e_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

125:
126: l_e_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
127: (l_e_process, 'PROJECT_TYPE');
128:
129: l_e_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
130: (l_e_process, 'FROM_PROJECT');
131:
132: l_e_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
133: (l_e_process, 'TO_PROJECT');

Line 132: l_e_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

128:
129: l_e_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
130: (l_e_process, 'FROM_PROJECT');
131:
132: l_e_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
133: (l_e_process, 'TO_PROJECT');
134:
135: l_e_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
136: (l_e_process, 'PLAN_TYPE_ID');

Line 135: l_e_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

131:
132: l_e_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
133: (l_e_process, 'TO_PROJECT');
134:
135: l_e_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
136: (l_e_process, 'PLAN_TYPE_ID');
137:
138: l_e_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
139: (l_e_process, 'RBS_HEADER_ID');

Line 138: l_e_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

134:
135: l_e_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
136: (l_e_process, 'PLAN_TYPE_ID');
137:
138: l_e_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
139: (l_e_process, 'RBS_HEADER_ID');
140:
141: l_e_transaction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
142: (l_e_process, 'TRANSACTION_TYPE');

Line 141: l_e_transaction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

137:
138: l_e_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
139: (l_e_process, 'RBS_HEADER_ID');
140:
141: l_e_transaction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
142: (l_e_process, 'TRANSACTION_TYPE');
143:
144: l_e_plan_versions := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
145: (l_e_process, 'PLAN_VERSION');

Line 144: l_e_plan_versions := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

140:
141: l_e_transaction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
142: (l_e_process, 'TRANSACTION_TYPE');
143:
144: l_e_plan_versions := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
145: (l_e_process, 'PLAN_VERSION');
146:
147: SELECT
148: DECODE(l_e_extraction_type,'PARTIAL','P','RBS','R',NULL,NULL,'I'),

Line 419: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

415: for x in 1 .. PJI_PJP_SUM_MAIN.g_parallel_processes loop
416:
417: l_process := PJI_PJP_SUM_MAIN.g_process || x;
418:
419: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
420: (l_process, 'EXTRACTION_TYPE');
421:
422: if (l_extraction_type is not null and
423: not PJI_PJP_SUM_MAIN.WORKER_STATUS(x, 'RUNNING')) then

Line 476: l_request_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

472: l_newline);
473:
474: if (l_extraction_type in ('FULL', 'INCREMENTAL', 'PARTIAL')) then
475:
476: l_request_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
477: (l_process, l_process);
478:
479: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_REQ_ID');
480:

Line 495: l_project_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

491:
492:
493: if (l_extraction_type in ('FULL', 'INCREMENTAL', 'PARTIAL')) then
494:
495: l_project_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
496: (l_process, 'PROJECT_OPERATING_UNIT');
497:
498: if (nvl(l_project_operating_unit, -1) = -1) then
499:

Line 526: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

522: end if;
523:
524: if (l_extraction_type in ('FULL', 'INCREMENTAL')) then
525:
526: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
527: (l_process, 'PROJECT_TYPE');
528:
529: if (nvl(l_project_type, 'PJI$NULL') = 'PJI$NULL') then
530:

Line 549: l_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

545: end if;
546:
547: if (l_extraction_type in ('FULL', 'INCREMENTAL')) then
548:
549: l_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
550: (l_process, 'PROJECT_ORGANIZATION_ID');
551:
552: if (nvl(l_project_organization_id, -1) = -1) then
553:

Line 580: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

576: end if;
577:
578: if (l_extraction_type in ('FULL', 'INCREMENTAL', 'PARTIAL')) then
579:
580: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
581: (l_process, 'FROM_PROJECT');
582:
583: if (nvl(l_from_project, 'PJI$NULL') = 'PJI$NULL') then
584:

Line 603: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

599: end if;
600:
601: if (l_extraction_type in ('FULL', 'INCREMENTAL', 'PARTIAL')) then
602:
603: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
604: (l_process, 'TO_PROJECT');
605:
606: if (nvl(l_to_project, 'PJI$NULL') = 'PJI$NULL') then
607:

Line 626: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

622: end if;
623:
624: if (l_extraction_type in ('PARTIAL')) then
625:
626: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
627: (l_process, 'PLAN_TYPE_ID');
628:
629: if (nvl(l_plan_type_id, -1) = -1) then
630:

Line 656: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

652: end if;
653:
654: if (l_extraction_type in ('RBS')) then
655:
656: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
657: (l_process, 'RBS_HEADER_ID');
658:
659: if (nvl(l_rbs_header_id, -1) = -1) then
660:

Line 686: l_transaction_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

682: end if;
683:
684: if (l_extraction_type in ('PARTIAL')) then -- Bug#5099574 Start
685:
686: l_transaction_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
687: (l_process, 'TRANSACTION_TYPE');
688:
689: l_plan_versions_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
690: (l_process, 'PLAN_VERSION');

Line 689: l_plan_versions_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

685:
686: l_transaction_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
687: (l_process, 'TRANSACTION_TYPE');
688:
689: l_plan_versions_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
690: (l_process, 'PLAN_VERSION');
691:
692: if (nvl(l_transaction_type_id, 'PJI$NULL') = 'PJI$NULL') then
693:

Line 746: l_only_pt_projects := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

742: end if; -- Bug#5099574 Ends
743:
744: if (l_extraction_type in ('FULL', 'INCREMENTAL') and 1 = 2) then
745:
746: l_only_pt_projects := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
747: (l_process, 'ONLY_PT_PROJECTS_FLAG');
748:
749: if (nvl(l_only_pt_projects, 'PJI$NULL') = 'PJI$NULL') then
750:

Line 2864: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'PRELOAD');

2860: l_worker_id := l_worker_id + 1;
2861:
2862: l_process := g_process || l_worker_id;
2863:
2864: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'PRELOAD');
2865:
2866: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2867: (l_process, l_process) is null) then
2868:

Line 2866: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2862: l_process := g_process || l_worker_id;
2863:
2864: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'PRELOAD');
2865:
2866: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2867: (l_process, l_process) is null) then
2868:
2869: if (p_worker_id = 0) then
2870: p_worker_id := l_worker_id;

Line 2875: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2871: end if;
2872:
2873: elsif (not PJI_PJP_SUM_MAIN.WORKER_STATUS(l_worker_id, 'RUNNING') and
2874: ((l_extraction_type = 'FULL' and
2875: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2876: (l_process, 'EXTRACTION_TYPE') = 'FULL') or
2877: (l_extraction_type = 'INCREMENTAL' and
2878: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2879: (l_process, 'EXTRACTION_TYPE') = 'FULL') or

Line 2878: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2874: ((l_extraction_type = 'FULL' and
2875: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2876: (l_process, 'EXTRACTION_TYPE') = 'FULL') or
2877: (l_extraction_type = 'INCREMENTAL' and
2878: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2879: (l_process, 'EXTRACTION_TYPE') = 'FULL') or
2880: (l_extraction_type = 'INCREMENTAL' and
2881: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2882: (l_process, 'EXTRACTION_TYPE') = 'INCREMENTAL') or

Line 2881: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2877: (l_extraction_type = 'INCREMENTAL' and
2878: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2879: (l_process, 'EXTRACTION_TYPE') = 'FULL') or
2880: (l_extraction_type = 'INCREMENTAL' and
2881: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2882: (l_process, 'EXTRACTION_TYPE') = 'INCREMENTAL') or
2883: (l_extraction_type = 'PARTIAL' and
2884: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2885: (l_process, 'EXTRACTION_TYPE') = 'PARTIAL') or

Line 2884: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2880: (l_extraction_type = 'INCREMENTAL' and
2881: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2882: (l_process, 'EXTRACTION_TYPE') = 'INCREMENTAL') or
2883: (l_extraction_type = 'PARTIAL' and
2884: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2885: (l_process, 'EXTRACTION_TYPE') = 'PARTIAL') or
2886: (l_extraction_type = 'RBS' and
2887: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2888: (l_process, 'EXTRACTION_TYPE') = 'RBS')) and

Line 2887: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2883: (l_extraction_type = 'PARTIAL' and
2884: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2885: (l_process, 'EXTRACTION_TYPE') = 'PARTIAL') or
2886: (l_extraction_type = 'RBS' and
2887: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2888: (l_process, 'EXTRACTION_TYPE') = 'RBS')) and
2889: nvl(p_operating_unit, -1) =
2890: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2891: 'PROJECT_OPERATING_UNIT') and

Line 2890: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2886: (l_extraction_type = 'RBS' and
2887: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2888: (l_process, 'EXTRACTION_TYPE') = 'RBS')) and
2889: nvl(p_operating_unit, -1) =
2890: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2891: 'PROJECT_OPERATING_UNIT') and
2892: nvl(p_project_type, 'PJI$NULL') =
2893: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2894: 'PROJECT_TYPE') and

Line 2893: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2889: nvl(p_operating_unit, -1) =
2890: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2891: 'PROJECT_OPERATING_UNIT') and
2892: nvl(p_project_type, 'PJI$NULL') =
2893: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2894: 'PROJECT_TYPE') and
2895: nvl(p_project_organization_id, -1) =
2896: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2897: 'PROJECT_ORGANIZATION_ID') and

Line 2896: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2892: nvl(p_project_type, 'PJI$NULL') =
2893: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2894: 'PROJECT_TYPE') and
2895: nvl(p_project_organization_id, -1) =
2896: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2897: 'PROJECT_ORGANIZATION_ID') and
2898: nvl(p_from_project, 'PJI$NULL') =
2899: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2900: 'FROM_PROJECT') and

Line 2899: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2895: nvl(p_project_organization_id, -1) =
2896: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2897: 'PROJECT_ORGANIZATION_ID') and
2898: nvl(p_from_project, 'PJI$NULL') =
2899: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2900: 'FROM_PROJECT') and
2901: nvl(p_to_project, 'PJI$NULL') =
2902: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2903: 'TO_PROJECT') and

Line 2902: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2898: nvl(p_from_project, 'PJI$NULL') =
2899: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2900: 'FROM_PROJECT') and
2901: nvl(p_to_project, 'PJI$NULL') =
2902: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2903: 'TO_PROJECT') and
2904: nvl(p_plan_type_id, -1) =
2905: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2906: 'PLAN_TYPE_ID') and

Line 2905: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2901: nvl(p_to_project, 'PJI$NULL') =
2902: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2903: 'TO_PROJECT') and
2904: nvl(p_plan_type_id, -1) =
2905: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2906: 'PLAN_TYPE_ID') and
2907: nvl(p_rbs_header_id, -1) =
2908: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2909: 'RBS_HEADER_ID') and

Line 2908: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2904: nvl(p_plan_type_id, -1) =
2905: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2906: 'PLAN_TYPE_ID') and
2907: nvl(p_rbs_header_id, -1) =
2908: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2909: 'RBS_HEADER_ID') and
2910: nvl(p_transaction_type, 'PJI$NULL') =
2911: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2912: 'TRANSACTION_TYPE') and

Line 2911: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574

2907: nvl(p_rbs_header_id, -1) =
2908: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2909: 'RBS_HEADER_ID') and
2910: nvl(p_transaction_type, 'PJI$NULL') =
2911: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2912: 'TRANSACTION_TYPE') and
2913: nvl(p_plan_versions, 'PJI$NULL') =
2914: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2915: 'PLAN_VERSION') and

Line 2914: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574

2910: nvl(p_transaction_type, 'PJI$NULL') =
2911: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2912: 'TRANSACTION_TYPE') and
2913: nvl(p_plan_versions, 'PJI$NULL') =
2914: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2915: 'PLAN_VERSION') and
2916: nvl(p_only_pt_projects_flag, 'PJI$NULL') =
2917: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2918: 'ONLY_PT_PROJECTS_FLAG')) then

Line 2917: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2913: nvl(p_plan_versions, 'PJI$NULL') =
2914: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2915: 'PLAN_VERSION') and
2916: nvl(p_only_pt_projects_flag, 'PJI$NULL') =
2917: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2918: 'ONLY_PT_PROJECTS_FLAG')) then
2919:
2920: p_worker_id := l_worker_id;
2921: l_existing_worker := 'Y'; -- To check the resubmit of failed run Bug 5057835

Line 2922: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2918: 'ONLY_PT_PROJECTS_FLAG')) then
2919:
2920: p_worker_id := l_worker_id;
2921: l_existing_worker := 'Y'; -- To check the resubmit of failed run Bug 5057835
2922: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2923: 'EXTRACTION_TYPE')
2924: = 'PARTIAL') then
2925: l_type := 1;
2926: l_incomplete_partial_count := l_incomplete_partial_count + 1;

Line 2934: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2930: end if;
2931:
2932: elsif (not PJI_PJP_SUM_MAIN.WORKER_STATUS(l_worker_id, 'RUNNING')) then
2933:
2934: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2935: 'EXTRACTION_TYPE')
2936: = 'PARTIAL') then
2937: l_incomplete_partial_count := l_incomplete_partial_count + 1;
2938: else

Line 2962: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, l_process,

2958: end if;
2959:
2960: l_process := g_process || p_worker_id;
2961:
2962: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, l_process,
2963: FND_GLOBAL.CONC_REQUEST_ID);
2964:
2965: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);
2966:

Line 2967: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y');

2963: FND_GLOBAL.CONC_REQUEST_ID);
2964:
2965: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);
2966:
2967: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y');
2968: -- Putting this insert here, Config Hist in case of resubmit of failed run Bug 5057835
2969: insert into PJI_SYSTEM_CONFIG_HIST
2970: (
2971: REQUEST_ID,

Line 3012: (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);')) then

3008: dual;
3009:
3010: -- If this is the resubmit of already existing failed run then Bug 5057835
3011: if l_existing_worker = 'Y' and
3012: (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);')) then
3013: commit; -- To release lock/ stamp parameters / config hist
3014: return;
3015: end if;
3016:

Line 3017: PJI_PROCESS_UTIL.REFRESH_STEP_TABLE;

3013: commit; -- To release lock/ stamp parameters / config hist
3014: return;
3015: end if;
3016:
3017: PJI_PROCESS_UTIL.REFRESH_STEP_TABLE;
3018:
3019: savepoint no_need_to_run_step; --Bug#5171542 Moving up, preload should not set when rollback
3020:
3021: if (p_run_mode = 'NO_PRELOAD') then

Line 3022: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PRELOAD', 'N');

3018:
3019: savepoint no_need_to_run_step; --Bug#5171542 Moving up, preload should not set when rollback
3020:
3021: if (p_run_mode = 'NO_PRELOAD') then
3022: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PRELOAD', 'N');
3023: end if;
3024:
3025: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
3026:

Line 3025: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');

3021: if (p_run_mode = 'NO_PRELOAD') then
3022: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PRELOAD', 'N');
3023: end if;
3024:
3025: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
3026:
3027: PJI_PJP_EXTRACTION_UTILS.UPDATE_EXTR_SCOPE;
3028:
3029: -- Moving down the query for l_rbs_ for the stamping of parameters Bug 5057835

Line 3392: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3388: end;
3389:
3390:
3391: if( l_extraction_type = 'FULL' ) then
3392: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3393: 'PRELOAD',
3394: 'Y');
3395:
3396: end if;

Line 3402: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3398:
3399:
3400: end if;
3401: -- Code for delete moved down Bug 5057835
3402: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3403: 'EXTRACTION_TYPE',
3404: l_extraction_type);
3405:
3406:

Line 3407: PJI_PROCESS_UTIL.ADD_STEPS(l_process, 'PJI_PJP', l_extraction_type);

3403: 'EXTRACTION_TYPE',
3404: l_extraction_type);
3405:
3406:
3407: PJI_PROCESS_UTIL.ADD_STEPS(l_process, 'PJI_PJP', l_extraction_type);
3408:
3409:
3410: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);')) then
3411: rollback to no_need_to_run_step;

Line 3410: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);')) then

3406:
3407: PJI_PROCESS_UTIL.ADD_STEPS(l_process, 'PJI_PJP', l_extraction_type);
3408:
3409:
3410: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);')) then
3411: rollback to no_need_to_run_step;
3412: Commit; -- To release lock/ stamp parameters / config hist
3413: return;
3414: end if;

Line 3438: -- IF PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER( g_process || c.WORKER_ID, 'EXTRACTION_TYPE')<> 'RBS' THEN

3434: prog_name_table.EXTEND;
3435: -- SUBMIT_REQUEST should check if the request is already running and
3436: -- just return the request id and program name if it is.
3437:
3438: -- IF PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER( g_process || c.WORKER_ID, 'EXTRACTION_TYPE')<> 'RBS' THEN
3439:
3440: SUBMIT_REQUEST(c.WORKER_ID, -- to retrieve the parameters
3441: request_id_table(l_count), -- in / out
3442: prog_name_table(l_count) -- in / out

Line 3456: PJI_PROCESS_UTIL.WAIT_FOR_REQUEST(request_id_table(i), 10);

3452:
3453: for i in 1..l_count loop
3454: if request_id_table(i) <> -1 then
3455: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);
3456: PJI_PROCESS_UTIL.WAIT_FOR_REQUEST(request_id_table(i), 10);
3457:
3458: if (not PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
3459: request_id_table(i),
3460: prog_name_table(i))) then

Line 3458: if (not PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',

3454: if request_id_table(i) <> -1 then
3455: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);
3456: PJI_PROCESS_UTIL.WAIT_FOR_REQUEST(request_id_table(i), 10);
3457:
3458: if (not PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
3459: request_id_table(i),
3460: prog_name_table(i))) then
3461:
3462: -- We may want to add, to the error message, the request

Line 3550: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE') = 'PARTIAL') then

3546:
3547:
3548: -- Bug#5099574 - Changes for Partial Refresh - Start - Populating the Refresh Code
3549:
3550: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE') = 'PARTIAL') then
3551:
3552: -- If p_transaction_type is null then l_refresh_code is set to 63 . So All Actuals and Plans get refreshed
3553: -- This change is done to make sure the code is compatible with R12 Code Bug# 5453009
3554:

Line 3598: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3594:
3595: end if;
3596:
3597:
3598: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3599: (l_process, 'PROJECT_TYPE', nvl(p_project_type, 'PJI$NULL'));
3600: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3601: (l_process, 'PROJECT_OPERATING_UNIT', nvl(p_operating_unit, -1));
3602: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3600: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3596:
3597:
3598: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3599: (l_process, 'PROJECT_TYPE', nvl(p_project_type, 'PJI$NULL'));
3600: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3601: (l_process, 'PROJECT_OPERATING_UNIT', nvl(p_operating_unit, -1));
3602: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3603: (l_process,
3604: 'PROJECT_ORGANIZATION_ID', nvl(p_project_organization_id, -1));

Line 3602: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3598: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3599: (l_process, 'PROJECT_TYPE', nvl(p_project_type, 'PJI$NULL'));
3600: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3601: (l_process, 'PROJECT_OPERATING_UNIT', nvl(p_operating_unit, -1));
3602: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3603: (l_process,
3604: 'PROJECT_ORGANIZATION_ID', nvl(p_project_organization_id, -1));
3605: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3606: (l_process, 'FROM_PROJECT', nvl(p_from_project, 'PJI$NULL'));

Line 3605: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3601: (l_process, 'PROJECT_OPERATING_UNIT', nvl(p_operating_unit, -1));
3602: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3603: (l_process,
3604: 'PROJECT_ORGANIZATION_ID', nvl(p_project_organization_id, -1));
3605: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3606: (l_process, 'FROM_PROJECT', nvl(p_from_project, 'PJI$NULL'));
3607: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3608: (l_process, 'TO_PROJECT', nvl(p_to_project, 'PJI$NULL'));
3609: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3607: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3603: (l_process,
3604: 'PROJECT_ORGANIZATION_ID', nvl(p_project_organization_id, -1));
3605: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3606: (l_process, 'FROM_PROJECT', nvl(p_from_project, 'PJI$NULL'));
3607: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3608: (l_process, 'TO_PROJECT', nvl(p_to_project, 'PJI$NULL'));
3609: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3610: (l_process, 'FROM_PROJECT_ID', nvl(p_from_project_id, -1));
3611: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3609: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3605: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3606: (l_process, 'FROM_PROJECT', nvl(p_from_project, 'PJI$NULL'));
3607: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3608: (l_process, 'TO_PROJECT', nvl(p_to_project, 'PJI$NULL'));
3609: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3610: (l_process, 'FROM_PROJECT_ID', nvl(p_from_project_id, -1));
3611: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3612: (l_process, 'TO_PROJECT_ID', nvl(p_to_project_id, -1));
3613: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3611: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3607: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3608: (l_process, 'TO_PROJECT', nvl(p_to_project, 'PJI$NULL'));
3609: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3610: (l_process, 'FROM_PROJECT_ID', nvl(p_from_project_id, -1));
3611: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3612: (l_process, 'TO_PROJECT_ID', nvl(p_to_project_id, -1));
3613: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3614: (l_process, 'PLAN_TYPE_ID', nvl(p_plan_type_id, -1));
3615: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3613: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3609: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3610: (l_process, 'FROM_PROJECT_ID', nvl(p_from_project_id, -1));
3611: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3612: (l_process, 'TO_PROJECT_ID', nvl(p_to_project_id, -1));
3613: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3614: (l_process, 'PLAN_TYPE_ID', nvl(p_plan_type_id, -1));
3615: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3616: (l_process, 'RBS_HEADER_ID', nvl(p_rbs_header_id, -1));
3617: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3615: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3611: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3612: (l_process, 'TO_PROJECT_ID', nvl(p_to_project_id, -1));
3613: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3614: (l_process, 'PLAN_TYPE_ID', nvl(p_plan_type_id, -1));
3615: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3616: (l_process, 'RBS_HEADER_ID', nvl(p_rbs_header_id, -1));
3617: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3618: (l_process, 'RBS_VERSION_ID', nvl(l_rbs_version_id, -1));
3619: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3617: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3613: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3614: (l_process, 'PLAN_TYPE_ID', nvl(p_plan_type_id, -1));
3615: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3616: (l_process, 'RBS_HEADER_ID', nvl(p_rbs_header_id, -1));
3617: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3618: (l_process, 'RBS_VERSION_ID', nvl(l_rbs_version_id, -1));
3619: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3620: (l_process,
3621: 'ONLY_PT_PROJECTS_FLAG', nvl(p_only_pt_projects_flag, 'PJI$NULL'));

Line 3619: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3615: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3616: (l_process, 'RBS_HEADER_ID', nvl(p_rbs_header_id, -1));
3617: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3618: (l_process, 'RBS_VERSION_ID', nvl(l_rbs_version_id, -1));
3619: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3620: (l_process,
3621: 'ONLY_PT_PROJECTS_FLAG', nvl(p_only_pt_projects_flag, 'PJI$NULL'));
3622:
3623: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3623: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3619: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3620: (l_process,
3621: 'ONLY_PT_PROJECTS_FLAG', nvl(p_only_pt_projects_flag, 'PJI$NULL'));
3622:
3623: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3624: (l_process,
3625: 'TRANSACTION_TYPE', nvl(p_transaction_type, 'PJI$NULL'));
3626: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3627: (l_process,

Line 3626: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3622:
3623: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3624: (l_process,
3625: 'TRANSACTION_TYPE', nvl(p_transaction_type, 'PJI$NULL'));
3626: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3627: (l_process,
3628: 'PLAN_VERSION', nvl(p_plan_versions, 'PJI$NULL'));
3629:
3630:

Line 3632: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3628: 'PLAN_VERSION', nvl(p_plan_versions, 'PJI$NULL'));
3629:
3630:
3631: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then
3632: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3633: 'PA_CALENDAR_FLAG',
3634: 'N');
3635: else
3636: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

Line 3636: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3632: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3633: 'PA_CALENDAR_FLAG',
3634: 'N');
3635: else
3636: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3637: 'PA_CALENDAR_FLAG',
3638: 'Y');
3639: end if;
3640:

Line 3642: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3638: 'Y');
3639: end if;
3640:
3641: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'N') then
3642: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3643: 'GL_CALENDAR_FLAG',
3644: 'N');
3645: else
3646: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

Line 3646: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3642: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3643: 'GL_CALENDAR_FLAG',
3644: 'N');
3645: else
3646: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3647: 'GL_CALENDAR_FLAG',
3648: 'Y');
3649: end if;
3650:

Line 3654: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE') = 'PARTIAL') then

3650:
3651: -- Bug#5099574 - Changes for Partial Refresh - Start - setting up the global process parameters
3652:
3653:
3654: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE') = 'PARTIAL') then
3655: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3656: (l_process,
3657: 'REFRESH_CODE', nvl(l_refresh_code, -1));
3658: end if;

Line 3655: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3651: -- Bug#5099574 - Changes for Partial Refresh - Start - setting up the global process parameters
3652:
3653:
3654: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE') = 'PARTIAL') then
3655: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3656: (l_process,
3657: 'REFRESH_CODE', nvl(l_refresh_code, -1));
3658: end if;
3659:

Line 3662: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3658: end if;
3659:
3660: -- Bug#5099574 - Changes for Partial Refresh - End -
3661:
3662: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3663: (l_process, 'PROGRAM_EXISTS', l_prg_exists);
3664:
3665: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);');
3666:

Line 3665: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);');

3661:
3662: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3663: (l_process, 'PROGRAM_EXISTS', l_prg_exists);
3664:
3665: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);');
3666:
3667: commit;
3668:
3669: end INIT_PROCESS;

Line 3690: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);')) then

3686: begin
3687:
3688: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
3689:
3690: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);')) then
3691: return;
3692: end if;
3693:
3694: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 3694: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3690: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);')) then
3691: return;
3692: end if;
3693:
3694: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3695: (l_process, 'EXTRACTION_TYPE');
3696:
3697: PJI_PJP_EXTRACTION_UTILS.SEED_PJI_PJP_STATS(p_worker_id);
3698:

Line 3820: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3816:
3817: PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);
3818: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);
3819:
3820: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3821: -- (l_process, 'FROM_PROJECT_ID') = -1 and
3822: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3823: -- (l_process, 'TO_PROJECT_ID') = -1) then
3824: -- PJI_PJP_EXTRACTION_UTILS.ANALYZE_PJP_FACTS;

Line 3822: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3818: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);
3819:
3820: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3821: -- (l_process, 'FROM_PROJECT_ID') = -1 and
3822: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3823: -- (l_process, 'TO_PROJECT_ID') = -1) then
3824: -- PJI_PJP_EXTRACTION_UTILS.ANALYZE_PJP_FACTS;
3825: -- end if;
3826:

Line 3827: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);');

3823: -- (l_process, 'TO_PROJECT_ID') = -1) then
3824: -- PJI_PJP_EXTRACTION_UTILS.ANALYZE_PJP_FACTS;
3825: -- end if;
3826:
3827: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);');
3828:
3829: commit;
3830:
3831: end RUN_PROCESS;

Line 3865: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);')) then

3861: begin
3862:
3863: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
3864:
3865: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);')) then
3866: return;
3867: end if;
3868: -- Changes for bug 6266824
3869: /* Commented for bug 6266824

Line 3893: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');

3889: elsif p_worker_id = 10 then
3890: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;
3891: end if;
3892: */
3893: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
3894:
3895: if (l_preload = 'Y') then
3896:
3897: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 3897: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3893: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
3894:
3895: if (l_preload = 'Y') then
3896:
3897: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3898: (l_process, 'PROJECT_TYPE');
3899:
3900: if (l_project_type = 'PJI$NULL') then
3901: l_project_type := null;

Line 3904: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3900: if (l_project_type = 'PJI$NULL') then
3901: l_project_type := null;
3902: end if;
3903:
3904: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3905: (l_process, 'PROJECT_OPERATING_UNIT');
3906:
3907: if (l_operating_unit = -1) then
3908: l_operating_unit := null;

Line 3911: l_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3907: if (l_operating_unit = -1) then
3908: l_operating_unit := null;
3909: end if;
3910:
3911: l_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3912: (l_process, 'PROJECT_ORGANIZATION_ID');
3913:
3914: if (l_project_organization_id = -1) then
3915: l_project_organization_id := null;

Line 3918: l_from_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3914: if (l_project_organization_id = -1) then
3915: l_project_organization_id := null;
3916: end if;
3917:
3918: l_from_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3919: (l_process, 'FROM_PROJECT_ID');
3920:
3921: if (l_from_project_id = -1) then
3922: l_from_project_id := null;

Line 3925: l_to_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3921: if (l_from_project_id = -1) then
3922: l_from_project_id := null;
3923: end if;
3924:
3925: l_to_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3926: (l_process, 'TO_PROJECT_ID');
3927:
3928: if (l_to_project_id = -1) then
3929: l_to_project_id := null;

Line 3932: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3928: if (l_to_project_id = -1) then
3929: l_to_project_id := null;
3930: end if;
3931:
3932: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3933: (l_process, 'FROM_PROJECT');
3934:
3935: if (l_from_project = 'PJI$NULL') then
3936: l_from_project := null;

Line 3939: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3935: if (l_from_project = 'PJI$NULL') then
3936: l_from_project := null;
3937: end if;
3938:
3939: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3940: (l_process, 'TO_PROJECT');
3941:
3942: if (l_to_project = 'PJI$NULL') then
3943: l_to_project := null;

Line 3946: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3942: if (l_to_project = 'PJI$NULL') then
3943: l_to_project := null;
3944: end if;
3945:
3946: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3947: (l_process, 'PLAN_TYPE_ID');
3948:
3949: if (l_plan_type_id = -1) then
3950: l_plan_type_id := null;

Line 3953: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3949: if (l_plan_type_id = -1) then
3950: l_plan_type_id := null;
3951: end if;
3952:
3953: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3954: (l_process, 'RBS_HEADER_ID');
3955:
3956: if (l_rbs_header_id = -1) then
3957: l_rbs_header_id := null;

Line 3960: l_only_pt_projects_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3956: if (l_rbs_header_id = -1) then
3957: l_rbs_header_id := null;
3958: end if;
3959:
3960: l_only_pt_projects_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3961: (l_process, 'ONLY_PT_PROJECTS_FLAG');
3962:
3963: if (l_only_pt_projects_flag = 'PJI$NULL') then
3964: l_only_pt_projects_flag := null;

Line 3988: PJI_PROCESS_UTIL.WRAPUP_PROCESS(l_process);

3984: delete from PJI_PJP_PROJ_BATCH_MAP where WORKER_ID = p_worker_id;
3985:
3986: -- mark current iteration as successful
3987:
3988: PJI_PROCESS_UTIL.WRAPUP_PROCESS(l_process);
3989:
3990: update PJI_SYSTEM_CONFIG_HIST
3991: set END_DATE = sysdate,
3992: COMPLETION_TEXT = 'Normal completion'

Line 4001: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);');

3997:
3998: PJI_UTILS.SET_PARAMETER('LAST_PJP_EXTR_DATE_' || l_process,
3999: to_char(sysdate, PJI_PJP_SUM_MAIN.g_date_mask));
4000:
4001: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);');
4002:
4003: if (l_preload = 'Y') then
4004:
4005: INIT_PROCESS(l_worker_id,

Line 4046: l_process_running := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4042: begin
4043:
4044: rollback;
4045:
4046: l_process_running := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4047: (g_process || p_worker_id, 'PROCESS_RUNNING');
4048:
4049: if (l_process_running is not null) then
4050:

Line 4051: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process || p_worker_id,

4047: (g_process || p_worker_id, 'PROCESS_RUNNING');
4048:
4049: if (l_process_running is not null) then
4050:
4051: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process || p_worker_id,
4052: 'PROCESS_RUNNING',
4053: 'F');
4054:
4055: end if;