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.
PACKAGE: APPS.PA_SCHEDULE_OBJECTS_PVT

Source


1 package PA_SCHEDULE_OBJECTS_PVT as
2 /*$Header: PASCHOBS.pls 120.1 2005/06/09 03:23:12 appldev  $*/
3 
4 
5 TYPE PA_SCHEDULE_OBJECTS_REC_TYPE IS RECORD (
6 OBJECT_TYPE				VARCHAR2(30)	:= NULL,
7 OBJECT_ID				NUMBER		:= NULL,
8 PARENT_OBJECT_TYPE			VARCHAR2(30)	:= NULL,
9 PARENT_OBJECT_ID			NUMBER		:= NULL,
10 CALENDAR_ID				NUMBER		:= NULL,
11 CONSTRAINT_TYPE_CODE			VARCHAR2(1)	:= NULL,
12 CONSTRAINT_DATE				DATE		:= NULL,
13 WBS_LEVEL				NUMBER		:= NULL,
14 START_DATE1				DATE		:= NULL,
15 START_DATE_OVERRIDE1			DATE		:= NULL,
16 FINISH_DATE1				DATE		:= NULL,
17 DURATION1				NUMBER		:= NULL,
18 TASK_STATUS1				NUMBER		:= NULL,
19 PROGRESS_STATUS_WEIGHT1			NUMBER		:= NULL,
20 PROGRESS_OVERRIDE1			NUMBER		:= NULL,
21 REMAINING_EFFORT1			NUMBER		:= NULL,
22 PERCENT_COMPLETE1			NUMBER		:= NULL,
23 PERCENT_OVERRIDE1			NUMBER		:= NULL,
24 TASK_WEIGHT1				NUMBER		:= NULL,
25 NUMBER_FIELD1				NUMBER		:= NULL,
26 ROLLUP_NODE1				VARCHAR2(1)	:= NULL,
27 DIRTY_FLAG1				VARCHAR2(1)	:= NULL,
28   ETC_Cost1			NUMBER		:= NULL,
29   PPL_ETC_COST1			NUMBER		:= NULL,
30   EQPMT_ETC_COST1		NUMBER		:= NULL,
31   PPL_UNPLAND_EFFORT1		NUMBER		:= NULL,
32   EQPMT_ETC_EFFORT1		NUMBER		:= NULL,
33   SUB_PRJ_ETC_COST1		NUMBER		:= NULL,
34   SUB_PRJ_PPL_ETC_COST1		NUMBER		:= NULL,
35   SUB_PRJ_EQPMT_ETC_COST1	NUMBER		:= NULL,
36   SUB_PRJ_PPL_ETC_EFFORT1	NUMBER		:= NULL,
37   SUB_PRJ_EQPMT_ETC_EFFORT1	NUMBER		:= NULL,
38   EARNED_VALUE1			NUMBER		:= NULL,
39   BAC_VALUE1			NUMBER		:= NULL,
40 START_DATE2				DATE		:= NULL,
41 START_DATE_OVERRIDE2			DATE		:= NULL,
42 FINISH_DATE2				DATE		:= NULL,
43 DURATION2				NUMBER		:= NULL,
44 TASK_STATUS2				NUMBER		:= NULL,
45 PROGRESS_STATUS_WEIGHT2			NUMBER		:= NULL,
46 PROGRESS_OVERRIDE2			NUMBER		:= NULL,
47 REMAINING_EFFORT2			NUMBER		:= NULL,
48 PERCENT_COMPLETE2			NUMBER		:= NULL,
49 PERCENT_OVERRIDE2			NUMBER		:= NULL,
50 TASK_WEIGHT2				NUMBER		:= NULL,
51 NUMBER_FIELD2				NUMBER		:= NULL,
52 ROLLUP_NODE2				VARCHAR2(1)	:= NULL,
53 DIRTY_FLAG2				VARCHAR2(1) 	:= NULL,
54   ETC_Cost2			NUMBER		:= NULL,
55   PPL_ETC_COST2			NUMBER		:= NULL,
56   EQPMT_ETC_COST2		NUMBER		:= NULL,
57   PPL_UNPLAND_EFFORT2		NUMBER		:= NULL,
58   EQPMT_ETC_EFFORT2		NUMBER		:= NULL,
59   SUB_PRJ_ETC_COST2		NUMBER		:= NULL,
60   SUB_PRJ_PPL_ETC_COST2		NUMBER		:= NULL,
61   SUB_PRJ_EQPMT_ETC_COST2	NUMBER		:= NULL,
62   SUB_PRJ_PPL_ETC_EFFORT2	NUMBER		:= NULL,
63   SUB_PRJ_EQPMT_ETC_EFFORT2	NUMBER		:= NULL,
64   EARNED_VALUE2			NUMBER		:= NULL,
65   BAC_VALUE2			NUMBER		:= NULL,
66 START_DATE3				DATE		:= NULL,
67 START_DATE_OVERRIDE3			DATE		:= NULL,
68 FINISH_DATE3				DATE		:= NULL,
69 DURATION3				NUMBER		:= NULL,
70 TASK_STATUS3				NUMBER		:= NULL,
71 PROGRESS_STATUS_WEIGHT3			NUMBER		:= NULL,
72 PROGRESS_OVERRIDE3			NUMBER		:= NULL,
73 REMAINING_EFFORT3			NUMBER		:= NULL,
74 PERCENT_COMPLETE3			NUMBER		:= NULL,
75 PERCENT_OVERRIDE3			NUMBER		:= NULL,
76 TASK_WEIGHT3				NUMBER		:= NULL,
77 NUMBER_FIELD3				NUMBER		:= NULL,
78 ROLLUP_NODE3				VARCHAR2(1)	:= NULL,
79 DIRTY_FLAG3				VARCHAR2(1) 	:= NULL,
80   ETC_Cost3			NUMBER		:= NULL,
81   PPL_ETC_COST3			NUMBER		:= NULL,
82   EQPMT_ETC_COST3		NUMBER		:= NULL,
83   PPL_UNPLAND_EFFORT3		NUMBER		:= NULL,
84   EQPMT_ETC_EFFORT3		NUMBER		:= NULL,
85   SUB_PRJ_ETC_COST3		NUMBER		:= NULL,
86   SUB_PRJ_PPL_ETC_COST3		NUMBER		:= NULL,
87   SUB_PRJ_EQPMT_ETC_COST3	NUMBER		:= NULL,
88   SUB_PRJ_PPL_ETC_EFFORT3	NUMBER		:= NULL,
89   SUB_PRJ_EQPMT_ETC_EFFORT3	NUMBER		:= NULL,
90   EARNED_VALUE3			NUMBER		:= NULL,
91   BAC_VALUE3			NUMBER		:= NULL,
92 START_DATE4				DATE		:= NULL,
93 START_DATE_OVERRIDE4			DATE		:= NULL,
94 FINISH_DATE4				DATE		:= NULL,
95 DURATION4				NUMBER		:= NULL,
96 TASK_STATUS4				NUMBER		:= NULL,
97 PROGRESS_STATUS_WEIGHT4			NUMBER		:= NULL,
98 PROGRESS_OVERRIDE4			NUMBER		:= NULL,
99 REMAINING_EFFORT4			NUMBER		:= NULL,
100 PERCENT_COMPLETE4			NUMBER		:= NULL,
101 PERCENT_OVERRIDE4			NUMBER		:= NULL,
102 TASK_WEIGHT4				NUMBER		:= NULL,
103 NUMBER_FIELD4				NUMBER		:= NULL,
104 ROLLUP_NODE4				VARCHAR2(1)	:= NULL,
105 DIRTY_FLAG4				VARCHAR2(1) 	:= NULL,
106   ETC_Cost4			NUMBER		:= NULL,
107   PPL_ETC_COST4			NUMBER		:= NULL,
108   EQPMT_ETC_COST4		NUMBER		:= NULL,
109   PPL_UNPLAND_EFFORT4		NUMBER		:= NULL,
110   EQPMT_ETC_EFFORT4		NUMBER		:= NULL,
111   SUB_PRJ_ETC_COST4		NUMBER		:= NULL,
112   SUB_PRJ_PPL_ETC_COST4		NUMBER		:= NULL,
113   SUB_PRJ_EQPMT_ETC_COST4	NUMBER		:= NULL,
114   SUB_PRJ_PPL_ETC_EFFORT4	NUMBER		:= NULL,
115   SUB_PRJ_EQPMT_ETC_EFFORT4	NUMBER		:= NULL,
116   EARNED_VALUE4			NUMBER		:= NULL,
117   BAC_VALUE4			NUMBER		:= NULL,
118 START_DATE5				DATE		:= NULL,
119 START_DATE_OVERRIDE5			DATE		:= NULL,
120 FINISH_DATE5				DATE		:= NULL,
121 DURATION5				NUMBER		:= NULL,
122 TASK_STATUS5				NUMBER		:= NULL,
123 PROGRESS_STATUS_WEIGHT5			NUMBER		:= NULL,
124 PROGRESS_OVERRIDE5			NUMBER		:= NULL,
125 REMAINING_EFFORT5			NUMBER		:= NULL,
126 PERCENT_COMPLETE5			NUMBER		:= NULL,
127 PERCENT_OVERRIDE5			NUMBER		:= NULL,
128 TASK_WEIGHT5				NUMBER		:= NULL,
129 NUMBER_FIELD5				NUMBER		:= NULL,
130 ROLLUP_NODE5				VARCHAR2(1)	:= NULL,
131 DIRTY_FLAG5				VARCHAR2(1) 	:= NULL,
132   ETC_Cost5			NUMBER		:= NULL,
133   PPL_ETC_COST5			NUMBER		:= NULL,
134   EQPMT_ETC_COST5		NUMBER		:= NULL,
135   PPL_UNPLAND_EFFORT5		NUMBER		:= NULL,
136   EQPMT_ETC_EFFORT5		NUMBER		:= NULL,
137   SUB_PRJ_ETC_COST5		NUMBER		:= NULL,
138   SUB_PRJ_PPL_ETC_COST5		NUMBER		:= NULL,
139   SUB_PRJ_EQPMT_ETC_COST5	NUMBER		:= NULL,
140   SUB_PRJ_PPL_ETC_EFFORT5	NUMBER		:= NULL,
141   SUB_PRJ_EQPMT_ETC_EFFORT5	NUMBER		:= NULL,
142   EARNED_VALUE5			NUMBER		:= NULL,
143   BAC_VALUE5			NUMBER		:= NULL,
144 START_DATE6				DATE		:= NULL,
145 START_DATE_OVERRIDE6			DATE		:= NULL,
146 FINISH_DATE6				DATE		:= NULL,
147 DURATION6				NUMBER		:= NULL,
148 TASK_STATUS6				NUMBER		:= NULL,
149 PROGRESS_STATUS_WEIGHT6			NUMBER		:= NULL,
150 PROGRESS_OVERRIDE6			NUMBER		:= NULL,
151 REMAINING_EFFORT6			NUMBER		:= NULL,
152 PERCENT_COMPLETE6			NUMBER		:= NULL,
153 PERCENT_OVERRIDE6			NUMBER		:= NULL,
154 TASK_WEIGHT6				NUMBER		:= NULL,
155 NUMBER_FIELD6				NUMBER		:= NULL,
156 ROLLUP_NODE6				VARCHAR2(1)	:= NULL,
157 DIRTY_FLAG6				VARCHAR2(1) 	:= NULL,
158   ETC_Cost6			NUMBER		:= NULL,
159   PPL_ETC_COST6			NUMBER		:= NULL,
160   EQPMT_ETC_COST6		NUMBER		:= NULL,
161   PPL_UNPLAND_EFFORT6		NUMBER		:= NULL,
162   EQPMT_ETC_EFFORT6		NUMBER		:= NULL,
163   SUB_PRJ_ETC_COST6		NUMBER		:= NULL,
164   SUB_PRJ_PPL_ETC_COST6		NUMBER		:= NULL,
165   SUB_PRJ_EQPMT_ETC_COST6	NUMBER		:= NULL,
166   SUB_PRJ_PPL_ETC_EFFORT6	NUMBER		:= NULL,
167   SUB_PRJ_EQPMT_ETC_EFFORT6	NUMBER		:= NULL,
168   EARNED_VALUE6			NUMBER		:= NULL,
169   BAC_VALUE6			NUMBER		:= NULL,
170   PERC_COMP_DERIVATIVE_CODE1	VARCHAR(30)	:= NULL,
171   PERC_COMP_DERIVATIVE_CODE2	VARCHAR(30)	:= NULL,
172   PERC_COMP_DERIVATIVE_CODE3	VARCHAR(30)	:= NULL,
173   PERC_COMP_DERIVATIVE_CODE4	VARCHAR(30)	:= NULL,
174   PERC_COMP_DERIVATIVE_CODE5	VARCHAR(30)	:= NULL,
175   PERC_COMP_DERIVATIVE_CODE6	VARCHAR(30)	:= NULL,
176   SUMMARY_OBJECT_FLAG		VARCHAR(1)	:= NULL -- Bug 4370746
177 );
178 TYPE PA_SCHEDULE_OBJECTS_TBL_TYPE IS TABLE OF PA_SCHEDULE_OBJECTS_REC_TYPE
179    INDEX BY BINARY_INTEGER;
180 
181 
182   procedure GENERATE_SCHEDULE (
183      p_api_version			IN	NUMBER	default	1.0
184     ,p_commit				IN	VARCHAR2 default 'N'
185     ,p_calling_module			IN	VARCHAR2 default 'SELF_SERVICE'
186     ,p_debug_mode			IN	VARCHAR2 default 'N'
187     ,p_max_msg_count			IN	NUMBER	 default NULL
188     ,p_number_digit			IN	NUMBER	 default 4
189     ,x_return_status			OUT NOCOPY	VARCHAR2
190     ,x_msg_count			OUT NOCOPY	NUMBER
191     ,x_msg_data				OUT NOCOPY	VARCHAR2
192     ,p_data_structure		IN OUT NOCOPY	PA_SCHEDULE_OBJECTS_TBL_TYPE
193     ,x_process_Number			OUT NOCOPY 	NUMBER
194     ,p_process_flag1			IN	VARCHAR2 default 'N'
195     ,p_derived_field1			IN	VARCHAR2 default 'DURATION'
196     ,p_process_rollup_flag1		IN	VARCHAR2 default 'N'
197     ,p_partial_process_flag1		IN	VARCHAR2 default 'N'
198     ,p_process_dependency_flag1		IN	VARCHAR2 default 'N'
199     ,p_process_constraint_flag1		IN	VARCHAR2 default 'N'
200     ,p_process_task_status_flag1	IN	VARCHAR2 default 'N'
201     ,p_process_progress_flag1		IN	VARCHAR2 default 'N'
202     ,p_process_effort_flag1		IN	VARCHAR2 default 'N'
203     ,p_process_percent_flag1		IN	VARCHAR2 default 'N'
204     ,p_process_number_flag1		IN	VARCHAR2 default 'N'
205     ,p_partial_dates_flag1		IN	VARCHAR2 default 'N'
206     ,p_partial_task_status_flag1	IN	VARCHAR2 default 'N'
207     ,p_partial_progress_flag1		IN	VARCHAR2 default 'N'
208     ,p_partial_effort_flag1		IN	VARCHAR2 default 'N'
209     ,p_partial_percent_flag1		IN	VARCHAR2 default 'N'
210     ,p_partial_number_flag1		IN	VARCHAR2 default 'N'
211     ,p_process_flag2			IN	VARCHAR2 default 'N'
212     ,p_derived_field2			IN	VARCHAR2 default 'DURATION'
213     ,p_process_rollup_flag2		IN	VARCHAR2 default 'N'
214     ,p_partial_process_flag2		IN	VARCHAR2 default 'N'
215     ,p_process_dependency_flag2		IN	VARCHAR2 default 'N'
216     ,p_process_constraint_flag2		IN	VARCHAR2 default 'N'
217     ,p_process_task_status_flag2	IN	VARCHAR2 default 'N'
218     ,p_process_progress_flag2		IN	VARCHAR2 default 'N'
219     ,p_process_effort_flag2		IN	VARCHAR2 default 'N'
220     ,p_process_percent_flag2		IN	VARCHAR2 default 'N'
221     ,p_process_number_flag2		IN	VARCHAR2 default 'N'
222     ,p_partial_dates_flag2		IN	VARCHAR2 default 'N'
223     ,p_partial_task_status_flag2	IN	VARCHAR2 default 'N'
224     ,p_partial_progress_flag2		IN	VARCHAR2 default 'N'
225     ,p_partial_effort_flag2		IN	VARCHAR2 default 'N'
226     ,p_partial_percent_flag2		IN	VARCHAR2 default 'N'
227     ,p_partial_number_flag2		IN	VARCHAR2 default 'N'
228     ,p_process_flag3			IN	VARCHAR2 default 'N'
229     ,p_derived_field3			IN	VARCHAR2 default 'DURATION'
230     ,p_process_rollup_flag3		IN	VARCHAR2 default 'N'
231     ,p_partial_process_flag3		IN	VARCHAR2 default 'N'
232     ,p_process_dependency_flag3		IN	VARCHAR2 default 'N'
233     ,p_process_constraint_flag3		IN	VARCHAR2 default 'N'
234     ,p_process_task_status_flag3	IN	VARCHAR2 default 'N'
235     ,p_process_progress_flag3		IN	VARCHAR2 default 'N'
236     ,p_process_effort_flag3		IN	VARCHAR2 default 'N'
237     ,p_process_percent_flag3		IN	VARCHAR2 default 'N'
238     ,p_process_number_flag3		IN	VARCHAR2 default 'N'
239     ,p_partial_dates_flag3		IN	VARCHAR2 default 'N'
240     ,p_partial_task_status_flag3	IN	VARCHAR2 default 'N'
241     ,p_partial_progress_flag3		IN	VARCHAR2 default 'N'
242     ,p_partial_effort_flag3		IN	VARCHAR2 default 'N'
243     ,p_partial_percent_flag3		IN	VARCHAR2 default 'N'
244     ,p_partial_number_flag3		IN	VARCHAR2 default 'N'
245     ,p_process_flag4			IN	VARCHAR2 default 'N'
246     ,p_derived_field4			IN	VARCHAR2 default 'DURATION'
247     ,p_process_rollup_flag4		IN	VARCHAR2 default 'N'
248     ,p_partial_process_flag4		IN	VARCHAR2 default 'N'
249     ,p_process_dependency_flag4		IN	VARCHAR2 default 'N'
250     ,p_process_constraint_flag4		IN	VARCHAR2 default 'N'
251     ,p_process_task_status_flag4	IN	VARCHAR2 default 'N'
252     ,p_process_progress_flag4		IN	VARCHAR2 default 'N'
253     ,p_process_effort_flag4		IN	VARCHAR2 default 'N'
254     ,p_process_percent_flag4		IN	VARCHAR2 default 'N'
255     ,p_process_number_flag4		IN	VARCHAR2 default 'N'
256     ,p_partial_dates_flag4		IN	VARCHAR2 default 'N'
257     ,p_partial_task_status_flag4	IN	VARCHAR2 default 'N'
258     ,p_partial_progress_flag4		IN	VARCHAR2 default 'N'
259     ,p_partial_effort_flag4		IN	VARCHAR2 default 'N'
260     ,p_partial_percent_flag4		IN	VARCHAR2 default 'N'
261     ,p_partial_number_flag4		IN	VARCHAR2 default 'N'
262     ,p_process_flag5			IN	VARCHAR2 default 'N'
263     ,p_derived_field5			IN	VARCHAR2 default 'DURATION'
264     ,p_process_rollup_flag5		IN	VARCHAR2 default 'N'
265     ,p_partial_process_flag5		IN	VARCHAR2 default 'N'
266     ,p_process_dependency_flag5		IN	VARCHAR2 default 'N'
267     ,p_process_constraint_flag5		IN	VARCHAR2 default 'N'
268     ,p_process_task_status_flag5	IN	VARCHAR2 default 'N'
269     ,p_process_progress_flag5		IN	VARCHAR2 default 'N'
270     ,p_process_effort_flag5		IN	VARCHAR2 default 'N'
271     ,p_process_percent_flag5		IN	VARCHAR2 default 'N'
272     ,p_process_number_flag5		IN	VARCHAR2 default 'N'
273     ,p_partial_dates_flag5		IN	VARCHAR2 default 'N'
274     ,p_partial_task_status_flag5	IN	VARCHAR2 default 'N'
275     ,p_partial_progress_flag5		IN	VARCHAR2 default 'N'
276     ,p_partial_effort_flag5		IN	VARCHAR2 default 'N'
277     ,p_partial_percent_flag5		IN	VARCHAR2 default 'N'
278     ,p_partial_number_flag5		IN	VARCHAR2 default 'N'
279     ,p_process_flag6			IN	VARCHAR2 default 'N'
280     ,p_derived_field6			IN	VARCHAR2 default 'DURATION'
281     ,p_process_rollup_flag6		IN	VARCHAR2 default 'N'
282     ,p_partial_process_flag6		IN	VARCHAR2 default 'N'
283     ,p_process_dependency_flag6		IN	VARCHAR2 default 'N'
284     ,p_process_constraint_flag6		IN	VARCHAR2 default 'N'
285     ,p_process_task_status_flag6	IN	VARCHAR2 default 'N'
286     ,p_process_progress_flag6		IN	VARCHAR2 default 'N'
287     ,p_process_effort_flag6		IN	VARCHAR2 default 'N'
288     ,p_process_percent_flag6		IN	VARCHAR2 default 'N'
289     ,p_process_number_flag6		IN	VARCHAR2 default 'N'
290     ,p_partial_dates_flag6		IN	VARCHAR2 default 'N'
291     ,p_partial_task_status_flag6	IN	VARCHAR2 default 'N'
292     ,p_partial_progress_flag6		IN	VARCHAR2 default 'N'
293     ,p_partial_effort_flag6		IN	VARCHAR2 default 'N'
294     ,p_partial_percent_flag6		IN	VARCHAR2 default 'N'
295     ,p_partial_number_flag6		IN	VARCHAR2 default 'N'
296 --
297     ,p_process_ETC_Flag1        IN      VARCHAR2 default 'N'
298     ,p_partial_ETC_Flag1        IN      VARCHAR2 default 'N'
299     ,p_process_ETC_Flag2        IN      VARCHAR2 default 'N'
300     ,p_partial_ETC_Flag2        IN      VARCHAR2 default 'N'
301     ,p_process_ETC_Flag3        IN      VARCHAR2 default 'N'
302     ,p_partial_ETC_Flag3        IN      VARCHAR2 default 'N'
303     ,p_process_ETC_Flag4        IN      VARCHAR2 default 'N'
304     ,p_partial_ETC_Flag4        IN      VARCHAR2 default 'N'
305     ,p_process_ETC_Flag5        IN      VARCHAR2 default 'N'
306     ,p_partial_ETC_Flag5        IN      VARCHAR2 default 'N'
307     ,p_process_ETC_Flag6        IN      VARCHAR2 default 'N'
308     ,p_partial_ETC_Flag6        IN      VARCHAR2 default 'N'
309     --
310     ,p_Rollup_Method		IN	VARCHAR2 default 'COST'
311   );
312 
313 
314   FUNCTION GET_PROGRESS_STATUS
315   (
316 	 p_not_started IN VARCHAR2 default 'N'
317 	,p_completed IN VARCHAR2 default 'N'
318 	,p_in_progress IN VARCHAR2 default 'N'
319 	,p_on_hold IN VARCHAR2 default 'N'
320   ) RETURN VARCHAR2;
321 
322 End PA_SCHEDULE_OBJECTS_PVT;