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 171: p_line_id_tbl IN PO_TBL_NUMBER

167: -- This procedure determines if Amount Agreed on blanket lines is greater
168: -- than or equal to zero. If not, return a failure.
169: -------------------------------------------------------------------------------
170: PROCEDURE amt_agreed_ge_zero(
171: p_line_id_tbl IN PO_TBL_NUMBER
172: , p_committed_amount_tbl IN PO_TBL_NUMBER
173: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
174: , x_result_type OUT NOCOPY VARCHAR2
175: )

Line 172: , p_committed_amount_tbl IN PO_TBL_NUMBER

168: -- than or equal to zero. If not, return a failure.
169: -------------------------------------------------------------------------------
170: PROCEDURE amt_agreed_ge_zero(
171: p_line_id_tbl IN PO_TBL_NUMBER
172: , p_committed_amount_tbl IN PO_TBL_NUMBER
173: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
174: , x_result_type OUT NOCOPY VARCHAR2
175: )
176: IS

Line 198: p_line_id_tbl IN PO_TBL_NUMBER

194: -- This procedure determines if Minimum Release Amount on blanket lines
195: -- is greater than or equal to zero. If not, return a failure.
196: -------------------------------------------------------------------------------
197: PROCEDURE min_rel_amt_ge_zero(
198: p_line_id_tbl IN PO_TBL_NUMBER
199: , p_min_release_amount_tbl IN PO_TBL_NUMBER
200: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
201: , x_result_type OUT NOCOPY VARCHAR2
202: )

Line 199: , p_min_release_amount_tbl IN PO_TBL_NUMBER

195: -- is greater than or equal to zero. If not, return a failure.
196: -------------------------------------------------------------------------------
197: PROCEDURE min_rel_amt_ge_zero(
198: p_line_id_tbl IN PO_TBL_NUMBER
199: , p_min_release_amount_tbl IN PO_TBL_NUMBER
200: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
201: , x_result_type OUT NOCOPY VARCHAR2
202: )
203: IS

Line 225: p_line_id_tbl IN PO_TBL_NUMBER

221: -- Validates that quantity is not null and greater than zero if it is not
222: -- a Rate or Fixed Price line.
223: -----------------------------------------------------------------------------
224: PROCEDURE quantity_gt_zero(
225: p_line_id_tbl IN PO_TBL_NUMBER
226: , p_quantity_tbl IN PO_TBL_NUMBER
227: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
228: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
229: , x_result_type OUT NOCOPY VARCHAR2

Line 226: , p_quantity_tbl IN PO_TBL_NUMBER

222: -- a Rate or Fixed Price line.
223: -----------------------------------------------------------------------------
224: PROCEDURE quantity_gt_zero(
225: p_line_id_tbl IN PO_TBL_NUMBER
226: , p_quantity_tbl IN PO_TBL_NUMBER
227: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
228: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
229: , x_result_type OUT NOCOPY VARCHAR2
230: )

Line 262: p_line_id_tbl IN PO_TBL_NUMBER

258: -- current transaction quantity, since over-receiving is allowed.
259: -- : Ignore qty milestones (there are other checks for those)
260: -----------------------------------------------------------------------------
261: PROCEDURE quantity_ge_quantity_exec(
262: p_line_id_tbl IN PO_TBL_NUMBER
263: , p_quantity_tbl IN PO_TBL_NUMBER
264: , x_result_set_id IN OUT NOCOPY NUMBER
265: , x_result_type OUT NOCOPY VARCHAR2
266: )

Line 263: , p_quantity_tbl IN PO_TBL_NUMBER

259: -- : Ignore qty milestones (there are other checks for those)
260: -----------------------------------------------------------------------------
261: PROCEDURE quantity_ge_quantity_exec(
262: p_line_id_tbl IN PO_TBL_NUMBER
263: , p_quantity_tbl IN PO_TBL_NUMBER
264: , x_result_set_id IN OUT NOCOPY NUMBER
265: , x_result_type OUT NOCOPY VARCHAR2
266: )
267: IS

Line 371: p_line_id_tbl IN PO_TBL_NUMBER

367:
368: -- Bug 5070210 Start
369: -- Bug 5446881: If the amount is null, we need to check against price * quantity
370: PROCEDURE advance_amt_le_amt(
371: p_line_id_tbl IN PO_TBL_NUMBER
372: , p_advance_tbl IN PO_TBL_NUMBER
373: , p_amount_tbl IN PO_TBL_NUMBER
374: , p_quantity_tbl IN PO_TBL_NUMBER
375: , p_price_tbl IN PO_TBL_NUMBER

Line 372: , p_advance_tbl IN PO_TBL_NUMBER

368: -- Bug 5070210 Start
369: -- Bug 5446881: If the amount is null, we need to check against price * quantity
370: PROCEDURE advance_amt_le_amt(
371: p_line_id_tbl IN PO_TBL_NUMBER
372: , p_advance_tbl IN PO_TBL_NUMBER
373: , p_amount_tbl IN PO_TBL_NUMBER
374: , p_quantity_tbl IN PO_TBL_NUMBER
375: , p_price_tbl IN PO_TBL_NUMBER
376: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 373: , p_amount_tbl IN PO_TBL_NUMBER

369: -- Bug 5446881: If the amount is null, we need to check against price * quantity
370: PROCEDURE advance_amt_le_amt(
371: p_line_id_tbl IN PO_TBL_NUMBER
372: , p_advance_tbl IN PO_TBL_NUMBER
373: , p_amount_tbl IN PO_TBL_NUMBER
374: , p_quantity_tbl IN PO_TBL_NUMBER
375: , p_price_tbl IN PO_TBL_NUMBER
376: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
377: , x_result_type OUT NOCOPY VARCHAR2

Line 374: , p_quantity_tbl IN PO_TBL_NUMBER

370: PROCEDURE advance_amt_le_amt(
371: p_line_id_tbl IN PO_TBL_NUMBER
372: , p_advance_tbl IN PO_TBL_NUMBER
373: , p_amount_tbl IN PO_TBL_NUMBER
374: , p_quantity_tbl IN PO_TBL_NUMBER
375: , p_price_tbl IN PO_TBL_NUMBER
376: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
377: , x_result_type OUT NOCOPY VARCHAR2
378: )

Line 375: , p_price_tbl IN PO_TBL_NUMBER

371: p_line_id_tbl IN PO_TBL_NUMBER
372: , p_advance_tbl IN PO_TBL_NUMBER
373: , p_amount_tbl IN PO_TBL_NUMBER
374: , p_quantity_tbl IN PO_TBL_NUMBER
375: , p_price_tbl IN PO_TBL_NUMBER
376: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
377: , x_result_type OUT NOCOPY VARCHAR2
378: )
379: IS

Line 429: p_line_id_tbl IN PO_TBL_NUMBER

425: -----------------------------------------------------------------------------
426: -- Validates that quantity is greater than or equal to quantity encumbered.
427: -----------------------------------------------------------------------------
428: PROCEDURE quantity_ge_quantity_enc(
429: p_line_id_tbl IN PO_TBL_NUMBER
430: , p_quantity_tbl IN PO_TBL_NUMBER
431: , x_result_set_id IN OUT NOCOPY NUMBER
432: , x_result_type OUT NOCOPY VARCHAR2
433: )

Line 430: , p_quantity_tbl IN PO_TBL_NUMBER

426: -- Validates that quantity is greater than or equal to quantity encumbered.
427: -----------------------------------------------------------------------------
428: PROCEDURE quantity_ge_quantity_enc(
429: p_line_id_tbl IN PO_TBL_NUMBER
430: , p_quantity_tbl IN PO_TBL_NUMBER
431: , x_result_set_id IN OUT NOCOPY NUMBER
432: , x_result_type OUT NOCOPY VARCHAR2
433: )
434: IS

Line 514: p_line_id_tbl IN PO_TBL_NUMBER

510: -- Shows a warning if quantity is changed and notification controls
511: -- are enabled.
512: -----------------------------------------------------------------------------
513: PROCEDURE quantity_notif_change(
514: p_line_id_tbl IN PO_TBL_NUMBER
515: , p_quantity_tbl IN PO_TBL_NUMBER
516: , x_result_set_id IN OUT NOCOPY NUMBER
517: , x_result_type OUT NOCOPY VARCHAR2
518: )

Line 515: , p_quantity_tbl IN PO_TBL_NUMBER

511: -- are enabled.
512: -----------------------------------------------------------------------------
513: PROCEDURE quantity_notif_change(
514: p_line_id_tbl IN PO_TBL_NUMBER
515: , p_quantity_tbl IN PO_TBL_NUMBER
516: , x_result_set_id IN OUT NOCOPY NUMBER
517: , x_result_type OUT NOCOPY VARCHAR2
518: )
519: IS

Line 540: p_line_id_tbl IN PO_TBL_NUMBER

536: -- Validates that amount is not null and greater than zero if the line is
537: -- Rate or Fixed Price.
538: -----------------------------------------------------------------------------
539: PROCEDURE amount_gt_zero(
540: p_line_id_tbl IN PO_TBL_NUMBER
541: , p_amount_tbl IN PO_TBL_NUMBER
542: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
543: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
544: , x_result_type OUT NOCOPY VARCHAR2

Line 541: , p_amount_tbl IN PO_TBL_NUMBER

537: -- Rate or Fixed Price.
538: -----------------------------------------------------------------------------
539: PROCEDURE amount_gt_zero(
540: p_line_id_tbl IN PO_TBL_NUMBER
541: , p_amount_tbl IN PO_TBL_NUMBER
542: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
543: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
544: , x_result_type OUT NOCOPY VARCHAR2
545: )

Line 577: p_line_id_tbl IN PO_TBL_NUMBER

573: -- current transaction amount, since over-receiving is allowed.
574: -- : Handle differing value bases and payment types
575: -----------------------------------------------------------------------------
576: PROCEDURE amount_ge_amount_exec(
577: p_line_id_tbl IN PO_TBL_NUMBER
578: , p_amount_tbl IN PO_TBL_NUMBER
579: , p_currency_code_tbl IN PO_TBL_VARCHAR30
580: , x_result_set_id IN OUT NOCOPY NUMBER
581: , x_result_type OUT NOCOPY VARCHAR2

Line 578: , p_amount_tbl IN PO_TBL_NUMBER

574: -- : Handle differing value bases and payment types
575: -----------------------------------------------------------------------------
576: PROCEDURE amount_ge_amount_exec(
577: p_line_id_tbl IN PO_TBL_NUMBER
578: , p_amount_tbl IN PO_TBL_NUMBER
579: , p_currency_code_tbl IN PO_TBL_VARCHAR30
580: , x_result_set_id IN OUT NOCOPY NUMBER
581: , x_result_type OUT NOCOPY VARCHAR2
582: )

Line 771: p_line_id_tbl IN PO_TBL_NUMBER

767: -- This check is only performed if amount is being reduced below the
768: -- current transaction amount.
769: -----------------------------------------------------------------------------
770: PROCEDURE amount_ge_timecard(
771: p_line_id_tbl IN PO_TBL_NUMBER
772: , p_amount_tbl IN PO_TBL_NUMBER
773: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
774: , x_result_type OUT NOCOPY VARCHAR2
775: )

Line 772: , p_amount_tbl IN PO_TBL_NUMBER

768: -- current transaction amount.
769: -----------------------------------------------------------------------------
770: PROCEDURE amount_ge_timecard(
771: p_line_id_tbl IN PO_TBL_NUMBER
772: , p_amount_tbl IN PO_TBL_NUMBER
773: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
774: , x_result_type OUT NOCOPY VARCHAR2
775: )
776: IS

Line 782: l_line_id_tbl PO_TBL_NUMBER;

778:
779: l_results_count NUMBER;
780: l_data_key NUMBER;
781:
782: l_line_id_tbl PO_TBL_NUMBER;
783: l_amount_tbl PO_TBL_NUMBER;
784:
785: l_timecard_amount_sum NUMBER;
786: l_return_status VARCHAR2(1);

Line 783: l_amount_tbl PO_TBL_NUMBER;

779: l_results_count NUMBER;
780: l_data_key NUMBER;
781:
782: l_line_id_tbl PO_TBL_NUMBER;
783: l_amount_tbl PO_TBL_NUMBER;
784:
785: l_timecard_amount_sum NUMBER;
786: l_return_status VARCHAR2(1);
787: BEGIN

Line 900: p_line_id_tbl IN PO_TBL_NUMBER

896: -- Assumption:
897: -- All of the unposted line data will be passed in
898: -- to this routine in order to get accurate results.
899: PROCEDURE line_num_unique(
900: p_line_id_tbl IN PO_TBL_NUMBER
901: , p_header_id_tbl IN PO_TBL_NUMBER
902: , p_line_num_tbl IN PO_TBL_NUMBER
903: , x_result_set_id IN OUT NOCOPY NUMBER
904: , x_result_type OUT NOCOPY VARCHAR2

Line 901: , p_header_id_tbl IN PO_TBL_NUMBER

897: -- All of the unposted line data will be passed in
898: -- to this routine in order to get accurate results.
899: PROCEDURE line_num_unique(
900: p_line_id_tbl IN PO_TBL_NUMBER
901: , p_header_id_tbl IN PO_TBL_NUMBER
902: , p_line_num_tbl IN PO_TBL_NUMBER
903: , x_result_set_id IN OUT NOCOPY NUMBER
904: , x_result_type OUT NOCOPY VARCHAR2
905: )

Line 902: , p_line_num_tbl IN PO_TBL_NUMBER

898: -- to this routine in order to get accurate results.
899: PROCEDURE line_num_unique(
900: p_line_id_tbl IN PO_TBL_NUMBER
901: , p_header_id_tbl IN PO_TBL_NUMBER
902: , p_line_num_tbl IN PO_TBL_NUMBER
903: , x_result_set_id IN OUT NOCOPY NUMBER
904: , x_result_type OUT NOCOPY VARCHAR2
905: )
906: IS

Line 926: p_line_id_tbl IN PO_TBL_NUMBER

922: -- Checks for null or non-positive line numbers.
923: -----------------------------------------------------------------------------
924:
925: PROCEDURE line_num_gt_zero(
926: p_line_id_tbl IN PO_TBL_NUMBER
927: , p_line_num_tbl IN PO_TBL_NUMBER
928: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
929: , x_result_type OUT NOCOPY VARCHAR2
930: )

Line 927: , p_line_num_tbl IN PO_TBL_NUMBER

923: -----------------------------------------------------------------------------
924:
925: PROCEDURE line_num_gt_zero(
926: p_line_id_tbl IN PO_TBL_NUMBER
927: , p_line_num_tbl IN PO_TBL_NUMBER
928: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
929: , x_result_type OUT NOCOPY VARCHAR2
930: )
931: IS

Line 958: p_line_id_tbl IN PO_TBL_NUMBER

954: --
955: -- Where clauses derived from L_ITEM_CSR in PO_AUTOSOURCE_SV.get_asl_info
956: ------------------------------------------------------------------------
957: PROCEDURE vmi_asl_exists(
958: p_line_id_tbl IN PO_TBL_NUMBER
959: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
960: , p_item_id_tbl IN PO_TBL_NUMBER
961: , p_org_id_tbl IN PO_TBL_NUMBER
962: , p_vendor_id_tbl IN PO_TBL_NUMBER

Line 960: , p_item_id_tbl IN PO_TBL_NUMBER

956: ------------------------------------------------------------------------
957: PROCEDURE vmi_asl_exists(
958: p_line_id_tbl IN PO_TBL_NUMBER
959: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
960: , p_item_id_tbl IN PO_TBL_NUMBER
961: , p_org_id_tbl IN PO_TBL_NUMBER
962: , p_vendor_id_tbl IN PO_TBL_NUMBER
963: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
964: , x_result_set_id IN OUT NOCOPY NUMBER

Line 961: , p_org_id_tbl IN PO_TBL_NUMBER

957: PROCEDURE vmi_asl_exists(
958: p_line_id_tbl IN PO_TBL_NUMBER
959: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
960: , p_item_id_tbl IN PO_TBL_NUMBER
961: , p_org_id_tbl IN PO_TBL_NUMBER
962: , p_vendor_id_tbl IN PO_TBL_NUMBER
963: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
964: , x_result_set_id IN OUT NOCOPY NUMBER
965: , x_result_type OUT NOCOPY VARCHAR2

Line 962: , p_vendor_id_tbl IN PO_TBL_NUMBER

958: p_line_id_tbl IN PO_TBL_NUMBER
959: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
960: , p_item_id_tbl IN PO_TBL_NUMBER
961: , p_org_id_tbl IN PO_TBL_NUMBER
962: , p_vendor_id_tbl IN PO_TBL_NUMBER
963: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
964: , x_result_set_id IN OUT NOCOPY NUMBER
965: , x_result_type OUT NOCOPY VARCHAR2
966: )

Line 963: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

959: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
960: , p_item_id_tbl IN PO_TBL_NUMBER
961: , p_org_id_tbl IN PO_TBL_NUMBER
962: , p_vendor_id_tbl IN PO_TBL_NUMBER
963: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
964: , x_result_set_id IN OUT NOCOPY NUMBER
965: , x_result_type OUT NOCOPY VARCHAR2
966: )
967: IS

Line 1066: p_line_id_tbl IN PO_TBL_NUMBER

1062: -- Validates that the start date is less than or equal to the end date.
1063: -- Shows error 'PO_SVC_ASSIGNMENT_DATES'.
1064: ------------------------------------------------------------------------
1065: PROCEDURE start_date_le_end_date(
1066: p_line_id_tbl IN PO_TBL_NUMBER
1067: , p_start_date_tbl IN PO_TBL_DATE
1068: , p_expiration_date_tbl IN PO_TBL_DATE
1069: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1070: , x_result_type OUT NOCOPY VARCHAR2

Line 1101: p_line_id_tbl IN PO_TBL_NUMBER

1097: -- Then throw the error 'PO_CHNG_OTL_INVALID_START_DATE'.
1098: --
1099: ------------------------------------------------------------------------
1100: PROCEDURE otl_invalid_start_date_change(
1101: p_line_id_tbl IN PO_TBL_NUMBER
1102: , p_start_date_tbl IN PO_TBL_DATE
1103: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1104: , x_result_type OUT NOCOPY VARCHAR2
1105: )

Line 1134: p_line_id_tbl IN PO_TBL_NUMBER

1130: -- Then throw the error 'PO_CHNG_OTL_INVALID_END_DATE'.
1131: --
1132: ------------------------------------------------------------------------
1133: PROCEDURE otl_invalid_end_date_change(
1134: p_line_id_tbl IN PO_TBL_NUMBER
1135: , p_expiration_date_tbl IN PO_TBL_DATE
1136: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1137: , x_result_type OUT NOCOPY VARCHAR2
1138: )

Line 1161: p_line_id_tbl IN PO_TBL_NUMBER

1157: -- Validates that the unit price is greater than or equal to zero
1158: -- for non-Fixed Price lines.
1159: -----------------------------------------------------------------------------
1160: PROCEDURE unit_price_ge_zero(
1161: p_line_id_tbl IN PO_TBL_NUMBER
1162: , p_unit_price_tbl IN PO_TBL_NUMBER
1163: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1164: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1165: , x_result_type OUT NOCOPY VARCHAR2

Line 1162: , p_unit_price_tbl IN PO_TBL_NUMBER

1158: -- for non-Fixed Price lines.
1159: -----------------------------------------------------------------------------
1160: PROCEDURE unit_price_ge_zero(
1161: p_line_id_tbl IN PO_TBL_NUMBER
1162: , p_unit_price_tbl IN PO_TBL_NUMBER
1163: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1164: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1165: , x_result_type OUT NOCOPY VARCHAR2
1166: )

Line 1170: l_line_id_tbl PO_TBL_NUMBER;

1166: )
1167: IS
1168: d_mod CONSTANT VARCHAR2(100) := D_unit_price_ge_zero;
1169:
1170: l_line_id_tbl PO_TBL_NUMBER;
1171: l_unit_price_tbl PO_TBL_NUMBER;
1172: l_input_size NUMBER;
1173: l_count NUMBER;
1174: BEGIN

Line 1171: l_unit_price_tbl PO_TBL_NUMBER;

1167: IS
1168: d_mod CONSTANT VARCHAR2(100) := D_unit_price_ge_zero;
1169:
1170: l_line_id_tbl PO_TBL_NUMBER;
1171: l_unit_price_tbl PO_TBL_NUMBER;
1172: l_input_size NUMBER;
1173: l_count NUMBER;
1174: BEGIN
1175:

Line 1185: l_line_id_tbl := PO_TBL_NUMBER();

1181: END IF;
1182:
1183: l_input_size := p_line_id_tbl.COUNT;
1184:
1185: l_line_id_tbl := PO_TBL_NUMBER();
1186: l_line_id_tbl.extend(l_input_size);
1187: l_unit_price_tbl := PO_TBL_NUMBER();
1188: l_unit_price_tbl.extend(l_input_size);
1189:

Line 1187: l_unit_price_tbl := PO_TBL_NUMBER();

1183: l_input_size := p_line_id_tbl.COUNT;
1184:
1185: l_line_id_tbl := PO_TBL_NUMBER();
1186: l_line_id_tbl.extend(l_input_size);
1187: l_unit_price_tbl := PO_TBL_NUMBER();
1188: l_unit_price_tbl.extend(l_input_size);
1189:
1190: l_count := 0;
1191:

Line 1229: p_line_id_tbl IN PO_TBL_NUMBER

1225: -----------------------------------------------------------------------------
1226: -- Validates that the list price per unit is greater than or equal to zero.
1227: -----------------------------------------------------------------------------
1228: PROCEDURE list_price_ge_zero(
1229: p_line_id_tbl IN PO_TBL_NUMBER
1230: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
1231: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1232: , x_result_type OUT NOCOPY VARCHAR2
1233: )

Line 1230: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER

1226: -- Validates that the list price per unit is greater than or equal to zero.
1227: -----------------------------------------------------------------------------
1228: PROCEDURE list_price_ge_zero(
1229: p_line_id_tbl IN PO_TBL_NUMBER
1230: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
1231: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1232: , x_result_type OUT NOCOPY VARCHAR2
1233: )
1234: IS

Line 1256: p_line_id_tbl IN PO_TBL_NUMBER

1252: -----------------------------------------------------------------------------
1253: -- Validates that the market price is greater than or equal to zero.
1254: -----------------------------------------------------------------------------
1255: PROCEDURE market_price_ge_zero(
1256: p_line_id_tbl IN PO_TBL_NUMBER
1257: , p_market_price_tbl IN PO_TBL_NUMBER
1258: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1259: , x_result_type OUT NOCOPY VARCHAR2
1260: )

Line 1257: , p_market_price_tbl IN PO_TBL_NUMBER

1253: -- Validates that the market price is greater than or equal to zero.
1254: -----------------------------------------------------------------------------
1255: PROCEDURE market_price_ge_zero(
1256: p_line_id_tbl IN PO_TBL_NUMBER
1257: , p_market_price_tbl IN PO_TBL_NUMBER
1258: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1259: , x_result_type OUT NOCOPY VARCHAR2
1260: )
1261: IS

Line 1286: p_line_id_tbl IN PO_TBL_NUMBER

1282: -- the price is not being used by another process that should
1283: -- prevent a price change.
1284: -----------------------------------------------------------------------------
1285: PROCEDURE validate_unit_price_change(
1286: p_line_id_tbl IN PO_TBL_NUMBER
1287: , p_unit_price_tbl IN PO_TBL_NUMBER
1288: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
1289: , x_result_set_id IN OUT NOCOPY NUMBER
1290: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1287: , p_unit_price_tbl IN PO_TBL_NUMBER

1283: -- prevent a price change.
1284: -----------------------------------------------------------------------------
1285: PROCEDURE validate_unit_price_change(
1286: p_line_id_tbl IN PO_TBL_NUMBER
1287: , p_unit_price_tbl IN PO_TBL_NUMBER
1288: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
1289: , x_result_set_id IN OUT NOCOPY NUMBER
1290: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1291: , x_result_type OUT NOCOPY VARCHAR2

Line 1297: l_line_id_tbl PO_TBL_NUMBER;

1293: IS
1294: d_mod CONSTANT VARCHAR2(100) := D_validate_unit_price_change;
1295:
1296: l_data_key NUMBER;
1297: l_line_id_tbl PO_TBL_NUMBER;
1298: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
1299: BEGIN
1300:
1301: IF PO_LOG.d_proc THEN

Line 1387: p_line_id_tbl IN PO_TBL_NUMBER

1383: -- of the Agreement.
1384: -- Agreements only.
1385: -----------------------------------------------------------------------------
1386: PROCEDURE expiration_ge_blanket_start(
1387: p_line_id_tbl IN PO_TBL_NUMBER
1388: , p_blanket_start_date_tbl IN PO_TBL_DATE
1389: , p_expiration_date_tbl IN PO_TBL_DATE
1390: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1391: , x_result_type OUT NOCOPY VARCHAR2

Line 1419: p_line_id_tbl IN PO_TBL_NUMBER

1415: -- of the Agreement.
1416: -- Agreements only.
1417: -----------------------------------------------------------------------------
1418: PROCEDURE expiration_le_blanket_end(
1419: p_line_id_tbl IN PO_TBL_NUMBER
1420: , p_blanket_end_date_tbl IN PO_TBL_DATE
1421: , p_expiration_date_tbl IN PO_TBL_DATE
1422: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1423: , x_result_type OUT NOCOPY VARCHAR2

Line 1451: p_line_id_tbl IN PO_TBL_NUMBER

1447: -------------------------------------------------------------------------
1448: -- The invoice close tolerance must be between 0 and 100, inclusive.
1449: -------------------------------------------------------------------------
1450: PROCEDURE recoupment_rate_range_check (
1451: p_line_id_tbl IN PO_TBL_NUMBER
1452: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
1453: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1454: , x_result_type OUT NOCOPY VARCHAR2
1455: )

Line 1452: , p_recoupment_rate_tbl IN PO_TBL_NUMBER

1448: -- The invoice close tolerance must be between 0 and 100, inclusive.
1449: -------------------------------------------------------------------------
1450: PROCEDURE recoupment_rate_range_check (
1451: p_line_id_tbl IN PO_TBL_NUMBER
1452: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
1453: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1454: , x_result_type OUT NOCOPY VARCHAR2
1455: )
1456: IS

Line 1474: p_line_id_tbl IN PO_TBL_NUMBER

1470:
1471: END recoupment_rate_range_check;
1472:
1473: PROCEDURE retainage_rate_range_check (
1474: p_line_id_tbl IN PO_TBL_NUMBER
1475: , p_retainage_rate_tbl IN PO_TBL_NUMBER
1476: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1477: , x_result_type OUT NOCOPY VARCHAR2
1478: )

Line 1475: , p_retainage_rate_tbl IN PO_TBL_NUMBER

1471: END recoupment_rate_range_check;
1472:
1473: PROCEDURE retainage_rate_range_check (
1474: p_line_id_tbl IN PO_TBL_NUMBER
1475: , p_retainage_rate_tbl IN PO_TBL_NUMBER
1476: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1477: , x_result_type OUT NOCOPY VARCHAR2
1478: )
1479: IS

Line 1497: p_line_id_tbl IN PO_TBL_NUMBER

1493:
1494: END retainage_rate_range_check;
1495:
1496: PROCEDURE prog_pay_rate_range_check (
1497: p_line_id_tbl IN PO_TBL_NUMBER
1498: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
1499: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1500: , x_result_type OUT NOCOPY VARCHAR2
1501: )

Line 1498: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER

1494: END retainage_rate_range_check;
1495:
1496: PROCEDURE prog_pay_rate_range_check (
1497: p_line_id_tbl IN PO_TBL_NUMBER
1498: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
1499: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1500: , x_result_type OUT NOCOPY VARCHAR2
1501: )
1502: IS

Line 1528: p_line_id_tbl IN PO_TBL_NUMBER

1524: -- This check is only performed if quantity is being reduced below the
1525: -- current transaction quantity, since over-receiving is allowed.
1526: -----------------------------------------------------------------------------
1527: PROCEDURE qty_ge_qty_milestone_exec(
1528: p_line_id_tbl IN PO_TBL_NUMBER
1529: , p_quantity_tbl IN PO_TBL_NUMBER
1530: , x_result_set_id IN OUT NOCOPY NUMBER
1531: , x_result_type OUT NOCOPY VARCHAR2
1532: )

Line 1529: , p_quantity_tbl IN PO_TBL_NUMBER

1525: -- current transaction quantity, since over-receiving is allowed.
1526: -----------------------------------------------------------------------------
1527: PROCEDURE qty_ge_qty_milestone_exec(
1528: p_line_id_tbl IN PO_TBL_NUMBER
1529: , p_quantity_tbl IN PO_TBL_NUMBER
1530: , x_result_set_id IN OUT NOCOPY NUMBER
1531: , x_result_type OUT NOCOPY VARCHAR2
1532: )
1533: IS

Line 1623: p_line_id_tbl IN PO_TBL_NUMBER

1619: -- This check is only performed if price is being reduced below the
1620: -- current transaction price, since over-receiving is allowed.
1621: -----------------------------------------------------------------------------
1622: PROCEDURE price_ge_price_milestone_exec(
1623: p_line_id_tbl IN PO_TBL_NUMBER
1624: , p_price_tbl IN PO_TBL_NUMBER
1625: , x_result_set_id IN OUT NOCOPY NUMBER
1626: , x_result_type OUT NOCOPY VARCHAR2
1627: )

Line 1624: , p_price_tbl IN PO_TBL_NUMBER

1620: -- current transaction price, since over-receiving is allowed.
1621: -----------------------------------------------------------------------------
1622: PROCEDURE price_ge_price_milestone_exec(
1623: p_line_id_tbl IN PO_TBL_NUMBER
1624: , p_price_tbl IN PO_TBL_NUMBER
1625: , x_result_set_id IN OUT NOCOPY NUMBER
1626: , x_result_type OUT NOCOPY VARCHAR2
1627: )
1628: IS

Line 1711: p_line_id_tbl IN PO_TBL_NUMBER

1707: -------------------------------------------------------------------------------
1708: -- Ensures that the Unit of Measure is not null for non-FIXED PRICE lines.
1709: -------------------------------------------------------------------------------
1710: PROCEDURE unit_meas_not_null(
1711: p_line_id_tbl IN PO_TBL_NUMBER
1712: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
1713: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1714: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1715: , x_result_type OUT NOCOPY VARCHAR2

Line 1774: p_line_id_tbl IN PO_TBL_NUMBER

1770: -------------------------------------------------------------------------------
1771: -- Ensures that the Item Description is not null.
1772: -------------------------------------------------------------------------------
1773: PROCEDURE item_description_not_null(
1774: p_line_id_tbl IN PO_TBL_NUMBER
1775: , p_item_description_tbl IN PO_TBL_VARCHAR2000
1776: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1777: , x_result_type OUT NOCOPY VARCHAR2
1778: )

Line 1800: p_line_id_tbl IN PO_TBL_NUMBER

1796: -------------------------------------------------------------------------------
1797: -- Ensures that the Category is not null.
1798: -------------------------------------------------------------------------------
1799: PROCEDURE category_id_not_null(
1800: p_line_id_tbl IN PO_TBL_NUMBER
1801: , p_category_id_tbl IN PO_TBL_NUMBER
1802: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1803: , x_result_type OUT NOCOPY VARCHAR2
1804: )

Line 1801: , p_category_id_tbl IN PO_TBL_NUMBER

1797: -- Ensures that the Category is not null.
1798: -------------------------------------------------------------------------------
1799: PROCEDURE category_id_not_null(
1800: p_line_id_tbl IN PO_TBL_NUMBER
1801: , p_category_id_tbl IN PO_TBL_NUMBER
1802: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1803: , x_result_type OUT NOCOPY VARCHAR2
1804: )
1805: IS

Line 1827: p_id_tbl IN PO_TBL_NUMBER

1823: -- If order_type_lookup_code is Quantity and outside_operation flag is 'Y',
1824: -- then the item_id cannot be null.
1825: ---------------------------------------------------------------------------
1826: PROCEDURE item_id_not_null(
1827: p_id_tbl IN PO_TBL_NUMBER
1828: , p_item_id_tbl IN PO_TBL_NUMBER
1829: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1830: , p_line_type_id_tbl IN PO_TBL_NUMBER
1831: , p_message_name IN VARCHAR2

Line 1828: , p_item_id_tbl IN PO_TBL_NUMBER

1824: -- then the item_id cannot be null.
1825: ---------------------------------------------------------------------------
1826: PROCEDURE item_id_not_null(
1827: p_id_tbl IN PO_TBL_NUMBER
1828: , p_item_id_tbl IN PO_TBL_NUMBER
1829: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1830: , p_line_type_id_tbl IN PO_TBL_NUMBER
1831: , p_message_name IN VARCHAR2
1832: , x_result_set_id IN OUT NOCOPY NUMBER

Line 1830: , p_line_type_id_tbl IN PO_TBL_NUMBER

1826: PROCEDURE item_id_not_null(
1827: p_id_tbl IN PO_TBL_NUMBER
1828: , p_item_id_tbl IN PO_TBL_NUMBER
1829: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
1830: , p_line_type_id_tbl IN PO_TBL_NUMBER
1831: , p_message_name IN VARCHAR2
1832: , x_result_set_id IN OUT NOCOPY NUMBER
1833: , x_result_type OUT NOCOPY VARCHAR2
1834: )

Line 1838: l_id_tbl PO_TBL_NUMBER;

1834: )
1835: IS
1836: d_mod CONSTANT VARCHAR2(100) := D_item_id_not_null;
1837:
1838: l_id_tbl PO_TBL_NUMBER;
1839: l_line_type_id_tbl PO_TBL_NUMBER;
1840: l_input_size NUMBER;
1841: l_count NUMBER;
1842:

Line 1839: l_line_type_id_tbl PO_TBL_NUMBER;

1835: IS
1836: d_mod CONSTANT VARCHAR2(100) := D_item_id_not_null;
1837:
1838: l_id_tbl PO_TBL_NUMBER;
1839: l_line_type_id_tbl PO_TBL_NUMBER;
1840: l_input_size NUMBER;
1841: l_count NUMBER;
1842:
1843: BEGIN

Line 1862: l_id_tbl := PO_TBL_NUMBER();

1858: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1859:
1860: l_input_size := p_id_tbl.COUNT;
1861:
1862: l_id_tbl := PO_TBL_NUMBER();
1863: l_id_tbl.extend(l_input_size);
1864: l_line_type_id_tbl := PO_TBL_NUMBER();
1865: l_line_type_id_tbl.extend(l_input_size);
1866:

Line 1864: l_line_type_id_tbl := PO_TBL_NUMBER();

1860: l_input_size := p_id_tbl.COUNT;
1861:
1862: l_id_tbl := PO_TBL_NUMBER();
1863: l_id_tbl.extend(l_input_size);
1864: l_line_type_id_tbl := PO_TBL_NUMBER();
1865: l_line_type_id_tbl.extend(l_input_size);
1866:
1867: l_count := 0;
1868:

Line 1933: p_line_id_tbl IN PO_TBL_NUMBER

1929: -------------------------------------------------------------------------------
1930: -- Ensures that the Job is not null for TEMP LABOR lines.
1931: -------------------------------------------------------------------------------
1932: PROCEDURE temp_labor_job_id_not_null(
1933: p_line_id_tbl IN PO_TBL_NUMBER
1934: , p_job_id_tbl IN PO_TBL_NUMBER
1935: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
1936: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1937: , x_result_type OUT NOCOPY VARCHAR2

Line 1934: , p_job_id_tbl IN PO_TBL_NUMBER

1930: -- Ensures that the Job is not null for TEMP LABOR lines.
1931: -------------------------------------------------------------------------------
1932: PROCEDURE temp_labor_job_id_not_null(
1933: p_line_id_tbl IN PO_TBL_NUMBER
1934: , p_job_id_tbl IN PO_TBL_NUMBER
1935: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
1936: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1937: , x_result_type OUT NOCOPY VARCHAR2
1938: )

Line 1996: p_line_id_tbl IN PO_TBL_NUMBER

1992: -- Ensures that the Source Doc Line is not null if the Source Doc is not null
1993: -- and the Source Doc is not a contract.
1994: -------------------------------------------------------------------------------
1995: PROCEDURE src_doc_line_not_null(
1996: p_line_id_tbl IN PO_TBL_NUMBER
1997: , p_from_header_id_tbl IN PO_TBL_NUMBER
1998: , p_from_line_id_tbl IN PO_TBL_NUMBER
1999: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2000: , x_result_type OUT NOCOPY VARCHAR2

Line 1997: , p_from_header_id_tbl IN PO_TBL_NUMBER

1993: -- and the Source Doc is not a contract.
1994: -------------------------------------------------------------------------------
1995: PROCEDURE src_doc_line_not_null(
1996: p_line_id_tbl IN PO_TBL_NUMBER
1997: , p_from_header_id_tbl IN PO_TBL_NUMBER
1998: , p_from_line_id_tbl IN PO_TBL_NUMBER
1999: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2000: , x_result_type OUT NOCOPY VARCHAR2
2001: )

Line 1998: , p_from_line_id_tbl IN PO_TBL_NUMBER

1994: -------------------------------------------------------------------------------
1995: PROCEDURE src_doc_line_not_null(
1996: p_line_id_tbl IN PO_TBL_NUMBER
1997: , p_from_header_id_tbl IN PO_TBL_NUMBER
1998: , p_from_line_id_tbl IN PO_TBL_NUMBER
1999: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2000: , x_result_type OUT NOCOPY VARCHAR2
2001: )
2002: IS

Line 2057: p_line_id_tbl IN PO_TBL_NUMBER

2053: -------------------------------------------------------------------------------
2054: -- Ensures that the Line Type is not null.
2055: -------------------------------------------------------------------------------
2056: PROCEDURE line_type_id_not_null(
2057: p_line_id_tbl IN PO_TBL_NUMBER
2058: , p_line_type_id_tbl IN PO_TBL_NUMBER
2059: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2060: , x_result_type OUT NOCOPY VARCHAR2
2061: )

Line 2058: , p_line_type_id_tbl IN PO_TBL_NUMBER

2054: -- Ensures that the Line Type is not null.
2055: -------------------------------------------------------------------------------
2056: PROCEDURE line_type_id_not_null(
2057: p_line_id_tbl IN PO_TBL_NUMBER
2058: , p_line_type_id_tbl IN PO_TBL_NUMBER
2059: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2060: , x_result_type OUT NOCOPY VARCHAR2
2061: )
2062: IS

Line 2082: p_line_id_tbl IN PO_TBL_NUMBER

2078: -------------------------------------------------------------------------------
2079: -- Ensures that the Start Date is not null for TEMP LABOR lines.
2080: -------------------------------------------------------------------------------
2081: PROCEDURE temp_lbr_start_date_not_null(
2082: p_line_id_tbl IN PO_TBL_NUMBER
2083: , p_start_date_tbl IN PO_TBL_DATE
2084: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
2085: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2086: , x_result_type OUT NOCOPY VARCHAR2

Line 2146: p_line_id_tbl IN PO_TBL_NUMBER

2142: -- Validates that secondary quantity is not null and greater than zero for
2143: -- an opm item.
2144: -----------------------------------------------------------------------------
2145: PROCEDURE line_sec_quantity_gt_zero(
2146: p_line_id_tbl IN PO_TBL_NUMBER
2147: , p_item_id_tbl IN PO_TBL_NUMBER
2148: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2149: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2150: , x_result_type OUT NOCOPY VARCHAR2

Line 2147: , p_item_id_tbl IN PO_TBL_NUMBER

2143: -- an opm item.
2144: -----------------------------------------------------------------------------
2145: PROCEDURE line_sec_quantity_gt_zero(
2146: p_line_id_tbl IN PO_TBL_NUMBER
2147: , p_item_id_tbl IN PO_TBL_NUMBER
2148: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2149: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2150: , x_result_type OUT NOCOPY VARCHAR2
2151: )

Line 2148: , p_sec_quantity_tbl IN PO_TBL_NUMBER

2144: -----------------------------------------------------------------------------
2145: PROCEDURE line_sec_quantity_gt_zero(
2146: p_line_id_tbl IN PO_TBL_NUMBER
2147: , p_item_id_tbl IN PO_TBL_NUMBER
2148: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2149: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2150: , x_result_type OUT NOCOPY VARCHAR2
2151: )
2152: IS

Line 2154: l_inv_org_id_tbl PO_TBL_NUMBER;

2150: , x_result_type OUT NOCOPY VARCHAR2
2151: )
2152: IS
2153: d_mod CONSTANT VARCHAR2(100) := D_line_sec_quantity_gt_zero;
2154: l_inv_org_id_tbl PO_TBL_NUMBER;
2155: l_def_inv_org_id NUMBER;
2156: l_input_size NUMBER;
2157:
2158: BEGIN

Line 2174: l_inv_org_id_tbl := PO_TBL_NUMBER();

2170: from financials_system_parameters;
2171:
2172: l_input_size := p_line_id_tbl.COUNT;
2173:
2174: l_inv_org_id_tbl := PO_TBL_NUMBER();
2175: l_inv_org_id_tbl.extend(l_input_size);
2176:
2177: FOR i IN 1 .. p_line_id_tbl.COUNT LOOP
2178: l_inv_org_id_tbl(i) := l_def_inv_org_id;

Line 2208: p_line_id_tbl IN PO_TBL_NUMBER

2204: -- Validates secondary quantity and the quantity combination for
2205: -- an opm item
2206: -----------------------------------------------------------------------------
2207: PROCEDURE line_qtys_within_deviation (
2208: p_line_id_tbl IN PO_TBL_NUMBER
2209: , p_item_id_tbl IN PO_TBL_NUMBER
2210: , p_quantity_tbl IN PO_TBL_NUMBER
2211: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2212: , p_sec_quantity_tbl IN PO_TBL_NUMBER

Line 2209: , p_item_id_tbl IN PO_TBL_NUMBER

2205: -- an opm item
2206: -----------------------------------------------------------------------------
2207: PROCEDURE line_qtys_within_deviation (
2208: p_line_id_tbl IN PO_TBL_NUMBER
2209: , p_item_id_tbl IN PO_TBL_NUMBER
2210: , p_quantity_tbl IN PO_TBL_NUMBER
2211: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2212: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2213: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

Line 2210: , p_quantity_tbl IN PO_TBL_NUMBER

2206: -----------------------------------------------------------------------------
2207: PROCEDURE line_qtys_within_deviation (
2208: p_line_id_tbl IN PO_TBL_NUMBER
2209: , p_item_id_tbl IN PO_TBL_NUMBER
2210: , p_quantity_tbl IN PO_TBL_NUMBER
2211: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2212: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2213: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2214: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 2212: , p_sec_quantity_tbl IN PO_TBL_NUMBER

2208: p_line_id_tbl IN PO_TBL_NUMBER
2209: , p_item_id_tbl IN PO_TBL_NUMBER
2210: , p_quantity_tbl IN PO_TBL_NUMBER
2211: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
2212: , p_sec_quantity_tbl IN PO_TBL_NUMBER
2213: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
2214: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2215: , x_result_type OUT NOCOPY VARCHAR2
2216: )

Line 2220: l_inv_org_id_tbl PO_TBL_NUMBER;

2216: )
2217: IS
2218:
2219: d_mod CONSTANT VARCHAR2(100) := D_line_qtys_within_deviation;
2220: l_inv_org_id_tbl PO_TBL_NUMBER;
2221: l_input_size NUMBER;
2222: l_def_inv_org_id NUMBER;
2223:
2224: BEGIN

Line 2240: l_inv_org_id_tbl := PO_TBL_NUMBER();

2236: from financials_system_parameters;
2237:
2238: l_input_size := p_line_id_tbl.COUNT;
2239:
2240: l_inv_org_id_tbl := PO_TBL_NUMBER();
2241: l_inv_org_id_tbl.extend(l_input_size);
2242:
2243: FOR i IN 1 .. p_line_id_tbl.COUNT LOOP
2244: l_inv_org_id_tbl(i) := l_def_inv_org_id;

Line 2275: p_line_id_tbl IN PO_TBL_NUMBER

2271: -- Validates that source doc line is not null if the source document is filled
2272: -- in and the source document is a blanket or quotation
2273: -----------------------------------------------------------------------------
2274: PROCEDURE from_line_id_not_null (
2275: p_line_id_tbl IN PO_TBL_NUMBER
2276: , p_from_header_id_tbl IN PO_TBL_NUMBER
2277: , p_from_line_id_tbl IN PO_TBL_NUMBER
2278: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2279: , x_result_type OUT NOCOPY VARCHAR2

Line 2276: , p_from_header_id_tbl IN PO_TBL_NUMBER

2272: -- in and the source document is a blanket or quotation
2273: -----------------------------------------------------------------------------
2274: PROCEDURE from_line_id_not_null (
2275: p_line_id_tbl IN PO_TBL_NUMBER
2276: , p_from_header_id_tbl IN PO_TBL_NUMBER
2277: , p_from_line_id_tbl IN PO_TBL_NUMBER
2278: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2279: , x_result_type OUT NOCOPY VARCHAR2
2280: )

Line 2277: , p_from_line_id_tbl IN PO_TBL_NUMBER

2273: -----------------------------------------------------------------------------
2274: PROCEDURE from_line_id_not_null (
2275: p_line_id_tbl IN PO_TBL_NUMBER
2276: , p_from_header_id_tbl IN PO_TBL_NUMBER
2277: , p_from_line_id_tbl IN PO_TBL_NUMBER
2278: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2279: , x_result_type OUT NOCOPY VARCHAR2
2280: )
2281: IS

Line 2363: p_line_id_tbl IN PO_TBL_NUMBER

2359: -- This procedure determines if Maximum Retainage Amount
2360: -- is greater than or equal to zero. If not, return a failure.
2361: -------------------------------------------------------------------------------
2362: PROCEDURE max_retain_amt_ge_zero(
2363: p_line_id_tbl IN PO_TBL_NUMBER
2364: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
2365: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2366: , x_result_type OUT NOCOPY VARCHAR2
2367: )

Line 2364: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

2360: -- is greater than or equal to zero. If not, return a failure.
2361: -------------------------------------------------------------------------------
2362: PROCEDURE max_retain_amt_ge_zero(
2363: p_line_id_tbl IN PO_TBL_NUMBER
2364: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
2365: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2366: , x_result_type OUT NOCOPY VARCHAR2
2367: )
2368: IS

Line 2393: p_line_id_tbl IN PO_TBL_NUMBER

2389: -- This procedure determines if Maximum Retainage Amount
2390: -- is greater than already retained amount. If not, return a failure.
2391: -------------------------------------------------------------------------------
2392: PROCEDURE max_retain_amt_ge_retained(
2393: p_line_id_tbl IN PO_TBL_NUMBER
2394: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
2395: , x_result_set_id IN OUT NOCOPY NUMBER
2396: , x_result_type OUT NOCOPY VARCHAR2
2397: )

Line 2394: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

2390: -- is greater than already retained amount. If not, return a failure.
2391: -------------------------------------------------------------------------------
2392: PROCEDURE max_retain_amt_ge_retained(
2393: p_line_id_tbl IN PO_TBL_NUMBER
2394: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
2395: , x_result_set_id IN OUT NOCOPY NUMBER
2396: , x_result_type OUT NOCOPY VARCHAR2
2397: )
2398: IS