[Home] [Help]
128:
129: PROCEDURE days_early_gte_zero(
130: p_line_loc_id_tbl IN PO_TBL_NUMBER
131: , p_days_early_rcpt_allowed_tbl IN PO_TBL_NUMBER
132: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
133: , x_result_type OUT NOCOPY VARCHAR2
134: )
135: IS
136: BEGIN
155: -------------------------------------------------------------------------
156: PROCEDURE days_late_gte_zero(
157: p_line_loc_id_tbl IN PO_TBL_NUMBER
158: , p_days_late_rcpt_allowed_tbl IN PO_TBL_NUMBER
159: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
160: , x_result_type OUT NOCOPY VARCHAR2
161: )
162: IS
163: BEGIN
183:
184: PROCEDURE rcv_close_tol_within_range (
185: p_line_loc_id_tbl IN PO_TBL_NUMBER
186: , p_receive_close_tolerance_tbl IN PO_TBL_NUMBER
187: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
188: , x_result_type OUT NOCOPY VARCHAR2
189: )
190: IS
191: BEGIN
210:
211: PROCEDURE over_rcpt_tol_within_range (
212: p_line_loc_id_tbl IN PO_TBL_NUMBER
213: , p_qty_rcv_tolerance_tbl IN PO_TBL_NUMBER
214: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
215: , x_result_type OUT NOCOPY VARCHAR2
216: )
217: IS
218: BEGIN
344: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
345: , p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1
346: , p_inspection_required_flag_tbl IN PO_TBL_VARCHAR1
347: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
348: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
349: , x_result_type OUT NOCOPY VARCHAR2
350: )
351: IS
352: d_mod CONSTANT VARCHAR2(100) := D_match_4way_check;
363: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
364: END IF;
365:
366: IF (x_results IS NULL) THEN
367: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
368: END IF;
369:
370: l_results_count := x_results.result_type.COUNT;
371:
411: -------------------------------------------------------------------------
412: PROCEDURE inv_close_tol_range_check (
413: p_line_loc_id_tbl IN PO_TBL_NUMBER
414: , p_invoice_close_tolerance_tbl IN PO_TBL_NUMBER
415: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
416: , x_result_type OUT NOCOPY VARCHAR2
417: )
418: IS
419: BEGIN
508: PROCEDURE ship_to_org_null_check(
509: p_line_loc_id_tbl IN PO_TBL_NUMBER
510: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
511: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
512: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
513: , x_result_type OUT NOCOPY VARCHAR2
514: )
515: IS
516: d_mod CONSTANT VARCHAR2(100) := D_ship_to_org_null_check;
576: PROCEDURE ship_to_loc_null_check(
577: p_line_loc_id_tbl IN PO_TBL_NUMBER
578: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
579: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
580: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
581: , x_result_type OUT NOCOPY VARCHAR2
582: )
583: IS
584: d_mod CONSTANT VARCHAR2(100) := D_ship_to_loc_null_check;
646: PROCEDURE ship_num_gt_zero(
647: p_line_loc_id_tbl IN PO_TBL_NUMBER
648: , p_shipment_num_tbl IN PO_TBL_NUMBER
649: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
650: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
651: , x_result_type OUT NOCOPY VARCHAR2
652: )
653: IS
654: l_line_loc_id_tbl PO_TBL_NUMBER; --
728: , p_line_id_tbl IN PO_TBL_NUMBER
729: , p_org_id_tbl IN PO_TBL_NUMBER
730: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
731: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
732: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
733: , x_result_type OUT NOCOPY VARCHAR2
734: )
735: IS
736: d_mod CONSTANT VARCHAR2(100) := D_is_org_in_current_sob_check;
756: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
757: END IF;
758:
759: IF (x_results IS NULL) THEN
760: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
761: END IF;
762:
763: l_results_count := x_results.result_type.COUNT;
764:
864: p_line_loc_id_tbl IN PO_TBL_NUMBER
865: , p_quantity_tbl IN PO_TBL_NUMBER
866: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
867: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
868: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
869: , x_result_type OUT NOCOPY VARCHAR2
870: )
871: IS
872: d_mod CONSTANT VARCHAR2(100) := D_quantity_gt_zero;
1046: p_line_loc_id_tbl IN PO_TBL_NUMBER
1047: , p_amount_tbl IN PO_TBL_NUMBER
1048: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
1049: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
1050: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1051: , x_result_type OUT NOCOPY VARCHAR2
1052: )
1053: IS
1054: d_mod CONSTANT VARCHAR2(100) := D_amount_gt_zero;
1225: p_line_loc_id_tbl IN PO_TBL_NUMBER
1226: , p_item_id_tbl IN PO_TBL_NUMBER
1227: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1228: , p_sec_quantity_tbl IN PO_TBL_NUMBER
1229: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1230: , x_result_type OUT NOCOPY VARCHAR2
1231: )
1232: IS
1233: d_mod CONSTANT VARCHAR2(100) := D_ship_sec_quantity_gt_zero;
1272: , p_quantity_tbl IN PO_TBL_NUMBER
1273: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
1274: , p_sec_quantity_tbl IN PO_TBL_NUMBER
1275: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
1276: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1277: , x_result_type OUT NOCOPY VARCHAR2
1278: )
1279: IS
1280:
1322: p_line_loc_id_tbl IN PO_TBL_NUMBER
1323: , p_payment_type_tbl IN PO_TBL_VARCHAR30
1324: , p_value_basis_tbl IN PO_TBL_VARCHAR30
1325: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
1326: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1327: , x_result_type OUT NOCOPY VARCHAR2
1328: ) IS
1329:
1330: d_mod CONSTANT VARCHAR2(100) := D_unit_of_meas_not_null;
1339: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1340: END IF;
1341:
1342: IF (x_results IS NULL) THEN
1343: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
1344: END IF;
1345:
1346: l_results_count := x_results.result_type.COUNT; -- Bug 5532560
1347: