[Home] [Help]
PACKAGE: APPS.PO_VAL_HEADERS
Source
1 PACKAGE PO_VAL_HEADERS AUTHID CURRENT_USER AS
2 -- $Header: PO_VAL_HEADERS.pls 120.14.12020000.4 2013/04/03 04:45:30 amalick ship $
3
4 PROCEDURE price_update_tol_ge_zero(
5 p_header_id_tbl IN PO_TBL_NUMBER
6 , p_price_update_tol_tbl IN PO_TBL_NUMBER
7 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8 , x_result_type OUT NOCOPY VARCHAR2
9 );
10
11 PROCEDURE amount_limit_ge_zero(
12 p_header_id_tbl IN PO_TBL_NUMBER
13 , p_amount_limit_tbl IN PO_TBL_NUMBER
14 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
15 , x_result_type OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE amt_limit_ge_amt_agreed(
19 p_header_id_tbl IN PO_TBL_NUMBER
20 , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
21 , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
22 , p_amount_limit_tbl IN PO_TBL_NUMBER
23 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
24 , x_result_type OUT NOCOPY VARCHAR2
25 );
26
27 PROCEDURE amount_agreed_ge_zero(
28 p_header_id_tbl IN PO_TBL_NUMBER
29 , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
30 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
31 , x_result_type OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE amount_agreed_not_null(
35 p_header_id_tbl IN PO_TBL_NUMBER
36 , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
37 , p_amount_limit_tbl IN PO_TBL_NUMBER
38 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
39 , x_result_type OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE warn_supplier_on_hold(
43 p_header_id_tbl IN PO_TBL_NUMBER
44 , p_vendor_id_tbl IN PO_TBL_NUMBER
45 , x_result_set_id IN OUT NOCOPY NUMBER
46 , x_result_type OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE rate_gt_zero(
50 p_header_id_tbl IN PO_TBL_NUMBER
51 , p_rate_tbl IN PO_TBL_NUMBER
52 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
53 , x_result_type OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE rate_combination_valid(
57 p_header_id_tbl IN PO_TBL_NUMBER
58 , p_org_id_tbl IN PO_TBL_NUMBER
59 , p_currency_code_tbl IN PO_TBL_VARCHAR30
60 , p_rate_type_tbl IN PO_TBL_VARCHAR30
61 , p_rate_date_tbl IN PO_TBL_DATE
62 , p_rate_tbl IN PO_TBL_NUMBER
63 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
64 , x_result_type OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE fax_email_address_valid(
68 p_header_id_tbl IN PO_TBL_NUMBER
69 , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30
70 , p_fax_tbl IN PO_TBL_VARCHAR30
71 , p_email_address_tbl IN PO_TBL_VARCHAR2000
72 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
73 , x_result_type OUT NOCOPY VARCHAR2
74 );
75
76 PROCEDURE effective_le_expiration(
77 p_header_id_tbl IN PO_TBL_NUMBER
78 , p_start_date_tbl IN PO_TBL_DATE
79 , p_end_date_tbl IN PO_TBL_DATE
80 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
81 , x_result_type OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE effective_from_le_order_date(
85 p_header_id_tbl IN PO_TBL_NUMBER
86 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
87 , p_start_date_tbl IN PO_TBL_DATE
88 , x_result_set_id IN OUT NOCOPY NUMBER
89 , x_result_type OUT NOCOPY VARCHAR2
90 );
91
92 PROCEDURE effective_to_ge_order_date(
93 p_header_id_tbl IN PO_TBL_NUMBER
94 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
95 , p_end_date_tbl IN PO_TBL_DATE
96 , x_result_set_id IN OUT NOCOPY NUMBER
97 , x_result_type OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE contract_start_le_order_date(
101 p_header_id_tbl IN PO_TBL_NUMBER
102 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
103 , p_start_date_tbl IN PO_TBL_DATE
104 , x_result_set_id IN OUT NOCOPY NUMBER
105 , x_result_type OUT NOCOPY VARCHAR2
106 );
107
108 PROCEDURE contract_end_ge_order_date(
109 p_header_id_tbl IN PO_TBL_NUMBER
110 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
111 , p_end_date_tbl IN PO_TBL_DATE
112 , x_result_set_id IN OUT NOCOPY NUMBER
113 , x_result_type OUT NOCOPY VARCHAR2
114 );
115
116 PROCEDURE doc_num_chars_valid(
117 p_header_id_tbl IN PO_TBL_NUMBER
118 , p_org_id_tbl IN PO_TBL_NUMBER
119 , p_style_id_tbl IN PO_TBL_NUMBER
120 , p_segment1_tbl IN PO_TBL_VARCHAR30
121 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
122 , x_result_type OUT NOCOPY VARCHAR2
123 );
124
125 PROCEDURE doc_num_unique(
126 p_header_id_tbl IN PO_TBL_NUMBER
127 , p_org_id_tbl IN PO_TBL_NUMBER
128 , p_segment1_tbl IN PO_TBL_VARCHAR30
129 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
130 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
131 , x_result_type OUT NOCOPY VARCHAR2
132 );
133
134 PROCEDURE check_agreement_dates(
135 p_online_report_id IN NUMBER
136 , p_login_id IN NUMBER
137 , p_user_id IN NUMBER
138 , x_sequence IN OUT NOCOPY NUMBER
139 );
140
141 PROCEDURE agent_id_not_null(
142 p_header_id_tbl IN PO_TBL_NUMBER
143 , p_agent_id_tbl IN PO_TBL_NUMBER
144 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
145 , x_result_type OUT NOCOPY VARCHAR2
146 );
147
148 PROCEDURE ship_to_loc_not_null(
149 p_header_id_tbl IN PO_TBL_NUMBER
150 , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
151 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
152 , x_result_type OUT NOCOPY VARCHAR2
153 );
154
155 PROCEDURE vendor_id_not_null(
156 p_header_id_tbl IN PO_TBL_NUMBER
157 , p_vendor_id_tbl IN PO_TBL_NUMBER
158 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
159 , x_result_type OUT NOCOPY VARCHAR2
160 );
161
162 PROCEDURE vendor_site_id_not_null(
163 p_header_id_tbl IN PO_TBL_NUMBER
164 , p_vendor_site_id_tbl IN PO_TBL_NUMBER
165 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
166 , x_result_type OUT NOCOPY VARCHAR2
167 );
168
169 --<Begin Bug# 5372769> EXCEPTION WHEN SAVE PO WO/ NUMBER IF DOCUMENT NUMBERING IS SET TO MANUAL
170 PROCEDURE segment1_not_null(
171 p_header_id_tbl IN PO_TBL_NUMBER
172 , p_segment1_tbl IN PO_TBL_VARCHAR30
173 , p_org_id_tbl IN PO_TBL_NUMBER
174 , x_result_set_id IN OUT NOCOPY NUMBER
175 , x_result_type OUT NOCOPY VARCHAR2
176 );
177 --<End 5372769>
178 --<Start Bug 9213424> Error when the ship_via field has an invalid value.
179 PROCEDURE ship_via_lookup_code_valid(p_header_id_tbl IN po_tbl_number,
180 p_ship_via_lookup_code_tbl IN PO_TBL_VARCHAR30,
181 --Bug 12409257 start. Bug 13771850-Revert 12409257 changes
182 p_org_id_tbl IN PO_TBL_NUMBER ,
183 -- p_ship_to_location_id_tbl IN PO_TBL_NUMBER ,
184 --Bug 12409257 end. Bug 13771850 end
185 x_result_set_id IN OUT NOCOPY NUMBER,
186 x_result_type OUT NOCOPY VARCHAR2);
187
188 --<End Bug 9213424>
189
190 --Mod Project
191 PROCEDURE mod_eff_dt_lt_need_by_dt(
192 p_header_id_tbl IN PO_TBL_NUMBER
193 ,p_mod_eff_date_tbl IN PO_TBL_DATE
194 ,x_result_set_id IN OUT NOCOPY NUMBER
195 ,x_result_type OUT NOCOPY VARCHAR2
196 );
197
198 PROCEDURE mod_eff_dt_not_null(
199 p_header_id_tbl IN PO_TBL_NUMBER
200 ,p_draft_type_tbl IN PO_TBL_VARCHAR30
201 ,p_mod_eff_date_tbl IN PO_TBL_DATE
202 ,x_result_set_id IN OUT NOCOPY NUMBER
203 ,x_result_type OUT NOCOPY VARCHAR2
204 );
205
206 PROCEDURE mod_no_cancel_shp_complt(
207 p_header_id_tbl IN PO_TBL_NUMBER
208 ,p_control_action_tbl IN PO_TBL_VARCHAR30
209 ,x_result_set_id IN OUT NOCOPY NUMBER
210 ,x_result_type OUT NOCOPY VARCHAR2
211 );
212
213 PROCEDURE print_form_format_valid(
214 p_header_id_tbl IN PO_TBL_NUMBER
215 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
216 , p_style_id_tbl IN PO_TBL_NUMBER
217 ,p_draft_type_tbl IN PO_TBL_VARCHAR30
218 , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000
219 , p_document_format_tbl IN PO_TBL_VARCHAR2000
220 , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER
221 , p_clm_ext_idv_tbl IN PO_TBL_VARCHAR2000
222 , p_clm_award_type_tbl IN PO_TBL_VARCHAR30 -- bug 10389450
223 , x_result_set_id IN OUT NOCOPY NUMBER
224 , x_result_type OUT NOCOPY VARCHAR2
225 );
226
227 PROCEDURE clm_eff_from_le_order_date(
228 p_header_id_tbl IN PO_TBL_NUMBER
229 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
230 , p_start_date_tbl IN PO_TBL_DATE
231 , p_clm_effective_date_tbl IN PO_TBL_DATE
232 , x_result_set_id IN OUT NOCOPY NUMBER
233 , x_result_type OUT NOCOPY VARCHAR2
234 );
235
236 PROCEDURE max_ceil_awd_amt_gt_min(
237 p_header_id_tbl IN PO_TBL_NUMBER
238 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
239 , p_amount_limit_tbl IN PO_TBL_NUMBER
240 , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER
241 , x_result_set_id IN OUT NOCOPY NUMBER
242 , x_result_type OUT NOCOPY VARCHAR2
243 );
244
245 PROCEDURE max_ord_amt_gt_min(
246 p_header_id_tbl IN PO_TBL_NUMBER
247 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
248 , p_min_order_amt_tbl IN PO_TBL_NUMBER
249 , p_max_order_amt_tbl IN PO_TBL_NUMBER
250 , x_result_set_id IN OUT NOCOPY NUMBER
251 , x_result_type OUT NOCOPY VARCHAR2
252 );
253
254 PROCEDURE min_guar_perc_range_check(
255 p_header_id_tbl IN PO_TBL_NUMBER
256 , p_min_guar_perc_tbl IN PO_TBL_NUMBER
257 , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
258 , x_result_type OUT NOCOPY VARCHAR2
259 );
260
261 PROCEDURE max_ceil_amt_gt_min_ord (
262 p_header_id_tbl IN PO_TBL_NUMBER
263 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
264 , p_amount_limit_tbl IN PO_TBL_NUMBER
265 , p_min_order_amt_tbl IN PO_TBL_NUMBER
266 , x_result_set_id IN OUT NOCOPY NUMBER
267 , x_result_type OUT NOCOPY VARCHAR2
268 );
269
270
271 PROCEDURE max_ceil_amt_gt_max_ord (
272 p_header_id_tbl IN PO_TBL_NUMBER
273 , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
274 , p_amount_limit_tbl IN PO_TBL_NUMBER
275 , p_max_order_amt_tbl IN PO_TBL_NUMBER
276 , x_result_set_id IN OUT NOCOPY NUMBER
277 , x_result_type OUT NOCOPY VARCHAR2
278 );
279
280 --CLM PDOI Integration starts
281 PROCEDURE validate_clm_standard_form (
282
283 p_intf_header_id IN PO_TBL_NUMBER,
284 p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
285 p_style_id_tbl IN PO_TBL_NUMBER,
286 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
287 x_result_type OUT NOCOPY VARCHAR2
288 );
289
290 PROCEDURE validate_clm_document_format(
291 p_intf_header_id IN PO_TBL_NUMBER,
292 p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
293 p_clm_document_format_tbl IN PO_TBL_VARCHAR2000,
294 p_style_id_tbl IN PO_TBL_NUMBER,
295 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
296 x_result_type OUT NOCOPY VARCHAR2
297 );
298
299 PROCEDURE validate_source_idv
300 (
301 p_intf_header_id in PO_TBL_NUMBER,
302 p_src_doc_id_tbl IN PO_TBL_NUMBER,
303 p_currency_code_tbl in PO_TBL_VARCHAR30,
304 p_org_id_tbl in PO_TBL_NUMBER,
305 x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
306 x_result_type OUT NOCOPY VARCHAR2
307 );
308
309 PROCEDURE validate_award_admin
310 (
311 p_intf_header_id IN PO_TBL_NUMBER,
312 p_award_admin_tbl IN PO_TBL_VARCHAR2000,
313 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
314 x_result_type OUT NOCOPY VARCHAR2
315 );
316
317 PROCEDURE validate_contract_officer
318 (
319 p_intf_header_id IN PO_TBL_NUMBER,
320 p_contract_officer_tbl IN PO_TBL_NUMBER,
321 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
322 x_result_type OUT NOCOPY VARCHAR2
323 );
324
325 PROCEDURE validate_umbrella_program_id
326 (
327 p_intf_header_id IN PO_TBL_NUMBER,
328 p_umbrella_program_id_tbl IN PO_TBL_NUMBER,
329 p_src_doc_id_tbl IN PO_TBL_NUMBER,
330 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
331 x_result_type OUT NOCOPY VARCHAR2
332 );
333
334 PROCEDURE validate_clm_award_type
335 (
336 p_intf_header_id IN PO_TBL_NUMBER,
337 p_clm_award_type_tbl IN PO_TBL_VARCHAR30,
338 p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
339 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
340 x_result_type OUT NOCOPY VARCHAR2
341 );
342
343 PROCEDURE validate_style_id
344 (
345 p_intf_header_id IN PO_TBL_NUMBER,
346 p_style_id_tbl IN PO_TBL_NUMBER,
347 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
348 x_result_type OUT NOCOPY VARCHAR2
349 );
350
351 PROCEDURE validate_idv_style_id
352 (
353 p_intf_header_id IN PO_TBL_NUMBER,
354 p_style_id_tbl IN PO_TBL_NUMBER,
355 p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
356 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
357 x_result_type OUT NOCOPY VARCHAR2
358 );
359
360 PROCEDURE validate_po_idv_vendor_site_id
361 (
362 p_intf_header_id IN PO_TBL_NUMBER,
363 p_vendor_site_id_tbl IN PO_TBL_NUMBER,
364 p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
365 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
366 x_result_type OUT NOCOPY VARCHAR2
367 );
368
369 PROCEDURE validate_po_idv_vendor_id
370 (
371 p_intf_header_id IN PO_TBL_NUMBER,
372 p_vendor_id_tbl IN PO_TBL_NUMBER,
373 p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
374 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
375 x_result_type OUT NOCOPY VARCHAR2
376 );
377 --CLM PDOI Integration ends
378
379 --<Bug 16474640>
380 PROCEDURE validate_mod_number(
381 p_header_id_tbl IN PO_TBL_NUMBER,
382 p_draft_type_tbl IN PO_TBL_VARCHAR30,
383 p_mod_number_tbl IN PO_TBL_VARCHAR100,
384 x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
385 x_result_type OUT NOCOPY VARCHAR2
386 );
387
388 END PO_VAL_HEADERS;