DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_VALIDATION_RESULTS_TYPE

Line 7: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 14: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 23: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 30: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 38: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 52: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 63: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 72: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 80: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 121: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 130: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 144: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 151: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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(

Line 165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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: -- EXCEPTION WHEN SAVE PO WO/ NUMBER IF DOCUMENT NUMBERING IS SET TO MANUAL

Line 257: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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 (

Line 286: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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(

Line 295: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

Line 305: x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

Line 313: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

Line 321: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

Line 330: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

Line 339: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_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

Line 347: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

Line 356: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

Line 365: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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

Line 374: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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:

Line 384: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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;