1 PACKAGE PO_HEADERS_SV6 AUTHID CURRENT_USER AS
2 /* $Header: POXPIV2S.pls 115.4 2003/06/26 22:17:45 dxie noship $ */
3
4 /*==================================================================
5 FUNCTION NAME: val_doc_num_uniqueness()
6
7 DESCRIPTION: This API is used to validate the uniqueness of the
8 document number for a particular document type.
9
10 PARAMETERS: x_segment1 IN VARCHAR2,
11 X_rowid IN VARCHAR2,
12 X_type_lookup_code IN VARCHAR2
13
14 DESIGN
15 REFERENCES: 832vlapi.doc
16
17 ALGORITHM: API will returns TRUE if validation succeeds, FALSE
18 otherwise.
19
20 NOTES:
21
22 OPEN ISSUES:
23
24 CLOSE ISSUES:
25
26 CHANGE
27 HISTORY: Created 03-Mar-1996 Rajan
28
29
30 =======================================================================*/
31 FUNCTION val_doc_num_uniqueness(x_segment1 IN VARCHAR2,
32 X_rowid IN VARCHAR2,
33 X_type_lookup_code IN VARCHAR2)
34 RETURN BOOLEAN;
35
36 /*==================================================================
37 FUNCTION NAME: val_header_id_uniqueness()
38
39 DESCRIPTION: This API is used to validate the uniqueness of
40 po_header_id in po_headers table.
41
42 PARAMETERS: x_po_header_id IN NUMBER
43 X_row_id IN VARCHAR2
44
45
46 DESIGN
47 REFERENCES: 832vlapi.doc
48
49 ALGORITHM: API will return TRUE if validation succeeds, FALSE
50 otherwise.
51
52 NOTES:
53
54 OPEN ISSUES:
55
56 CLOSE ISSUES:
57
58 CHANGE
59 HISTORY: Created 03-Mar-1996 Rajan
60
61
62 =======================================================================*/
63 FUNCTION val_header_id_uniqueness (x_po_header_id IN NUMBER,
64 x_rowid IN VARCHAR2)
65 RETURN BOOLEAN;
66
67 /*==================================================================
68 FUNCTION NAME: val_rate_info()
69
70 DESCRIPTION: This API is used to validate rate_type, rate_date
71 and rate information
72
73 PARAMETERS: X_base_currency_code IN VARCHAR2,
74 X_currency_code IN VARCHAR2,
75 X_rate_type_code IN VARCHAR2,
76 X_rate_date IN DATE,
77 X_rate IN NUMBER,
78 x_error_code IN OUT VARCHAR2
79
80
81 DESIGN
82 REFERENCES: 832vlapi.doc
83
84 ALGORITHM: API will return TRUE if validation succeeds, FALSE
85 and error_code otherwise.
86
87 NOTES:
88
89 OPEN ISSUES:
90
91 CLOSE ISSUES:
92
93 CHANGE
94 HISTORY: Created 03-Mar-1996 Rajan
95 Modified 13-MAR-1996 Daisy Yu
96
97 =======================================================================*/
98 FUNCTION val_rate_info(X_base_currency_code IN VARCHAR2,
99 X_currency_code IN VARCHAR2,
100 X_rate_type_code IN varchar2,
101 X_rate_date IN DATE,
102 X_rate IN NUMBER,
103 X_error_code IN OUT NOCOPY VARCHAR2)
104 RETURN BOOLEAN;
105
106 /*==================================================================
107 FUNCTION NAME: val_doc_num()
108
109 DESCRIPTION: This API is used to validate the document number(
110 i.e. to find out if it is a numeric value and also
111 to check if it is greater than zero(only if the option
112 is 'numeric')).
113
114 PARAMETERS: X_doc_type IN VARCHAR2,
115 X_doc_num IN VARCHAR2,
116 X_user_defined_num IN VARCHAR2,
117 X_user_defined_po_num_code IN VARCHAR2,
118 X_error_code IN OUT VARCHAR2
119
120
121 DESIGN
122 REFERENCES: 832vlapi.doc
123
124 ALGORITHM: API will return TRUE if validation succeeds, FALSE
125 otherwise.
126
127 NOTES:
128
129 OPEN ISSUES:
130
131 CLOSE ISSUES:
132
133 CHANGE
134 HISTORY: Created 03-Mar-1996 Rajan
135 Modified 13-MAR-1996 Daisy Yu
136
137 =======================================================================*/
138 FUNCTION val_doc_num(X_doc_type IN VARCHAR2,
139 X_doc_num IN VARCHAR2,
140 X_user_defined_num IN VARCHAR2,
141 X_user_defined_po_num_code IN VARCHAR2,
142 X_error_code IN OUT NOCOPY VARCHAR2 )
143 RETURN BOOLEAN;
144
145 /*==================================================================
146 FUNCTION NAME: val_lookup_code()
147
148 DESCRIPTION: This API is used to validate the lookup_code and
149 make sure it is valid and active.
150
151 PARAMETERS: X_lookup_code IN VARCHAR2,
152 X_lookup_type IN VARCHAR2
153
154
155 DESIGN
156 REFERENCES: 832vlapi.doc
157
158 ALGORITHM: API will return TRUE if validation succeeds, FALSE
159 otherwise.
160
161 NOTES:
162
163 OPEN ISSUES:
164
165 CLOSE ISSUES:
166
167 CHANGE
168 HISTORY: Created 03-Mar-1996 Rajan
169 Modified 13-MAR-1996 Daisy Yu
170
171 =======================================================================*/
172 FUNCTION val_lookup_code (X_lookup_code IN VARCHAR2,
173 X_lookup_type IN VARCHAR2)
174 RETURN BOOLEAN;
175
176
177 /*==================================================================
178 PROCEDURE NAME: validate_po_headers()
179
180 DESCRIPTION: This API is used to validate all columns in
181 po_headers table during the purchasing Docs
182 open interface Load.
183
184 PARAMETERS:
185
186
187 DESIGN
188 REFERENCES: 832vlapi.doc
189
190 ALGORITHM:
191
192 NOTES:
193
194 OPEN ISSUES:
195
196 CLOSE ISSUES:
197
198 CHANGE
199 HISTORY: Created 03-Mar-1996 Rajan Odayar
200 Modified 16-MAR-1996 Daisy Yu
201 Modified 24-APR-1996 Daisy Yu
202 Modified 11-Jun-1996 KKCHAN
203 * added approval_status validation
204
205 =======================================================================*/
206
207 PROCEDURE validate_po_headers(
208 X_PO_HEADER_ID IN NUMBER,
209 X_AGENT_ID IN NUMBER,
210 X_TYPE_LOOKUP_CODE IN VARCHAR2,
211 X_LAST_UPDATE_DATE IN DATE,
212 X_LAST_UPDATED_BY IN NUMBER,
213 X_SEGMENT1 IN VARCHAR2,
214 X_SUMMARY_FLAG IN VARCHAR2,
215 X_ENABLED_FLAG IN VARCHAR2,
216 X_SEGMENT2 IN VARCHAR2,
217 X_SEGMENT3 IN VARCHAR2,
218 X_SEGMENT4 IN VARCHAR2,
219 X_SEGMENT5 IN VARCHAR2,
220 X_START_DATE_ACTIVE IN DATE,
221 X_END_DATE_ACTIVE IN DATE,
222 X_LAST_UPDATE_LOGIN IN NUMBER,
223 X_CREATION_DATE IN DATE,
224 X_CREATED_BY IN NUMBER,
225 X_VENDOR_ID IN NUMBER,
226 X_VENDOR_SITE_ID IN NUMBER,
227 X_VENDOR_CONTACT_ID IN NUMBER,
228 X_SHIP_TO_LOCATION_ID IN NUMBER,
229 X_BILL_TO_LOCATION_ID IN NUMBER,
230 X_TERMS_ID IN NUMBER,
231 X_SHIP_VIA_LOOKUP_CODE IN VARCHAR2,
232 X_FOB_LOOKUP_CODE IN VARCHAR2,
233 X_FREIGHT_TERMS_LOOKUP_CODE IN VARCHAR2,
234 X_STATUS_LOOKUP_CODE IN VARCHAR2,
235 X_CURRENCY_CODE IN VARCHAR2,
236 X_RATE_TYPE IN VARCHAR2,
237 X_RATE_DATE IN DATE,
238 X_RATE IN NUMBER,
239 X_FROM_HEADER_ID IN NUMBER,
240 X_FROM_TYPE_LOOKUP_CODE IN VARCHAR2,
241 X_START_DATE IN DATE,
242 X_END_DATE IN DATE,
243 X_BLANKET_TOTAL_AMOUNT IN NUMBER,
244 X_AUTHORIZATION_STATUS IN VARCHAR2,
245 X_REVISION_NUM IN NUMBER,
246 -- Bug 902976, zxzhang, 10/04/99
247 -- Change REVISED_DATE from VarChar(25) to Date.
248 -- X_REVISED_DATE IN VARCHAR2,
249 X_REVISED_DATE IN DATE,
250 X_APPROVED_FLAG IN VARCHAR2,
251 X_APPROVED_DATE IN DATE,
252 X_AMOUNT_LIMIT IN NUMBER,
253 X_MIN_RELEASE_AMOUNT IN NUMBER,
254 X_NOTE_TO_AUTHORIZER IN VARCHAR2,
255 X_NOTE_TO_VENDOR IN VARCHAR2,
256 X_NOTE_TO_RECEIVER IN VARCHAR2,
257 X_PRINT_COUNT IN NUMBER,
258 X_PRINTED_DATE IN DATE,
259 X_VENDOR_ORDER_NUM IN VARCHAR2,
260 X_CONFIRMING_ORDER_FLAG IN VARCHAR2,
261 X_COMMENTS IN VARCHAR2,
262 X_REPLY_DATE IN DATE,
263 X_REPLY_METHOD_LOOKUP_CODE IN VARCHAR2,
264 X_RFQ_CLOSE_DATE IN DATE,
265 X_QUOTE_TYPE_LOOKUP_CODE IN VARCHAR2,
266 X_QUOTATION_CLASS_CODE IN VARCHAR2,
267 X_QUOTE_WARNING_DELAY IN NUMBER,
268 X_QUOTE_VENDOR_QUOTE_NUM IN VARCHAR2,
269 X_ACCEPTANCE_REQUIRED_FLAG IN VARCHAR2,
270 X_ACCEPTANCE_DUE_DATE IN DATE,
271 X_CLOSED_DATE IN DATE,
272 X_USER_HOLD_FLAG IN VARCHAR2,
273 X_APPROVAL_REQUIRED_FLAG IN VARCHAR2,
274 X_CANCEL_FLAG IN VARCHAR2,
275 X_FIRM_STATUS_LOOKUP_CODE IN VARCHAR2,
276 X_FIRM_DATE IN DATE,
277 X_FROZEN_FLAG IN VARCHAR2,
278 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
279 X_ATTRIBUTE1 IN VARCHAR2,
280 X_ATTRIBUTE2 IN VARCHAR2,
281 X_ATTRIBUTE3 IN VARCHAR2,
282 X_ATTRIBUTE4 IN VARCHAR2,
283 X_ATTRIBUTE5 IN VARCHAR2,
284 X_ATTRIBUTE6 IN VARCHAR2,
285 X_ATTRIBUTE7 IN VARCHAR2,
286 X_ATTRIBUTE8 IN VARCHAR2,
287 X_ATTRIBUTE9 IN VARCHAR2,
288 X_ATTRIBUTE10 IN VARCHAR2,
289 X_ATTRIBUTE11 IN VARCHAR2,
290 X_ATTRIBUTE12 IN VARCHAR2,
291 X_ATTRIBUTE13 IN VARCHAR2,
292 X_ATTRIBUTE14 IN VARCHAR2,
293 X_ATTRIBUTE15 IN VARCHAR2,
294 X_CLOSED_CODE IN VARCHAR2,
295 X_USSGL_TRANSACTION_CODE IN VARCHAR2,
296 X_GOVERNMENT_CONTEXT IN VARCHAR2,
297 X_REQUEST_ID IN NUMBER,
298 X_PROGRAM_APPLICATION_ID IN NUMBER,
299 X_PROGRAM_ID IN NUMBER,
300 X_PROGRAM_UPDATE_DATE IN DATE,
301 X_INTERFACE_SOURCE_CODE IN VARCHAR2,
302 X_INTERFACE_HEADER_ID IN NUMBER,
303 X_REFERENCE_NUM IN VARCHAR2,
304 X_ORG_ID IN NUMBER,
305 X_QUOTE_WARNING_DELAY_UNIT IN VARCHAR2,
306 X_APPROVAL_STATUS IN VARCHAR2,
307 X_release_num IN NUMBER,
308 X_po_release_id IN NUMBER,
309 X_release_date IN DATE,
310 X_manual_quote_num_type IN VARCHAR2,
311 X_manual_po_num_type IN VARCHAR2,
312 X_amount_agreed IN NUMBER,
313 X_base_currency_code IN VARCHAR2,
314 X_chart_of_accounts_id IN NUMBER,
315 X_def_inv_org_id IN NUMBER,
316 X_header_processable_flag IN OUT NOCOPY VARCHAR2,
317 X_action_code IN VARCHAR2,
318 p_shipping_control IN VARCHAR2 -- <INBOUND LOGISTICS FPJ>
319 );
320
321
322 END PO_HEADERS_SV6;