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_PUB

Source


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