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_PROGRESS_REPORT_PVT

Source


1 package PA_PROGRESS_REPORT_PVT AUTHID CURRENT_USER as
2 /* $Header: PAPRRPVS.pls 120.1 2005/08/19 16:45:21 mwasowic noship $ */
3 
4 
5 PROCEDURE Create_REPORT_REGION
6 (
7  p_api_version                 IN     NUMBER :=  1.0,
8  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
9  p_commit                      IN     VARCHAR2 := FND_API.g_false,
10  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
11  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
12 
13  p_version_id                  IN NUMBER,
14  P_REGION_SOURCE_TYPE in VARCHAR2 default 'STD',
15  P_REGION_CODE in VARCHAR2,
16  P_RECORD_SEQUENCE in NUMBER,
17  P_ATTRIBUTE1 in VARCHAR2,
18  P_ATTRIBUTE2 in VARCHAR2,
19  P_ATTRIBUTE3 in VARCHAR2,
20  P_ATTRIBUTE4 in VARCHAR2,
21  P_ATTRIBUTE5 in VARCHAR2,
22  P_ATTRIBUTE6 in VARCHAR2,
23  P_ATTRIBUTE7 in VARCHAR2,
24  P_ATTRIBUTE8 in VARCHAR2,
25  P_ATTRIBUTE9 in VARCHAR2,
26  P_ATTRIBUTE10 in VARCHAR2,
27  P_ATTRIBUTE11 in VARCHAR2,
28  P_ATTRIBUTE12 in VARCHAR2,
29  P_ATTRIBUTE13 in VARCHAR2,
30  P_ATTRIBUTE14 in VARCHAR2,
31  P_ATTRIBUTE15 in VARCHAR2,
32  P_ATTRIBUTE16 in VARCHAR2,
33  P_ATTRIBUTE17 in VARCHAR2,
34  P_ATTRIBUTE18 in VARCHAR2,
35  P_ATTRIBUTE19 in VARCHAR2,
36  P_ATTRIBUTE20 in VARCHAR2,
37   P_UDS_ATTRIBUTE_CATEGORY in VARCHAR2 default null,
38   P_UDS_ATTRIBUTE1 in VARCHAR2 default null,
39   P_UDS_ATTRIBUTE2 in VARCHAR2 default null,
40   P_UDS_ATTRIBUTE3 in VARCHAR2 default null,
41   P_UDS_ATTRIBUTE4 in VARCHAR2 default null,
42   P_UDS_ATTRIBUTE5 in VARCHAR2 default null,
43   P_UDS_ATTRIBUTE6 in VARCHAR2 default null,
44   P_UDS_ATTRIBUTE7 in VARCHAR2 default null,
45   P_UDS_ATTRIBUTE8 in VARCHAR2 default null,
46   P_UDS_ATTRIBUTE9 in VARCHAR2 default null,
47   P_UDS_ATTRIBUTE10 in VARCHAR2 default null,
48   P_UDS_ATTRIBUTE11 in VARCHAR2 default null,
49   P_UDS_ATTRIBUTE12 in VARCHAR2 default null,
50   P_UDS_ATTRIBUTE13 in VARCHAR2 default null,
51   P_UDS_ATTRIBUTE14 in VARCHAR2 default null,
52   P_UDS_ATTRIBUTE15 in VARCHAR2 default null,
53   P_UDS_ATTRIBUTE16 in VARCHAR2 default null,
54   P_UDS_ATTRIBUTE17 in VARCHAR2 default null,
55   P_UDS_ATTRIBUTE18 in VARCHAR2 default null,
56   P_UDS_ATTRIBUTE19 in VARCHAR2 default null,
57   P_UDS_ATTRIBUTE20 in VARCHAR2 default null,
58  x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
59  x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
60  x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
61    );
62 
63 
64 PROCEDURE Update_REPORT_REGION
65 (
66 
67  p_api_version                 IN     NUMBER :=  1.0,
68  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
69  p_commit                      IN     VARCHAR2 := FND_API.g_false,
70  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
71  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
72 
73  P_VERSION_ID in NUMBER,
74  P_REGION_SOURCE_TYPE in VARCHAR2,
75  P_REGION_CODE in VARCHAR2,
76  P_RECORD_SEQUENCE in NUMBER,
77  P_RECORD_VERSION_NUMBER in NUMBER,
78  P_ATTRIBUTE1 in VARCHAR2,
79  P_ATTRIBUTE2 in VARCHAR2,
80  P_ATTRIBUTE3 in VARCHAR2,
81  P_ATTRIBUTE4 in VARCHAR2,
82  P_ATTRIBUTE5 in VARCHAR2,
83  P_ATTRIBUTE6 in VARCHAR2,
84  P_ATTRIBUTE7 in VARCHAR2,
85  P_ATTRIBUTE8 in VARCHAR2,
86  P_ATTRIBUTE9 in VARCHAR2,
87  P_ATTRIBUTE10 in VARCHAR2,
88  P_ATTRIBUTE11 in VARCHAR2,
89  P_ATTRIBUTE12 in VARCHAR2,
90  P_ATTRIBUTE13 in VARCHAR2,
91  P_ATTRIBUTE14 in VARCHAR2,
92  P_ATTRIBUTE15 in VARCHAR2,
93  P_ATTRIBUTE16 in VARCHAR2,
94  P_ATTRIBUTE17 in VARCHAR2,
95  P_ATTRIBUTE18 in VARCHAR2,
96  P_ATTRIBUTE19 in VARCHAR2,
97  P_ATTRIBUTE20 in VARCHAR2,
98   P_UDS_ATTRIBUTE_CATEGORY in VARCHAR2 ,
99   P_UDS_ATTRIBUTE1 in VARCHAR2 ,
100   P_UDS_ATTRIBUTE2 in VARCHAR2 ,
101   P_UDS_ATTRIBUTE3 in VARCHAR2 ,
102   P_UDS_ATTRIBUTE4 in VARCHAR2 ,
103   P_UDS_ATTRIBUTE5 in VARCHAR2 ,
104   P_UDS_ATTRIBUTE6 in VARCHAR2 ,
105   P_UDS_ATTRIBUTE7 in VARCHAR2 ,
106   P_UDS_ATTRIBUTE8 in VARCHAR2 ,
107   P_UDS_ATTRIBUTE9 in VARCHAR2 ,
108   P_UDS_ATTRIBUTE10 in VARCHAR2 ,
109   P_UDS_ATTRIBUTE11 in VARCHAR2 ,
110   P_UDS_ATTRIBUTE12 in VARCHAR2 ,
111   P_UDS_ATTRIBUTE13 in VARCHAR2 ,
112   P_UDS_ATTRIBUTE14 in VARCHAR2 ,
113   P_UDS_ATTRIBUTE15 in VARCHAR2 ,
114   P_UDS_ATTRIBUTE16 in VARCHAR2 ,
115   P_UDS_ATTRIBUTE17 in VARCHAR2 ,
116   P_UDS_ATTRIBUTE18 in VARCHAR2 ,
117   P_UDS_ATTRIBUTE19 in VARCHAR2 ,
118   P_UDS_ATTRIBUTE20 in VARCHAR2 ,
119  x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
120  x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
121  x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
122 ) ;
123 
124 PROCEDURE Delete_Report_Region
125 (
126  p_api_version                 IN     NUMBER :=  1.0,
127  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
128  p_commit                      IN     VARCHAR2 := FND_API.g_false,
129  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
130  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
131 
132  p_version_id                  IN     number,
133  P_REGION_SOURCE_TYPE          in VARCHAR2,
134  P_REGION_CODE                 in VARCHAR2,
135  P_RECORD_SEQUENCE             in NUMBER,
136  p_record_version_number       IN NUMBER ,
137 
138  x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
139  x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
140  x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
141  );
142 
143 PROCEDURE create_report
144   (
145    p_api_version                 IN     NUMBER :=  1.0,
146    p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
147    p_commit                      IN     VARCHAR2 := FND_API.g_false,
148    p_validate_only               IN     VARCHAR2 := FND_API.g_true,
149    p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
150 
151    p_object_id                   IN     NUMBER := NULL,
152    p_object_type                 IN     VARCHAR2 := NULL,
153    p_report_type_id              IN     NUMBER := NULL,
154 
155    x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
156    x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
157    x_msg_data                    OUT    NOCOPY VARCHAR2,    --File.Sql.39 bug 4440895
158    x_version_id                  OUT    NOCOPY NUMBER --File.Sql.39 bug 4440895
159    );
160 
161 
162 PROCEDURE delete_report
163   (
164    p_api_version                 IN     NUMBER :=  1.0,
165    p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
166    p_commit                      IN     VARCHAR2 := FND_API.g_false,
167    p_validate_only               IN     VARCHAR2 := FND_API.g_true,
168    p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
169 
170    p_version_id                  IN     NUMBER :=NULL,
171    p_record_version_number       IN     NUMBER := NULL,
172 
173    x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
174    x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
175    x_msg_data                    OUT    NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
176    );
177 
178 PROCEDURE submit_report
179   (
180    p_api_version                 IN     NUMBER :=  1.0,
181    p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
182    p_commit                      IN     VARCHAR2 := FND_API.g_false,
183    p_validate_only               IN     VARCHAR2 := FND_API.g_true,
184    p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
185 
186    p_version_id                  IN     NUMBER := NULL,
187    p_record_version_number       IN     NUMBER := NULL,
188    p_summary_version_number       IN     NUMBER := NULL,
189 
190    x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
191    x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
192    x_msg_data                    OUT    NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
193    );
194 
195 PROCEDURE cancel_report
196 (
197    p_api_version                 IN     NUMBER :=  1.0,
198    p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
199    p_commit                      IN     VARCHAR2 := FND_API.g_false,
200    p_validate_only               IN     VARCHAR2 := FND_API.g_true,
201    p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
202 
203    p_version_id                  IN     NUMBER :=NULL,
204    p_record_version_number       IN     NUMBER := NULL,
205    p_cancel_comments             IN     VARCHAR2 := NULL,
206 
207    x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
208    x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
209    x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
210  ) ;
211 
212 PROCEDURE rework_report
213   (
214    p_api_version                 IN     NUMBER :=  1.0,
215    p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
216    p_commit                      IN     VARCHAR2 := FND_API.g_false,
217    p_validate_only               IN     VARCHAR2 := FND_API.g_true,
218    p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
219 
220    p_version_id                  IN     NUMBER := NULL,
221    p_record_version_number       IN     NUMBER := NULL,
222 
223    x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
224    x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
225    x_msg_data                    OUT    NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
226    );
227 
228 PROCEDURE publish_report (
229  p_api_version                 IN     NUMBER :=  1.0,
230  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
231  p_commit                      IN     VARCHAR2 := FND_API.g_false,
232  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
233  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
234 
235   p_version_id IN NUMBER := null,
236   p_record_version_number       IN     NUMBER := NULL,
237   p_summary_version_number       IN     NUMBER := NULL,
238 
239   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
240   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
241   x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
242 );
243 
244 
245 
246 PROCEDURE update_report_details
247   (
248    p_api_version                 IN     NUMBER :=  1.0,
249    p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
250    p_commit                      IN     VARCHAR2 := FND_API.g_false,
251    p_validate_only               IN     VARCHAR2 := FND_API.g_true,
252    p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
253 
254    p_version_id                  IN     NUMBER := NULL,
255 
256    p_report_start_date           IN     DATE:= NULL,
257    p_report_end_date             IN     DATE:= NULL,
258    p_reported_by                 IN     NUMBER:= NULL,
259    p_reported_by_name            IN     VARCHAR2:= NULL,
260    p_progress_status             IN     VARCHAR2:= NULL,
261    p_overview                    IN     VARCHAR2:= NULL,
262    p_record_version_number       IN     NUMBER := NULL,
263 
264    x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
265    x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
266    x_msg_data                    OUT    NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
267   );
268 
269 
270 PROCEDURE approve_report (
271  p_api_version                 IN     NUMBER :=  1.0,
272  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
273  p_commit                      IN     VARCHAR2 := FND_API.g_false,
274  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
275  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
276 
277   p_version_id IN NUMBER := null,
278   p_record_version_number       IN     NUMBER := NULL,
279 
280   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
281   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
282   x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
283 			  ) ;
284 
285 PROCEDURE reject_report (
286  p_api_version                 IN     NUMBER :=  1.0,
287  p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
288  p_commit                      IN     VARCHAR2 := FND_API.g_false,
289  p_validate_only               IN     VARCHAR2 := FND_API.g_true,
290  p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
291 
292   p_version_id IN NUMBER := null,
293   p_record_version_number       IN     NUMBER := NULL,
294 
295   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
296   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
297   x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
298 			  ) ;
299 
300 PROCEDURE define_progress_report_setup
301   (
302    p_api_version                 IN     NUMBER :=  1.0,
303    p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
304    p_commit                      IN     VARCHAR2 := FND_API.g_false,
305    p_validate_only               IN     VARCHAR2 := FND_API.g_true,
306    p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
307 
308    p_object_id                   IN     NUMBER := NULL,
309    p_object_type                 IN     VARCHAR2 := NULL,
310    p_page_type_code              IN     VARCHAR2 := 'PPR',
311    p_page_id                     IN     NUMBER := NULL,
312    p_page_name                   IN     VARCHAR2 := NULL,
313    p_approval_required           IN     VARCHAR2 := NULL,
314    --p_auto_publish                IN     VARCHAR2 := NULL,
315    p_report_cycle_id             IN     NUMBER := NULL,
316    p_report_offset_days          IN     NUMBER := NULL,
317    p_next_reporting_date         IN     DATE := NULL,
318    p_reminder_days              IN     NUMBER := NULL,
319    p_reminder_days_type         IN     VARCHAR2 := NULL,
320    p_initial_progress_status 	IN	VARCHAR2 := NULL,
324    p_approver_source_id          IN     NUMBER:= NULL,
321    p_final_progress_status	IN	VARCHAR2 := NULL,
322    p_rollup_progress_status	IN	VARCHAR2 := NULL,
323    p_report_type_id              IN     NUMBER:= NULL,
325    p_approver_source_name        IN     VARCHAR2:= NULL,
326    p_approver_source_type        IN     NUMBER:= NULL,
327    p_effective_from              IN     DATE:= NULL,
328    p_effective_to                IN     DATE:= NULL,
329    p_object_page_layout_id       IN     NUMBER := NULL,
330    p_action_set_id               IN     NUMBER := NULL,
331    p_record_version_number       IN     NUMBER := NULL,
332    p_function_name	         IN     VARCHAR2:= NULL,
333    x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
334    x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
335    x_msg_data                    OUT    NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
336   );
337 
338 PROCEDURE update_project_perccomplete
339   (
340    p_version_id NUMBER,
341 
342    x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
343    x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
344    x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
345    ) ;
346 
347 PROCEDURE change_report_status
348   (
349    p_api_version                 IN     NUMBER :=  1.0,
350    p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
351    p_commit                      IN     VARCHAR2 := FND_API.g_false,
352    p_validate_only               IN     VARCHAR2 := FND_API.g_false,
353    p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
354 
355    p_version_id                  IN     NUMBER := NULL,
356    p_report_status               IN     VARCHAR2 := NULL,
357    p_record_version_number       IN     NUMBER := NULL,
358    p_summary_version_number       IN     NUMBER := NULL,
359    p_published_date                 IN     DATE := NULL,
360    p_cancel_comment              IN     VARCHAR2 := NULL,
361    p_cancel_date                 IN     DATE := NULL,
362 
363    x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
364    x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
365    x_msg_data                    OUT    NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
366    ) ;
367 
368 --Added for Bug 3684164.
369 PROCEDURE delete_version_data
370    (
371      p_page_id                 IN     pa_page_layouts.page_id%TYPE
372     ,p_region_source_type_tbl  IN     SYSTEM.PA_VARCHAR2_30_TBL_TYPE
373     ,p_region_code_tbl         IN     SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
374     ,p_region_source_code_tbl  IN     SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
375     ,x_return_status           OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
376     ,x_msg_count               OUT    NOCOPY NUMBER --File.Sql.39 bug 4440895
377     ,x_msg_data                OUT    NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
378 
379 END  PA_PROGRESS_REPORT_PVT;
380