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.OZF_REQUEST_HEADERS_ALL_PKG

Source


1 package OZF_REQUEST_HEADERS_ALL_PKG as
2 /* $Header: ozftreqs.pls 120.1 2006/08/02 21:15:09 mkothari noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_REQUEST_HEADER_ID in NUMBER,
6   X_OBJECT_VERSION_NUMBER in NUMBER,
7   X_CREATION_DATE in DATE,
8   X_CREATED_BY in NUMBER,
9   X_LAST_UPDATE_DATE in DATE,
10   X_LAST_UPDATED_BY in NUMBER,
11   X_LAST_UPDATE_LOGIN in NUMBER,
12   X_REQUEST_ID in NUMBER,
13   X_program_application_id in   NUMBER,
14   X_program_update_date in   DATE,
15   X_program_id  in  NUMBER,
16   X_CREATE_FROM in VARCHAR2,
17   X_REQUEST_NUMBER in VARCHAR2,
18   X_SHIP_FROM_STOCK_FLAG in VARCHAR2,
19   X_REQUEST_TYPE_CODE in VARCHAR2,
20   X_REQUEST_CLASS in VARCHAR2,
21   X_BENEFIT_ID in NUMBER,
22   X_ACTIVITY_MEDIA_ID in NUMBER,
23   X_SUBMITTED_BY in NUMBER,
24   X_SUBMITTED_DATE in DATE,
25   X_PARTNER_CONTACT_ID in NUMBER,
26   X_PARTNER_CONTACT_PHONE_NUMBER in VARCHAR2,
27   X_PARTNER_CONTACT_EMAIL_ADDRES in VARCHAR2,
28   X_OFFER_ID in NUMBER,
29   X_OFFER_TYPE in VARCHAR2,
30   X_LINKED_REQUEST_HEADER_ID in NUMBER,
31   X_ROOT_REQUEST_HEADER_ID in NUMBER,
32   X_START_DATE in DATE,
33   X_END_DATE in DATE,
34   X_STATUS_CODE in VARCHAR2,
35   X_REQUEST_OUTCOME in VARCHAR2,
36   X_DECLINE_REASON_CODE in VARCHAR2,
37   X_RETURN_REASON_CODE in  VARCHAR2,
38   X_CURRENCY_CODE in VARCHAR2,
39   X_PARTNER_AMOUNT in NUMBER,
40   X_REQUESTED_AMOUNT in NUMBER,
41   X_APPROVED_AMOUNT in NUMBER,
42   X_EXCHANGE_RATE_TYPE in VARCHAR2,
43   X_EXCHANGE_RATE_DATE in DATE,
44   X_EXCHANGE_RATE in NUMBER,
45   X_PARTNER_ACCTD_AMOUNT in NUMBER,
46   X_REQUESTED_ACCTD_AMOUNT in NUMBER,
47   X_APPROVED_ACCTD_AMOUNT in NUMBER,
48   X_APPROVED_BY in NUMBER,
49   X_APPROVED_DATE in DATE,
50   X_AUTHORIZATION_CODE in VARCHAR2,
51   X_AGREEMENT_NUMBER in VARCHAR2,
52   X_PARTNER_ID in NUMBER,
53   X_PARTNER_SITE_USE_ID in NUMBER,
54   X_END_CUST_PARTY_ID in NUMBER,
55   X_END_CUST_SITE_USE_ID in NUMBER,
56   X_END_CUST_DUNS_NUMBER in NUMBER,
57   X_END_CUST_NAME in VARCHAR2,
58   X_END_CUST_ADDRESS1 in VARCHAR2,
59   X_END_CUST_ADDRESS2 in VARCHAR2,
60   X_END_CUST_ADDRESS3 in VARCHAR2,
61   X_END_CUST_ADDRESS4 in VARCHAR2,
62   X_END_CUST_PROVINCE in VARCHAR2,
63   X_END_CUST_COUNTY in VARCHAR2,
64   X_END_CUST_CITY in VARCHAR2,
65   X_END_CUST_STATE in VARCHAR2,
66   X_END_CUST_POSTAL_CODE in VARCHAR2,
67   X_END_CUST_COUNTRY in VARCHAR2,
68   X_END_CUST_ADDR_LINES_PHONETIC in VARCHAR2,
69   X_END_CUST_CONTACT_FIRST_NAME in VARCHAR2,
70   X_END_CUST_CONTACT_LAST_NAME in VARCHAR2,
71   X_END_CUST_CONTACT_TITLE in VARCHAR2,
72   X_END_CUST_CONTACT_EMAIL_ADDRE in VARCHAR2,
73   X_END_CUST_CONTACT_PHONE_TYPE in VARCHAR2,
74   X_END_CUST_CONTACT_PHONE_NUMBE in VARCHAR2,
75   X_END_CUST_CONTACT_PHONE_EXTN in VARCHAR2,
76   X_RESELLER_PARTY_ID in NUMBER,
77   X_RESELLER_DUNS_NUMBER in NUMBER,
78   X_RESELLER_SITE_USE_ID in NUMBER,
79   X_RESELLER_NAME in VARCHAR2,
80   X_RESELLER_ADDRESS1 in VARCHAR2,
81   X_RESELLER_ADDRESS2 in VARCHAR2,
82   X_RESELLER_ADDRESS3 in VARCHAR2,
83   X_RESELLER_ADDRESS4 in VARCHAR2,
84   X_RESELLER_PROVINCE in VARCHAR2,
85   X_RESELLER_COUNTY in VARCHAR2,
86   X_RESELLER_CITY in VARCHAR2,
87   X_RESELLER_STATE in VARCHAR2,
88   X_RESELLER_POSTAL_CODE in VARCHAR2,
89   X_RESELLER_COUNTRY in VARCHAR2,
90   X_RESELLER_ADDR_LINES_PHONETIC in VARCHAR2,
91   X_RESELLER_CONTACT_FIRST_NAME in VARCHAR2,
92   X_RESELLER_CONTACT_LAST_NAME in VARCHAR2,
93   X_RESELLER_CONTACT_TITLE in VARCHAR2,
94   X_RESELLER_CONTACT_EMAIL_ADDRE in VARCHAR2,
95   X_RESELLER_CONTACT_PHONE_NUMBE in VARCHAR2,
96   X_RESELLER_CONTACT_PHONE_TYPE in VARCHAR2,
97   X_RESELLER_CONTACT_PHONE_EXTN in VARCHAR2,
98   X_CUSTOMER_MERGE_FLAG in VARCHAR2,
99   X_ATTRIBUTE_CATEGORY in VARCHAR2,
100   X_ATTRIBUTE1 in VARCHAR2,
101   X_ATTRIBUTE2 in VARCHAR2,
102   X_ATTRIBUTE3 in VARCHAR2,
103   X_ATTRIBUTE4 in VARCHAR2,
104   X_ATTRIBUTE5 in VARCHAR2,
105   X_ATTRIBUTE6 in VARCHAR2,
106   X_ATTRIBUTE7 in VARCHAR2,
107   X_ATTRIBUTE8 in VARCHAR2,
108   X_ATTRIBUTE9 in VARCHAR2,
109   X_ATTRIBUTE10 in VARCHAR2,
110   X_ATTRIBUTE11 in VARCHAR2,
111   X_ATTRIBUTE12 in VARCHAR2,
112   X_ATTRIBUTE13 in VARCHAR2,
113   X_ATTRIBUTE14 in VARCHAR2,
114   X_ATTRIBUTE15 in VARCHAR2,X_ORG_ID in NUMBER,
115   X_SECURITY_GROUP_ID in NUMBER,
116   X_REQUEST_NAME in VARCHAR2,
117   X_REQUEST_DESCRIPTION in VARCHAR2, X_COMMENTS in VARCHAR2
118  );
119 procedure LOCK_ROW (
120      X_REQUEST_HEADER_ID in NUMBER,
121   X_REQUEST_CLASS in VARCHAR2,
122   X_OBJECT_VERSION_NUMBER in NUMBER,
123   X_REQUEST_ID in NUMBER,
124   X_CREATE_FROM in VARCHAR2,
125   X_REQUEST_NUMBER in VARCHAR2,
126   X_SHIP_FROM_STOCK_FLAG in VARCHAR2,
127   X_REQUEST_TYPE_CODE in VARCHAR2,
128   X_BENEFIT_ID in NUMBER,
129   X_ACTIVITY_MEDIA_ID in NUMBER,
130   X_SUBMITTED_BY in NUMBER,
131   X_SUBMITTED_DATE in DATE,
132   X_PARTNER_CONTACT_ID in NUMBER,
133   X_PARTNER_CONTACT_PHONE_NUMBER in VARCHAR2,
134   X_PARTNER_CONTACT_EMAIL_ADDRES in VARCHAR2,
135   X_OFFER_ID in NUMBER,
136   X_OFFER_TYPE in VARCHAR2,
137   X_LINKED_REQUEST_HEADER_ID in NUMBER,
138   X_ROOT_REQUEST_HEADER_ID in NUMBER,
139   X_START_DATE in DATE,
140   X_END_DATE in DATE,
141   X_STATUS_CODE in VARCHAR2,
142   X_REQUEST_OUTCOME in VARCHAR2,
143   X_DECLINE_REASON_CODE in VARCHAR2,
144   X_RETURN_REASON_CODE in VARCHAR2,
145   X_CURRENCY_CODE in VARCHAR2,
146   X_PARTNER_AMOUNT in NUMBER,
147   X_REQUESTED_AMOUNT in NUMBER,
148   X_APPROVED_AMOUNT in NUMBER,
149   X_EXCHANGE_RATE_TYPE in VARCHAR2,
150   X_EXCHANGE_RATE_DATE in DATE,
151   X_EXCHANGE_RATE in NUMBER,
152   X_PARTNER_ACCTD_AMOUNT in NUMBER,
153   X_REQUESTED_ACCTD_AMOUNT in NUMBER,
154   X_APPROVED_ACCTD_AMOUNT in NUMBER,
155   X_APPROVED_BY in NUMBER,
156   X_APPROVED_DATE in DATE,
157   X_AUTHORIZATION_CODE in VARCHAR2,
158   X_AGREEMENT_NUMBER in VARCHAR2,
159   X_PARTNER_ID in NUMBER,
160   X_PARTNER_SITE_USE_ID in NUMBER,
161   X_END_CUST_PARTY_ID in NUMBER,
162   X_END_CUST_SITE_USE_ID in NUMBER,
163   X_END_CUST_DUNS_NUMBER in NUMBER,
164   X_END_CUST_NAME in VARCHAR2,
165   X_END_CUST_ADDRESS1 in VARCHAR2,
166   X_END_CUST_ADDRESS2 in VARCHAR2,
167   X_END_CUST_ADDRESS3 in VARCHAR2,
168   X_END_CUST_ADDRESS4 in VARCHAR2,
169   X_END_CUST_PROVINCE in VARCHAR2,
170   X_END_CUST_COUNTY  in VARCHAR2,
171   X_END_CUST_CITY in VARCHAR2,
172   X_END_CUST_STATE in VARCHAR2,
173   X_END_CUST_POSTAL_CODE in VARCHAR2,
174   X_END_CUST_COUNTRY in VARCHAR2,
175   X_END_CUST_ADDR_LINES_PHONETIC in VARCHAR2,
176   X_END_CUST_CONTACT_FIRST_NAME in VARCHAR2,
177   X_END_CUST_CONTACT_LAST_NAME in VARCHAR2,
178   X_END_CUST_CONTACT_TITLE in VARCHAR2,
179   X_END_CUST_CONTACT_EMAIL_ADDRE in VARCHAR2,
180   X_END_CUST_CONTACT_PHONE_TYPE in VARCHAR2,
181   X_END_CUST_CONTACT_PHONE_NUMBE in VARCHAR2,
182   X_END_CUST_CONTACT_PHONE_EXTN in VARCHAR2,
183   X_RESELLER_PARTY_ID in NUMBER,
184   X_RESELLER_DUNS_NUMBER in NUMBER,
185   X_RESELLER_SITE_USE_ID in NUMBER,
186   X_RESELLER_NAME in VARCHAR2,
187   X_RESELLER_ADDRESS1 in VARCHAR2,
188   X_RESELLER_ADDRESS2 in VARCHAR2,
189   X_RESELLER_ADDRESS3 in VARCHAR2,
190   X_RESELLER_ADDRESS4 in VARCHAR2,
191   X_RESELLER_PROVINCE in VARCHAR2,
192   X_RESELLER_COUNTY in VARCHAR2,
193   X_RESELLER_CITY in VARCHAR2,
194   X_RESELLER_STATE in VARCHAR2,
195   X_RESELLER_POSTAL_CODE in VARCHAR2,
196   X_RESELLER_COUNTRY in VARCHAR2,
197   X_RESELLER_ADDR_LINES_PHONETIC in VARCHAR2,
198   X_RESELLER_CONTACT_FIRST_NAME in VARCHAR2,
199   X_RESELLER_CONTACT_LAST_NAME in VARCHAR2,
200   X_RESELLER_CONTACT_TITLE in VARCHAR2,
201   X_RESELLER_CONTACT_EMAIL_ADDRE in VARCHAR2,
202   X_RESELLER_CONTACT_PHONE_NUMBE in VARCHAR2,
203   X_RESELLER_CONTACT_PHONE_TYPE in VARCHAR2,
204   X_RESELLER_CONTACT_PHONE_EXTN in VARCHAR2,
205   X_CUSTOMER_MERGE_FLAG in VARCHAR2,
206   X_ATTRIBUTE_CATEGORY in VARCHAR2,
207   X_ATTRIBUTE1 in VARCHAR2,
208   X_ATTRIBUTE2 in VARCHAR2,
209   X_ATTRIBUTE3 in VARCHAR2,
210   X_ATTRIBUTE4 in VARCHAR2,
211   X_ATTRIBUTE5 in VARCHAR2,
212   X_ATTRIBUTE6 in VARCHAR2,
213   X_ATTRIBUTE7 in VARCHAR2,
214   X_ATTRIBUTE8 in VARCHAR2,
215   X_ATTRIBUTE9 in VARCHAR2,
216   X_ATTRIBUTE10 in VARCHAR2,
217   X_ATTRIBUTE11 in VARCHAR2,
218   X_ATTRIBUTE12 in VARCHAR2,
219   X_ATTRIBUTE13 in VARCHAR2,
220   X_ATTRIBUTE14 in VARCHAR2,
221   X_ATTRIBUTE15 in VARCHAR2,
222   X_SECURITY_GROUP_ID in NUMBER,
223   X_REQUEST_NAME in VARCHAR2,
224   X_REQUEST_DESCRIPTION in VARCHAR2,
225   X_COMMENTS in VARCHAR2,
226   X_PROGRAM_ID NUMBER,
227   X_PROGRAM_APPLICATION_ID NUMBER,
228   X_PROGRAM_UPDATE_DATE date,
229   X_ORG_ID NUMBER
230 );
231 procedure UPDATE_ROW (
232     X_REQUEST_HEADER_ID in NUMBER,
233   X_REQUEST_CLASS in VARCHAR2,
234   X_OBJECT_VERSION_NUMBER in NUMBER,
235   X_REQUEST_ID in NUMBER,
236   X_CREATE_FROM in VARCHAR2,
237   X_REQUEST_NUMBER in VARCHAR2,
238   X_SHIP_FROM_STOCK_FLAG in VARCHAR2,
239   X_REQUEST_TYPE_CODE in VARCHAR2,
240   X_BENEFIT_ID in NUMBER,
241   X_ACTIVITY_MEDIA_ID in NUMBER,
242   X_SUBMITTED_BY in NUMBER,
243   X_SUBMITTED_DATE in DATE,
244   X_PARTNER_CONTACT_ID in NUMBER,
245   X_PARTNER_CONTACT_PHONE_NUMBER in VARCHAR2,
246   X_PARTNER_CONTACT_EMAIL_ADDRES in VARCHAR2,
247   X_OFFER_ID in NUMBER,
248   X_OFFER_TYPE in VARCHAR2,
249   X_LINKED_REQUEST_HEADER_ID in NUMBER,
250   X_ROOT_REQUEST_HEADER_ID in NUMBER,
251   X_START_DATE in DATE,
252   X_END_DATE in DATE,
253   X_STATUS_CODE in VARCHAR2,
254   X_REQUEST_OUTCOME in VARCHAR2,
255   X_DECLINE_REASON_CODE in VARCHAR2,
256   X_RETURN_REASON_CODE in VARCHAR2,
257   X_CURRENCY_CODE in VARCHAR2,
258   X_PARTNER_AMOUNT in NUMBER,
259   X_REQUESTED_AMOUNT in NUMBER,
260   X_APPROVED_AMOUNT in NUMBER,
261   X_EXCHANGE_RATE_TYPE in VARCHAR2,
262   X_EXCHANGE_RATE_DATE in DATE,
263   X_EXCHANGE_RATE in NUMBER,
264   X_PARTNER_ACCTD_AMOUNT in NUMBER,
265   X_REQUESTED_ACCTD_AMOUNT in NUMBER,
266   X_APPROVED_ACCTD_AMOUNT in NUMBER,
267   X_APPROVED_BY in NUMBER,
268   X_APPROVED_DATE in DATE,
269   X_AUTHORIZATION_CODE in VARCHAR2,
270   X_AGREEMENT_NUMBER in VARCHAR2,
271   X_PARTNER_ID in NUMBER,
272   X_PARTNER_SITE_USE_ID in NUMBER,
273   X_END_CUST_PARTY_ID in NUMBER,
274   X_END_CUST_SITE_USE_ID in NUMBER,
275   X_END_CUST_DUNS_NUMBER in NUMBER,
276   X_END_CUST_NAME in VARCHAR2,
277   X_END_CUST_ADDRESS1 in VARCHAR2,
278   X_END_CUST_ADDRESS2 in VARCHAR2,
279   X_END_CUST_ADDRESS3 in VARCHAR2,
280   X_END_CUST_ADDRESS4 in VARCHAR2,
281   X_END_CUST_PROVINCE in VARCHAR2,
282   X_END_CUST_COUNTY  in VARCHAR2,
283   X_END_CUST_CITY in VARCHAR2,
284   X_END_CUST_STATE in VARCHAR2,
285   X_END_CUST_POSTAL_CODE in VARCHAR2,
286   X_END_CUST_COUNTRY in VARCHAR2,
287   X_END_CUST_ADDR_LINES_PHONETIC in VARCHAR2,
288   X_END_CUST_CONTACT_FIRST_NAME in VARCHAR2,
289   X_END_CUST_CONTACT_LAST_NAME in VARCHAR2,
290   X_END_CUST_CONTACT_TITLE in VARCHAR2,
291   X_END_CUST_CONTACT_EMAIL_ADDRE in VARCHAR2,
292   X_END_CUST_CONTACT_PHONE_TYPE in VARCHAR2,
293   X_END_CUST_CONTACT_PHONE_NUMBE in VARCHAR2,
294   X_END_CUST_CONTACT_PHONE_EXTN in VARCHAR2,
295   X_RESELLER_PARTY_ID in NUMBER,
296   X_RESELLER_DUNS_NUMBER in NUMBER,
297   X_RESELLER_SITE_USE_ID in NUMBER,
298   X_RESELLER_NAME in VARCHAR2,
299   X_RESELLER_ADDRESS1 in VARCHAR2,
300   X_RESELLER_ADDRESS2 in VARCHAR2,
301   X_RESELLER_ADDRESS3 in VARCHAR2,
302   X_RESELLER_ADDRESS4 in VARCHAR2,
303   X_RESELLER_PROVINCE in VARCHAR2,
304   X_RESELLER_COUNTY in VARCHAR2,
305   X_RESELLER_CITY in VARCHAR2,
306   X_RESELLER_STATE in VARCHAR2,
307   X_RESELLER_POSTAL_CODE in VARCHAR2,
308   X_RESELLER_COUNTRY in VARCHAR2,
309   X_RESELLER_ADDR_LINES_PHONETIC in VARCHAR2,
310   X_RESELLER_CONTACT_FIRST_NAME in VARCHAR2,
311   X_RESELLER_CONTACT_LAST_NAME in VARCHAR2,
312   X_RESELLER_CONTACT_TITLE in VARCHAR2,
313   X_RESELLER_CONTACT_EMAIL_ADDRE in VARCHAR2,
314   X_RESELLER_CONTACT_PHONE_NUMBE in VARCHAR2,
315   X_RESELLER_CONTACT_PHONE_TYPE in VARCHAR2,
316   X_RESELLER_CONTACT_PHONE_EXTN in VARCHAR2,
317   X_CUSTOMER_MERGE_FLAG in VARCHAR2,
318   X_ATTRIBUTE_CATEGORY in VARCHAR2,
319   X_ATTRIBUTE1 in VARCHAR2,
320   X_ATTRIBUTE2 in VARCHAR2,
321   X_ATTRIBUTE3 in VARCHAR2,
322   X_ATTRIBUTE4 in VARCHAR2,
323   X_ATTRIBUTE5 in VARCHAR2,
324   X_ATTRIBUTE6 in VARCHAR2,
325   X_ATTRIBUTE7 in VARCHAR2,
326   X_ATTRIBUTE8 in VARCHAR2,
327   X_ATTRIBUTE9 in VARCHAR2,
328   X_ATTRIBUTE10 in VARCHAR2,
329   X_ATTRIBUTE11 in VARCHAR2,
330   X_ATTRIBUTE12 in VARCHAR2,
331   X_ATTRIBUTE13 in VARCHAR2,
332   X_ATTRIBUTE14 in VARCHAR2,
333   X_ATTRIBUTE15 in VARCHAR2,
334   X_SECURITY_GROUP_ID in NUMBER,
335   X_REQUEST_NAME in VARCHAR2,
336   X_REQUEST_DESCRIPTION in VARCHAR2,
337   X_COMMENTS in VARCHAR2,
338   X_LAST_UPDATE_DATE in DATE,
339   X_LAST_UPDATED_BY in NUMBER,
340   X_LAST_UPDATE_LOGIN in NUMBER,
341   X_PROGRAM_ID NUMBER,
342   X_PROGRAM_APPLICATION_ID NUMBER,
343   X_PROGRAM_UPDATE_DATE date,
344   X_ORG_ID NUMBER
345 );
346 procedure DELETE_ROW (
347   X_REQUEST_HEADER_ID in NUMBER
348 );
349 procedure ADD_LANGUAGE;
350 end OZF_REQUEST_HEADERS_ALL_PKG;
351