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 442: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

438: for x in 1 .. PJI_PJP_SUM_MAIN.g_parallel_processes loop
439:
440: l_process := PJI_PJP_SUM_MAIN.g_process || x;
441:
442: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
443: (l_process, 'EXTRACTION_TYPE');
444:
445: if (l_extraction_type is not null and
446: not PJI_PJP_SUM_MAIN.WORKER_STATUS(x, 'RUNNING')) then

Line 499: l_request_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

495: l_newline);
496:
497: if (l_extraction_type in ('FULL', 'INCREMENTAL', 'PARTIAL')) then
498:
499: l_request_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
500: (l_process, l_process);
501:
502: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_REQ_ID');
503:

Line 518: l_project_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

514:
515:
516: if (l_extraction_type in ('FULL', 'INCREMENTAL', 'PARTIAL')) then
517:
518: l_project_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
519: (l_process, 'PROJECT_OPERATING_UNIT');
520:
521: if (nvl(l_project_operating_unit, -1) = -1) then
522:

Line 549: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

545: end if;
546:
547: if (l_extraction_type in ('FULL', 'INCREMENTAL')) then
548:
549: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
550: (l_process, 'PROJECT_TYPE');
551:
552: if (nvl(l_project_type, 'PJI$NULL') = 'PJI$NULL') then
553:

Line 572: l_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

568: end if;
569:
570: if (l_extraction_type in ('FULL', 'INCREMENTAL')) then
571:
572: l_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
573: (l_process, 'PROJECT_ORGANIZATION_ID');
574:
575: if (nvl(l_project_organization_id, -1) = -1) then
576:

Line 603: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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

Line 626: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

622: end if;
623:
624: if (l_extraction_type in ('FULL', 'INCREMENTAL', 'PARTIAL')) then
625:
626: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
627: (l_process, 'TO_PROJECT');
628:
629: if (nvl(l_to_project, 'PJI$NULL') = 'PJI$NULL') then
630:

Line 649: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

645: end if;
646:
647: if (l_extraction_type in ('PARTIAL')) then
648:
649: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
650: (l_process, 'PLAN_TYPE_ID');
651:
652: if (nvl(l_plan_type_id, -1) = -1) then
653:

Line 679: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

675: end if;
676:
677: if (l_extraction_type in ('RBS')) then
678:
679: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
680: (l_process, 'RBS_HEADER_ID');
681:
682: if (nvl(l_rbs_header_id, -1) = -1) then
683:

Line 709: l_transaction_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

705: end if;
706:
707: if (l_extraction_type in ('PARTIAL')) then -- Bug#5099574 Start
708:
709: l_transaction_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
710: (l_process, 'TRANSACTION_TYPE');
711:
712: l_plan_versions_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
713: (l_process, 'PLAN_VERSION');

Line 712: l_plan_versions_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

708:
709: l_transaction_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
710: (l_process, 'TRANSACTION_TYPE');
711:
712: l_plan_versions_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
713: (l_process, 'PLAN_VERSION');
714:
715: if (nvl(l_transaction_type_id, 'PJI$NULL') = 'PJI$NULL') then
716:

Line 769: l_only_pt_projects := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

765: end if; -- Bug#5099574 Ends
766:
767: if (l_extraction_type in ('FULL', 'INCREMENTAL') and 1 = 2) then
768:
769: l_only_pt_projects := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
770: (l_process, 'ONLY_PT_PROJECTS_FLAG');
771:
772: if (nvl(l_only_pt_projects, 'PJI$NULL') = 'PJI$NULL') then
773:

Line 2888: IF ( PJI_PROCESS_UTIL.REQUEST_STATUS(

2884: AND P.Concurrent_Program_Name = 'PJI_PJP_LAUNCH_RPP_PRG'
2885: And P.Application_ID = c.Application_ID
2886: And c.Application_Short_Name = 'PJI';
2887:
2888: IF ( PJI_PROCESS_UTIL.REQUEST_STATUS(
2889: 'RUNNING',
2890: l_req_id1,
2891: 'PJI_PJP_LAUNCH_UPP_PRG') ) or
2892: ( PJI_PROCESS_UTIL.REQUEST_STATUS(

Line 2892: ( PJI_PROCESS_UTIL.REQUEST_STATUS(

2888: IF ( PJI_PROCESS_UTIL.REQUEST_STATUS(
2889: 'RUNNING',
2890: l_req_id1,
2891: 'PJI_PJP_LAUNCH_UPP_PRG') ) or
2892: ( PJI_PROCESS_UTIL.REQUEST_STATUS(
2893: 'RUNNING',
2894: l_req_id2,
2895: 'PJI_PJP_LAUNCH_RPP_PRG') )
2896:

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

2931: l_worker_id := l_worker_id + 1;
2932:
2933: l_process := g_process || l_worker_id;
2934:
2935: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'PRELOAD');
2936:
2937: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2938: (l_process, l_process) is null) then
2939:

Line 2937: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2933: l_process := g_process || l_worker_id;
2934:
2935: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'PRELOAD');
2936:
2937: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2938: (l_process, l_process) is null) then
2939:
2940: if (p_worker_id = 0) then
2941: p_worker_id := l_worker_id;

Line 2946: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2942: end if;
2943:
2944: elsif (not PJI_PJP_SUM_MAIN.WORKER_STATUS(l_worker_id, 'RUNNING') and
2945: ((l_extraction_type = 'FULL' and
2946: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2947: (l_process, 'EXTRACTION_TYPE') = 'FULL') or
2948: (l_extraction_type = 'INCREMENTAL' and
2949: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2950: (l_process, 'EXTRACTION_TYPE') = 'FULL') or

Line 2949: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2945: ((l_extraction_type = 'FULL' and
2946: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2947: (l_process, 'EXTRACTION_TYPE') = 'FULL') or
2948: (l_extraction_type = 'INCREMENTAL' and
2949: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2950: (l_process, 'EXTRACTION_TYPE') = 'FULL') or
2951: (l_extraction_type = 'INCREMENTAL' and
2952: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2953: (l_process, 'EXTRACTION_TYPE') = 'INCREMENTAL') or

Line 2952: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2948: (l_extraction_type = 'INCREMENTAL' and
2949: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2950: (l_process, 'EXTRACTION_TYPE') = 'FULL') or
2951: (l_extraction_type = 'INCREMENTAL' and
2952: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2953: (l_process, 'EXTRACTION_TYPE') = 'INCREMENTAL') or
2954: (l_extraction_type = 'PARTIAL' and
2955: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2956: (l_process, 'EXTRACTION_TYPE') = 'PARTIAL') or

Line 2955: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2951: (l_extraction_type = 'INCREMENTAL' and
2952: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2953: (l_process, 'EXTRACTION_TYPE') = 'INCREMENTAL') or
2954: (l_extraction_type = 'PARTIAL' and
2955: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2956: (l_process, 'EXTRACTION_TYPE') = 'PARTIAL') or
2957: (l_extraction_type = 'RBS' and
2958: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2959: (l_process, 'EXTRACTION_TYPE') = 'RBS')) and

Line 2958: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

2954: (l_extraction_type = 'PARTIAL' and
2955: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2956: (l_process, 'EXTRACTION_TYPE') = 'PARTIAL') or
2957: (l_extraction_type = 'RBS' and
2958: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2959: (l_process, 'EXTRACTION_TYPE') = 'RBS')) and
2960: nvl(p_operating_unit, -1) =
2961: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2962: 'PROJECT_OPERATING_UNIT') and

Line 2961: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2957: (l_extraction_type = 'RBS' and
2958: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
2959: (l_process, 'EXTRACTION_TYPE') = 'RBS')) and
2960: nvl(p_operating_unit, -1) =
2961: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2962: 'PROJECT_OPERATING_UNIT') and
2963: nvl(p_project_type, 'PJI$NULL') =
2964: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2965: 'PROJECT_TYPE') and

Line 2964: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2960: nvl(p_operating_unit, -1) =
2961: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2962: 'PROJECT_OPERATING_UNIT') and
2963: nvl(p_project_type, 'PJI$NULL') =
2964: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2965: 'PROJECT_TYPE') and
2966: nvl(p_project_organization_id, -1) =
2967: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2968: 'PROJECT_ORGANIZATION_ID') and

Line 2967: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2963: nvl(p_project_type, 'PJI$NULL') =
2964: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2965: 'PROJECT_TYPE') and
2966: nvl(p_project_organization_id, -1) =
2967: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2968: 'PROJECT_ORGANIZATION_ID') and
2969: nvl(p_from_project, 'PJI$NULL') =
2970: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2971: 'FROM_PROJECT') and

Line 2970: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2966: nvl(p_project_organization_id, -1) =
2967: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2968: 'PROJECT_ORGANIZATION_ID') and
2969: nvl(p_from_project, 'PJI$NULL') =
2970: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2971: 'FROM_PROJECT') and
2972: nvl(p_to_project, 'PJI$NULL') =
2973: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2974: 'TO_PROJECT') and

Line 2973: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2969: nvl(p_from_project, 'PJI$NULL') =
2970: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2971: 'FROM_PROJECT') and
2972: nvl(p_to_project, 'PJI$NULL') =
2973: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2974: 'TO_PROJECT') and
2975: nvl(p_plan_type_id, -1) =
2976: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2977: 'PLAN_TYPE_ID') and

Line 2976: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2972: nvl(p_to_project, 'PJI$NULL') =
2973: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2974: 'TO_PROJECT') and
2975: nvl(p_plan_type_id, -1) =
2976: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2977: 'PLAN_TYPE_ID') and
2978: nvl(p_rbs_header_id, -1) =
2979: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2980: 'RBS_HEADER_ID') and

Line 2979: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2975: nvl(p_plan_type_id, -1) =
2976: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2977: 'PLAN_TYPE_ID') and
2978: nvl(p_rbs_header_id, -1) =
2979: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2980: 'RBS_HEADER_ID') and
2981: nvl(p_transaction_type, 'PJI$NULL') =
2982: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2983: 'TRANSACTION_TYPE') and

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

2978: nvl(p_rbs_header_id, -1) =
2979: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2980: 'RBS_HEADER_ID') and
2981: nvl(p_transaction_type, 'PJI$NULL') =
2982: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2983: 'TRANSACTION_TYPE') and
2984: nvl(p_plan_versions, 'PJI$NULL') =
2985: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2986: 'PLAN_VERSION') and

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

2981: nvl(p_transaction_type, 'PJI$NULL') =
2982: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2983: 'TRANSACTION_TYPE') and
2984: nvl(p_plan_versions, 'PJI$NULL') =
2985: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2986: 'PLAN_VERSION') and
2987: nvl(p_only_pt_projects_flag, 'PJI$NULL') =
2988: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2989: 'ONLY_PT_PROJECTS_FLAG') and

Line 2988: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2984: nvl(p_plan_versions, 'PJI$NULL') =
2985: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, -- Bug#5099574
2986: 'PLAN_VERSION') and
2987: nvl(p_only_pt_projects_flag, 'PJI$NULL') =
2988: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2989: 'ONLY_PT_PROJECTS_FLAG') and
2990: --12.1.3 enhancement
2991: nvl(p_project_status, 'PJI$NULL') =
2992: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

Line 2992: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2988: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2989: 'ONLY_PT_PROJECTS_FLAG') and
2990: --12.1.3 enhancement
2991: nvl(p_project_status, 'PJI$NULL') =
2992: PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2993: 'PROJECT_STATUS')) then
2994:
2995: p_worker_id := l_worker_id;
2996: l_existing_worker := 'Y'; -- To check the resubmit of failed run Bug 5057835

Line 2997: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

2993: 'PROJECT_STATUS')) then
2994:
2995: p_worker_id := l_worker_id;
2996: l_existing_worker := 'Y'; -- To check the resubmit of failed run Bug 5057835
2997: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
2998: 'EXTRACTION_TYPE')
2999: = 'PARTIAL') then
3000: l_type := 1;
3001: l_incomplete_partial_count := l_incomplete_partial_count + 1;

Line 3009: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

3005: end if;
3006:
3007: elsif (not PJI_PJP_SUM_MAIN.WORKER_STATUS(l_worker_id, 'RUNNING')) then
3008:
3009: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
3010: 'EXTRACTION_TYPE')
3011: = 'PARTIAL') then
3012: l_incomplete_partial_count := l_incomplete_partial_count + 1;
3013: else

Line 3037: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, l_process,

3033: end if;
3034:
3035: l_process := g_process || p_worker_id;
3036:
3037: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, l_process,
3038: FND_GLOBAL.CONC_REQUEST_ID);
3039:
3040: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);
3041:

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

3038: FND_GLOBAL.CONC_REQUEST_ID);
3039:
3040: PJI_PJP_EXTRACTION_UTILS.SET_WORKER_ID(p_worker_id);
3041:
3042: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PROCESS_RUNNING', 'Y');
3043: -- Putting this insert here, Config Hist in case of resubmit of failed run Bug 5057835
3044: insert into PJI_SYSTEM_CONFIG_HIST
3045: (
3046: REQUEST_ID,

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

3085: dual;
3086:
3087: -- If this is the resubmit of already existing failed run then Bug 5057835
3088: if l_existing_worker = 'Y' and
3089: (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);')) then
3090: commit; -- To release lock/ stamp parameters / config hist
3091: return;
3092: end if;
3093:

Line 3094: PJI_PROCESS_UTIL.REFRESH_STEP_TABLE;

3090: commit; -- To release lock/ stamp parameters / config hist
3091: return;
3092: end if;
3093:
3094: PJI_PROCESS_UTIL.REFRESH_STEP_TABLE;
3095:
3096: savepoint no_need_to_run_step; --Bug#5171542 Moving up, preload should not set when rollback
3097:
3098: if (p_run_mode = 'NO_PRELOAD') then

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

3095:
3096: savepoint no_need_to_run_step; --Bug#5171542 Moving up, preload should not set when rollback
3097:
3098: if (p_run_mode = 'NO_PRELOAD') then
3099: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PRELOAD', 'N');
3100: end if;
3101:
3102: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
3103:

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

3098: if (p_run_mode = 'NO_PRELOAD') then
3099: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process, 'PRELOAD', 'N');
3100: end if;
3101:
3102: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
3103:
3104: PJI_PJP_EXTRACTION_UTILS.UPDATE_EXTR_SCOPE;
3105:
3106: -- Moving down the query for l_rbs_ for the stamping of parameters Bug 5057835

Line 3588: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3584: end;
3585:
3586:
3587: if( l_extraction_type = 'FULL' ) then
3588: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3589: 'PRELOAD',
3590: 'Y');
3591:
3592: end if;

Line 3598: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3594:
3595:
3596: end if;
3597: -- Code for delete moved down Bug 5057835
3598: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3599: 'EXTRACTION_TYPE',
3600: l_extraction_type);
3601:
3602:

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

3599: 'EXTRACTION_TYPE',
3600: l_extraction_type);
3601:
3602:
3603: PJI_PROCESS_UTIL.ADD_STEPS(l_process, 'PJI_PJP', l_extraction_type);
3604:
3605:
3606: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);')) then
3607: rollback to no_need_to_run_step;

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

3602:
3603: PJI_PROCESS_UTIL.ADD_STEPS(l_process, 'PJI_PJP', l_extraction_type);
3604:
3605:
3606: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);')) then
3607: rollback to no_need_to_run_step;
3608: Commit; -- To release lock/ stamp parameters / config hist
3609: return;
3610: end if;

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

3630: prog_name_table.EXTEND;
3631: -- SUBMIT_REQUEST should check if the request is already running and
3632: -- just return the request id and program name if it is.
3633:
3634: -- IF PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER( g_process || c.WORKER_ID, 'EXTRACTION_TYPE')<> 'RBS' THEN
3635:
3636: SUBMIT_REQUEST(c.WORKER_ID, -- to retrieve the parameters
3637: request_id_table(l_count), -- in / out
3638: prog_name_table(l_count) -- in / out

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

3648:
3649: for i in 1..l_count loop
3650: if request_id_table(i) <> -1 then
3651: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);
3652: PJI_PROCESS_UTIL.WAIT_FOR_REQUEST(request_id_table(i), 10);
3653:
3654: if (not PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
3655: request_id_table(i),
3656: prog_name_table(i))) then

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

3650: if request_id_table(i) <> -1 then
3651: pa_debug.log_message('Current Program is waiting for the Concurrent request with the request no: '||request_id_table(i), 1);
3652: PJI_PROCESS_UTIL.WAIT_FOR_REQUEST(request_id_table(i), 10);
3653:
3654: if (not PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
3655: request_id_table(i),
3656: prog_name_table(i))) then
3657:
3658: -- We may want to add, to the error message, the request

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

3744:
3745:
3746: -- Bug#5099574 - Changes for Partial Refresh - Start - Populating the Refresh Code
3747:
3748: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE') = 'PARTIAL') then
3749:
3750: -- If p_transaction_type is null then l_refresh_code is set to 63 . So All Actuals and Plans get refreshed
3751: -- This change is done to make sure the code is compatible with R12 Code Bug# 5453009
3752:

Line 3796: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3792:
3793: end if;
3794:
3795:
3796: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3797: (l_process, 'PROJECT_TYPE', nvl(p_project_type, 'PJI$NULL'));
3798: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3799: (l_process, 'PROJECT_OPERATING_UNIT', nvl(p_operating_unit, -1));
3800: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3798: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3794:
3795:
3796: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3797: (l_process, 'PROJECT_TYPE', nvl(p_project_type, 'PJI$NULL'));
3798: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3799: (l_process, 'PROJECT_OPERATING_UNIT', nvl(p_operating_unit, -1));
3800: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3801: (l_process,
3802: 'PROJECT_ORGANIZATION_ID', nvl(p_project_organization_id, -1));

Line 3800: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3796: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3797: (l_process, 'PROJECT_TYPE', nvl(p_project_type, 'PJI$NULL'));
3798: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3799: (l_process, 'PROJECT_OPERATING_UNIT', nvl(p_operating_unit, -1));
3800: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3801: (l_process,
3802: 'PROJECT_ORGANIZATION_ID', nvl(p_project_organization_id, -1));
3803: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3804: (l_process, 'FROM_PROJECT', nvl(p_from_project, 'PJI$NULL'));

Line 3803: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3799: (l_process, 'PROJECT_OPERATING_UNIT', nvl(p_operating_unit, -1));
3800: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3801: (l_process,
3802: 'PROJECT_ORGANIZATION_ID', nvl(p_project_organization_id, -1));
3803: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3804: (l_process, 'FROM_PROJECT', nvl(p_from_project, 'PJI$NULL'));
3805: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3806: (l_process, 'TO_PROJECT', nvl(p_to_project, 'PJI$NULL'));
3807: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3805: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3801: (l_process,
3802: 'PROJECT_ORGANIZATION_ID', nvl(p_project_organization_id, -1));
3803: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3804: (l_process, 'FROM_PROJECT', nvl(p_from_project, 'PJI$NULL'));
3805: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3806: (l_process, 'TO_PROJECT', nvl(p_to_project, 'PJI$NULL'));
3807: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3808: (l_process, 'FROM_PROJECT_ID', nvl(p_from_project_id, -1));
3809: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3807: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3803: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3804: (l_process, 'FROM_PROJECT', nvl(p_from_project, 'PJI$NULL'));
3805: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3806: (l_process, 'TO_PROJECT', nvl(p_to_project, 'PJI$NULL'));
3807: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3808: (l_process, 'FROM_PROJECT_ID', nvl(p_from_project_id, -1));
3809: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3810: (l_process, 'TO_PROJECT_ID', nvl(p_to_project_id, -1));
3811: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3809: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3805: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3806: (l_process, 'TO_PROJECT', nvl(p_to_project, 'PJI$NULL'));
3807: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3808: (l_process, 'FROM_PROJECT_ID', nvl(p_from_project_id, -1));
3809: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3810: (l_process, 'TO_PROJECT_ID', nvl(p_to_project_id, -1));
3811: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3812: (l_process, 'PLAN_TYPE_ID', nvl(p_plan_type_id, -1));
3813: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3811: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3807: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3808: (l_process, 'FROM_PROJECT_ID', nvl(p_from_project_id, -1));
3809: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3810: (l_process, 'TO_PROJECT_ID', nvl(p_to_project_id, -1));
3811: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3812: (l_process, 'PLAN_TYPE_ID', nvl(p_plan_type_id, -1));
3813: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3814: (l_process, 'RBS_HEADER_ID', nvl(p_rbs_header_id, -1));
3815: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3813: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3809: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3810: (l_process, 'TO_PROJECT_ID', nvl(p_to_project_id, -1));
3811: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3812: (l_process, 'PLAN_TYPE_ID', nvl(p_plan_type_id, -1));
3813: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3814: (l_process, 'RBS_HEADER_ID', nvl(p_rbs_header_id, -1));
3815: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3816: (l_process, 'RBS_VERSION_ID', nvl(l_rbs_version_id, -1));
3817: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3815: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3811: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3812: (l_process, 'PLAN_TYPE_ID', nvl(p_plan_type_id, -1));
3813: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3814: (l_process, 'RBS_HEADER_ID', nvl(p_rbs_header_id, -1));
3815: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3816: (l_process, 'RBS_VERSION_ID', nvl(l_rbs_version_id, -1));
3817: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3818: (l_process,
3819: 'ONLY_PT_PROJECTS_FLAG', nvl(p_only_pt_projects_flag, 'PJI$NULL'));

Line 3817: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3813: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3814: (l_process, 'RBS_HEADER_ID', nvl(p_rbs_header_id, -1));
3815: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3816: (l_process, 'RBS_VERSION_ID', nvl(l_rbs_version_id, -1));
3817: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3818: (l_process,
3819: 'ONLY_PT_PROJECTS_FLAG', nvl(p_only_pt_projects_flag, 'PJI$NULL'));
3820:
3821: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

Line 3821: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3817: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3818: (l_process,
3819: 'ONLY_PT_PROJECTS_FLAG', nvl(p_only_pt_projects_flag, 'PJI$NULL'));
3820:
3821: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3822: (l_process,
3823: 'TRANSACTION_TYPE', nvl(p_transaction_type, 'PJI$NULL'));
3824: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3825: (l_process,

Line 3824: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3820:
3821: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3822: (l_process,
3823: 'TRANSACTION_TYPE', nvl(p_transaction_type, 'PJI$NULL'));
3824: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3825: (l_process,
3826: 'PLAN_VERSION', nvl(p_plan_versions, 'PJI$NULL'));
3827:
3828: --12.1.3 enhancement

Line 3829: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3825: (l_process,
3826: 'PLAN_VERSION', nvl(p_plan_versions, 'PJI$NULL'));
3827:
3828: --12.1.3 enhancement
3829: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3830: (l_process, 'PROJECT_STATUS',NVL(p_project_status,'PJI$NULL'));
3831:
3832:
3833: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then

Line 3834: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3830: (l_process, 'PROJECT_STATUS',NVL(p_project_status,'PJI$NULL'));
3831:
3832:
3833: if (PJI_UTILS.GET_SETUP_PARAMETER('PA_PERIOD_FLAG') = 'N') then
3834: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3835: 'PA_CALENDAR_FLAG',
3836: 'N');
3837: else
3838: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

Line 3838: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3834: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3835: 'PA_CALENDAR_FLAG',
3836: 'N');
3837: else
3838: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3839: 'PA_CALENDAR_FLAG',
3840: 'Y');
3841: end if;
3842:

Line 3844: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3840: 'Y');
3841: end if;
3842:
3843: if (PJI_UTILS.GET_SETUP_PARAMETER('GL_PERIOD_FLAG') = 'N') then
3844: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3845: 'GL_CALENDAR_FLAG',
3846: 'N');
3847: else
3848: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

Line 3848: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,

3844: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3845: 'GL_CALENDAR_FLAG',
3846: 'N');
3847: else
3848: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(l_process,
3849: 'GL_CALENDAR_FLAG',
3850: 'Y');
3851: end if;
3852:

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

3852:
3853: -- Bug#5099574 - Changes for Partial Refresh - Start - setting up the global process parameters
3854:
3855:
3856: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE') = 'PARTIAL') then
3857: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3858: (l_process,
3859: 'REFRESH_CODE', nvl(l_refresh_code, -1));
3860: end if;

Line 3857: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3853: -- Bug#5099574 - Changes for Partial Refresh - Start - setting up the global process parameters
3854:
3855:
3856: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'EXTRACTION_TYPE') = 'PARTIAL') then
3857: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3858: (l_process,
3859: 'REFRESH_CODE', nvl(l_refresh_code, -1));
3860: end if;
3861:

Line 3864: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER

3860: end if;
3861:
3862: -- Bug#5099574 - Changes for Partial Refresh - End -
3863:
3864: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3865: (l_process, 'PROGRAM_EXISTS', l_prg_exists);
3866:
3867: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);');
3868:

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

3863:
3864: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER
3865: (l_process, 'PROGRAM_EXISTS', l_prg_exists);
3866:
3867: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.INIT_PROCESS(p_worker_id, p_run_mode);');
3868:
3869: commit;
3870:
3871: end INIT_PROCESS;

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

3889: begin
3890:
3891: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
3892:
3893: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);')) then
3894: return;
3895: end if;
3896:
3897: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 3897: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3893: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);')) then
3894: return;
3895: end if;
3896:
3897: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3898: (l_process, 'EXTRACTION_TYPE');
3899:
3900: /* Added for Bug 8708651 */
3901: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');

Line 4048: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4044:
4045: PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);
4046: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);
4047:
4048: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4049: -- (l_process, 'FROM_PROJECT_ID') = -1 and
4050: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4051: -- (l_process, 'TO_PROJECT_ID') = -1) then
4052: -- PJI_PJP_EXTRACTION_UTILS.ANALYZE_PJP_FACTS;

Line 4050: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4046: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);
4047:
4048: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4049: -- (l_process, 'FROM_PROJECT_ID') = -1 and
4050: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4051: -- (l_process, 'TO_PROJECT_ID') = -1) then
4052: -- PJI_PJP_EXTRACTION_UTILS.ANALYZE_PJP_FACTS;
4053: -- end if;
4054:

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

4051: -- (l_process, 'TO_PROJECT_ID') = -1) then
4052: -- PJI_PJP_EXTRACTION_UTILS.ANALYZE_PJP_FACTS;
4053: -- end if;
4054:
4055: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.RUN_PROCESS(p_worker_id);');
4056:
4057: commit;
4058:
4059: end RUN_PROCESS;

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

4090: begin
4091:
4092: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4093:
4094: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);')) then
4095: return;
4096: end if;
4097: -- Changes for bug 6266824
4098: /* Commented for bug 6266824

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

4118: elsif p_worker_id = 10 then
4119: lock table PJI_PJP_PROJ_BATCH_MAP PARTITION(P10) in exclusive mode;
4120: end if;
4121: */
4122: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
4123:
4124: if (l_preload = 'Y') then
4125:
4126: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 4126: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4122: l_preload := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PRELOAD');
4123:
4124: if (l_preload = 'Y') then
4125:
4126: l_project_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4127: (l_process, 'PROJECT_TYPE');
4128:
4129: if (l_project_type = 'PJI$NULL') then
4130: l_project_type := null;

Line 4133: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4129: if (l_project_type = 'PJI$NULL') then
4130: l_project_type := null;
4131: end if;
4132:
4133: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4134: (l_process, 'PROJECT_OPERATING_UNIT');
4135:
4136: if (l_operating_unit = -1) then
4137: l_operating_unit := null;

Line 4140: l_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4136: if (l_operating_unit = -1) then
4137: l_operating_unit := null;
4138: end if;
4139:
4140: l_project_organization_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4141: (l_process, 'PROJECT_ORGANIZATION_ID');
4142:
4143: if (l_project_organization_id = -1) then
4144: l_project_organization_id := null;

Line 4147: l_from_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4143: if (l_project_organization_id = -1) then
4144: l_project_organization_id := null;
4145: end if;
4146:
4147: l_from_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4148: (l_process, 'FROM_PROJECT_ID');
4149:
4150: if (l_from_project_id = -1) then
4151: l_from_project_id := null;

Line 4154: l_to_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4150: if (l_from_project_id = -1) then
4151: l_from_project_id := null;
4152: end if;
4153:
4154: l_to_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4155: (l_process, 'TO_PROJECT_ID');
4156:
4157: if (l_to_project_id = -1) then
4158: l_to_project_id := null;

Line 4161: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4157: if (l_to_project_id = -1) then
4158: l_to_project_id := null;
4159: end if;
4160:
4161: l_from_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4162: (l_process, 'FROM_PROJECT');
4163:
4164: if (l_from_project = 'PJI$NULL') then
4165: l_from_project := null;

Line 4168: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4164: if (l_from_project = 'PJI$NULL') then
4165: l_from_project := null;
4166: end if;
4167:
4168: l_to_project := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4169: (l_process, 'TO_PROJECT');
4170:
4171: if (l_to_project = 'PJI$NULL') then
4172: l_to_project := null;

Line 4175: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4171: if (l_to_project = 'PJI$NULL') then
4172: l_to_project := null;
4173: end if;
4174:
4175: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4176: (l_process, 'PLAN_TYPE_ID');
4177:
4178: if (l_plan_type_id = -1) then
4179: l_plan_type_id := null;

Line 4182: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4178: if (l_plan_type_id = -1) then
4179: l_plan_type_id := null;
4180: end if;
4181:
4182: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4183: (l_process, 'RBS_HEADER_ID');
4184:
4185: if (l_rbs_header_id = -1) then
4186: l_rbs_header_id := null;

Line 4189: l_only_pt_projects_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4185: if (l_rbs_header_id = -1) then
4186: l_rbs_header_id := null;
4187: end if;
4188:
4189: l_only_pt_projects_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4190: (l_process, 'ONLY_PT_PROJECTS_FLAG');
4191:
4192: if (l_only_pt_projects_flag = 'PJI$NULL') then
4193: l_only_pt_projects_flag := null;

Line 4197: l_project_status := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4193: l_only_pt_projects_flag := null;
4194: end if;
4195:
4196: -- 12.1.3 enhancement
4197: l_project_status := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4198: (l_process, 'PROJECT_STATUS');
4199:
4200: if (l_project_status = 'PJI$NULL') then
4201: l_project_status := null;

Line 4226: PJI_PROCESS_UTIL.WRAPUP_PROCESS(l_process);

4222: delete from PJI_PJP_PROJ_BATCH_MAP where WORKER_ID = p_worker_id;
4223:
4224: -- mark current iteration as successful
4225:
4226: PJI_PROCESS_UTIL.WRAPUP_PROCESS(l_process);
4227:
4228: update PJI_SYSTEM_CONFIG_HIST
4229: set END_DATE = sysdate,
4230: COMPLETION_TEXT = 'Normal completion'

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

4235:
4236: PJI_UTILS.SET_PARAMETER('LAST_PJP_EXTR_DATE_' || l_process,
4237: to_char(sysdate, PJI_PJP_SUM_MAIN.g_date_mask));
4238:
4239: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_MAIN.WRAPUP_PROCESS(p_worker_id);');
4240:
4241: if (l_preload = 'Y') then
4242:
4243: INIT_PROCESS(l_worker_id,

Line 4287: l_process_running := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4283: begin
4284:
4285: rollback;
4286:
4287: l_process_running := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4288: (g_process || p_worker_id, 'PROCESS_RUNNING');
4289:
4290: if (l_process_running is not null) then
4291:

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

4288: (g_process || p_worker_id, 'PROCESS_RUNNING');
4289:
4290: if (l_process_running is not null) then
4291:
4292: PJI_PROCESS_UTIL.SET_PROCESS_PARAMETER(g_process || p_worker_id,
4293: 'PROCESS_RUNNING',
4294: 'F');
4295:
4296: end if;