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.

APPS.PO_VAL_HEADERS dependencies on PO_TBL_NUMBER

Line 177: p_header_id_tbl IN PO_TBL_NUMBER

173: -- Checks that the Price Update Tolerance is greater than or equal to zero.
174: -- Agreements only.
175: ---------------------------------------------------------------------------
176: PROCEDURE price_update_tol_ge_zero(
177: p_header_id_tbl IN PO_TBL_NUMBER
178: , p_price_update_tol_tbl IN PO_TBL_NUMBER
179: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
180: , x_result_type OUT NOCOPY VARCHAR2
181: )

Line 178: , p_price_update_tol_tbl IN PO_TBL_NUMBER

174: -- Agreements only.
175: ---------------------------------------------------------------------------
176: PROCEDURE price_update_tol_ge_zero(
177: p_header_id_tbl IN PO_TBL_NUMBER
178: , p_price_update_tol_tbl IN PO_TBL_NUMBER
179: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
180: , x_result_type OUT NOCOPY VARCHAR2
181: )
182: IS

Line 205: p_header_id_tbl IN PO_TBL_NUMBER

201: -- Checks that the Amount Limit is greater than or equal to zero.
202: -- Agreements only.
203: ---------------------------------------------------------------------------
204: PROCEDURE amount_limit_ge_zero(
205: p_header_id_tbl IN PO_TBL_NUMBER
206: , p_amount_limit_tbl IN PO_TBL_NUMBER
207: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
208: , x_result_type OUT NOCOPY VARCHAR2
209: )

Line 206: , p_amount_limit_tbl IN PO_TBL_NUMBER

202: -- Agreements only.
203: ---------------------------------------------------------------------------
204: PROCEDURE amount_limit_ge_zero(
205: p_header_id_tbl IN PO_TBL_NUMBER
206: , p_amount_limit_tbl IN PO_TBL_NUMBER
207: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
208: , x_result_type OUT NOCOPY VARCHAR2
209: )
210: IS

Line 233: p_header_id_tbl IN PO_TBL_NUMBER

229: -- Checks that the Amount Limit is greater than or equal to the Amount Agreed.
230: -- Agreements only.
231: ---------------------------------------------------------------------------
232: PROCEDURE amt_limit_ge_amt_agreed(
233: p_header_id_tbl IN PO_TBL_NUMBER
234: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
235: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
236: , p_amount_limit_tbl IN PO_TBL_NUMBER
237: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 234: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599

230: -- Agreements only.
231: ---------------------------------------------------------------------------
232: PROCEDURE amt_limit_ge_amt_agreed(
233: p_header_id_tbl IN PO_TBL_NUMBER
234: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
235: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
236: , p_amount_limit_tbl IN PO_TBL_NUMBER
237: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
238: , x_result_type OUT NOCOPY VARCHAR2

Line 235: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER

231: ---------------------------------------------------------------------------
232: PROCEDURE amt_limit_ge_amt_agreed(
233: p_header_id_tbl IN PO_TBL_NUMBER
234: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
235: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
236: , p_amount_limit_tbl IN PO_TBL_NUMBER
237: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
238: , x_result_type OUT NOCOPY VARCHAR2
239: )

Line 236: , p_amount_limit_tbl IN PO_TBL_NUMBER

232: PROCEDURE amt_limit_ge_amt_agreed(
233: p_header_id_tbl IN PO_TBL_NUMBER
234: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
235: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
236: , p_amount_limit_tbl IN PO_TBL_NUMBER
237: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
238: , x_result_type OUT NOCOPY VARCHAR2
239: )
240: IS

Line 281: p_header_id_tbl IN PO_TBL_NUMBER

277: -- Checks that the Amount Agreed is greater than or equal to zero.
278: -- Agreements only.
279: ---------------------------------------------------------------------------
280: PROCEDURE amount_agreed_ge_zero(
281: p_header_id_tbl IN PO_TBL_NUMBER
282: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
283: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
284: , x_result_type OUT NOCOPY VARCHAR2
285: )

Line 282: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER

278: -- Agreements only.
279: ---------------------------------------------------------------------------
280: PROCEDURE amount_agreed_ge_zero(
281: p_header_id_tbl IN PO_TBL_NUMBER
282: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
283: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
284: , x_result_type OUT NOCOPY VARCHAR2
285: )
286: IS

Line 309: p_header_id_tbl IN PO_TBL_NUMBER

305: -- Checks that the Amount Agreed is not null if Amount Limit is not null.
306: -- Agreements only.
307: ---------------------------------------------------------------------------
308: PROCEDURE amount_agreed_not_null(
309: p_header_id_tbl IN PO_TBL_NUMBER
310: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
311: , p_amount_limit_tbl IN PO_TBL_NUMBER
312: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
313: , x_result_type OUT NOCOPY VARCHAR2

Line 310: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER

306: -- Agreements only.
307: ---------------------------------------------------------------------------
308: PROCEDURE amount_agreed_not_null(
309: p_header_id_tbl IN PO_TBL_NUMBER
310: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
311: , p_amount_limit_tbl IN PO_TBL_NUMBER
312: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
313: , x_result_type OUT NOCOPY VARCHAR2
314: )

Line 311: , p_amount_limit_tbl IN PO_TBL_NUMBER

307: ---------------------------------------------------------------------------
308: PROCEDURE amount_agreed_not_null(
309: p_header_id_tbl IN PO_TBL_NUMBER
310: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
311: , p_amount_limit_tbl IN PO_TBL_NUMBER
312: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
313: , x_result_type OUT NOCOPY VARCHAR2
314: )
315: IS

Line 372: p_header_id_tbl IN PO_TBL_NUMBER

368: ---------------------------------------------------------------------------
369: -- Display a warning message if the supplier is on hold.
370: ---------------------------------------------------------------------------
371: PROCEDURE warn_supplier_on_hold(
372: p_header_id_tbl IN PO_TBL_NUMBER
373: , p_vendor_id_tbl IN PO_TBL_NUMBER
374: , x_result_set_id IN OUT NOCOPY NUMBER
375: , x_result_type OUT NOCOPY VARCHAR2
376: )

Line 373: , p_vendor_id_tbl IN PO_TBL_NUMBER

369: -- Display a warning message if the supplier is on hold.
370: ---------------------------------------------------------------------------
371: PROCEDURE warn_supplier_on_hold(
372: p_header_id_tbl IN PO_TBL_NUMBER
373: , p_vendor_id_tbl IN PO_TBL_NUMBER
374: , x_result_set_id IN OUT NOCOPY NUMBER
375: , x_result_type OUT NOCOPY VARCHAR2
376: )
377: IS

Line 444: p_header_id_tbl IN PO_TBL_NUMBER

440: -- For Rate Type of User, the Rate is also required (not null),
441: -- but that is handled elsewhere (in the UI).
442: ---------------------------------------------------------------------------
443: PROCEDURE rate_gt_zero(
444: p_header_id_tbl IN PO_TBL_NUMBER
445: , p_rate_tbl IN PO_TBL_NUMBER
446: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
447: , x_result_type OUT NOCOPY VARCHAR2
448: )

Line 445: , p_rate_tbl IN PO_TBL_NUMBER

441: -- but that is handled elsewhere (in the UI).
442: ---------------------------------------------------------------------------
443: PROCEDURE rate_gt_zero(
444: p_header_id_tbl IN PO_TBL_NUMBER
445: , p_rate_tbl IN PO_TBL_NUMBER
446: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
447: , x_result_type OUT NOCOPY VARCHAR2
448: )
449: IS

Line 475: p_header_id_tbl IN PO_TBL_NUMBER

471: -- 2. Rate Date
472: -- 3. Rate
473: ---------------------------------------------------------------------------
474: PROCEDURE rate_combination_valid(
475: p_header_id_tbl IN PO_TBL_NUMBER
476: , p_org_id_tbl IN PO_TBL_NUMBER
477: , p_currency_code_tbl IN PO_TBL_VARCHAR30
478: , p_rate_type_tbl IN PO_TBL_VARCHAR30
479: , p_rate_date_tbl IN PO_TBL_DATE

Line 476: , p_org_id_tbl IN PO_TBL_NUMBER

472: -- 3. Rate
473: ---------------------------------------------------------------------------
474: PROCEDURE rate_combination_valid(
475: p_header_id_tbl IN PO_TBL_NUMBER
476: , p_org_id_tbl IN PO_TBL_NUMBER
477: , p_currency_code_tbl IN PO_TBL_VARCHAR30
478: , p_rate_type_tbl IN PO_TBL_VARCHAR30
479: , p_rate_date_tbl IN PO_TBL_DATE
480: , p_rate_tbl IN PO_TBL_NUMBER

Line 480: , p_rate_tbl IN PO_TBL_NUMBER

476: , p_org_id_tbl IN PO_TBL_NUMBER
477: , p_currency_code_tbl IN PO_TBL_VARCHAR30
478: , p_rate_type_tbl IN PO_TBL_VARCHAR30
479: , p_rate_date_tbl IN PO_TBL_DATE
480: , p_rate_tbl IN PO_TBL_NUMBER
481: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
482: , x_result_type OUT NOCOPY VARCHAR2
483: )
484: IS

Line 587: p_header_id_tbl IN PO_TBL_NUMBER

583: -- is email and that fax number is not null if supplier notification method
584: -- is fax.
585: ---------------------------------------------------------------------------
586: PROCEDURE fax_email_address_valid(
587: p_header_id_tbl IN PO_TBL_NUMBER
588: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30
589: , p_fax_tbl IN PO_TBL_VARCHAR30
590: , p_email_address_tbl IN PO_TBL_VARCHAR2000
591: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 662: p_header_id_tbl IN PO_TBL_NUMBER

658: -- the Effective Date.
659: -- Agreements only.
660: ---------------------------------------------------------------------------
661: PROCEDURE effective_le_expiration(
662: p_header_id_tbl IN PO_TBL_NUMBER
663: , p_start_date_tbl IN PO_TBL_DATE
664: , p_end_date_tbl IN PO_TBL_DATE
665: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
666: , x_result_type OUT NOCOPY VARCHAR2

Line 700: p_header_id_tbl IN PO_TBL_NUMBER

696: -- the Creation Date of any Orders referencing the Agreement.
697: -- Agreements only.
698: ---------------------------------------------------------------------------
699: PROCEDURE effective_from_le_order_date(
700: p_header_id_tbl IN PO_TBL_NUMBER
701: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
702: , p_start_date_tbl IN PO_TBL_DATE
703: , x_result_set_id IN OUT NOCOPY NUMBER
704: , x_result_type OUT NOCOPY VARCHAR2

Line 775: p_header_id_tbl IN PO_TBL_NUMBER

771: -- Checks that the CLM Effective From Date is less than or equal to
772: -- the order start Date
773: ---------------------------------------------------------------------------
774: PROCEDURE clm_eff_from_le_order_date(
775: p_header_id_tbl IN PO_TBL_NUMBER
776: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
777: , p_start_date_tbl IN PO_TBL_DATE
778: , p_clm_effective_date_tbl IN PO_TBL_DATE
779: , x_result_set_id IN OUT NOCOPY NUMBER

Line 850: p_header_id_tbl IN PO_TBL_NUMBER

846: -- Checks that the CLM amount limit is less than or equal to
847: -- the minimum guarantee award amount
848: ---------------------------------------------------------------------------
849: PROCEDURE max_ceil_awd_amt_gt_min(
850: p_header_id_tbl IN PO_TBL_NUMBER
851: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
852: , p_amount_limit_tbl IN PO_TBL_NUMBER
853: , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER
854: , x_result_set_id IN OUT NOCOPY NUMBER

Line 852: , p_amount_limit_tbl IN PO_TBL_NUMBER

848: ---------------------------------------------------------------------------
849: PROCEDURE max_ceil_awd_amt_gt_min(
850: p_header_id_tbl IN PO_TBL_NUMBER
851: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
852: , p_amount_limit_tbl IN PO_TBL_NUMBER
853: , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER
854: , x_result_set_id IN OUT NOCOPY NUMBER
855: , x_result_type OUT NOCOPY VARCHAR2
856: )

Line 853: , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER

849: PROCEDURE max_ceil_awd_amt_gt_min(
850: p_header_id_tbl IN PO_TBL_NUMBER
851: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
852: , p_amount_limit_tbl IN PO_TBL_NUMBER
853: , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER
854: , x_result_set_id IN OUT NOCOPY NUMBER
855: , x_result_type OUT NOCOPY VARCHAR2
856: )
857: IS

Line 924: p_header_id_tbl IN PO_TBL_NUMBER

920: ---------------------------------------------------------------------------
921: -- Checks that Maximum Ceiling Award Amount >= Minimum Per Order Amount
922: ---------------------------------------------------------------------------
923: PROCEDURE max_ceil_amt_gt_min_ord (
924: p_header_id_tbl IN PO_TBL_NUMBER
925: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
926: , p_amount_limit_tbl IN PO_TBL_NUMBER
927: , p_min_order_amt_tbl IN PO_TBL_NUMBER
928: , x_result_set_id IN OUT NOCOPY NUMBER

Line 926: , p_amount_limit_tbl IN PO_TBL_NUMBER

922: ---------------------------------------------------------------------------
923: PROCEDURE max_ceil_amt_gt_min_ord (
924: p_header_id_tbl IN PO_TBL_NUMBER
925: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
926: , p_amount_limit_tbl IN PO_TBL_NUMBER
927: , p_min_order_amt_tbl IN PO_TBL_NUMBER
928: , x_result_set_id IN OUT NOCOPY NUMBER
929: , x_result_type OUT NOCOPY VARCHAR2
930: )

Line 927: , p_min_order_amt_tbl IN PO_TBL_NUMBER

923: PROCEDURE max_ceil_amt_gt_min_ord (
924: p_header_id_tbl IN PO_TBL_NUMBER
925: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
926: , p_amount_limit_tbl IN PO_TBL_NUMBER
927: , p_min_order_amt_tbl IN PO_TBL_NUMBER
928: , x_result_set_id IN OUT NOCOPY NUMBER
929: , x_result_type OUT NOCOPY VARCHAR2
930: )
931: IS

Line 997: p_header_id_tbl IN PO_TBL_NUMBER

993: ---------------------------------------------------------------------------
994: -- Checks that Maximum Ceiling Award Amount >= Maximum Per Order Amount
995: ---------------------------------------------------------------------------
996: PROCEDURE max_ceil_amt_gt_max_ord (
997: p_header_id_tbl IN PO_TBL_NUMBER
998: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
999: , p_amount_limit_tbl IN PO_TBL_NUMBER
1000: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1001: , x_result_set_id IN OUT NOCOPY NUMBER

Line 999: , p_amount_limit_tbl IN PO_TBL_NUMBER

995: ---------------------------------------------------------------------------
996: PROCEDURE max_ceil_amt_gt_max_ord (
997: p_header_id_tbl IN PO_TBL_NUMBER
998: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
999: , p_amount_limit_tbl IN PO_TBL_NUMBER
1000: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1001: , x_result_set_id IN OUT NOCOPY NUMBER
1002: , x_result_type OUT NOCOPY VARCHAR2
1003: )

Line 1000: , p_max_order_amt_tbl IN PO_TBL_NUMBER

996: PROCEDURE max_ceil_amt_gt_max_ord (
997: p_header_id_tbl IN PO_TBL_NUMBER
998: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
999: , p_amount_limit_tbl IN PO_TBL_NUMBER
1000: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1001: , x_result_set_id IN OUT NOCOPY NUMBER
1002: , x_result_type OUT NOCOPY VARCHAR2
1003: )
1004: IS

Line 1071: p_header_id_tbl IN PO_TBL_NUMBER

1067: ---------------------------------------------------------------------------
1068: -- Checks that the Minimum Guarantee Award Amount Percentage between 0 and 100
1069: ---------------------------------------------------------------------------
1070: PROCEDURE min_guar_perc_range_check(
1071: p_header_id_tbl IN PO_TBL_NUMBER
1072: , p_min_guar_perc_tbl IN PO_TBL_NUMBER
1073: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1074: , x_result_type OUT NOCOPY VARCHAR2
1075: )

Line 1072: , p_min_guar_perc_tbl IN PO_TBL_NUMBER

1068: -- Checks that the Minimum Guarantee Award Amount Percentage between 0 and 100
1069: ---------------------------------------------------------------------------
1070: PROCEDURE min_guar_perc_range_check(
1071: p_header_id_tbl IN PO_TBL_NUMBER
1072: , p_min_guar_perc_tbl IN PO_TBL_NUMBER
1073: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1074: , x_result_type OUT NOCOPY VARCHAR2
1075: )
1076: IS

Line 1109: p_header_id_tbl IN PO_TBL_NUMBER

1105: ---------------------------------------------------------------------------
1106: -- Checks that the CLM minimum order amount should be less than maximum order amount
1107: ---------------------------------------------------------------------------
1108: PROCEDURE max_ord_amt_gt_min(
1109: p_header_id_tbl IN PO_TBL_NUMBER
1110: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1111: , p_min_order_amt_tbl IN PO_TBL_NUMBER
1112: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1113: , x_result_set_id IN OUT NOCOPY NUMBER

Line 1111: , p_min_order_amt_tbl IN PO_TBL_NUMBER

1107: ---------------------------------------------------------------------------
1108: PROCEDURE max_ord_amt_gt_min(
1109: p_header_id_tbl IN PO_TBL_NUMBER
1110: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1111: , p_min_order_amt_tbl IN PO_TBL_NUMBER
1112: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1113: , x_result_set_id IN OUT NOCOPY NUMBER
1114: , x_result_type OUT NOCOPY VARCHAR2
1115: )

Line 1112: , p_max_order_amt_tbl IN PO_TBL_NUMBER

1108: PROCEDURE max_ord_amt_gt_min(
1109: p_header_id_tbl IN PO_TBL_NUMBER
1110: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1111: , p_min_order_amt_tbl IN PO_TBL_NUMBER
1112: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1113: , x_result_set_id IN OUT NOCOPY NUMBER
1114: , x_result_type OUT NOCOPY VARCHAR2
1115: )
1116: IS

Line 1183: p_header_id_tbl IN PO_TBL_NUMBER

1179: ---------------------------------------------------------------------------
1180: -- For CLM standard form and document format cannot be null
1181: ---------------------------------------------------------------------------
1182: PROCEDURE print_form_format_valid(
1183: p_header_id_tbl IN PO_TBL_NUMBER
1184: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1185: , p_style_id_tbl IN PO_TBL_NUMBER
1186: , p_draft_type_tbl IN PO_TBL_VARCHAR30
1187: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000

Line 1185: , p_style_id_tbl IN PO_TBL_NUMBER

1181: ---------------------------------------------------------------------------
1182: PROCEDURE print_form_format_valid(
1183: p_header_id_tbl IN PO_TBL_NUMBER
1184: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1185: , p_style_id_tbl IN PO_TBL_NUMBER
1186: , p_draft_type_tbl IN PO_TBL_VARCHAR30
1187: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000
1188: , p_document_format_tbl IN PO_TBL_VARCHAR2000
1189: , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER

Line 1189: , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER

1185: , p_style_id_tbl IN PO_TBL_NUMBER
1186: , p_draft_type_tbl IN PO_TBL_VARCHAR30
1187: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000
1188: , p_document_format_tbl IN PO_TBL_VARCHAR2000
1189: , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER
1190: , p_clm_ext_idv_tbl IN PO_TBL_VARCHAR2000
1191: , p_clm_award_type_tbl IN PO_TBL_VARCHAR30 -- bug 10389450
1192: , x_result_set_id IN OUT NOCOPY NUMBER
1193: , x_result_type OUT NOCOPY VARCHAR2

Line 1274: p_header_id_tbl IN PO_TBL_NUMBER

1270: -- the Creation Date of any Orders referencing the Agreement.
1271: -- Agreements only.
1272: ---------------------------------------------------------------------------
1273: PROCEDURE effective_to_ge_order_date(
1274: p_header_id_tbl IN PO_TBL_NUMBER
1275: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1276: , p_end_date_tbl IN PO_TBL_DATE
1277: , x_result_set_id IN OUT NOCOPY NUMBER
1278: , x_result_type OUT NOCOPY VARCHAR2

Line 1358: p_header_id_tbl IN PO_TBL_NUMBER

1354: -- Checks that the Effective From Date is less than or equal to
1355: -- the Creation Date of any Orders referencing the Contract.
1356: ---------------------------------------------------------------------------
1357: PROCEDURE contract_start_le_order_date(
1358: p_header_id_tbl IN PO_TBL_NUMBER
1359: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1360: , p_start_date_tbl IN PO_TBL_DATE
1361: , x_result_set_id IN OUT NOCOPY NUMBER
1362: , x_result_type OUT NOCOPY VARCHAR2

Line 1442: p_header_id_tbl IN PO_TBL_NUMBER

1438: -- Checks that the Effective To Date is greater than or equal to
1439: -- the Creation Date of any Orders referencing the Contract.
1440: ---------------------------------------------------------------------------
1441: PROCEDURE contract_end_ge_order_date(
1442: p_header_id_tbl IN PO_TBL_NUMBER
1443: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1444: , p_end_date_tbl IN PO_TBL_DATE
1445: , x_result_set_id IN OUT NOCOPY NUMBER
1446: , x_result_type OUT NOCOPY VARCHAR2

Line 1525: p_header_id_tbl IN PO_TBL_NUMBER

1521: ---------------------------------------------------------------------------
1522: -- Checks that the Document Number is numeric, if required.
1523: ---------------------------------------------------------------------------
1524: PROCEDURE doc_num_chars_valid(
1525: p_header_id_tbl IN PO_TBL_NUMBER
1526: , p_org_id_tbl IN PO_TBL_NUMBER
1527: , p_style_id_tbl IN PO_TBL_NUMBER
1528: , p_segment1_tbl IN PO_TBL_VARCHAR30
1529: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1526: , p_org_id_tbl IN PO_TBL_NUMBER

1522: -- Checks that the Document Number is numeric, if required.
1523: ---------------------------------------------------------------------------
1524: PROCEDURE doc_num_chars_valid(
1525: p_header_id_tbl IN PO_TBL_NUMBER
1526: , p_org_id_tbl IN PO_TBL_NUMBER
1527: , p_style_id_tbl IN PO_TBL_NUMBER
1528: , p_segment1_tbl IN PO_TBL_VARCHAR30
1529: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1530: , x_result_type OUT NOCOPY VARCHAR2

Line 1527: , p_style_id_tbl IN PO_TBL_NUMBER

1523: ---------------------------------------------------------------------------
1524: PROCEDURE doc_num_chars_valid(
1525: p_header_id_tbl IN PO_TBL_NUMBER
1526: , p_org_id_tbl IN PO_TBL_NUMBER
1527: , p_style_id_tbl IN PO_TBL_NUMBER
1528: , p_segment1_tbl IN PO_TBL_VARCHAR30
1529: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1530: , x_result_type OUT NOCOPY VARCHAR2
1531: )

Line 1537: l_header_id_tbl PO_TBL_NUMBER;

1533: d_mod CONSTANT VARCHAR2(100) := D_doc_num_chars_valid;
1534:
1535: l_results_count NUMBER;
1536: l_data_key NUMBER;
1537: l_header_id_tbl PO_TBL_NUMBER;
1538: l_segment1_tbl PO_TBL_VARCHAR30;
1539: l_num_test NUMBER;
1540: L_TEMP_SEGMENT PO_HEADERS_ALL.SEGMENT1%TYPE;
1541: BEGIN

Line 1659: p_header_id_tbl IN PO_TBL_NUMBER

1655: ---------------------------------------------------------------------------
1656: -- Checks that the Document Number is unique within the Org.
1657: ---------------------------------------------------------------------------
1658: PROCEDURE doc_num_unique(
1659: p_header_id_tbl IN PO_TBL_NUMBER
1660: , p_org_id_tbl IN PO_TBL_NUMBER
1661: , p_segment1_tbl IN PO_TBL_VARCHAR30
1662: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1663: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1660: , p_org_id_tbl IN PO_TBL_NUMBER

1656: -- Checks that the Document Number is unique within the Org.
1657: ---------------------------------------------------------------------------
1658: PROCEDURE doc_num_unique(
1659: p_header_id_tbl IN PO_TBL_NUMBER
1660: , p_org_id_tbl IN PO_TBL_NUMBER
1661: , p_segment1_tbl IN PO_TBL_VARCHAR30
1662: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1663: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1664: , x_result_type OUT NOCOPY VARCHAR2

Line 1673: l_header_id_tbl PO_TBL_NUMBER;

1669:
1670: l_results_count NUMBER;
1671:
1672: l_data_key NUMBER;
1673: l_header_id_tbl PO_TBL_NUMBER;
1674: l_org_id_tbl PO_TBL_NUMBER;
1675: l_segment1_tbl PO_TBL_VARCHAR30;
1676: l_nonunique_tbl PO_TBL_VARCHAR2000;
1677:

Line 1674: l_org_id_tbl PO_TBL_NUMBER;

1670: l_results_count NUMBER;
1671:
1672: l_data_key NUMBER;
1673: l_header_id_tbl PO_TBL_NUMBER;
1674: l_org_id_tbl PO_TBL_NUMBER;
1675: l_segment1_tbl PO_TBL_VARCHAR30;
1676: l_nonunique_tbl PO_TBL_VARCHAR2000;
1677:
1678: l_check_sourcing_flag VARCHAR2(2000);

Line 2178: p_header_id_tbl IN PO_TBL_NUMBER

2174: -------------------------------------------------------------------------------
2175: -- Ensures that the Buyer is not null.
2176: -------------------------------------------------------------------------------
2177: PROCEDURE agent_id_not_null(
2178: p_header_id_tbl IN PO_TBL_NUMBER
2179: , p_agent_id_tbl IN PO_TBL_NUMBER
2180: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2181: , x_result_type OUT NOCOPY VARCHAR2
2182: )

Line 2179: , p_agent_id_tbl IN PO_TBL_NUMBER

2175: -- Ensures that the Buyer is not null.
2176: -------------------------------------------------------------------------------
2177: PROCEDURE agent_id_not_null(
2178: p_header_id_tbl IN PO_TBL_NUMBER
2179: , p_agent_id_tbl IN PO_TBL_NUMBER
2180: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2181: , x_result_type OUT NOCOPY VARCHAR2
2182: )
2183: IS

Line 2204: p_header_id_tbl IN PO_TBL_NUMBER

2200: -------------------------------------------------------------------------------
2201: -- Ensures that the Default Ship-To / Work Location is not null.
2202: -------------------------------------------------------------------------------
2203: PROCEDURE ship_to_loc_not_null(
2204: p_header_id_tbl IN PO_TBL_NUMBER
2205: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
2206: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2207: , x_result_type OUT NOCOPY VARCHAR2
2208: )

Line 2205: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER

2201: -- Ensures that the Default Ship-To / Work Location is not null.
2202: -------------------------------------------------------------------------------
2203: PROCEDURE ship_to_loc_not_null(
2204: p_header_id_tbl IN PO_TBL_NUMBER
2205: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
2206: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2207: , x_result_type OUT NOCOPY VARCHAR2
2208: )
2209: IS

Line 2230: p_header_id_tbl IN PO_TBL_NUMBER

2226: -------------------------------------------------------------------------------
2227: -- Ensures that the Supplier is not null.
2228: -------------------------------------------------------------------------------
2229: PROCEDURE vendor_id_not_null(
2230: p_header_id_tbl IN PO_TBL_NUMBER
2231: , p_vendor_id_tbl IN PO_TBL_NUMBER
2232: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2233: , x_result_type OUT NOCOPY VARCHAR2
2234: )

Line 2231: , p_vendor_id_tbl IN PO_TBL_NUMBER

2227: -- Ensures that the Supplier is not null.
2228: -------------------------------------------------------------------------------
2229: PROCEDURE vendor_id_not_null(
2230: p_header_id_tbl IN PO_TBL_NUMBER
2231: , p_vendor_id_tbl IN PO_TBL_NUMBER
2232: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2233: , x_result_type OUT NOCOPY VARCHAR2
2234: )
2235: IS

Line 2256: p_header_id_tbl IN PO_TBL_NUMBER

2252: -------------------------------------------------------------------------------
2253: -- Ensures that the Supplier Site is not null.
2254: -------------------------------------------------------------------------------
2255: PROCEDURE vendor_site_id_not_null(
2256: p_header_id_tbl IN PO_TBL_NUMBER
2257: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
2258: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2259: , x_result_type OUT NOCOPY VARCHAR2
2260: )

Line 2257: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

2253: -- Ensures that the Supplier Site is not null.
2254: -------------------------------------------------------------------------------
2255: PROCEDURE vendor_site_id_not_null(
2256: p_header_id_tbl IN PO_TBL_NUMBER
2257: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
2258: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2259: , x_result_type OUT NOCOPY VARCHAR2
2260: )
2261: IS

Line 2282: p_header_id_tbl IN PO_TBL_NUMBER

2278: -------------------------------------------------------------------------------
2279: -- Ensures that the Segment1 is not null.
2280: -------------------------------------------------------------------------------
2281: PROCEDURE segment1_not_null(
2282: p_header_id_tbl IN PO_TBL_NUMBER
2283: , p_segment1_tbl IN PO_TBL_VARCHAR30
2284: , p_org_id_tbl IN PO_TBL_NUMBER
2285: , x_result_set_id IN OUT NOCOPY NUMBER
2286: , x_result_type OUT NOCOPY VARCHAR2

Line 2284: , p_org_id_tbl IN PO_TBL_NUMBER

2280: -------------------------------------------------------------------------------
2281: PROCEDURE segment1_not_null(
2282: p_header_id_tbl IN PO_TBL_NUMBER
2283: , p_segment1_tbl IN PO_TBL_VARCHAR30
2284: , p_org_id_tbl IN PO_TBL_NUMBER
2285: , x_result_set_id IN OUT NOCOPY NUMBER
2286: , x_result_type OUT NOCOPY VARCHAR2
2287: )
2288: IS

Line 2326: p_header_id_tbl IN po_tbl_number,

2322: END segment1_not_null;
2323: --
2324: -- Error when the ship_via field has an invalid value.
2325: PROCEDURE ship_via_lookup_code_valid(
2326: p_header_id_tbl IN po_tbl_number,
2327: p_ship_via_lookup_code_tbl IN po_tbl_varchar30,
2328: --Bug 12409257 start.Bug 13771850-Revert 12409257 changes
2329: p_org_id_tbl IN PO_TBL_NUMBER,
2330: --p_ship_to_location_id_tbl IN PO_TBL_NUMBER,

Line 2329: p_org_id_tbl IN PO_TBL_NUMBER,

2325: PROCEDURE ship_via_lookup_code_valid(
2326: p_header_id_tbl IN po_tbl_number,
2327: p_ship_via_lookup_code_tbl IN po_tbl_varchar30,
2328: --Bug 12409257 start.Bug 13771850-Revert 12409257 changes
2329: p_org_id_tbl IN PO_TBL_NUMBER,
2330: --p_ship_to_location_id_tbl IN PO_TBL_NUMBER,
2331: --Bug 12409257 end.Bug 13771850 end
2332: x_result_set_id IN OUT NOCOPY NUMBER,
2333: x_result_type OUT NOCOPY VARCHAR2)

Line 2330: --p_ship_to_location_id_tbl IN PO_TBL_NUMBER,

2326: p_header_id_tbl IN po_tbl_number,
2327: p_ship_via_lookup_code_tbl IN po_tbl_varchar30,
2328: --Bug 12409257 start.Bug 13771850-Revert 12409257 changes
2329: p_org_id_tbl IN PO_TBL_NUMBER,
2330: --p_ship_to_location_id_tbl IN PO_TBL_NUMBER,
2331: --Bug 12409257 end.Bug 13771850 end
2332: x_result_set_id IN OUT NOCOPY NUMBER,
2333: x_result_type OUT NOCOPY VARCHAR2)
2334: IS

Line 2421: p_header_id_tbl IN PO_TBL_NUMBER

2417: -------------------------------------------------------------------------------
2418: -- Mod_effective date is less then earlist need_by_date
2419: -------------------------------------------------------------------------------
2420: PROCEDURE mod_eff_dt_lt_need_by_dt(
2421: p_header_id_tbl IN PO_TBL_NUMBER
2422: ,p_mod_eff_date_tbl IN PO_TBL_DATE
2423: ,x_result_set_id IN OUT NOCOPY NUMBER
2424: ,x_result_type OUT NOCOPY VARCHAR2
2425: )

Line 2486: p_header_id_tbl IN PO_TBL_NUMBER

2482: -------------------------------------------------------------------------------
2483: -- Mod_effective date cannot be null for Modification
2484: -------------------------------------------------------------------------------
2485: PROCEDURE mod_eff_dt_not_null(
2486: p_header_id_tbl IN PO_TBL_NUMBER
2487: ,p_draft_type_tbl IN PO_TBL_VARCHAR30
2488: ,p_mod_eff_date_tbl IN PO_TBL_DATE
2489: ,x_result_set_id IN OUT NOCOPY NUMBER
2490: ,x_result_type OUT NOCOPY VARCHAR2

Line 2545: p_header_id_tbl IN PO_TBL_NUMBER

2541:
2542: END mod_eff_dt_not_null;
2543:
2544: PROCEDURE mod_no_cancel_shp_complt(
2545: p_header_id_tbl IN PO_TBL_NUMBER
2546: ,p_control_action_tbl IN PO_TBL_VARCHAR30
2547: ,x_result_set_id IN OUT NOCOPY NUMBER
2548: ,x_result_type OUT NOCOPY VARCHAR2
2549: )

Line 2610: p_intf_header_id IN PO_TBL_NUMBER,

2606:
2607:
2608: PROCEDURE validate_clm_standard_form (
2609:
2610: p_intf_header_id IN PO_TBL_NUMBER,
2611: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
2612: p_style_id_tbl IN PO_TBL_NUMBER,
2613: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2614: x_result_type OUT NOCOPY VARCHAR2

Line 2612: p_style_id_tbl IN PO_TBL_NUMBER,

2608: PROCEDURE validate_clm_standard_form (
2609:
2610: p_intf_header_id IN PO_TBL_NUMBER,
2611: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
2612: p_style_id_tbl IN PO_TBL_NUMBER,
2613: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2614: x_result_type OUT NOCOPY VARCHAR2
2615: ) IS
2616:

Line 2679: p_intf_header_id IN PO_TBL_NUMBER,

2675: END validate_clm_standard_form;
2676:
2677:
2678: PROCEDURE validate_clm_document_format(
2679: p_intf_header_id IN PO_TBL_NUMBER,
2680: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
2681: p_clm_document_format_tbl IN PO_TBL_VARCHAR2000,
2682: p_style_id_tbl IN PO_TBL_NUMBER,
2683: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 2682: p_style_id_tbl IN PO_TBL_NUMBER,

2678: PROCEDURE validate_clm_document_format(
2679: p_intf_header_id IN PO_TBL_NUMBER,
2680: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
2681: p_clm_document_format_tbl IN PO_TBL_VARCHAR2000,
2682: p_style_id_tbl IN PO_TBL_NUMBER,
2683: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2684: x_result_type OUT NOCOPY VARCHAR2
2685: ) IS
2686:

Line 2761: p_intf_header_id in PO_TBL_NUMBER,

2757:
2758:
2759: PROCEDURE validate_source_idv
2760: (
2761: p_intf_header_id in PO_TBL_NUMBER,
2762: p_src_doc_id_tbl IN PO_TBL_NUMBER,
2763: p_currency_code_tbl in PO_TBL_VARCHAR30,
2764: p_org_id_tbl in PO_TBL_NUMBER,
2765: x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 2762: p_src_doc_id_tbl IN PO_TBL_NUMBER,

2758:
2759: PROCEDURE validate_source_idv
2760: (
2761: p_intf_header_id in PO_TBL_NUMBER,
2762: p_src_doc_id_tbl IN PO_TBL_NUMBER,
2763: p_currency_code_tbl in PO_TBL_VARCHAR30,
2764: p_org_id_tbl in PO_TBL_NUMBER,
2765: x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2766: x_result_type OUT NOCOPY VARCHAR2

Line 2764: p_org_id_tbl in PO_TBL_NUMBER,

2760: (
2761: p_intf_header_id in PO_TBL_NUMBER,
2762: p_src_doc_id_tbl IN PO_TBL_NUMBER,
2763: p_currency_code_tbl in PO_TBL_VARCHAR30,
2764: p_org_id_tbl in PO_TBL_NUMBER,
2765: x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2766: x_result_type OUT NOCOPY VARCHAR2
2767: ) IS
2768:

Line 2867: p_intf_header_id IN PO_TBL_NUMBER,

2863:
2864:
2865: PROCEDURE validate_award_admin
2866: (
2867: p_intf_header_id IN PO_TBL_NUMBER,
2868: p_award_admin_tbl IN PO_TBL_VARCHAR2000,
2869: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2870: x_result_type OUT NOCOPY VARCHAR2
2871: )IS

Line 2935: p_intf_header_id IN PO_TBL_NUMBER,

2931:
2932:
2933: PROCEDURE validate_contract_officer
2934: (
2935: p_intf_header_id IN PO_TBL_NUMBER,
2936: p_contract_officer_tbl IN PO_TBL_NUMBER,
2937: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2938: x_result_type OUT NOCOPY VARCHAR2
2939: )IS

Line 2936: p_contract_officer_tbl IN PO_TBL_NUMBER,

2932:
2933: PROCEDURE validate_contract_officer
2934: (
2935: p_intf_header_id IN PO_TBL_NUMBER,
2936: p_contract_officer_tbl IN PO_TBL_NUMBER,
2937: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2938: x_result_type OUT NOCOPY VARCHAR2
2939: )IS
2940:

Line 3003: p_intf_header_id IN PO_TBL_NUMBER,

2999:
3000:
3001: PROCEDURE validate_umbrella_program_id
3002: (
3003: p_intf_header_id IN PO_TBL_NUMBER,
3004: p_umbrella_program_id_tbl IN PO_TBL_NUMBER,
3005: p_src_doc_id_tbl IN PO_TBL_NUMBER,
3006: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3007: x_result_type OUT NOCOPY VARCHAR2

Line 3004: p_umbrella_program_id_tbl IN PO_TBL_NUMBER,

3000:
3001: PROCEDURE validate_umbrella_program_id
3002: (
3003: p_intf_header_id IN PO_TBL_NUMBER,
3004: p_umbrella_program_id_tbl IN PO_TBL_NUMBER,
3005: p_src_doc_id_tbl IN PO_TBL_NUMBER,
3006: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3007: x_result_type OUT NOCOPY VARCHAR2
3008: ) IS

Line 3005: p_src_doc_id_tbl IN PO_TBL_NUMBER,

3001: PROCEDURE validate_umbrella_program_id
3002: (
3003: p_intf_header_id IN PO_TBL_NUMBER,
3004: p_umbrella_program_id_tbl IN PO_TBL_NUMBER,
3005: p_src_doc_id_tbl IN PO_TBL_NUMBER,
3006: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3007: x_result_type OUT NOCOPY VARCHAR2
3008: ) IS
3009:

Line 3072: p_intf_header_id IN PO_TBL_NUMBER,

3068:
3069:
3070: PROCEDURE validate_clm_award_type
3071: (
3072: p_intf_header_id IN PO_TBL_NUMBER,
3073: p_clm_award_type_tbl IN PO_TBL_VARCHAR30,
3074: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
3075: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3076: x_result_type OUT NOCOPY VARCHAR2

Line 3171: p_intf_header_id IN PO_TBL_NUMBER,

3167:
3168:
3169: PROCEDURE validate_style_id
3170: (
3171: p_intf_header_id IN PO_TBL_NUMBER,
3172: p_style_id_tbl IN PO_TBL_NUMBER,
3173: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3174: x_result_type OUT NOCOPY VARCHAR2
3175: ) IS

Line 3172: p_style_id_tbl IN PO_TBL_NUMBER,

3168:
3169: PROCEDURE validate_style_id
3170: (
3171: p_intf_header_id IN PO_TBL_NUMBER,
3172: p_style_id_tbl IN PO_TBL_NUMBER,
3173: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3174: x_result_type OUT NOCOPY VARCHAR2
3175: ) IS
3176:

Line 3179: l_clm_style_id_tbl PO_TBL_NUMBER;

3175: ) IS
3176:
3177: d_mod CONSTANT VARCHAR2(100) := D_validate_style_id;
3178: l_results_count NUMBER :=0;
3179: l_clm_style_id_tbl PO_TBL_NUMBER;
3180: l_data_key NUMBER := NULL;
3181: l_intf_header_id_tbl PO_TBL_NUMBER;
3182: l_style_id_tbl PO_TBL_NUMBER;
3183: BEGIN

Line 3181: l_intf_header_id_tbl PO_TBL_NUMBER;

3177: d_mod CONSTANT VARCHAR2(100) := D_validate_style_id;
3178: l_results_count NUMBER :=0;
3179: l_clm_style_id_tbl PO_TBL_NUMBER;
3180: l_data_key NUMBER := NULL;
3181: l_intf_header_id_tbl PO_TBL_NUMBER;
3182: l_style_id_tbl PO_TBL_NUMBER;
3183: BEGIN
3184: -- skip the validation for non-CLM documents
3185: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 3182: l_style_id_tbl PO_TBL_NUMBER;

3178: l_results_count NUMBER :=0;
3179: l_clm_style_id_tbl PO_TBL_NUMBER;
3180: l_data_key NUMBER := NULL;
3181: l_intf_header_id_tbl PO_TBL_NUMBER;
3182: l_style_id_tbl PO_TBL_NUMBER;
3183: BEGIN
3184: -- skip the validation for non-CLM documents
3185: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN
3186: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

Line 3262: p_intf_header_id IN PO_TBL_NUMBER,

3258:
3259: /*Style id of the source idv should be same as that of the po*/
3260: PROCEDURE validate_idv_style_id
3261: (
3262: p_intf_header_id IN PO_TBL_NUMBER,
3263: p_style_id_tbl IN PO_TBL_NUMBER,
3264: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3265: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3266: x_result_type OUT NOCOPY VARCHAR2

Line 3263: p_style_id_tbl IN PO_TBL_NUMBER,

3259: /*Style id of the source idv should be same as that of the po*/
3260: PROCEDURE validate_idv_style_id
3261: (
3262: p_intf_header_id IN PO_TBL_NUMBER,
3263: p_style_id_tbl IN PO_TBL_NUMBER,
3264: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3265: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3266: x_result_type OUT NOCOPY VARCHAR2
3267: ) IS

Line 3264: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,

3260: PROCEDURE validate_idv_style_id
3261: (
3262: p_intf_header_id IN PO_TBL_NUMBER,
3263: p_style_id_tbl IN PO_TBL_NUMBER,
3264: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3265: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3266: x_result_type OUT NOCOPY VARCHAR2
3267: ) IS
3268:

Line 3271: l_intf_header_id_tbl PO_TBL_NUMBER;

3267: ) IS
3268:
3269: d_mod CONSTANT VARCHAR2(100) := D_validate_idv_style_id;
3270: l_data_key NUMBER := NULL;
3271: l_intf_header_id_tbl PO_TBL_NUMBER;
3272: l_style_id_tbl PO_TBL_NUMBER;
3273: BEGIN
3274:
3275: IF PO_LOG.d_proc THEN

Line 3272: l_style_id_tbl PO_TBL_NUMBER;

3268:
3269: d_mod CONSTANT VARCHAR2(100) := D_validate_idv_style_id;
3270: l_data_key NUMBER := NULL;
3271: l_intf_header_id_tbl PO_TBL_NUMBER;
3272: l_style_id_tbl PO_TBL_NUMBER;
3273: BEGIN
3274:
3275: IF PO_LOG.d_proc THEN
3276: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

Line 3332: p_intf_header_id IN PO_TBL_NUMBER,

3328:
3329: /*Vendor_id info should be same as that on the source idv*/
3330: PROCEDURE validate_po_idv_vendor_id
3331: (
3332: p_intf_header_id IN PO_TBL_NUMBER,
3333: p_vendor_id_tbl IN PO_TBL_NUMBER,
3334: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3335: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3336: x_result_type OUT NOCOPY VARCHAR2

Line 3333: p_vendor_id_tbl IN PO_TBL_NUMBER,

3329: /*Vendor_id info should be same as that on the source idv*/
3330: PROCEDURE validate_po_idv_vendor_id
3331: (
3332: p_intf_header_id IN PO_TBL_NUMBER,
3333: p_vendor_id_tbl IN PO_TBL_NUMBER,
3334: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3335: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3336: x_result_type OUT NOCOPY VARCHAR2
3337: ) IS

Line 3334: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,

3330: PROCEDURE validate_po_idv_vendor_id
3331: (
3332: p_intf_header_id IN PO_TBL_NUMBER,
3333: p_vendor_id_tbl IN PO_TBL_NUMBER,
3334: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3335: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3336: x_result_type OUT NOCOPY VARCHAR2
3337: ) IS
3338:

Line 3341: l_intf_header_id_tbl PO_TBL_NUMBER;

3337: ) IS
3338:
3339: d_mod CONSTANT VARCHAR2(100) := D_validate_po_idv_vendor_id;
3340: l_data_key NUMBER := NULL;
3341: l_intf_header_id_tbl PO_TBL_NUMBER;
3342: l_vendor_id_tbl PO_TBL_NUMBER;
3343: BEGIN
3344:
3345: IF PO_LOG.d_proc THEN

Line 3342: l_vendor_id_tbl PO_TBL_NUMBER;

3338:
3339: d_mod CONSTANT VARCHAR2(100) := D_validate_po_idv_vendor_id;
3340: l_data_key NUMBER := NULL;
3341: l_intf_header_id_tbl PO_TBL_NUMBER;
3342: l_vendor_id_tbl PO_TBL_NUMBER;
3343: BEGIN
3344:
3345: IF PO_LOG.d_proc THEN
3346: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

Line 3404: p_intf_header_id IN PO_TBL_NUMBER,

3400:
3401: /*Vendor_site_id info should be same as that on the source idv*/
3402: PROCEDURE validate_po_idv_vendor_site_id
3403: (
3404: p_intf_header_id IN PO_TBL_NUMBER,
3405: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
3406: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3407: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3408: x_result_type OUT NOCOPY VARCHAR2

Line 3405: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

3401: /*Vendor_site_id info should be same as that on the source idv*/
3402: PROCEDURE validate_po_idv_vendor_site_id
3403: (
3404: p_intf_header_id IN PO_TBL_NUMBER,
3405: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
3406: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3407: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3408: x_result_type OUT NOCOPY VARCHAR2
3409: ) IS

Line 3406: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,

3402: PROCEDURE validate_po_idv_vendor_site_id
3403: (
3404: p_intf_header_id IN PO_TBL_NUMBER,
3405: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
3406: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
3407: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3408: x_result_type OUT NOCOPY VARCHAR2
3409: ) IS
3410:

Line 3413: l_intf_header_id_tbl PO_TBL_NUMBER;

3409: ) IS
3410:
3411: d_mod CONSTANT VARCHAR2(100) := D_val_po_idv_vendor_site_id;
3412: l_data_key NUMBER := NULL;
3413: l_intf_header_id_tbl PO_TBL_NUMBER;
3414: l_vendor_site_id_tbl PO_TBL_NUMBER;
3415: BEGIN
3416:
3417: IF PO_LOG.d_proc THEN

Line 3414: l_vendor_site_id_tbl PO_TBL_NUMBER;

3410:
3411: d_mod CONSTANT VARCHAR2(100) := D_val_po_idv_vendor_site_id;
3412: l_data_key NUMBER := NULL;
3413: l_intf_header_id_tbl PO_TBL_NUMBER;
3414: l_vendor_site_id_tbl PO_TBL_NUMBER;
3415: BEGIN
3416:
3417: IF PO_LOG.d_proc THEN
3418: PO_LOG.proc_begin(d_mod,'p_intf_header_id',p_intf_header_id);

Line 3474: p_header_id_tbl IN PO_TBL_NUMBER,

3470:
3471:
3472: -- : This validation avoids null PAR/MOD document Number
3473: PROCEDURE validate_mod_number(
3474: p_header_id_tbl IN PO_TBL_NUMBER,
3475: p_draft_type_tbl IN PO_TBL_VARCHAR30,
3476: p_mod_number_tbl IN PO_TBL_VARCHAR100,
3477: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
3478: x_result_type OUT NOCOPY VARCHAR2