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_PKG

Source


1 PACKAGE PA_PROGRESS_REPORT_PKG AUTHID CURRENT_USER AS
2 --$Header: PAPRRPHS.pls 120.1 2005/08/19 16:45:03 mwasowic noship $
3 procedure INSERT_PROGRESS_REPORT_VER_ROW (
4 
5   P_OBJECT_ID in NUMBER,
6   P_OBJECT_TYPE in VARCHAR2,
7   P_PAGE_ID in NUMBER,
8   P_PAGE_TYPE in VARCHAR2,
9   P_PAGE_STATUS in VARCHAR2,
10 
11     p_report_start_date IN DATE,
12     p_report_end_date IN DATE,
13     p_reported_by in NUMBER,
14     p_progress_status in VARCHAR2,
15     p_overview in VARCHAR2,
16     p_current_flag in VARCHAR2,
17     p_published_date IN DATE,
18     p_comments in VARCHAR2,
19     p_canceled_date IN DATE,
20 
21   p_report_type_id              IN NUMBER,
22   X_VERSION_ID                  out NOCOPY NUMBER, --File.Sql.39 bug 4440895
23   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
25   x_msg_data                    OUT    NOCOPY VARCHAR2			    --File.Sql.39 bug 4440895
26 );
27 
28 procedure UPDATE_PROGRESS_REPORT_VER_ROW (
29   P_VERSION_ID in NUMBER,
30   P_OBJECT_ID in NUMBER,
31   P_OBJECT_TYPE in VARCHAR2,
32   P_PAGE_ID in NUMBER,
33   P_PAGE_TYPE in VARCHAR2,
34   P_PAGE_STATUS in VARCHAR2,
35 
36     p_report_start_date IN DATE,
37     p_report_end_date IN DATE,
38     p_reported_by in NUMBER,
39     p_progress_status in VARCHAR2,
40     p_overview in VARCHAR2,
41     p_current_flag in VARCHAR2,
42     p_published_date IN DATE,
43     p_comments in VARCHAR2,
44     p_canceled_date IN DATE,
45 
46   P_RECORD_VERSION_NUMBER in NUMBER,
47   P_summary_VERSION_NUMBER in NUMBER,
48   p_report_type_id              IN NUMBER,
49 
50   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
51   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
52   x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53 );
54 
55 procedure DELETE_PROGRESS_REPORT_VER_ROW (
56   P_VERSION_ID in NUMBER,
57   P_RECORD_VERSION_NUMBER in NUMBER,
58 
59   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
60   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
61   x_msg_data                    OUT    NOCOPY VARCHAR2	       --File.Sql.39 bug 4440895
62 ) ;
63 
64 procedure INSERT_PROGRESS_REPORT_VAL_ROW (
65   P_VERSION_ID in NUMBER,
66   P_REGION_SOURCE_TYPE in VARCHAR2,
67   P_REGION_CODE in VARCHAR2,
68   P_RECORD_SEQUENCE in NUMBER,
69   P_ATTRIBUTE1 in VARCHAR2,
70   P_ATTRIBUTE2 in VARCHAR2,
71   P_ATTRIBUTE3 in VARCHAR2,
72   P_ATTRIBUTE4 in VARCHAR2,
73   P_ATTRIBUTE5 in VARCHAR2,
74   P_ATTRIBUTE6 in VARCHAR2,
75   P_ATTRIBUTE7 in VARCHAR2,
76   P_ATTRIBUTE8 in VARCHAR2,
77   P_ATTRIBUTE9 in VARCHAR2,
78   P_ATTRIBUTE10 in VARCHAR2,
79   P_ATTRIBUTE11 in VARCHAR2,
80   P_ATTRIBUTE12 in VARCHAR2,
81   P_ATTRIBUTE13 in VARCHAR2,
82   P_ATTRIBUTE14 in VARCHAR2,
83   P_ATTRIBUTE15 in VARCHAR2,
84   P_ATTRIBUTE16 in VARCHAR2,
85   P_ATTRIBUTE17 in VARCHAR2,
86   P_ATTRIBUTE18 in VARCHAR2,
87   P_ATTRIBUTE19 in VARCHAR2,
88   P_ATTRIBUTE20 in VARCHAR2,
89   P_UDS_ATTRIBUTE_CATEGORY in VARCHAR2,
90   P_UDS_ATTRIBUTE1 in VARCHAR2,
91   P_UDS_ATTRIBUTE2 in VARCHAR2,
92   P_UDS_ATTRIBUTE3 in VARCHAR2,
93   P_UDS_ATTRIBUTE4 in VARCHAR2,
94   P_UDS_ATTRIBUTE5 in VARCHAR2,
95   P_UDS_ATTRIBUTE6 in VARCHAR2,
96   P_UDS_ATTRIBUTE7 in VARCHAR2,
97   P_UDS_ATTRIBUTE8 in VARCHAR2,
98   P_UDS_ATTRIBUTE9 in VARCHAR2,
99   P_UDS_ATTRIBUTE10 in VARCHAR2,
100   P_UDS_ATTRIBUTE11 in VARCHAR2,
101   P_UDS_ATTRIBUTE12 in VARCHAR2,
102   P_UDS_ATTRIBUTE13 in VARCHAR2,
103   P_UDS_ATTRIBUTE14 in VARCHAR2,
104   P_UDS_ATTRIBUTE15 in VARCHAR2,
105   P_UDS_ATTRIBUTE16 in VARCHAR2,
106   P_UDS_ATTRIBUTE17 in VARCHAR2,
107   P_UDS_ATTRIBUTE18 in VARCHAR2,
108   P_UDS_ATTRIBUTE19 in VARCHAR2,
109   P_UDS_ATTRIBUTE20 in VARCHAR2,
110   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
111   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
112   x_msg_data                    OUT    NOCOPY VARCHAR2				      --File.Sql.39 bug 4440895
113 );
114 
115 procedure UPDATE_PROGRESS_REPORT_VAL_ROW (
116   P_VERSION_ID in NUMBER,
117   P_REGION_SOURCE_TYPE in VARCHAR2,
118   P_REGION_CODE in VARCHAR2,
119   P_RECORD_SEQUENCE in NUMBER,
120   P_RECORD_VERSION_NUMBER in NUMBER,
121   P_ATTRIBUTE1 in VARCHAR2,
122   P_ATTRIBUTE2 in VARCHAR2,
123   P_ATTRIBUTE3 in VARCHAR2,
124   P_ATTRIBUTE4 in VARCHAR2,
125   P_ATTRIBUTE5 in VARCHAR2,
126   P_ATTRIBUTE6 in VARCHAR2,
127   P_ATTRIBUTE7 in VARCHAR2,
128   P_ATTRIBUTE8 in VARCHAR2,
129   P_ATTRIBUTE9 in VARCHAR2,
130   P_ATTRIBUTE10 in VARCHAR2,
131   P_ATTRIBUTE11 in VARCHAR2,
132   P_ATTRIBUTE12 in VARCHAR2,
133   P_ATTRIBUTE13 in VARCHAR2,
134   P_ATTRIBUTE14 in VARCHAR2,
135   P_ATTRIBUTE15 in VARCHAR2,
136   P_ATTRIBUTE16 in VARCHAR2,
137   P_ATTRIBUTE17 in VARCHAR2,
138   P_ATTRIBUTE18 in VARCHAR2,
139   P_ATTRIBUTE19 in VARCHAR2,
140   P_ATTRIBUTE20 in VARCHAR2,
141   P_UDS_ATTRIBUTE_CATEGORY in VARCHAR2,
142   P_UDS_ATTRIBUTE1 in VARCHAR2,
143   P_UDS_ATTRIBUTE2 in VARCHAR2,
144   P_UDS_ATTRIBUTE3 in VARCHAR2,
145   P_UDS_ATTRIBUTE4 in VARCHAR2,
146   P_UDS_ATTRIBUTE5 in VARCHAR2,
147   P_UDS_ATTRIBUTE6 in VARCHAR2,
148   P_UDS_ATTRIBUTE7 in VARCHAR2,
149   P_UDS_ATTRIBUTE8 in VARCHAR2,
150   P_UDS_ATTRIBUTE9 in VARCHAR2,
151   P_UDS_ATTRIBUTE10 in VARCHAR2,
152   P_UDS_ATTRIBUTE11 in VARCHAR2,
153   P_UDS_ATTRIBUTE12 in VARCHAR2,
154   P_UDS_ATTRIBUTE13 in VARCHAR2,
155   P_UDS_ATTRIBUTE14 in VARCHAR2,
156   P_UDS_ATTRIBUTE15 in VARCHAR2,
157   P_UDS_ATTRIBUTE16 in VARCHAR2,
158   P_UDS_ATTRIBUTE17 in VARCHAR2,
159   P_UDS_ATTRIBUTE18 in VARCHAR2,
160   P_UDS_ATTRIBUTE19 in VARCHAR2,
161   P_UDS_ATTRIBUTE20 in VARCHAR2,
162 
163   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
164   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
165   x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
166 );
167 
168 procedure DELETE_PROGRESS_REPORT_VAL_ROW (
169   P_VERSION_ID in NUMBER,
170   P_REGION_SOURCE_TYPE in VARCHAR2,
171   P_REGION_CODE in VARCHAR2,
172   P_RECORD_SEQUENCE in NUMBER,
173   P_RECORD_VERSION_NUMBER in NUMBER,
174 
175   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
176   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
177   x_msg_data                    OUT    NOCOPY VARCHAR2			      --File.Sql.39 bug 4440895
178 );
179 
180 procedure INSERT_OBJECT_PAGE_LAYOUT_ROW (
181 
182   P_OBJECT_ID in NUMBER,
183   P_OBJECT_TYPE in VARCHAR2,
184   P_PAGE_ID in NUMBER,
185   P_PAGE_TYPE_CODE in VARCHAR2,
186 
187   P_APPROVAL_REQUIRED in VARCHAR2,
188   --P_AUTO_PUBLISH in VARCHAR2,
189   P_REPORTING_CYCLE_ID in NUMBER,
190   P_REPORTING_OFFSET_DAYS in NUMBER,
191   P_NEXT_REPORTING_DATE in DATE,
192   P_REMINDER_DAYS in NUMBER,
193   P_REMINDER_DAYS_TYPE in VARCHAR2,
194   P_INITIAL_PROGRESS_STATUS in VARCHAR2,
195   P_FINAL_PROGRESS_STATUS in VARCHAR2,
196   P_ROLLUP_PROGRESS_STATUS in VARCHAR2,
197   p_report_type_id              IN     NUMBER,
198   p_approver_source_id          IN     NUMBER,
199   p_approver_source_type        IN     NUMBER,
200   p_effective_from              IN     DATE,
201   p_effective_to                IN     DATE,
202   p_function_name		IN     VARCHAR2 := NULL,
203   x_object_page_layout_id       OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
204   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
205   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
206   x_msg_data                    OUT    NOCOPY VARCHAR2			    --File.Sql.39 bug 4440895
207 );
208 
209 procedure UPDATE_OBJECT_PAGE_LAYOUT_ROW (
210   P_OBJECT_ID in NUMBER,
211   P_OBJECT_TYPE in VARCHAR2,
212   P_PAGE_ID in NUMBER,
213   P_PAGE_TYPE_CODE in VARCHAR2,
214 
215   P_APPROVAL_REQUIRED in VARCHAR2,
216   --P_AUTO_PUBLISH in VARCHAR2,
217   P_REPORTING_CYCLE_ID in NUMBER,
218   P_REPORTING_OFFSET_DAYS in NUMBER,
219   P_NEXT_REPORTING_DATE in DATE,
220   P_REMINDER_DAYS in NUMBER,
221   P_REMINDER_DAYS_TYPE in VARCHAR2,
222   P_INITIAL_PROGRESS_STATUS in VARCHAR2,
223   P_FINAL_PROGRESS_STATUS in VARCHAR2,
224   P_ROLLUP_PROGRESS_STATUS in VARCHAR2,
225   p_report_type_id              IN     NUMBER,
226   p_approver_source_id          IN     NUMBER,
227   p_approver_source_type        IN     NUMBER,
228   p_effective_from              IN     DATE,
229   p_effective_to                IN     DATE,
230   p_object_page_layout_id       IN     NUMBER,
231   p_record_version_number	IN     NUMBER,
232   p_function_name		IN     VARCHAR2 := 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 DELETE_PROGRESS_REPORT_VALS (
240   P_VERSION_ID in NUMBER,
241 
242   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
243   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
244   x_msg_data                    OUT    NOCOPY VARCHAR2			      --File.Sql.39 bug 4440895
245 				       ) ;
246 
247 
248 procedure DELETE_PROGRESS_REPORT_REGION (
249   P_VERSION_ID in NUMBER,
250   p_region_source_type in VARCHAR2,
251   p_region_code IN VARCHAR2,
252 
253   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
254   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
255   x_msg_data                    OUT    NOCOPY VARCHAR2			      --File.Sql.39 bug 4440895
256 					 ) ;
257 
258 procedure DELETE_OBJECT_PAGE_LAYOUTS (
259   P_OBJECT_ID in NUMBER,
260   P_OBJECT_TYPE in VARCHAR2,
261 
262   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
263   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
264   x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
265 				      ) ;
266 
267 
268 END  PA_PROGRESS_REPORT_PKG;