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_LINES dependencies on PO_TBL_NUMBER

Line 279: p_line_id_tbl IN PO_TBL_NUMBER

275: -- This procedure determines if Amount Agreed on blanket lines is greater
276: -- than or equal to zero. If not, return a failure.
277: -------------------------------------------------------------------------------
278: PROCEDURE amt_agreed_ge_zero(
279: p_line_id_tbl IN PO_TBL_NUMBER
280: , p_committed_amount_tbl IN PO_TBL_NUMBER
281: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
282: , x_result_type OUT NOCOPY VARCHAR2
283: )

Line 280: , p_committed_amount_tbl IN PO_TBL_NUMBER

276: -- than or equal to zero. If not, return a failure.
277: -------------------------------------------------------------------------------
278: PROCEDURE amt_agreed_ge_zero(
279: p_line_id_tbl IN PO_TBL_NUMBER
280: , p_committed_amount_tbl IN PO_TBL_NUMBER
281: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
282: , x_result_type OUT NOCOPY VARCHAR2
283: )
284: IS

Line 306: p_line_id_tbl IN PO_TBL_NUMBER

302: -- This procedure determines if Minimum Release Amount on blanket lines
303: -- is greater than or equal to zero. If not, return a failure.
304: -------------------------------------------------------------------------------
305: PROCEDURE min_rel_amt_ge_zero(
306: p_line_id_tbl IN PO_TBL_NUMBER
307: , p_min_release_amount_tbl IN PO_TBL_NUMBER
308: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
309: , x_result_type OUT NOCOPY VARCHAR2
310: )

Line 307: , p_min_release_amount_tbl IN PO_TBL_NUMBER

303: -- is greater than or equal to zero. If not, return a failure.
304: -------------------------------------------------------------------------------
305: PROCEDURE min_rel_amt_ge_zero(
306: p_line_id_tbl IN PO_TBL_NUMBER
307: , p_min_release_amount_tbl IN PO_TBL_NUMBER
308: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
309: , x_result_type OUT NOCOPY VARCHAR2
310: )
311: IS

Line 333: p_line_id_tbl IN PO_TBL_NUMBER

329: -- Validates that quantity is not null and greater than zero if it is not
330: -- a Rate or Fixed Price line.
331: -----------------------------------------------------------------------------
332: PROCEDURE quantity_gt_zero(
333: p_line_id_tbl IN PO_TBL_NUMBER
334: , p_quantity_tbl IN PO_TBL_NUMBER
335: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
336: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
337: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes

Line 334: , p_quantity_tbl IN PO_TBL_NUMBER

330: -- a Rate or Fixed Price line.
331: -----------------------------------------------------------------------------
332: PROCEDURE quantity_gt_zero(
333: p_line_id_tbl IN PO_TBL_NUMBER
334: , p_quantity_tbl IN PO_TBL_NUMBER
335: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
336: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
337: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
338: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 340: , p_header_id_tbl IN PO_TBL_NUMBER --

336: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
337: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
338: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
339: , x_result_type OUT NOCOPY VARCHAR2
340: , p_header_id_tbl IN PO_TBL_NUMBER --
341: )
342: IS
343: BEGIN
344:

Line 376: p_line_id_tbl IN PO_TBL_NUMBER

372: -- current transaction quantity, since over-receiving is allowed.
373: -- : Ignore qty milestones (there are other checks for those)
374: -----------------------------------------------------------------------------
375: PROCEDURE quantity_ge_quantity_exec(
376: p_line_id_tbl IN PO_TBL_NUMBER
377: , p_quantity_tbl IN PO_TBL_NUMBER
378: , x_result_set_id IN OUT NOCOPY NUMBER
379: , x_result_type OUT NOCOPY VARCHAR2
380: )

Line 377: , p_quantity_tbl IN PO_TBL_NUMBER

373: -- : Ignore qty milestones (there are other checks for those)
374: -----------------------------------------------------------------------------
375: PROCEDURE quantity_ge_quantity_exec(
376: p_line_id_tbl IN PO_TBL_NUMBER
377: , p_quantity_tbl IN PO_TBL_NUMBER
378: , x_result_set_id IN OUT NOCOPY NUMBER
379: , x_result_type OUT NOCOPY VARCHAR2
380: )
381: IS

Line 485: p_line_id_tbl IN PO_TBL_NUMBER

481:
482: -- Bug 5070210 Start
483: -- Bug 5446881: If the amount is null, we need to check against price * quantity
484: PROCEDURE advance_amt_le_amt(
485: p_line_id_tbl IN PO_TBL_NUMBER
486: , p_advance_tbl IN PO_TBL_NUMBER
487: , p_amount_tbl IN PO_TBL_NUMBER
488: , p_quantity_tbl IN PO_TBL_NUMBER
489: , p_price_tbl IN PO_TBL_NUMBER

Line 486: , p_advance_tbl IN PO_TBL_NUMBER

482: -- Bug 5070210 Start
483: -- Bug 5446881: If the amount is null, we need to check against price * quantity
484: PROCEDURE advance_amt_le_amt(
485: p_line_id_tbl IN PO_TBL_NUMBER
486: , p_advance_tbl IN PO_TBL_NUMBER
487: , p_amount_tbl IN PO_TBL_NUMBER
488: , p_quantity_tbl IN PO_TBL_NUMBER
489: , p_price_tbl IN PO_TBL_NUMBER
490: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 487: , p_amount_tbl IN PO_TBL_NUMBER

483: -- Bug 5446881: If the amount is null, we need to check against price * quantity
484: PROCEDURE advance_amt_le_amt(
485: p_line_id_tbl IN PO_TBL_NUMBER
486: , p_advance_tbl IN PO_TBL_NUMBER
487: , p_amount_tbl IN PO_TBL_NUMBER
488: , p_quantity_tbl IN PO_TBL_NUMBER
489: , p_price_tbl IN PO_TBL_NUMBER
490: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
491: , x_result_type OUT NOCOPY VARCHAR2

Line 488: , p_quantity_tbl IN PO_TBL_NUMBER

484: PROCEDURE advance_amt_le_amt(
485: p_line_id_tbl IN PO_TBL_NUMBER
486: , p_advance_tbl IN PO_TBL_NUMBER
487: , p_amount_tbl IN PO_TBL_NUMBER
488: , p_quantity_tbl IN PO_TBL_NUMBER
489: , p_price_tbl IN PO_TBL_NUMBER
490: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
491: , x_result_type OUT NOCOPY VARCHAR2
492: )

Line 489: , p_price_tbl IN PO_TBL_NUMBER

485: p_line_id_tbl IN PO_TBL_NUMBER
486: , p_advance_tbl IN PO_TBL_NUMBER
487: , p_amount_tbl IN PO_TBL_NUMBER
488: , p_quantity_tbl IN PO_TBL_NUMBER
489: , p_price_tbl IN PO_TBL_NUMBER
490: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
491: , x_result_type OUT NOCOPY VARCHAR2
492: )
493: IS

Line 543: p_line_id_tbl IN PO_TBL_NUMBER

539: -- Bug 5070210 End
540:
541: --
542: PROCEDURE complex_po_attributes_check(
543: p_line_id_tbl IN PO_TBL_NUMBER
544: , p_style_id_tbl IN PO_TBL_NUMBER
545: , p_retainage_rate_tbl IN PO_TBL_NUMBER
546: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
547: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER

Line 544: , p_style_id_tbl IN PO_TBL_NUMBER

540:
541: --
542: PROCEDURE complex_po_attributes_check(
543: p_line_id_tbl IN PO_TBL_NUMBER
544: , p_style_id_tbl IN PO_TBL_NUMBER
545: , p_retainage_rate_tbl IN PO_TBL_NUMBER
546: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
547: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
548: , p_recoupment_rate_tbl IN PO_TBL_NUMBER

Line 545: , p_retainage_rate_tbl IN PO_TBL_NUMBER

541: --
542: PROCEDURE complex_po_attributes_check(
543: p_line_id_tbl IN PO_TBL_NUMBER
544: , p_style_id_tbl IN PO_TBL_NUMBER
545: , p_retainage_rate_tbl IN PO_TBL_NUMBER
546: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
547: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
548: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
549: , p_advance_tbl IN PO_TBL_NUMBER

Line 546: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

542: PROCEDURE complex_po_attributes_check(
543: p_line_id_tbl IN PO_TBL_NUMBER
544: , p_style_id_tbl IN PO_TBL_NUMBER
545: , p_retainage_rate_tbl IN PO_TBL_NUMBER
546: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
547: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
548: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
549: , p_advance_tbl IN PO_TBL_NUMBER
550: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 547: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER

543: p_line_id_tbl IN PO_TBL_NUMBER
544: , p_style_id_tbl IN PO_TBL_NUMBER
545: , p_retainage_rate_tbl IN PO_TBL_NUMBER
546: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
547: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
548: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
549: , p_advance_tbl IN PO_TBL_NUMBER
550: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
551: , x_result_type OUT NOCOPY VARCHAR2

Line 548: , p_recoupment_rate_tbl IN PO_TBL_NUMBER

544: , p_style_id_tbl IN PO_TBL_NUMBER
545: , p_retainage_rate_tbl IN PO_TBL_NUMBER
546: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
547: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
548: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
549: , p_advance_tbl IN PO_TBL_NUMBER
550: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
551: , x_result_type OUT NOCOPY VARCHAR2
552: )

Line 549: , p_advance_tbl IN PO_TBL_NUMBER

545: , p_retainage_rate_tbl IN PO_TBL_NUMBER
546: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
547: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
548: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
549: , p_advance_tbl IN PO_TBL_NUMBER
550: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
551: , x_result_type OUT NOCOPY VARCHAR2
552: )
553: IS

Line 676: p_line_id_tbl IN PO_TBL_NUMBER

672: -----------------------------------------------------------------------------
673: -- Validates that quantity is greater than or equal to quantity encumbered.
674: -----------------------------------------------------------------------------
675: PROCEDURE quantity_ge_quantity_enc(
676: p_line_id_tbl IN PO_TBL_NUMBER
677: , p_quantity_tbl IN PO_TBL_NUMBER
678: , x_result_set_id IN OUT NOCOPY NUMBER
679: , x_result_type OUT NOCOPY VARCHAR2
680: )

Line 677: , p_quantity_tbl IN PO_TBL_NUMBER

673: -- Validates that quantity is greater than or equal to quantity encumbered.
674: -----------------------------------------------------------------------------
675: PROCEDURE quantity_ge_quantity_enc(
676: p_line_id_tbl IN PO_TBL_NUMBER
677: , p_quantity_tbl IN PO_TBL_NUMBER
678: , x_result_set_id IN OUT NOCOPY NUMBER
679: , x_result_type OUT NOCOPY VARCHAR2
680: )
681: IS

Line 768: p_line_id_tbl IN PO_TBL_NUMBER

764: -- Shows a warning if quantity is changed and notification controls
765: -- are enabled.
766: -----------------------------------------------------------------------------
767: PROCEDURE quantity_notif_change(
768: p_line_id_tbl IN PO_TBL_NUMBER
769: , p_quantity_tbl IN PO_TBL_NUMBER
770: , x_result_set_id IN OUT NOCOPY NUMBER
771: , x_result_type OUT NOCOPY VARCHAR2
772: )

Line 769: , p_quantity_tbl IN PO_TBL_NUMBER

765: -- are enabled.
766: -----------------------------------------------------------------------------
767: PROCEDURE quantity_notif_change(
768: p_line_id_tbl IN PO_TBL_NUMBER
769: , p_quantity_tbl IN PO_TBL_NUMBER
770: , x_result_set_id IN OUT NOCOPY NUMBER
771: , x_result_type OUT NOCOPY VARCHAR2
772: )
773: IS

Line 794: p_line_id_tbl IN PO_TBL_NUMBER

790: -- Validates that amount is not null and greater than zero if the line is
791: -- Rate or Fixed Price.
792: -----------------------------------------------------------------------------
793: PROCEDURE amount_gt_zero(
794: p_line_id_tbl IN PO_TBL_NUMBER
795: , p_amount_tbl IN PO_TBL_NUMBER
796: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
797: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
798: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes

Line 795: , p_amount_tbl IN PO_TBL_NUMBER

791: -- Rate or Fixed Price.
792: -----------------------------------------------------------------------------
793: PROCEDURE amount_gt_zero(
794: p_line_id_tbl IN PO_TBL_NUMBER
795: , p_amount_tbl IN PO_TBL_NUMBER
796: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
797: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
798: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
799: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 801: , p_header_id_tbl IN PO_TBL_NUMBER --

797: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
798: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
799: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
800: , x_result_type OUT NOCOPY VARCHAR2
801: , p_header_id_tbl IN PO_TBL_NUMBER --
802: )
803: IS
804: BEGIN
805:

Line 837: p_line_id_tbl IN PO_TBL_NUMBER

833: -- current transaction amount, since over-receiving is allowed.
834: -- : Handle differing value bases and payment types
835: -----------------------------------------------------------------------------
836: PROCEDURE amount_ge_amount_exec(
837: p_line_id_tbl IN PO_TBL_NUMBER
838: , p_amount_tbl IN PO_TBL_NUMBER
839: , p_currency_code_tbl IN PO_TBL_VARCHAR30
840: , x_result_set_id IN OUT NOCOPY NUMBER
841: , x_result_type OUT NOCOPY VARCHAR2

Line 838: , p_amount_tbl IN PO_TBL_NUMBER

834: -- : Handle differing value bases and payment types
835: -----------------------------------------------------------------------------
836: PROCEDURE amount_ge_amount_exec(
837: p_line_id_tbl IN PO_TBL_NUMBER
838: , p_amount_tbl IN PO_TBL_NUMBER
839: , p_currency_code_tbl IN PO_TBL_VARCHAR30
840: , x_result_set_id IN OUT NOCOPY NUMBER
841: , x_result_type OUT NOCOPY VARCHAR2
842: )

Line 1031: p_line_id_tbl IN PO_TBL_NUMBER

1027: -- This check is only performed if amount is being reduced below the
1028: -- current transaction amount.
1029: -----------------------------------------------------------------------------
1030: PROCEDURE amount_ge_timecard(
1031: p_line_id_tbl IN PO_TBL_NUMBER
1032: , p_amount_tbl IN PO_TBL_NUMBER
1033: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1034: , x_result_type OUT NOCOPY VARCHAR2
1035: )

Line 1032: , p_amount_tbl IN PO_TBL_NUMBER

1028: -- current transaction amount.
1029: -----------------------------------------------------------------------------
1030: PROCEDURE amount_ge_timecard(
1031: p_line_id_tbl IN PO_TBL_NUMBER
1032: , p_amount_tbl IN PO_TBL_NUMBER
1033: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1034: , x_result_type OUT NOCOPY VARCHAR2
1035: )
1036: IS

Line 1042: l_line_id_tbl PO_TBL_NUMBER;

1038:
1039: l_results_count NUMBER;
1040: l_data_key NUMBER;
1041:
1042: l_line_id_tbl PO_TBL_NUMBER;
1043: l_amount_tbl PO_TBL_NUMBER;
1044:
1045: l_timecard_amount_sum NUMBER;
1046: l_return_status VARCHAR2(1);

Line 1043: l_amount_tbl PO_TBL_NUMBER;

1039: l_results_count NUMBER;
1040: l_data_key NUMBER;
1041:
1042: l_line_id_tbl PO_TBL_NUMBER;
1043: l_amount_tbl PO_TBL_NUMBER;
1044:
1045: l_timecard_amount_sum NUMBER;
1046: l_return_status VARCHAR2(1);
1047: BEGIN

Line 1160: p_line_id_tbl IN PO_TBL_NUMBER

1156: -- Assumption:
1157: -- All of the unposted line data will be passed in
1158: -- to this routine in order to get accurate results.
1159: PROCEDURE line_num_unique(
1160: p_line_id_tbl IN PO_TBL_NUMBER
1161: , p_header_id_tbl IN PO_TBL_NUMBER
1162: , p_line_num_tbl IN PO_TBL_NUMBER
1163: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1164: , p_draft_id_tbl IN PO_TBL_NUMBER

Line 1161: , p_header_id_tbl IN PO_TBL_NUMBER

1157: -- All of the unposted line data will be passed in
1158: -- to this routine in order to get accurate results.
1159: PROCEDURE line_num_unique(
1160: p_line_id_tbl IN PO_TBL_NUMBER
1161: , p_header_id_tbl IN PO_TBL_NUMBER
1162: , p_line_num_tbl IN PO_TBL_NUMBER
1163: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1164: , p_draft_id_tbl IN PO_TBL_NUMBER
1165: , x_result_set_id IN OUT NOCOPY NUMBER

Line 1162: , p_line_num_tbl IN PO_TBL_NUMBER

1158: -- to this routine in order to get accurate results.
1159: PROCEDURE line_num_unique(
1160: p_line_id_tbl IN PO_TBL_NUMBER
1161: , p_header_id_tbl IN PO_TBL_NUMBER
1162: , p_line_num_tbl IN PO_TBL_NUMBER
1163: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1164: , p_draft_id_tbl IN PO_TBL_NUMBER
1165: , x_result_set_id IN OUT NOCOPY NUMBER
1166: , x_result_type OUT NOCOPY VARCHAR2

Line 1164: , p_draft_id_tbl IN PO_TBL_NUMBER

1160: p_line_id_tbl IN PO_TBL_NUMBER
1161: , p_header_id_tbl IN PO_TBL_NUMBER
1162: , p_line_num_tbl IN PO_TBL_NUMBER
1163: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
1164: , p_draft_id_tbl IN PO_TBL_NUMBER
1165: , x_result_set_id IN OUT NOCOPY NUMBER
1166: , x_result_type OUT NOCOPY VARCHAR2
1167: )
1168: IS

Line 1190: p_line_id_tbl IN PO_TBL_NUMBER

1186: -- Checks for null or non-positive line numbers.
1187: -----------------------------------------------------------------------------
1188:
1189: PROCEDURE line_num_gt_zero(
1190: p_line_id_tbl IN PO_TBL_NUMBER
1191: , p_line_num_tbl IN PO_TBL_NUMBER
1192: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1193: , x_result_type OUT NOCOPY VARCHAR2
1194: )

Line 1191: , p_line_num_tbl IN PO_TBL_NUMBER

1187: -----------------------------------------------------------------------------
1188:
1189: PROCEDURE line_num_gt_zero(
1190: p_line_id_tbl IN PO_TBL_NUMBER
1191: , p_line_num_tbl IN PO_TBL_NUMBER
1192: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1193: , x_result_type OUT NOCOPY VARCHAR2
1194: )
1195: IS

Line 1222: p_line_id_tbl IN PO_TBL_NUMBER

1218: --
1219: -- Where clauses derived from L_ITEM_CSR in PO_AUTOSOURCE_SV.get_asl_info
1220: ------------------------------------------------------------------------
1221: PROCEDURE vmi_asl_exists(
1222: p_line_id_tbl IN PO_TBL_NUMBER
1223: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1224: , p_item_id_tbl IN PO_TBL_NUMBER
1225: , p_org_id_tbl IN PO_TBL_NUMBER
1226: , p_vendor_id_tbl IN PO_TBL_NUMBER

Line 1224: , p_item_id_tbl IN PO_TBL_NUMBER

1220: ------------------------------------------------------------------------
1221: PROCEDURE vmi_asl_exists(
1222: p_line_id_tbl IN PO_TBL_NUMBER
1223: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1224: , p_item_id_tbl IN PO_TBL_NUMBER
1225: , p_org_id_tbl IN PO_TBL_NUMBER
1226: , p_vendor_id_tbl IN PO_TBL_NUMBER
1227: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
1228: , x_result_set_id IN OUT NOCOPY NUMBER

Line 1225: , p_org_id_tbl IN PO_TBL_NUMBER

1221: PROCEDURE vmi_asl_exists(
1222: p_line_id_tbl IN PO_TBL_NUMBER
1223: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1224: , p_item_id_tbl IN PO_TBL_NUMBER
1225: , p_org_id_tbl IN PO_TBL_NUMBER
1226: , p_vendor_id_tbl IN PO_TBL_NUMBER
1227: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
1228: , x_result_set_id IN OUT NOCOPY NUMBER
1229: , x_result_type OUT NOCOPY VARCHAR2

Line 1226: , p_vendor_id_tbl IN PO_TBL_NUMBER

1222: p_line_id_tbl IN PO_TBL_NUMBER
1223: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1224: , p_item_id_tbl IN PO_TBL_NUMBER
1225: , p_org_id_tbl IN PO_TBL_NUMBER
1226: , p_vendor_id_tbl IN PO_TBL_NUMBER
1227: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
1228: , x_result_set_id IN OUT NOCOPY NUMBER
1229: , x_result_type OUT NOCOPY VARCHAR2
1230: )

Line 1227: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

1223: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1224: , p_item_id_tbl IN PO_TBL_NUMBER
1225: , p_org_id_tbl IN PO_TBL_NUMBER
1226: , p_vendor_id_tbl IN PO_TBL_NUMBER
1227: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
1228: , x_result_set_id IN OUT NOCOPY NUMBER
1229: , x_result_type OUT NOCOPY VARCHAR2
1230: )
1231: IS

Line 1330: p_line_id_tbl IN PO_TBL_NUMBER

1326: -- Validates that the start date is less than or equal to the end date.
1327: -- Shows error 'PO_SVC_ASSIGNMENT_DATES'.
1328: ------------------------------------------------------------------------
1329: PROCEDURE start_date_le_end_date(
1330: p_line_id_tbl IN PO_TBL_NUMBER
1331: , p_start_date_tbl IN PO_TBL_DATE
1332: , p_expiration_date_tbl IN PO_TBL_DATE
1333: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1334: , x_result_type OUT NOCOPY VARCHAR2

Line 1367: p_line_id_tbl IN PO_TBL_NUMBER

1363: -- to the order end date.
1364: ------------------------------------------------------------------------
1365: PROCEDURE order_start_date_le_end_date
1366: (
1367: p_line_id_tbl IN PO_TBL_NUMBER
1368: , p_start_date_tbl IN PO_TBL_DATE
1369: , p_expiration_date_tbl IN PO_TBL_DATE
1370: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1371: , x_result_type OUT NOCOPY VARCHAR2

Line 1432: p_line_id_tbl IN PO_TBL_NUMBER

1428:
1429:
1430: PROCEDURE order_start_date_gt_sysdate
1431: (
1432: p_line_id_tbl IN PO_TBL_NUMBER
1433: , p_order_from_date_tbl IN PO_TBL_DATE
1434: , p_draft_id_tbl IN PO_TBL_NUMBER
1435: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1436: , x_result_type OUT NOCOPY VARCHAR2

Line 1434: , p_draft_id_tbl IN PO_TBL_NUMBER

1430: PROCEDURE order_start_date_gt_sysdate
1431: (
1432: p_line_id_tbl IN PO_TBL_NUMBER
1433: , p_order_from_date_tbl IN PO_TBL_DATE
1434: , p_draft_id_tbl IN PO_TBL_NUMBER
1435: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1436: , x_result_type OUT NOCOPY VARCHAR2
1437: )
1438: IS

Line 1518: p_line_id_tbl IN PO_TBL_NUMBER

1514:
1515:
1516: PROCEDURE max_tot_amt_le_line_tot_amt
1517: (
1518: p_line_id_tbl IN PO_TBL_NUMBER
1519: , p_max_total_amt_tbl IN PO_TBL_NUMBER
1520: , p_line_amount_tbl IN PO_TBL_NUMBER
1521: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1522: , x_result_type OUT NOCOPY VARCHAR2

Line 1519: , p_max_total_amt_tbl IN PO_TBL_NUMBER

1515:
1516: PROCEDURE max_tot_amt_le_line_tot_amt
1517: (
1518: p_line_id_tbl IN PO_TBL_NUMBER
1519: , p_max_total_amt_tbl IN PO_TBL_NUMBER
1520: , p_line_amount_tbl IN PO_TBL_NUMBER
1521: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1522: , x_result_type OUT NOCOPY VARCHAR2
1523: )

Line 1520: , p_line_amount_tbl IN PO_TBL_NUMBER

1516: PROCEDURE max_tot_amt_le_line_tot_amt
1517: (
1518: p_line_id_tbl IN PO_TBL_NUMBER
1519: , p_max_total_amt_tbl IN PO_TBL_NUMBER
1520: , p_line_amount_tbl IN PO_TBL_NUMBER
1521: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1522: , x_result_type OUT NOCOPY VARCHAR2
1523: )
1524: IS

Line 1573: p_line_id_tbl IN PO_TBL_NUMBER

1569:
1570:
1571: PROCEDURE max_tot_amt_ge_min_tot_amt
1572: (
1573: p_line_id_tbl IN PO_TBL_NUMBER
1574: , p_max_total_amt_tbl IN PO_TBL_NUMBER
1575: , p_min_total_amt_tbl IN PO_TBL_NUMBER
1576: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1577: , x_result_type OUT NOCOPY VARCHAR2

Line 1574: , p_max_total_amt_tbl IN PO_TBL_NUMBER

1570:
1571: PROCEDURE max_tot_amt_ge_min_tot_amt
1572: (
1573: p_line_id_tbl IN PO_TBL_NUMBER
1574: , p_max_total_amt_tbl IN PO_TBL_NUMBER
1575: , p_min_total_amt_tbl IN PO_TBL_NUMBER
1576: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1577: , x_result_type OUT NOCOPY VARCHAR2
1578: )

Line 1575: , p_min_total_amt_tbl IN PO_TBL_NUMBER

1571: PROCEDURE max_tot_amt_ge_min_tot_amt
1572: (
1573: p_line_id_tbl IN PO_TBL_NUMBER
1574: , p_max_total_amt_tbl IN PO_TBL_NUMBER
1575: , p_min_total_amt_tbl IN PO_TBL_NUMBER
1576: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1577: , x_result_type OUT NOCOPY VARCHAR2
1578: )
1579: IS

Line 1627: p_line_id_tbl IN PO_TBL_NUMBER

1623: END max_tot_amt_ge_min_tot_amt;
1624:
1625: PROCEDURE max_tot_qty_le_line_tot_qty
1626: (
1627: p_line_id_tbl IN PO_TBL_NUMBER
1628: , p_max_total_qty_tbl IN PO_TBL_NUMBER
1629: , p_line_qty_tbl IN PO_TBL_NUMBER
1630: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1631: , x_result_type OUT NOCOPY VARCHAR2

Line 1628: , p_max_total_qty_tbl IN PO_TBL_NUMBER

1624:
1625: PROCEDURE max_tot_qty_le_line_tot_qty
1626: (
1627: p_line_id_tbl IN PO_TBL_NUMBER
1628: , p_max_total_qty_tbl IN PO_TBL_NUMBER
1629: , p_line_qty_tbl IN PO_TBL_NUMBER
1630: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1631: , x_result_type OUT NOCOPY VARCHAR2
1632: )

Line 1629: , p_line_qty_tbl IN PO_TBL_NUMBER

1625: PROCEDURE max_tot_qty_le_line_tot_qty
1626: (
1627: p_line_id_tbl IN PO_TBL_NUMBER
1628: , p_max_total_qty_tbl IN PO_TBL_NUMBER
1629: , p_line_qty_tbl IN PO_TBL_NUMBER
1630: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1631: , x_result_type OUT NOCOPY VARCHAR2
1632: )
1633: IS

Line 1682: p_line_id_tbl IN PO_TBL_NUMBER

1678:
1679:
1680: PROCEDURE max_tot_qty_ge_min_tot_qty
1681: (
1682: p_line_id_tbl IN PO_TBL_NUMBER
1683: , p_max_total_qty_tbl IN PO_TBL_NUMBER
1684: , p_min_total_qty_tbl IN PO_TBL_NUMBER
1685: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1686: , x_result_type OUT NOCOPY VARCHAR2

Line 1683: , p_max_total_qty_tbl IN PO_TBL_NUMBER

1679:
1680: PROCEDURE max_tot_qty_ge_min_tot_qty
1681: (
1682: p_line_id_tbl IN PO_TBL_NUMBER
1683: , p_max_total_qty_tbl IN PO_TBL_NUMBER
1684: , p_min_total_qty_tbl IN PO_TBL_NUMBER
1685: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1686: , x_result_type OUT NOCOPY VARCHAR2
1687: )

Line 1684: , p_min_total_qty_tbl IN PO_TBL_NUMBER

1680: PROCEDURE max_tot_qty_ge_min_tot_qty
1681: (
1682: p_line_id_tbl IN PO_TBL_NUMBER
1683: , p_max_total_qty_tbl IN PO_TBL_NUMBER
1684: , p_min_total_qty_tbl IN PO_TBL_NUMBER
1685: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1686: , x_result_type OUT NOCOPY VARCHAR2
1687: )
1688: IS

Line 1737: p_line_id_tbl IN PO_TBL_NUMBER

1733:
1734:
1735: PROCEDURE max_ord_amt_le_max_tot_amt
1736: (
1737: p_line_id_tbl IN PO_TBL_NUMBER
1738: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1739: , p_max_tot_amount_tbl IN PO_TBL_NUMBER
1740: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1741: , x_result_type OUT NOCOPY VARCHAR2

Line 1738: , p_max_order_amt_tbl IN PO_TBL_NUMBER

1734:
1735: PROCEDURE max_ord_amt_le_max_tot_amt
1736: (
1737: p_line_id_tbl IN PO_TBL_NUMBER
1738: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1739: , p_max_tot_amount_tbl IN PO_TBL_NUMBER
1740: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1741: , x_result_type OUT NOCOPY VARCHAR2
1742: )

Line 1739: , p_max_tot_amount_tbl IN PO_TBL_NUMBER

1735: PROCEDURE max_ord_amt_le_max_tot_amt
1736: (
1737: p_line_id_tbl IN PO_TBL_NUMBER
1738: , p_max_order_amt_tbl IN PO_TBL_NUMBER
1739: , p_max_tot_amount_tbl IN PO_TBL_NUMBER
1740: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1741: , x_result_type OUT NOCOPY VARCHAR2
1742: )
1743: IS

Line 1792: p_line_id_tbl IN PO_TBL_NUMBER

1788:
1789:
1790: PROCEDURE max_ord_amt_ge_min_ord_amt
1791: (
1792: p_line_id_tbl IN PO_TBL_NUMBER
1793: , p_max_ord_amt_tbl IN PO_TBL_NUMBER
1794: , p_min_ord_amt_tbl IN PO_TBL_NUMBER
1795: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1796: , x_result_type OUT NOCOPY VARCHAR2

Line 1793: , p_max_ord_amt_tbl IN PO_TBL_NUMBER

1789:
1790: PROCEDURE max_ord_amt_ge_min_ord_amt
1791: (
1792: p_line_id_tbl IN PO_TBL_NUMBER
1793: , p_max_ord_amt_tbl IN PO_TBL_NUMBER
1794: , p_min_ord_amt_tbl IN PO_TBL_NUMBER
1795: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1796: , x_result_type OUT NOCOPY VARCHAR2
1797: )

Line 1794: , p_min_ord_amt_tbl IN PO_TBL_NUMBER

1790: PROCEDURE max_ord_amt_ge_min_ord_amt
1791: (
1792: p_line_id_tbl IN PO_TBL_NUMBER
1793: , p_max_ord_amt_tbl IN PO_TBL_NUMBER
1794: , p_min_ord_amt_tbl IN PO_TBL_NUMBER
1795: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1796: , x_result_type OUT NOCOPY VARCHAR2
1797: )
1798: IS

Line 1846: p_line_id_tbl IN PO_TBL_NUMBER

1842: END max_ord_amt_ge_min_ord_amt;
1843:
1844: PROCEDURE max_ord_qty_le_max_tot_qty
1845: (
1846: p_line_id_tbl IN PO_TBL_NUMBER
1847: , p_max_order_qty_tbl IN PO_TBL_NUMBER
1848: , p_max_tot_qty_tbl IN PO_TBL_NUMBER
1849: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1850: , x_result_type OUT NOCOPY VARCHAR2

Line 1847: , p_max_order_qty_tbl IN PO_TBL_NUMBER

1843:
1844: PROCEDURE max_ord_qty_le_max_tot_qty
1845: (
1846: p_line_id_tbl IN PO_TBL_NUMBER
1847: , p_max_order_qty_tbl IN PO_TBL_NUMBER
1848: , p_max_tot_qty_tbl IN PO_TBL_NUMBER
1849: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1850: , x_result_type OUT NOCOPY VARCHAR2
1851: )

Line 1848: , p_max_tot_qty_tbl IN PO_TBL_NUMBER

1844: PROCEDURE max_ord_qty_le_max_tot_qty
1845: (
1846: p_line_id_tbl IN PO_TBL_NUMBER
1847: , p_max_order_qty_tbl IN PO_TBL_NUMBER
1848: , p_max_tot_qty_tbl IN PO_TBL_NUMBER
1849: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1850: , x_result_type OUT NOCOPY VARCHAR2
1851: )
1852: IS

Line 1901: p_line_id_tbl IN PO_TBL_NUMBER

1897:
1898:
1899: PROCEDURE max_ord_qty_ge_min_ord_qty
1900: (
1901: p_line_id_tbl IN PO_TBL_NUMBER
1902: , p_max_ord_qty_tbl IN PO_TBL_NUMBER
1903: , p_min_ord_qty_tbl IN PO_TBL_NUMBER
1904: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1905: , x_result_type OUT NOCOPY VARCHAR2

Line 1902: , p_max_ord_qty_tbl IN PO_TBL_NUMBER

1898:
1899: PROCEDURE max_ord_qty_ge_min_ord_qty
1900: (
1901: p_line_id_tbl IN PO_TBL_NUMBER
1902: , p_max_ord_qty_tbl IN PO_TBL_NUMBER
1903: , p_min_ord_qty_tbl IN PO_TBL_NUMBER
1904: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1905: , x_result_type OUT NOCOPY VARCHAR2
1906: )

Line 1903: , p_min_ord_qty_tbl IN PO_TBL_NUMBER

1899: PROCEDURE max_ord_qty_ge_min_ord_qty
1900: (
1901: p_line_id_tbl IN PO_TBL_NUMBER
1902: , p_max_ord_qty_tbl IN PO_TBL_NUMBER
1903: , p_min_ord_qty_tbl IN PO_TBL_NUMBER
1904: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1905: , x_result_type OUT NOCOPY VARCHAR2
1906: )
1907: IS

Line 1964: p_line_id_tbl IN PO_TBL_NUMBER

1960: -- Then throw the error 'PO_CHNG_OTL_INVALID_START_DATE'.
1961: --
1962: ------------------------------------------------------------------------
1963: PROCEDURE otl_invalid_start_date_change(
1964: p_line_id_tbl IN PO_TBL_NUMBER
1965: , p_start_date_tbl IN PO_TBL_DATE
1966: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1967: , x_result_type OUT NOCOPY VARCHAR2
1968: )

Line 1997: p_line_id_tbl IN PO_TBL_NUMBER

1993: -- Then throw the error 'PO_CHNG_OTL_INVALID_END_DATE'.
1994: --
1995: ------------------------------------------------------------------------
1996: PROCEDURE otl_invalid_end_date_change(
1997: p_line_id_tbl IN PO_TBL_NUMBER
1998: , p_expiration_date_tbl IN PO_TBL_DATE
1999: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2000: , x_result_type OUT NOCOPY VARCHAR2
2001: )

Line 2024: p_line_id_tbl IN PO_TBL_NUMBER

2020: -- Validates that the unit price is greater than or equal to zero
2021: -- for non-Fixed Price lines.
2022: -----------------------------------------------------------------------------
2023: PROCEDURE unit_price_ge_zero(
2024: p_line_id_tbl IN PO_TBL_NUMBER
2025: , p_unit_price_tbl IN PO_TBL_NUMBER
2026: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2027: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2028: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2025: , p_unit_price_tbl IN PO_TBL_NUMBER

2021: -- for non-Fixed Price lines.
2022: -----------------------------------------------------------------------------
2023: PROCEDURE unit_price_ge_zero(
2024: p_line_id_tbl IN PO_TBL_NUMBER
2025: , p_unit_price_tbl IN PO_TBL_NUMBER
2026: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2027: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2028: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2029: , x_result_type OUT NOCOPY VARCHAR2

Line 2034: l_line_id_tbl PO_TBL_NUMBER;

2030: )
2031: IS
2032: d_mod CONSTANT VARCHAR2(100) := D_unit_price_ge_zero;
2033:
2034: l_line_id_tbl PO_TBL_NUMBER;
2035: l_unit_price_tbl PO_TBL_NUMBER;
2036: l_input_size NUMBER;
2037: l_count NUMBER;
2038: BEGIN

Line 2035: l_unit_price_tbl PO_TBL_NUMBER;

2031: IS
2032: d_mod CONSTANT VARCHAR2(100) := D_unit_price_ge_zero;
2033:
2034: l_line_id_tbl PO_TBL_NUMBER;
2035: l_unit_price_tbl PO_TBL_NUMBER;
2036: l_input_size NUMBER;
2037: l_count NUMBER;
2038: BEGIN
2039:

Line 2050: l_line_id_tbl := PO_TBL_NUMBER();

2046: END IF;
2047:
2048: l_input_size := p_line_id_tbl.COUNT;
2049:
2050: l_line_id_tbl := PO_TBL_NUMBER();
2051: l_line_id_tbl.extend(l_input_size);
2052: l_unit_price_tbl := PO_TBL_NUMBER();
2053: l_unit_price_tbl.extend(l_input_size);
2054:

Line 2052: l_unit_price_tbl := PO_TBL_NUMBER();

2048: l_input_size := p_line_id_tbl.COUNT;
2049:
2050: l_line_id_tbl := PO_TBL_NUMBER();
2051: l_line_id_tbl.extend(l_input_size);
2052: l_unit_price_tbl := PO_TBL_NUMBER();
2053: l_unit_price_tbl.extend(l_input_size);
2054:
2055: l_count := 0;
2056:

Line 2096: p_line_id_tbl IN PO_TBL_NUMBER

2092: -----------------------------------------------------------------------------
2093: -- Validates that the list price per unit is greater than or equal to zero.
2094: -----------------------------------------------------------------------------
2095: PROCEDURE list_price_ge_zero(
2096: p_line_id_tbl IN PO_TBL_NUMBER
2097: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
2098: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2099: , x_result_type OUT NOCOPY VARCHAR2
2100: )

Line 2097: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER

2093: -- Validates that the list price per unit is greater than or equal to zero.
2094: -----------------------------------------------------------------------------
2095: PROCEDURE list_price_ge_zero(
2096: p_line_id_tbl IN PO_TBL_NUMBER
2097: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
2098: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2099: , x_result_type OUT NOCOPY VARCHAR2
2100: )
2101: IS

Line 2123: p_line_id_tbl IN PO_TBL_NUMBER

2119: -----------------------------------------------------------------------------
2120: -- Validates that the market price is greater than or equal to zero.
2121: -----------------------------------------------------------------------------
2122: PROCEDURE market_price_ge_zero(
2123: p_line_id_tbl IN PO_TBL_NUMBER
2124: , p_market_price_tbl IN PO_TBL_NUMBER
2125: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2126: , x_result_type OUT NOCOPY VARCHAR2
2127: )

Line 2124: , p_market_price_tbl IN PO_TBL_NUMBER

2120: -- Validates that the market price is greater than or equal to zero.
2121: -----------------------------------------------------------------------------
2122: PROCEDURE market_price_ge_zero(
2123: p_line_id_tbl IN PO_TBL_NUMBER
2124: , p_market_price_tbl IN PO_TBL_NUMBER
2125: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2126: , x_result_type OUT NOCOPY VARCHAR2
2127: )
2128: IS

Line 2153: p_line_id_tbl IN PO_TBL_NUMBER

2149: -- the price is not being used by another process that should
2150: -- prevent a price change.
2151: -----------------------------------------------------------------------------
2152: PROCEDURE validate_unit_price_change(
2153: p_line_id_tbl IN PO_TBL_NUMBER
2154: , p_unit_price_tbl IN PO_TBL_NUMBER
2155: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
2156: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1
2157: , x_result_set_id IN OUT NOCOPY NUMBER

Line 2154: , p_unit_price_tbl IN PO_TBL_NUMBER

2150: -- prevent a price change.
2151: -----------------------------------------------------------------------------
2152: PROCEDURE validate_unit_price_change(
2153: p_line_id_tbl IN PO_TBL_NUMBER
2154: , p_unit_price_tbl IN PO_TBL_NUMBER
2155: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
2156: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1
2157: , x_result_set_id IN OUT NOCOPY NUMBER
2158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2165: l_line_id_tbl PO_TBL_NUMBER;

2161: IS
2162: d_mod CONSTANT VARCHAR2(100) := D_validate_unit_price_change;
2163:
2164: l_data_key NUMBER;
2165: l_line_id_tbl PO_TBL_NUMBER;
2166: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
2167: l_amount_changed_flag_tbl PO_TBL_VARCHAR1; -- --
2168:
2169: BEGIN

Line 2262: p_line_id_tbl IN PO_TBL_NUMBER

2258: -- of the Agreement.
2259: -- Agreements only.
2260: -----------------------------------------------------------------------------
2261: PROCEDURE expiration_ge_blanket_start(
2262: p_line_id_tbl IN PO_TBL_NUMBER
2263: , p_blanket_start_date_tbl IN PO_TBL_DATE
2264: , p_expiration_date_tbl IN PO_TBL_DATE
2265: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2266: , x_result_type OUT NOCOPY VARCHAR2

Line 2294: p_line_id_tbl IN PO_TBL_NUMBER

2290: -- of the Agreement.
2291: -- Agreements only.
2292: -----------------------------------------------------------------------------
2293: PROCEDURE expiration_le_blanket_end(
2294: p_line_id_tbl IN PO_TBL_NUMBER
2295: , p_blanket_end_date_tbl IN PO_TBL_DATE
2296: , p_expiration_date_tbl IN PO_TBL_DATE
2297: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2298: , x_result_type OUT NOCOPY VARCHAR2

Line 2326: p_line_id_tbl IN PO_TBL_NUMBER

2322: -------------------------------------------------------------------------
2323: -- The invoice close tolerance must be between 0 and 100, inclusive.
2324: -------------------------------------------------------------------------
2325: PROCEDURE recoupment_rate_range_check (
2326: p_line_id_tbl IN PO_TBL_NUMBER
2327: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
2328: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2329: , x_result_type OUT NOCOPY VARCHAR2
2330: )

Line 2327: , p_recoupment_rate_tbl IN PO_TBL_NUMBER

2323: -- The invoice close tolerance must be between 0 and 100, inclusive.
2324: -------------------------------------------------------------------------
2325: PROCEDURE recoupment_rate_range_check (
2326: p_line_id_tbl IN PO_TBL_NUMBER
2327: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
2328: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2329: , x_result_type OUT NOCOPY VARCHAR2
2330: )
2331: IS

Line 2349: p_line_id_tbl IN PO_TBL_NUMBER

2345:
2346: END recoupment_rate_range_check;
2347:
2348: PROCEDURE retainage_rate_range_check (
2349: p_line_id_tbl IN PO_TBL_NUMBER
2350: , p_retainage_rate_tbl IN PO_TBL_NUMBER
2351: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2352: , x_result_type OUT NOCOPY VARCHAR2
2353: )

Line 2350: , p_retainage_rate_tbl IN PO_TBL_NUMBER

2346: END recoupment_rate_range_check;
2347:
2348: PROCEDURE retainage_rate_range_check (
2349: p_line_id_tbl IN PO_TBL_NUMBER
2350: , p_retainage_rate_tbl IN PO_TBL_NUMBER
2351: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2352: , x_result_type OUT NOCOPY VARCHAR2
2353: )
2354: IS

Line 2372: p_line_id_tbl IN PO_TBL_NUMBER

2368:
2369: END retainage_rate_range_check;
2370:
2371: PROCEDURE prog_pay_rate_range_check (
2372: p_line_id_tbl IN PO_TBL_NUMBER
2373: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
2374: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2375: , x_result_type OUT NOCOPY VARCHAR2
2376: )

Line 2373: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER

2369: END retainage_rate_range_check;
2370:
2371: PROCEDURE prog_pay_rate_range_check (
2372: p_line_id_tbl IN PO_TBL_NUMBER
2373: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
2374: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2375: , x_result_type OUT NOCOPY VARCHAR2
2376: )
2377: IS

Line 2403: p_line_id_tbl IN PO_TBL_NUMBER

2399: -- This check is only performed if quantity is being reduced below the
2400: -- current transaction quantity, since over-receiving is allowed.
2401: -----------------------------------------------------------------------------
2402: PROCEDURE qty_ge_qty_milestone_exec(
2403: p_line_id_tbl IN PO_TBL_NUMBER
2404: , p_quantity_tbl IN PO_TBL_NUMBER
2405: , x_result_set_id IN OUT NOCOPY NUMBER
2406: , x_result_type OUT NOCOPY VARCHAR2
2407: )

Line 2404: , p_quantity_tbl IN PO_TBL_NUMBER

2400: -- current transaction quantity, since over-receiving is allowed.
2401: -----------------------------------------------------------------------------
2402: PROCEDURE qty_ge_qty_milestone_exec(
2403: p_line_id_tbl IN PO_TBL_NUMBER
2404: , p_quantity_tbl IN PO_TBL_NUMBER
2405: , x_result_set_id IN OUT NOCOPY NUMBER
2406: , x_result_type OUT NOCOPY VARCHAR2
2407: )
2408: IS

Line 2498: p_line_id_tbl IN PO_TBL_NUMBER

2494: -- This check is only performed if price is being reduced below the
2495: -- current transaction price, since over-receiving is allowed.
2496: -----------------------------------------------------------------------------
2497: PROCEDURE price_ge_price_milestone_exec(
2498: p_line_id_tbl IN PO_TBL_NUMBER
2499: , p_price_tbl IN PO_TBL_NUMBER
2500: , x_result_set_id IN OUT NOCOPY NUMBER
2501: , x_result_type OUT NOCOPY VARCHAR2
2502: )

Line 2499: , p_price_tbl IN PO_TBL_NUMBER

2495: -- current transaction price, since over-receiving is allowed.
2496: -----------------------------------------------------------------------------
2497: PROCEDURE price_ge_price_milestone_exec(
2498: p_line_id_tbl IN PO_TBL_NUMBER
2499: , p_price_tbl IN PO_TBL_NUMBER
2500: , x_result_set_id IN OUT NOCOPY NUMBER
2501: , x_result_type OUT NOCOPY VARCHAR2
2502: )
2503: IS

Line 2586: p_line_id_tbl IN PO_TBL_NUMBER

2582: -------------------------------------------------------------------------------
2583: -- Ensures that the Unit of Measure is not null for non-FIXED PRICE lines.
2584: -------------------------------------------------------------------------------
2585: PROCEDURE unit_meas_not_null(
2586: p_line_id_tbl IN PO_TBL_NUMBER
2587: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
2588: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2589: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2590: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2653: p_line_id_tbl IN PO_TBL_NUMBER

2649: -------------------------------------------------------------------------------
2650: -- Ensures that the Item Description is not null.
2651: -------------------------------------------------------------------------------
2652: PROCEDURE item_description_not_null(
2653: p_line_id_tbl IN PO_TBL_NUMBER
2654: , p_item_description_tbl IN PO_TBL_VARCHAR2000
2655: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2656: , x_result_type OUT NOCOPY VARCHAR2
2657: )

Line 2679: p_line_id_tbl IN PO_TBL_NUMBER

2675: -------------------------------------------------------------------------------
2676: -- Ensures that the Category is not null.
2677: -------------------------------------------------------------------------------
2678: PROCEDURE category_id_not_null(
2679: p_line_id_tbl IN PO_TBL_NUMBER
2680: , p_category_id_tbl IN PO_TBL_NUMBER
2681: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2682: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2683: , x_result_type OUT NOCOPY VARCHAR2

Line 2680: , p_category_id_tbl IN PO_TBL_NUMBER

2676: -- Ensures that the Category is not null.
2677: -------------------------------------------------------------------------------
2678: PROCEDURE category_id_not_null(
2679: p_line_id_tbl IN PO_TBL_NUMBER
2680: , p_category_id_tbl IN PO_TBL_NUMBER
2681: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2682: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2683: , x_result_type OUT NOCOPY VARCHAR2
2684: )

Line 2687: l_line_id_tbl PO_TBL_NUMBER;

2683: , x_result_type OUT NOCOPY VARCHAR2
2684: )
2685: IS
2686:
2687: l_line_id_tbl PO_TBL_NUMBER;
2688: l_category_id_tbl PO_TBL_NUMBER;
2689: l_input_size NUMBER;
2690: l_count NUMBER;
2691:

Line 2688: l_category_id_tbl PO_TBL_NUMBER;

2684: )
2685: IS
2686:
2687: l_line_id_tbl PO_TBL_NUMBER;
2688: l_category_id_tbl PO_TBL_NUMBER;
2689: l_input_size NUMBER;
2690: l_count NUMBER;
2691:
2692: BEGIN

Line 2696: l_line_id_tbl := PO_TBL_NUMBER();

2692: BEGIN
2693: -- CLM changes
2694: l_input_size := p_line_id_tbl.COUNT;
2695:
2696: l_line_id_tbl := PO_TBL_NUMBER();
2697: l_line_id_tbl.extend(l_input_size);
2698: l_category_id_tbl := PO_TBL_NUMBER();
2699: l_category_id_tbl.extend(l_input_size);
2700:

Line 2698: l_category_id_tbl := PO_TBL_NUMBER();

2694: l_input_size := p_line_id_tbl.COUNT;
2695:
2696: l_line_id_tbl := PO_TBL_NUMBER();
2697: l_line_id_tbl.extend(l_input_size);
2698: l_category_id_tbl := PO_TBL_NUMBER();
2699: l_category_id_tbl.extend(l_input_size);
2700:
2701: l_count := 0;
2702:

Line 2733: p_id_tbl IN PO_TBL_NUMBER

2729: -- If order_type_lookup_code is Quantity and outside_operation flag is 'Y',
2730: -- then the item_id cannot be null.
2731: ---------------------------------------------------------------------------
2732: PROCEDURE item_id_not_null(
2733: p_id_tbl IN PO_TBL_NUMBER
2734: , p_item_id_tbl IN PO_TBL_NUMBER
2735: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2736: , p_line_type_id_tbl IN PO_TBL_NUMBER
2737: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

Line 2734: , p_item_id_tbl IN PO_TBL_NUMBER

2730: -- then the item_id cannot be null.
2731: ---------------------------------------------------------------------------
2732: PROCEDURE item_id_not_null(
2733: p_id_tbl IN PO_TBL_NUMBER
2734: , p_item_id_tbl IN PO_TBL_NUMBER
2735: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2736: , p_line_type_id_tbl IN PO_TBL_NUMBER
2737: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2738: , p_message_name IN VARCHAR2

Line 2736: , p_line_type_id_tbl IN PO_TBL_NUMBER

2732: PROCEDURE item_id_not_null(
2733: p_id_tbl IN PO_TBL_NUMBER
2734: , p_item_id_tbl IN PO_TBL_NUMBER
2735: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2736: , p_line_type_id_tbl IN PO_TBL_NUMBER
2737: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2738: , p_message_name IN VARCHAR2
2739: , x_result_set_id IN OUT NOCOPY NUMBER
2740: , x_result_type OUT NOCOPY VARCHAR2

Line 2745: l_id_tbl PO_TBL_NUMBER;

2741: )
2742: IS
2743: d_mod CONSTANT VARCHAR2(100) := D_item_id_not_null;
2744:
2745: l_id_tbl PO_TBL_NUMBER;
2746: l_line_type_id_tbl PO_TBL_NUMBER;
2747: l_input_size NUMBER;
2748: l_count NUMBER;
2749:

Line 2746: l_line_type_id_tbl PO_TBL_NUMBER;

2742: IS
2743: d_mod CONSTANT VARCHAR2(100) := D_item_id_not_null;
2744:
2745: l_id_tbl PO_TBL_NUMBER;
2746: l_line_type_id_tbl PO_TBL_NUMBER;
2747: l_input_size NUMBER;
2748: l_count NUMBER;
2749:
2750: BEGIN

Line 2770: l_id_tbl := PO_TBL_NUMBER();

2766: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
2767:
2768: l_input_size := p_id_tbl.COUNT;
2769:
2770: l_id_tbl := PO_TBL_NUMBER();
2771: l_id_tbl.extend(l_input_size);
2772: l_line_type_id_tbl := PO_TBL_NUMBER();
2773: l_line_type_id_tbl.extend(l_input_size);
2774:

Line 2772: l_line_type_id_tbl := PO_TBL_NUMBER();

2768: l_input_size := p_id_tbl.COUNT;
2769:
2770: l_id_tbl := PO_TBL_NUMBER();
2771: l_id_tbl.extend(l_input_size);
2772: l_line_type_id_tbl := PO_TBL_NUMBER();
2773: l_line_type_id_tbl.extend(l_input_size);
2774:
2775: l_count := 0;
2776:

Line 2845: p_line_id_tbl IN PO_TBL_NUMBER

2841: -------------------------------------------------------------------------------
2842: -- Ensures that the Job is not null for TEMP LABOR lines.
2843: -------------------------------------------------------------------------------
2844: PROCEDURE temp_labor_job_id_not_null(
2845: p_line_id_tbl IN PO_TBL_NUMBER
2846: , p_job_id_tbl IN PO_TBL_NUMBER
2847: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
2848: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2849: , x_result_type OUT NOCOPY VARCHAR2

Line 2846: , p_job_id_tbl IN PO_TBL_NUMBER

2842: -- Ensures that the Job is not null for TEMP LABOR lines.
2843: -------------------------------------------------------------------------------
2844: PROCEDURE temp_labor_job_id_not_null(
2845: p_line_id_tbl IN PO_TBL_NUMBER
2846: , p_job_id_tbl IN PO_TBL_NUMBER
2847: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
2848: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2849: , x_result_type OUT NOCOPY VARCHAR2
2850: )

Line 2908: p_line_id_tbl IN PO_TBL_NUMBER

2904: -- Ensures that the Source Doc Line is not null if the Source Doc is not null
2905: -- and the Source Doc is not a contract.
2906: -------------------------------------------------------------------------------
2907: PROCEDURE src_doc_line_not_null(
2908: p_line_id_tbl IN PO_TBL_NUMBER
2909: , p_from_header_id_tbl IN PO_TBL_NUMBER
2910: , p_from_line_id_tbl IN PO_TBL_NUMBER
2911: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2912: , x_result_type OUT NOCOPY VARCHAR2

Line 2909: , p_from_header_id_tbl IN PO_TBL_NUMBER

2905: -- and the Source Doc is not a contract.
2906: -------------------------------------------------------------------------------
2907: PROCEDURE src_doc_line_not_null(
2908: p_line_id_tbl IN PO_TBL_NUMBER
2909: , p_from_header_id_tbl IN PO_TBL_NUMBER
2910: , p_from_line_id_tbl IN PO_TBL_NUMBER
2911: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2912: , x_result_type OUT NOCOPY VARCHAR2
2913: )

Line 2910: , p_from_line_id_tbl IN PO_TBL_NUMBER

2906: -------------------------------------------------------------------------------
2907: PROCEDURE src_doc_line_not_null(
2908: p_line_id_tbl IN PO_TBL_NUMBER
2909: , p_from_header_id_tbl IN PO_TBL_NUMBER
2910: , p_from_line_id_tbl IN PO_TBL_NUMBER
2911: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2912: , x_result_type OUT NOCOPY VARCHAR2
2913: )
2914: IS

Line 2977: p_line_id_tbl IN PO_TBL_NUMBER

2973: -------------------------------------------------------------------------------
2974: -- Ensures that the Line Type is not null.
2975: -------------------------------------------------------------------------------
2976: PROCEDURE line_type_id_not_null(
2977: p_line_id_tbl IN PO_TBL_NUMBER
2978: , p_line_type_id_tbl IN PO_TBL_NUMBER
2979: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2980: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2981: , x_result_type OUT NOCOPY VARCHAR2

Line 2978: , p_line_type_id_tbl IN PO_TBL_NUMBER

2974: -- Ensures that the Line Type is not null.
2975: -------------------------------------------------------------------------------
2976: PROCEDURE line_type_id_not_null(
2977: p_line_id_tbl IN PO_TBL_NUMBER
2978: , p_line_type_id_tbl IN PO_TBL_NUMBER
2979: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2980: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2981: , x_result_type OUT NOCOPY VARCHAR2
2982: )

Line 2985: l_line_id_tbl PO_TBL_NUMBER;

2981: , x_result_type OUT NOCOPY VARCHAR2
2982: )
2983: IS
2984:
2985: l_line_id_tbl PO_TBL_NUMBER;
2986: l_line_type_id_tbl PO_TBL_NUMBER;
2987: l_input_size NUMBER;
2988: l_count NUMBER;
2989:

Line 2986: l_line_type_id_tbl PO_TBL_NUMBER;

2982: )
2983: IS
2984:
2985: l_line_id_tbl PO_TBL_NUMBER;
2986: l_line_type_id_tbl PO_TBL_NUMBER;
2987: l_input_size NUMBER;
2988: l_count NUMBER;
2989:
2990: BEGIN

Line 2994: l_line_id_tbl := PO_TBL_NUMBER();

2990: BEGIN
2991: -- CLM changes
2992: l_input_size := p_line_id_tbl.COUNT;
2993:
2994: l_line_id_tbl := PO_TBL_NUMBER();
2995: l_line_id_tbl.extend(l_input_size);
2996: l_line_type_id_tbl := PO_TBL_NUMBER();
2997: l_line_type_id_tbl.extend(l_input_size);
2998:

Line 2996: l_line_type_id_tbl := PO_TBL_NUMBER();

2992: l_input_size := p_line_id_tbl.COUNT;
2993:
2994: l_line_id_tbl := PO_TBL_NUMBER();
2995: l_line_id_tbl.extend(l_input_size);
2996: l_line_type_id_tbl := PO_TBL_NUMBER();
2997: l_line_type_id_tbl.extend(l_input_size);
2998:
2999: l_count := 0;
3000:

Line 3029: p_line_id_tbl IN PO_TBL_NUMBER

3025: -------------------------------------------------------------------------------
3026: -- Ensures that the Start Date is not null for TEMP LABOR lines.
3027: -------------------------------------------------------------------------------
3028: PROCEDURE temp_lbr_start_date_not_null(
3029: p_line_id_tbl IN PO_TBL_NUMBER
3030: , p_start_date_tbl IN PO_TBL_DATE
3031: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
3032: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3033: , x_result_type OUT NOCOPY VARCHAR2

Line 3093: p_line_id_tbl IN PO_TBL_NUMBER

3089: -- Validates that secondary quantity is not null and greater than zero for
3090: -- an opm item.
3091: -----------------------------------------------------------------------------
3092: PROCEDURE line_sec_quantity_gt_zero(
3093: p_line_id_tbl IN PO_TBL_NUMBER
3094: , p_item_id_tbl IN PO_TBL_NUMBER
3095: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3096: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3097: , x_result_type OUT NOCOPY VARCHAR2

Line 3094: , p_item_id_tbl IN PO_TBL_NUMBER

3090: -- an opm item.
3091: -----------------------------------------------------------------------------
3092: PROCEDURE line_sec_quantity_gt_zero(
3093: p_line_id_tbl IN PO_TBL_NUMBER
3094: , p_item_id_tbl IN PO_TBL_NUMBER
3095: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3096: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3097: , x_result_type OUT NOCOPY VARCHAR2
3098: )

Line 3095: , p_sec_quantity_tbl IN PO_TBL_NUMBER

3091: -----------------------------------------------------------------------------
3092: PROCEDURE line_sec_quantity_gt_zero(
3093: p_line_id_tbl IN PO_TBL_NUMBER
3094: , p_item_id_tbl IN PO_TBL_NUMBER
3095: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3096: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3097: , x_result_type OUT NOCOPY VARCHAR2
3098: )
3099: IS

Line 3101: l_inv_org_id_tbl PO_TBL_NUMBER;

3097: , x_result_type OUT NOCOPY VARCHAR2
3098: )
3099: IS
3100: d_mod CONSTANT VARCHAR2(100) := D_line_sec_quantity_gt_zero;
3101: l_inv_org_id_tbl PO_TBL_NUMBER;
3102: l_def_inv_org_id NUMBER;
3103: l_input_size NUMBER;
3104:
3105: BEGIN

Line 3121: l_inv_org_id_tbl := PO_TBL_NUMBER();

3117: from financials_system_parameters;
3118:
3119: l_input_size := p_line_id_tbl.COUNT;
3120:
3121: l_inv_org_id_tbl := PO_TBL_NUMBER();
3122: l_inv_org_id_tbl.extend(l_input_size);
3123:
3124: FOR i IN 1 .. p_line_id_tbl.COUNT LOOP
3125: l_inv_org_id_tbl(i) := l_def_inv_org_id;

Line 3155: p_line_id_tbl IN PO_TBL_NUMBER

3151: -- Validates secondary quantity and the quantity combination for
3152: -- an opm item
3153: -----------------------------------------------------------------------------
3154: PROCEDURE line_qtys_within_deviation (
3155: p_line_id_tbl IN PO_TBL_NUMBER
3156: , p_item_id_tbl IN PO_TBL_NUMBER
3157: , p_quantity_tbl IN PO_TBL_NUMBER
3158: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
3159: , p_sec_quantity_tbl IN PO_TBL_NUMBER

Line 3156: , p_item_id_tbl IN PO_TBL_NUMBER

3152: -- an opm item
3153: -----------------------------------------------------------------------------
3154: PROCEDURE line_qtys_within_deviation (
3155: p_line_id_tbl IN PO_TBL_NUMBER
3156: , p_item_id_tbl IN PO_TBL_NUMBER
3157: , p_quantity_tbl IN PO_TBL_NUMBER
3158: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
3159: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3160: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

Line 3157: , p_quantity_tbl IN PO_TBL_NUMBER

3153: -----------------------------------------------------------------------------
3154: PROCEDURE line_qtys_within_deviation (
3155: p_line_id_tbl IN PO_TBL_NUMBER
3156: , p_item_id_tbl IN PO_TBL_NUMBER
3157: , p_quantity_tbl IN PO_TBL_NUMBER
3158: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
3159: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3160: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
3161: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 3159: , p_sec_quantity_tbl IN PO_TBL_NUMBER

3155: p_line_id_tbl IN PO_TBL_NUMBER
3156: , p_item_id_tbl IN PO_TBL_NUMBER
3157: , p_quantity_tbl IN PO_TBL_NUMBER
3158: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
3159: , p_sec_quantity_tbl IN PO_TBL_NUMBER
3160: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
3161: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3162: , x_result_type OUT NOCOPY VARCHAR2
3163: )

Line 3167: l_inv_org_id_tbl PO_TBL_NUMBER;

3163: )
3164: IS
3165:
3166: d_mod CONSTANT VARCHAR2(100) := D_line_qtys_within_deviation;
3167: l_inv_org_id_tbl PO_TBL_NUMBER;
3168: l_input_size NUMBER;
3169: l_def_inv_org_id NUMBER;
3170:
3171: BEGIN

Line 3187: l_inv_org_id_tbl := PO_TBL_NUMBER();

3183: from financials_system_parameters;
3184:
3185: l_input_size := p_line_id_tbl.COUNT;
3186:
3187: l_inv_org_id_tbl := PO_TBL_NUMBER();
3188: l_inv_org_id_tbl.extend(l_input_size);
3189:
3190: FOR i IN 1 .. p_line_id_tbl.COUNT LOOP
3191: l_inv_org_id_tbl(i) := l_def_inv_org_id;

Line 3222: p_line_id_tbl IN PO_TBL_NUMBER

3218: -- Validates that source doc line is not null if the source document is filled
3219: -- in and the source document is a blanket or quotation
3220: -----------------------------------------------------------------------------
3221: PROCEDURE from_line_id_not_null (
3222: p_line_id_tbl IN PO_TBL_NUMBER
3223: , p_from_header_id_tbl IN PO_TBL_NUMBER
3224: , p_from_line_id_tbl IN PO_TBL_NUMBER
3225: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3226: , x_result_type OUT NOCOPY VARCHAR2

Line 3223: , p_from_header_id_tbl IN PO_TBL_NUMBER

3219: -- in and the source document is a blanket or quotation
3220: -----------------------------------------------------------------------------
3221: PROCEDURE from_line_id_not_null (
3222: p_line_id_tbl IN PO_TBL_NUMBER
3223: , p_from_header_id_tbl IN PO_TBL_NUMBER
3224: , p_from_line_id_tbl IN PO_TBL_NUMBER
3225: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3226: , x_result_type OUT NOCOPY VARCHAR2
3227: )

Line 3224: , p_from_line_id_tbl IN PO_TBL_NUMBER

3220: -----------------------------------------------------------------------------
3221: PROCEDURE from_line_id_not_null (
3222: p_line_id_tbl IN PO_TBL_NUMBER
3223: , p_from_header_id_tbl IN PO_TBL_NUMBER
3224: , p_from_line_id_tbl IN PO_TBL_NUMBER
3225: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3226: , x_result_type OUT NOCOPY VARCHAR2
3227: )
3228: IS

Line 3310: p_line_id_tbl IN PO_TBL_NUMBER

3306: -- This procedure determines if Maximum Retainage Amount
3307: -- is greater than or equal to zero. If not, return a failure.
3308: -------------------------------------------------------------------------------
3309: PROCEDURE max_retain_amt_ge_zero(
3310: p_line_id_tbl IN PO_TBL_NUMBER
3311: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
3312: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3313: , x_result_type OUT NOCOPY VARCHAR2
3314: )

Line 3311: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

3307: -- is greater than or equal to zero. If not, return a failure.
3308: -------------------------------------------------------------------------------
3309: PROCEDURE max_retain_amt_ge_zero(
3310: p_line_id_tbl IN PO_TBL_NUMBER
3311: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
3312: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3313: , x_result_type OUT NOCOPY VARCHAR2
3314: )
3315: IS

Line 3340: p_line_id_tbl IN PO_TBL_NUMBER

3336: -- This procedure determines if Maximum Retainage Amount
3337: -- is greater than already retained amount. If not, return a failure.
3338: -------------------------------------------------------------------------------
3339: PROCEDURE max_retain_amt_ge_retained(
3340: p_line_id_tbl IN PO_TBL_NUMBER
3341: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
3342: , x_result_set_id IN OUT NOCOPY NUMBER
3343: , x_result_type OUT NOCOPY VARCHAR2
3344: )

Line 3341: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

3337: -- is greater than already retained amount. If not, return a failure.
3338: -------------------------------------------------------------------------------
3339: PROCEDURE max_retain_amt_ge_retained(
3340: p_line_id_tbl IN PO_TBL_NUMBER
3341: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
3342: , x_result_set_id IN OUT NOCOPY NUMBER
3343: , x_result_type OUT NOCOPY VARCHAR2
3344: )
3345: IS

Line 3418: p_line_id_tbl IN PO_TBL_NUMBER

3414: END max_retain_amt_ge_retained;
3415: --Bug 5453079 END
3416:
3417: PROCEDURE option_from_date_not_null (
3418: p_line_id_tbl IN PO_TBL_NUMBER
3419: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3420: , p_option_from_date_tbl IN PO_TBL_DATE
3421: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3422: , x_result_type OUT NOCOPY VARCHAR2

Line 3473: p_line_id_tbl IN PO_TBL_NUMBER

3469: RAISE;
3470: END option_from_date_not_null;
3471:
3472: PROCEDURE option_to_date_not_null (
3473: p_line_id_tbl IN PO_TBL_NUMBER
3474: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3475: ,p_option_to_Date_tbl IN PO_TBL_DATE
3476: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3477: , x_result_type OUT NOCOPY VARCHAR2

Line 3528: p_line_id_tbl IN PO_TBL_NUMBER

3524: RAISE;
3525: END option_to_date_not_null;
3526:
3527: PROCEDURE option_to_date_le_from_date (
3528: p_line_id_tbl IN PO_TBL_NUMBER
3529: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3530: ,p_option_from_date_tbl IN PO_TBL_DATE
3531: ,p_option_to_Date_tbl IN PO_TBL_DATE
3532: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 3589: p_line_id_tbl IN PO_TBL_NUMBER

3585: RAISE;
3586: END option_to_date_le_from_date;
3587:
3588: PROCEDURE option_from_date_le_sysdate (
3589: p_line_id_tbl IN PO_TBL_NUMBER
3590: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3591: ,p_option_from_date_tbl IN PO_TBL_DATE
3592: , p_draft_id_tbl IN PO_TBL_NUMBER
3593: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 3592: , p_draft_id_tbl IN PO_TBL_NUMBER

3588: PROCEDURE option_from_date_le_sysdate (
3589: p_line_id_tbl IN PO_TBL_NUMBER
3590: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3591: ,p_option_from_date_tbl IN PO_TBL_DATE
3592: , p_draft_id_tbl IN PO_TBL_NUMBER
3593: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3594: , x_result_type OUT NOCOPY VARCHAR2
3595: )
3596: IS

Line 3673: p_line_id_tbl IN PO_TBL_NUMBER

3669:
3670: END option_from_date_le_sysdate;
3671:
3672: PROCEDURE option_fm_date_le_ex_date (
3673: p_line_id_tbl IN PO_TBL_NUMBER
3674: , p_exer_flag_tbl IN PO_TBL_VARCHAR1
3675: , p_option_from_date_tbl IN PO_TBL_DATE
3676: , p_option_exer_date_tbl IN PO_TBL_DATE
3677: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 3734: p_line_id_tbl IN PO_TBL_NUMBER

3730: RAISE;
3731: END option_fm_date_le_ex_date;
3732:
3733: PROCEDURE line_num_disp_check (
3734: p_line_id_tbl IN PO_TBL_NUMBER
3735: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
3736: , p_group_line_id_tbl IN PO_TBL_NUMBER
3737: , p_clm_exhibit_name_tbl IN PO_TBL_VARCHAR20
3738: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 3736: , p_group_line_id_tbl IN PO_TBL_NUMBER

3732:
3733: PROCEDURE line_num_disp_check (
3734: p_line_id_tbl IN PO_TBL_NUMBER
3735: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
3736: , p_group_line_id_tbl IN PO_TBL_NUMBER
3737: , p_clm_exhibit_name_tbl IN PO_TBL_VARCHAR20
3738: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3739: , x_result_type OUT NOCOPY VARCHAR2
3740: )is

Line 3865: p_line_id_tbl IN PO_TBL_NUMBER

3861:
3862: END line_num_disp_check;
3863:
3864: PROCEDURE mod_no_cancel_shp_complt(
3865: p_line_id_tbl IN PO_TBL_NUMBER
3866: ,p_control_action_tbl IN PO_TBL_VARCHAR30
3867: ,x_result_set_id IN OUT NOCOPY NUMBER
3868: ,x_result_type OUT NOCOPY VARCHAR2
3869: )

Line 3935: p_header_id_tbl IN PO_TBL_NUMBER,

3931: -- 2. SLIN numbers are in sync with CLIN numbers.
3932: -- NOTE: The logic has been copied from PO_VALIDATION_HELPER.child_num_unique.
3933: -------------------------------------------------------------------------------
3934: PROCEDURE clin_slin_num_check(
3935: p_header_id_tbl IN PO_TBL_NUMBER,
3936: p_draft_id_tbl IN PO_TBL_NUMBER,
3937: p_line_id_tbl IN PO_TBL_NUMBER,
3938: p_group_line_id_tbl IN PO_TBL_NUMBER,
3939: p_line_num_display_tbl IN PO_TBL_VARCHAR100,

Line 3936: p_draft_id_tbl IN PO_TBL_NUMBER,

3932: -- NOTE: The logic has been copied from PO_VALIDATION_HELPER.child_num_unique.
3933: -------------------------------------------------------------------------------
3934: PROCEDURE clin_slin_num_check(
3935: p_header_id_tbl IN PO_TBL_NUMBER,
3936: p_draft_id_tbl IN PO_TBL_NUMBER,
3937: p_line_id_tbl IN PO_TBL_NUMBER,
3938: p_group_line_id_tbl IN PO_TBL_NUMBER,
3939: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
3940: p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL, --

Line 3937: p_line_id_tbl IN PO_TBL_NUMBER,

3933: -------------------------------------------------------------------------------
3934: PROCEDURE clin_slin_num_check(
3935: p_header_id_tbl IN PO_TBL_NUMBER,
3936: p_draft_id_tbl IN PO_TBL_NUMBER,
3937: p_line_id_tbl IN PO_TBL_NUMBER,
3938: p_group_line_id_tbl IN PO_TBL_NUMBER,
3939: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
3940: p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL, --
3941: x_result_set_id IN OUT NOCOPY NUMBER,

Line 3938: p_group_line_id_tbl IN PO_TBL_NUMBER,

3934: PROCEDURE clin_slin_num_check(
3935: p_header_id_tbl IN PO_TBL_NUMBER,
3936: p_draft_id_tbl IN PO_TBL_NUMBER,
3937: p_line_id_tbl IN PO_TBL_NUMBER,
3938: p_group_line_id_tbl IN PO_TBL_NUMBER,
3939: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
3940: p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL, --
3941: x_result_set_id IN OUT NOCOPY NUMBER,
3942: x_result_type OUT NOCOPY VARCHAR2

Line 3945: l_parent_id_tbl PO_TBL_NUMBER;

3941: x_result_set_id IN OUT NOCOPY NUMBER,
3942: x_result_type OUT NOCOPY VARCHAR2
3943: )
3944: IS
3945: l_parent_id_tbl PO_TBL_NUMBER;
3946: l_data_key NUMBER;
3947: d_mod CONSTANT VARCHAR2(100) := D_clin_slin_num_check;
3948: l_par_draft_id_tbl po_tbl_number;
3949: BEGIN

Line 3948: l_par_draft_id_tbl po_tbl_number;

3944: IS
3945: l_parent_id_tbl PO_TBL_NUMBER;
3946: l_data_key NUMBER;
3947: d_mod CONSTANT VARCHAR2(100) := D_clin_slin_num_check;
3948: l_par_draft_id_tbl po_tbl_number;
3949: BEGIN
3950: --
3951: -- skip the validation for non-CLM documents
3952: IF NOT PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 3967: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_header_id_tbl;

3963: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
3964: END IF;
3965:
3966: -- Get a distinct list of parent ids.
3967: l_parent_id_tbl := PO_TBL_NUMBER() MULTISET UNION DISTINCT p_header_id_tbl;
3968: l_data_key := PO_CORE_S.get_session_gt_nextval();
3969:
3970: FOR i IN 1 .. l_parent_id_tbl.COUNT LOOP
3971: -- Extract Par Line ids of this line

Line 4112: p_line_id_tbl IN PO_TBL_NUMBER,

4108: -- 2. Priced SLIN under a priced CLIN is not allowed.
4109: -------------------------------------------------------------------------------
4110:
4111: PROCEDURE clin_slin_structure(
4112: p_line_id_tbl IN PO_TBL_NUMBER,
4113: --p_draft_id_tbl IN PO_TBL_NUMBER,
4114: p_intf_line_id_tbl IN PO_TBL_NUMBER,
4115: p_group_line_id_tbl IN PO_TBL_NUMBER,
4116: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 4113: --p_draft_id_tbl IN PO_TBL_NUMBER,

4109: -------------------------------------------------------------------------------
4110:
4111: PROCEDURE clin_slin_structure(
4112: p_line_id_tbl IN PO_TBL_NUMBER,
4113: --p_draft_id_tbl IN PO_TBL_NUMBER,
4114: p_intf_line_id_tbl IN PO_TBL_NUMBER,
4115: p_group_line_id_tbl IN PO_TBL_NUMBER,
4116: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
4117: x_result_type OUT NOCOPY VARCHAR2

Line 4114: p_intf_line_id_tbl IN PO_TBL_NUMBER,

4110:
4111: PROCEDURE clin_slin_structure(
4112: p_line_id_tbl IN PO_TBL_NUMBER,
4113: --p_draft_id_tbl IN PO_TBL_NUMBER,
4114: p_intf_line_id_tbl IN PO_TBL_NUMBER,
4115: p_group_line_id_tbl IN PO_TBL_NUMBER,
4116: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
4117: x_result_type OUT NOCOPY VARCHAR2
4118: )

Line 4115: p_group_line_id_tbl IN PO_TBL_NUMBER,

4111: PROCEDURE clin_slin_structure(
4112: p_line_id_tbl IN PO_TBL_NUMBER,
4113: --p_draft_id_tbl IN PO_TBL_NUMBER,
4114: p_intf_line_id_tbl IN PO_TBL_NUMBER,
4115: p_group_line_id_tbl IN PO_TBL_NUMBER,
4116: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
4117: x_result_type OUT NOCOPY VARCHAR2
4118: )
4119: IS

Line 4193: p_intf_line_id_tbl IN PO_TBL_NUMBER

4189:
4190:
4191:
4192: PROCEDURE validate_contract_type(
4193: p_intf_line_id_tbl IN PO_TBL_NUMBER
4194: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
4195: , p_contract_type_tbl IN PO_TBL_VARCHAR240
4196: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4197: , x_result_type OUT NOCOPY VARCHAR2

Line 4282: p_intf_line_id_tbl IN PO_TBL_NUMBER

4278:
4279:
4280:
4281: PROCEDURE validate_cost_constraint(
4282: p_intf_line_id_tbl IN PO_TBL_NUMBER
4283: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
4284: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4285: , x_result_type OUT NOCOPY VARCHAR2
4286: ) IS

Line 4354: p_intf_line_id_tbl IN PO_TBL_NUMBER

4350: END validate_cost_constraint;
4351:
4352:
4353: PROCEDURE check_contract_num_and_ver(
4354: p_intf_line_id_tbl IN PO_TBL_NUMBER
4355: , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER
4356: , p_oke_contract_header_num_tbl IN PO_TBL_VARCHAR240
4357: , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER
4358: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 4355: , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER

4351:
4352:
4353: PROCEDURE check_contract_num_and_ver(
4354: p_intf_line_id_tbl IN PO_TBL_NUMBER
4355: , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER
4356: , p_oke_contract_header_num_tbl IN PO_TBL_VARCHAR240
4357: , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER
4358: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4359: , x_result_type OUT NOCOPY VARCHAR2

Line 4357: , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER

4353: PROCEDURE check_contract_num_and_ver(
4354: p_intf_line_id_tbl IN PO_TBL_NUMBER
4355: , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER
4356: , p_oke_contract_header_num_tbl IN PO_TBL_VARCHAR240
4357: , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER
4358: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4359: , x_result_type OUT NOCOPY VARCHAR2
4360: ) IS
4361:

Line 4460: p_intf_line_id_tbl IN PO_TBL_NUMBER

4456:
4457:
4458:
4459: PROCEDURE validate_option_indicator(
4460: p_intf_line_id_tbl IN PO_TBL_NUMBER
4461: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4462: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4463: , x_result_type OUT NOCOPY VARCHAR2
4464: ) IS

Line 4525: p_intf_line_id_tbl IN PO_TBL_NUMBER

4521: END validate_option_indicator;
4522:
4523:
4524: PROCEDURE validate_clm_base_line_num(
4525: p_intf_line_id_tbl IN PO_TBL_NUMBER
4526: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4527: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
4528: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4529: , x_result_type OUT NOCOPY VARCHAR2

Line 4527: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER

4523:
4524: PROCEDURE validate_clm_base_line_num(
4525: p_intf_line_id_tbl IN PO_TBL_NUMBER
4526: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4527: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
4528: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4529: , x_result_type OUT NOCOPY VARCHAR2
4530: ) IS
4531:

Line 4628: p_intf_line_id_tbl IN PO_TBL_NUMBER

4624:
4625:
4626:
4627: PROCEDURE validate_clm_option_num(
4628: p_intf_line_id_tbl IN PO_TBL_NUMBER
4629: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4630: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
4631: , p_clm_option_num_tbl IN PO_TBL_NUMBER
4632: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 4630: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER

4626:
4627: PROCEDURE validate_clm_option_num(
4628: p_intf_line_id_tbl IN PO_TBL_NUMBER
4629: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4630: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
4631: , p_clm_option_num_tbl IN PO_TBL_NUMBER
4632: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4633: , x_result_type OUT NOCOPY VARCHAR2
4634: ) IS

Line 4631: , p_clm_option_num_tbl IN PO_TBL_NUMBER

4627: PROCEDURE validate_clm_option_num(
4628: p_intf_line_id_tbl IN PO_TBL_NUMBER
4629: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4630: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
4631: , p_clm_option_num_tbl IN PO_TBL_NUMBER
4632: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4633: , x_result_type OUT NOCOPY VARCHAR2
4634: ) IS
4635:

Line 4724: p_intf_line_id_tbl IN PO_TBL_NUMBER

4720:
4721:
4722:
4723: PROCEDURE validate_clm_idc_type(
4724: p_intf_line_id_tbl IN PO_TBL_NUMBER
4725: , p_clm_idc_type_tbl IN PO_TBL_VARCHAR240
4726: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4727: , x_result_type OUT NOCOPY VARCHAR2
4728: ) IS

Line 4797: p_intf_line_id_tbl IN PO_TBL_NUMBER

4793: END validate_clm_idc_type;
4794:
4795:
4796: PROCEDURE validate_clin_line_num_disp(
4797: p_intf_line_id_tbl IN PO_TBL_NUMBER
4798: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
4799: , p_group_line_id_tbl IN PO_TBL_NUMBER
4800: , p_intf_header_id_tbl IN PO_TBL_NUMBER
4801: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 4799: , p_group_line_id_tbl IN PO_TBL_NUMBER

4795:
4796: PROCEDURE validate_clin_line_num_disp(
4797: p_intf_line_id_tbl IN PO_TBL_NUMBER
4798: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
4799: , p_group_line_id_tbl IN PO_TBL_NUMBER
4800: , p_intf_header_id_tbl IN PO_TBL_NUMBER
4801: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4802: , x_result_type OUT NOCOPY VARCHAR2
4803: ) IS

Line 4800: , p_intf_header_id_tbl IN PO_TBL_NUMBER

4796: PROCEDURE validate_clin_line_num_disp(
4797: p_intf_line_id_tbl IN PO_TBL_NUMBER
4798: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
4799: , p_group_line_id_tbl IN PO_TBL_NUMBER
4800: , p_intf_header_id_tbl IN PO_TBL_NUMBER
4801: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4802: , x_result_type OUT NOCOPY VARCHAR2
4803: ) IS
4804:

Line 4881: p_intf_line_id_tbl IN PO_TBL_NUMBER

4877: END validate_clin_line_num_disp;
4878:
4879:
4880: PROCEDURE idv_reference_equal_check(
4881: p_intf_line_id_tbl IN PO_TBL_NUMBER
4882: , p_from_header_id_tbl IN PO_TBL_NUMBER
4883: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4884: , x_result_type OUT NOCOPY VARCHAR2
4885: ) IS

Line 4882: , p_from_header_id_tbl IN PO_TBL_NUMBER

4878:
4879:
4880: PROCEDURE idv_reference_equal_check(
4881: p_intf_line_id_tbl IN PO_TBL_NUMBER
4882: , p_from_header_id_tbl IN PO_TBL_NUMBER
4883: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4884: , x_result_type OUT NOCOPY VARCHAR2
4885: ) IS
4886:

Line 4890: l_intf_line_id_tbl PO_TBL_NUMBER;

4886:
4887: d_mod CONSTANT VARCHAR2(100) := D_idv_reference_equal_check;
4888: l_results_count NUMBER := 0;
4889: l_line_count NUMBER := 0;
4890: l_intf_line_id_tbl PO_TBL_NUMBER;
4891: l_data_key NUMBER;
4892: BEGIN
4893:
4894: IF PO_LOG.d_proc THEN

Line 4955: p_intf_line_id_tbl IN PO_TBL_NUMBER

4951:
4952:
4953:
4954: PROCEDURE validate_clm_line_type_id(
4955: p_intf_line_id_tbl IN PO_TBL_NUMBER
4956: , p_line_type_id_tbl IN PO_TBL_NUMBER
4957: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4958: , x_result_type OUT NOCOPY VARCHAR2
4959: ) IS

Line 4956: , p_line_type_id_tbl IN PO_TBL_NUMBER

4952:
4953:
4954: PROCEDURE validate_clm_line_type_id(
4955: p_intf_line_id_tbl IN PO_TBL_NUMBER
4956: , p_line_type_id_tbl IN PO_TBL_NUMBER
4957: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4958: , x_result_type OUT NOCOPY VARCHAR2
4959: ) IS
4960:

Line 4964: l_intf_line_id_tbl PO_TBL_NUMBER;

4960:
4961: d_mod CONSTANT VARCHAR2(100) := D_validate_clm_line_type_id;
4962: l_results_count NUMBER := 0;
4963: l_line_count NUMBER := 0;
4964: l_intf_line_id_tbl PO_TBL_NUMBER;
4965: l_data_key NUMBER;
4966: BEGIN
4967: IF PO_LOG.d_proc THEN
4968: PO_LOG.proc_begin(d_mod,'p_intf_line_id_tbl',p_intf_line_id_tbl);

Line 5048: p_line_id_tbl IN PO_TBL_NUMBER

5044: --Testing:
5045: --End of Comments
5046: ------------------------------------------------------------------------
5047: PROCEDURE validate_comments_not_null(
5048: p_line_id_tbl IN PO_TBL_NUMBER
5049: , p_draft_id_tbl IN PO_TBL_NUMBER
5050: , p_draft_type_tbl IN PO_TBL_VARCHAR30
5051: , p_comments_tbl IN PO_TBL_VARCHAR2000
5052: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 5049: , p_draft_id_tbl IN PO_TBL_NUMBER

5045: --End of Comments
5046: ------------------------------------------------------------------------
5047: PROCEDURE validate_comments_not_null(
5048: p_line_id_tbl IN PO_TBL_NUMBER
5049: , p_draft_id_tbl IN PO_TBL_NUMBER
5050: , p_draft_type_tbl IN PO_TBL_VARCHAR30
5051: , p_comments_tbl IN PO_TBL_VARCHAR2000
5052: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
5053: , x_result_type OUT NOCOPY VARCHAR2

Line 5111: p_header_id_tbl IN PO_TBL_NUMBER,

5107: -- 1. Exhibit name is a valid name from the available lookups.
5108: -- 2. Exhibit should not have been used for CDRL for this document.
5109: -------------------------------------------------------------------------------
5110: PROCEDURE validate_exhibit_name(
5111: p_header_id_tbl IN PO_TBL_NUMBER,
5112: p_draft_id_tbl IN PO_TBL_NUMBER,
5113: p_line_id_tbl IN PO_TBL_NUMBER,
5114: p_exhibit_name_tbl IN PO_TBL_VARCHAR20,
5115: x_result_set_id IN OUT NOCOPY NUMBER,

Line 5112: p_draft_id_tbl IN PO_TBL_NUMBER,

5108: -- 2. Exhibit should not have been used for CDRL for this document.
5109: -------------------------------------------------------------------------------
5110: PROCEDURE validate_exhibit_name(
5111: p_header_id_tbl IN PO_TBL_NUMBER,
5112: p_draft_id_tbl IN PO_TBL_NUMBER,
5113: p_line_id_tbl IN PO_TBL_NUMBER,
5114: p_exhibit_name_tbl IN PO_TBL_VARCHAR20,
5115: x_result_set_id IN OUT NOCOPY NUMBER,
5116: x_result_type OUT NOCOPY VARCHAR2

Line 5113: p_line_id_tbl IN PO_TBL_NUMBER,

5109: -------------------------------------------------------------------------------
5110: PROCEDURE validate_exhibit_name(
5111: p_header_id_tbl IN PO_TBL_NUMBER,
5112: p_draft_id_tbl IN PO_TBL_NUMBER,
5113: p_line_id_tbl IN PO_TBL_NUMBER,
5114: p_exhibit_name_tbl IN PO_TBL_VARCHAR20,
5115: x_result_set_id IN OUT NOCOPY NUMBER,
5116: x_result_type OUT NOCOPY VARCHAR2
5117: )

Line 5190: p_po_line_id IN PO_TBL_NUMBER,

5186:
5187: END validate_exhibit_name;
5188: -- bug 16461105
5189: PROCEDURE validate_undef_amt_le_line_amt(
5190: p_po_line_id IN PO_TBL_NUMBER,
5191: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
5192: p_unit_price IN PO_TBL_NUMBER,
5193: p_quantity IN PO_TBL_NUMBER,
5194: p_old_quantity IN PO_TBL_NUMBER,

Line 5192: p_unit_price IN PO_TBL_NUMBER,

5188: -- bug 16461105
5189: PROCEDURE validate_undef_amt_le_line_amt(
5190: p_po_line_id IN PO_TBL_NUMBER,
5191: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
5192: p_unit_price IN PO_TBL_NUMBER,
5193: p_quantity IN PO_TBL_NUMBER,
5194: p_old_quantity IN PO_TBL_NUMBER,
5195: p_old_unit_price IN PO_TBL_NUMBER,
5196: p_draft_id IN PO_TBL_NUMBER,

Line 5193: p_quantity IN PO_TBL_NUMBER,

5189: PROCEDURE validate_undef_amt_le_line_amt(
5190: p_po_line_id IN PO_TBL_NUMBER,
5191: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
5192: p_unit_price IN PO_TBL_NUMBER,
5193: p_quantity IN PO_TBL_NUMBER,
5194: p_old_quantity IN PO_TBL_NUMBER,
5195: p_old_unit_price IN PO_TBL_NUMBER,
5196: p_draft_id IN PO_TBL_NUMBER,
5197: p_undef_amount IN PO_TBL_NUMBER,

Line 5194: p_old_quantity IN PO_TBL_NUMBER,

5190: p_po_line_id IN PO_TBL_NUMBER,
5191: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
5192: p_unit_price IN PO_TBL_NUMBER,
5193: p_quantity IN PO_TBL_NUMBER,
5194: p_old_quantity IN PO_TBL_NUMBER,
5195: p_old_unit_price IN PO_TBL_NUMBER,
5196: p_draft_id IN PO_TBL_NUMBER,
5197: p_undef_amount IN PO_TBL_NUMBER,
5198: p_po_line_uca_id IN PO_TBL_NUMBER,

Line 5195: p_old_unit_price IN PO_TBL_NUMBER,

5191: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
5192: p_unit_price IN PO_TBL_NUMBER,
5193: p_quantity IN PO_TBL_NUMBER,
5194: p_old_quantity IN PO_TBL_NUMBER,
5195: p_old_unit_price IN PO_TBL_NUMBER,
5196: p_draft_id IN PO_TBL_NUMBER,
5197: p_undef_amount IN PO_TBL_NUMBER,
5198: p_po_line_uca_id IN PO_TBL_NUMBER,
5199: p_ucas_po_line_id IN PO_TBL_NUMBER,

Line 5196: p_draft_id IN PO_TBL_NUMBER,

5192: p_unit_price IN PO_TBL_NUMBER,
5193: p_quantity IN PO_TBL_NUMBER,
5194: p_old_quantity IN PO_TBL_NUMBER,
5195: p_old_unit_price IN PO_TBL_NUMBER,
5196: p_draft_id IN PO_TBL_NUMBER,
5197: p_undef_amount IN PO_TBL_NUMBER,
5198: p_po_line_uca_id IN PO_TBL_NUMBER,
5199: p_ucas_po_line_id IN PO_TBL_NUMBER,
5200: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,

Line 5197: p_undef_amount IN PO_TBL_NUMBER,

5193: p_quantity IN PO_TBL_NUMBER,
5194: p_old_quantity IN PO_TBL_NUMBER,
5195: p_old_unit_price IN PO_TBL_NUMBER,
5196: p_draft_id IN PO_TBL_NUMBER,
5197: p_undef_amount IN PO_TBL_NUMBER,
5198: p_po_line_uca_id IN PO_TBL_NUMBER,
5199: p_ucas_po_line_id IN PO_TBL_NUMBER,
5200: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,
5201: x_result_type OUT nocopy VARCHAR2)

Line 5198: p_po_line_uca_id IN PO_TBL_NUMBER,

5194: p_old_quantity IN PO_TBL_NUMBER,
5195: p_old_unit_price IN PO_TBL_NUMBER,
5196: p_draft_id IN PO_TBL_NUMBER,
5197: p_undef_amount IN PO_TBL_NUMBER,
5198: p_po_line_uca_id IN PO_TBL_NUMBER,
5199: p_ucas_po_line_id IN PO_TBL_NUMBER,
5200: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,
5201: x_result_type OUT nocopy VARCHAR2)
5202:

Line 5199: p_ucas_po_line_id IN PO_TBL_NUMBER,

5195: p_old_unit_price IN PO_TBL_NUMBER,
5196: p_draft_id IN PO_TBL_NUMBER,
5197: p_undef_amount IN PO_TBL_NUMBER,
5198: p_po_line_uca_id IN PO_TBL_NUMBER,
5199: p_ucas_po_line_id IN PO_TBL_NUMBER,
5200: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,
5201: x_result_type OUT nocopy VARCHAR2)
5202:
5203: IS

Line 5205: l_undef_amt_tbl po_tbl_number;

5201: x_result_type OUT nocopy VARCHAR2)
5202:
5203: IS
5204: d_mod CONSTANT VARCHAR2(100) := D_mod_undef_amt_le_line_amt;
5205: l_undef_amt_tbl po_tbl_number;
5206: l_extended_price_tbl po_tbl_number;
5207: l_po_line_uca_id_tbl po_tbl_number;
5208: l_po_draft_id_tbl po_tbl_number; --bug 16385613
5209: l_results_count NUMBER; -- bug 16759650

Line 5206: l_extended_price_tbl po_tbl_number;

5202:
5203: IS
5204: d_mod CONSTANT VARCHAR2(100) := D_mod_undef_amt_le_line_amt;
5205: l_undef_amt_tbl po_tbl_number;
5206: l_extended_price_tbl po_tbl_number;
5207: l_po_line_uca_id_tbl po_tbl_number;
5208: l_po_draft_id_tbl po_tbl_number; --bug 16385613
5209: l_results_count NUMBER; -- bug 16759650
5210: BEGIN

Line 5207: l_po_line_uca_id_tbl po_tbl_number;

5203: IS
5204: d_mod CONSTANT VARCHAR2(100) := D_mod_undef_amt_le_line_amt;
5205: l_undef_amt_tbl po_tbl_number;
5206: l_extended_price_tbl po_tbl_number;
5207: l_po_line_uca_id_tbl po_tbl_number;
5208: l_po_draft_id_tbl po_tbl_number; --bug 16385613
5209: l_results_count NUMBER; -- bug 16759650
5210: BEGIN
5211:

Line 5208: l_po_draft_id_tbl po_tbl_number; --bug 16385613

5204: d_mod CONSTANT VARCHAR2(100) := D_mod_undef_amt_le_line_amt;
5205: l_undef_amt_tbl po_tbl_number;
5206: l_extended_price_tbl po_tbl_number;
5207: l_po_line_uca_id_tbl po_tbl_number;
5208: l_po_draft_id_tbl po_tbl_number; --bug 16385613
5209: l_results_count NUMBER; -- bug 16759650
5210: BEGIN
5211:
5212: IF PO_LOG.d_proc THEN