DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_VALIDATION_RESULTS_TYPE

Line 49: x_results IN OUT NOCOPY po_validation_results_type,

45: PROCEDURE need_by_date(
46: p_id_tbl IN po_tbl_number,
47: p_purchase_basis_tbl IN po_tbl_varchar30,
48: p_need_by_date_tbl IN po_tbl_date,
49: x_results IN OUT NOCOPY po_validation_results_type,
50: x_result_type OUT NOCOPY VARCHAR2)
51: IS
52: d_mod CONSTANT VARCHAR2(100) := d_need_by_date;
53: BEGIN

Line 55: x_results := po_validation_results_type.new_instance();

51: IS
52: d_mod CONSTANT VARCHAR2(100) := d_need_by_date;
53: BEGIN
54: IF (x_results IS NULL) THEN
55: x_results := po_validation_results_type.new_instance();
56: END IF;
57:
58: x_result_type := po_validations.c_result_type_success;
59:

Line 100: x_results IN OUT NOCOPY po_validation_results_type,

96: PROCEDURE promised_date(
97: p_id_tbl IN po_tbl_number,
98: p_purchase_basis_tbl IN po_tbl_varchar30,
99: p_promised_date_tbl IN po_tbl_date,
100: x_results IN OUT NOCOPY po_validation_results_type,
101: x_result_type OUT NOCOPY VARCHAR2)
102: IS
103: d_mod CONSTANT VARCHAR2(100) := d_promised_date;
104: BEGIN

Line 106: x_results := po_validation_results_type.new_instance();

102: IS
103: d_mod CONSTANT VARCHAR2(100) := d_promised_date;
104: BEGIN
105: IF (x_results IS NULL) THEN
106: x_results := po_validation_results_type.new_instance();
107: END IF;
108:
109: x_result_type := po_validations.c_result_type_success;
110:

Line 152: x_results IN OUT NOCOPY po_validation_results_type,

148: p_id_tbl IN po_tbl_number,
149: p_shipment_type_tbl IN po_tbl_varchar30,
150: p_style_id_tbl IN po_tbl_number, -- PDOI for Complex PO Project
151: p_doc_type IN VARCHAR2,
152: x_results IN OUT NOCOPY po_validation_results_type,
153: x_result_type OUT NOCOPY VARCHAR2)
154: IS
155: d_mod CONSTANT VARCHAR2(100) := d_shipment_type;
156: l_is_complex_work_style BOOLEAN; -- PDOI for Complex PO Project

Line 159: x_results := po_validation_results_type.new_instance();

155: d_mod CONSTANT VARCHAR2(100) := d_shipment_type;
156: l_is_complex_work_style BOOLEAN; -- PDOI for Complex PO Project
157: BEGIN
158: IF (x_results IS NULL) THEN
159: x_results := po_validation_results_type.new_instance();
160: END IF;
161:
162: x_result_type := po_validations.c_result_type_success;
163:

Line 223: x_results IN OUT NOCOPY po_validation_results_type,

219: po_line_id_tbl IN po_tbl_number,
220: p_style_id_tbl IN po_tbl_number,
221: p_payment_type_tbl IN po_tbl_varchar30,
222: p_shipment_type_tbl IN po_tbl_varchar30,
223: x_results IN OUT NOCOPY po_validation_results_type,
224: x_result_type OUT NOCOPY VARCHAR2)
225: IS
226: d_mod CONSTANT VARCHAR2(100) := d_payment_type;
227: l_line_id NUMBER;

Line 241: x_results := po_validation_results_type.new_instance();

237: l_lumpsum_allowed_flag VARCHAR2(1) := 'N';
238: l_rate_allowed_flag VARCHAR2(1) := 'N';
239: BEGIN
240: IF (x_results IS NULL) THEN
241: x_results := po_validation_results_type.new_instance();
242: END IF;
243:
244: x_result_type := po_validations.c_result_type_success;
245:

Line 438: x_results IN OUT NOCOPY po_validation_results_type,

434: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug 4642348
435: p_style_id_tbl IN po_tbl_number, -- PDOI for Complex PO Project
436: p_doc_type IN VARCHAR2, -- bug 4642348
437: x_result_set_id IN OUT NOCOPY NUMBER,
438: x_results IN OUT NOCOPY po_validation_results_type,
439: x_result_type OUT NOCOPY VARCHAR2)
440: IS
441: d_mod CONSTANT VARCHAR2(100) := d_shipment_num;
442: l_is_complex_work_style BOOLEAN; -- PDOI for Complex PO Project

Line 449: x_results := po_validation_results_type.new_instance();

445: x_result_set_id := po_validations.next_result_set_id();
446: END IF;
447:
448: IF (x_results IS NULL) THEN
449: x_results := po_validation_results_type.new_instance();
450: END IF;
451:
452: IF po_log.d_proc THEN
453: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 576: x_results IN OUT NOCOPY po_validation_results_type,

572: p_shipment_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
573: p_style_id_tbl IN po_tbl_number, -- PDOI for Complex PO Project
574: p_payment_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
575: p_line_quantity_tbl IN po_tbl_number, -- PDOI for Complex PO Project
576: x_results IN OUT NOCOPY po_validation_results_type,
577: x_result_type OUT NOCOPY VARCHAR2)
578: IS
579: d_mod CONSTANT VARCHAR2(100) := d_quantity;
580: l_is_financing_style BOOLEAN; -- PDOI for Complex PO Project

Line 583: x_results := po_validation_results_type.new_instance();

579: d_mod CONSTANT VARCHAR2(100) := d_quantity;
580: l_is_financing_style BOOLEAN; -- PDOI for Complex PO Project
581: BEGIN
582: IF (x_results IS NULL) THEN
583: x_results := po_validation_results_type.new_instance();
584: END IF;
585:
586: x_result_type := po_validations.c_result_type_success;
587:

Line 675: x_results IN OUT NOCOPY po_validation_results_type,

671: p_shipment_type_tbl IN po_tbl_varchar30,
672: p_style_id_tbl IN po_tbl_number,
673: p_payment_type_tbl IN po_tbl_varchar30,
674: p_line_amount_tbl IN po_tbl_number,
675: x_results IN OUT NOCOPY po_validation_results_type,
676: x_result_type OUT NOCOPY VARCHAR2)
677: IS
678: d_mod CONSTANT VARCHAR2(100) := d_amount;
679: l_is_financing_style BOOLEAN;

Line 682: x_results := po_validation_results_type.new_instance();

678: d_mod CONSTANT VARCHAR2(100) := d_amount;
679: l_is_financing_style BOOLEAN;
680: BEGIN
681: IF (x_results IS NULL) THEN
682: x_results := po_validation_results_type.new_instance();
683: END IF;
684:
685: x_result_type := po_validations.c_result_type_success;
686:

Line 743: x_results IN OUT NOCOPY po_validation_results_type,

739: p_shipment_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
740: p_style_id_tbl IN po_tbl_number, -- PDOI for Complex PO Project
741: p_payment_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
742: p_line_unit_price_tbl IN po_tbl_number, -- PDOI for Complex PO Project
743: x_results IN OUT NOCOPY po_validation_results_type,
744: x_result_type OUT NOCOPY VARCHAR2)
745: IS
746: d_mod CONSTANT VARCHAR2(100) := d_price_override;
747: l_is_financing_style BOOLEAN; -- PDOI for Complex PO Project

Line 750: x_results := po_validation_results_type.new_instance();

746: d_mod CONSTANT VARCHAR2(100) := d_price_override;
747: l_is_financing_style BOOLEAN; -- PDOI for Complex PO Project
748: BEGIN
749: IF (x_results IS NULL) THEN
750: x_results := po_validation_results_type.new_instance();
751: END IF;
752:
753: x_result_type := po_validations.c_result_type_success;
754:

Line 837: x_results IN OUT NOCOPY po_validation_results_type,

833: p_id_tbl IN po_tbl_number,
834: p_price_discount_tbl IN po_tbl_number,
835: p_price_override_tbl IN po_tbl_number,
836: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
837: x_results IN OUT NOCOPY po_validation_results_type,
838: x_result_type OUT NOCOPY VARCHAR2)
839: IS
840: d_mod CONSTANT VARCHAR2(100) := d_price_discount;
841: BEGIN

Line 843: x_results := po_validation_results_type.new_instance();

839: IS
840: d_mod CONSTANT VARCHAR2(100) := d_price_discount;
841: BEGIN
842: IF (x_results IS NULL) THEN
843: x_results := po_validation_results_type.new_instance();
844: END IF;
845:
846: x_result_type := po_validations.c_result_type_success;
847:

Line 1112: x_results IN OUT NOCOPY po_validation_results_type,

1108: p_to_date_tbl IN po_tbl_date,
1109: p_quantity_tbl IN po_tbl_number,
1110: p_ship_to_org_id_tbl IN po_tbl_number,
1111: p_ship_to_location_id_tbl IN po_tbl_number,
1112: x_results IN OUT NOCOPY po_validation_results_type,
1113: x_result_type OUT NOCOPY VARCHAR2)
1114: IS
1115: d_mod CONSTANT VARCHAR2(100) := d_price_break_attributes;
1116: BEGIN

Line 1118: x_results := po_validation_results_type.new_instance();

1114: IS
1115: d_mod CONSTANT VARCHAR2(100) := d_price_break_attributes;
1116: BEGIN
1117: IF (x_results IS NULL) THEN
1118: x_results := po_validation_results_type.new_instance();
1119: END IF;
1120:
1121: x_result_type := po_validations.c_result_type_success;
1122:

Line 1172: x_results IN OUT NOCOPY po_validation_results_type,

1168: p_from_date_tbl IN po_tbl_date,
1169: p_header_start_date_tbl IN po_tbl_date,
1170: p_header_end_date_tbl IN po_tbl_date,
1171: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
1172: x_results IN OUT NOCOPY po_validation_results_type,
1173: x_result_type OUT NOCOPY VARCHAR2)
1174: IS
1175: d_mod CONSTANT VARCHAR2(100) := d_effective_dates;
1176: BEGIN

Line 1178: x_results := po_validation_results_type.new_instance();

1174: IS
1175: d_mod CONSTANT VARCHAR2(100) := d_effective_dates;
1176: BEGIN
1177: IF (x_results IS NULL) THEN
1178: x_results := po_validation_results_type.new_instance();
1179: END IF;
1180:
1181: x_result_type := po_validations.c_result_type_success;
1182:

Line 1422: x_results IN OUT NOCOPY po_validation_results_type,

1418: PROCEDURE enforce_ship_to_loc_code(
1419: p_id_tbl IN po_tbl_number,
1420: p_enforce_ship_to_loc_code_tbl IN po_tbl_varchar30,
1421: p_shipment_type_tbl IN po_tbl_varchar30,
1422: x_results IN OUT NOCOPY po_validation_results_type,
1423: x_result_type OUT NOCOPY VARCHAR2)
1424: IS
1425: d_mod CONSTANT VARCHAR2(100) := d_enforce_ship_to_loc_code;
1426: BEGIN

Line 1428: x_results := po_validation_results_type.new_instance();

1424: IS
1425: d_mod CONSTANT VARCHAR2(100) := d_enforce_ship_to_loc_code;
1426: BEGIN
1427: IF (x_results IS NULL) THEN
1428: x_results := po_validation_results_type.new_instance();
1429: END IF;
1430:
1431: x_result_type := po_validations.c_result_type_success;
1432:

Line 1477: x_results IN OUT NOCOPY po_validation_results_type,

1473: PROCEDURE allow_sub_receipts_flag(
1474: p_id_tbl IN po_tbl_number,
1475: p_shipment_type_tbl IN po_tbl_varchar30,
1476: p_allow_sub_receipts_flag_tbl IN po_tbl_varchar1,
1477: x_results IN OUT NOCOPY po_validation_results_type,
1478: x_result_type OUT NOCOPY VARCHAR2)
1479: IS
1480: d_mod CONSTANT VARCHAR2(100) := d_allow_sub_receipts_flag;
1481: BEGIN

Line 1483: x_results := po_validation_results_type.new_instance();

1479: IS
1480: d_mod CONSTANT VARCHAR2(100) := d_allow_sub_receipts_flag;
1481: BEGIN
1482: IF (x_results IS NULL) THEN
1483: x_results := po_validation_results_type.new_instance();
1484: END IF;
1485:
1486: x_result_type := po_validations.c_result_type_success;
1487:

Line 1530: x_results IN OUT NOCOPY po_validation_results_type,

1526: PROCEDURE days_early_receipt_allowed(
1527: p_id_tbl IN po_tbl_number,
1528: p_shipment_type_tbl IN po_tbl_varchar30,
1529: p_days_early_rcpt_allowed_tbl IN po_tbl_number,
1530: x_results IN OUT NOCOPY po_validation_results_type,
1531: x_result_type OUT NOCOPY VARCHAR2)
1532: IS
1533: d_mod CONSTANT VARCHAR2(100) := d_days_early_receipt_allowed;
1534: BEGIN

Line 1536: x_results := po_validation_results_type.new_instance();

1532: IS
1533: d_mod CONSTANT VARCHAR2(100) := d_days_early_receipt_allowed;
1534: BEGIN
1535: IF (x_results IS NULL) THEN
1536: x_results := po_validation_results_type.new_instance();
1537: END IF;
1538:
1539: x_result_type := po_validations.c_result_type_success;
1540:

Line 1584: x_results IN OUT NOCOPY po_validation_results_type,

1580: PROCEDURE receipt_days_exception_code(
1581: p_id_tbl IN po_tbl_number,
1582: p_shipment_type_tbl IN po_tbl_varchar30,
1583: p_rcpt_days_exception_code_tbl IN po_tbl_varchar30,
1584: x_results IN OUT NOCOPY po_validation_results_type,
1585: x_result_type OUT NOCOPY VARCHAR2)
1586: IS
1587: d_mod CONSTANT VARCHAR2(100) := d_receipt_days_exception_code;
1588: BEGIN

Line 1590: x_results := po_validation_results_type.new_instance();

1586: IS
1587: d_mod CONSTANT VARCHAR2(100) := d_receipt_days_exception_code;
1588: BEGIN
1589: IF (x_results IS NULL) THEN
1590: x_results := po_validation_results_type.new_instance();
1591: END IF;
1592:
1593: x_result_type := po_validations.c_result_type_success;
1594:

Line 1638: x_results IN OUT NOCOPY po_validation_results_type,

1634: PROCEDURE invoice_close_tolerance(
1635: p_id_tbl IN po_tbl_number,
1636: p_shipment_type_tbl IN po_tbl_varchar30,
1637: p_invoice_close_tolerance_tbl IN po_tbl_number,
1638: x_results IN OUT NOCOPY po_validation_results_type,
1639: x_result_type OUT NOCOPY VARCHAR2)
1640: IS
1641: d_mod CONSTANT VARCHAR2(100) := d_invoice_close_tolerance;
1642: BEGIN

Line 1644: x_results := po_validation_results_type.new_instance();

1640: IS
1641: d_mod CONSTANT VARCHAR2(100) := d_invoice_close_tolerance;
1642: BEGIN
1643: IF (x_results IS NULL) THEN
1644: x_results := po_validation_results_type.new_instance();
1645: END IF;
1646:
1647: x_result_type := po_validations.c_result_type_success;
1648:

Line 1692: x_results IN OUT NOCOPY po_validation_results_type,

1688: PROCEDURE receive_close_tolerance(
1689: p_id_tbl IN po_tbl_number,
1690: p_shipment_type_tbl IN po_tbl_varchar30,
1691: p_receive_close_tolerance_tbl IN po_tbl_number,
1692: x_results IN OUT NOCOPY po_validation_results_type,
1693: x_result_type OUT NOCOPY VARCHAR2)
1694: IS
1695: d_mod CONSTANT VARCHAR2(100) := d_receive_close_tolerance;
1696: BEGIN

Line 1698: x_results := po_validation_results_type.new_instance();

1694: IS
1695: d_mod CONSTANT VARCHAR2(100) := d_receive_close_tolerance;
1696: BEGIN
1697: IF (x_results IS NULL) THEN
1698: x_results := po_validation_results_type.new_instance();
1699: END IF;
1700:
1701: x_result_type := po_validations.c_result_type_success;
1702:

Line 1815: x_results IN OUT NOCOPY po_validation_results_type,

1811: -------------------------------------------------------------------------
1812: PROCEDURE accrue_on_receipt_flag(
1813: p_id_tbl IN po_tbl_number,
1814: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
1815: x_results IN OUT NOCOPY po_validation_results_type,
1816: x_result_type OUT NOCOPY VARCHAR2)
1817: IS
1818: d_mod CONSTANT VARCHAR2(100) := d_accrue_on_receipt_flag;
1819: BEGIN

Line 1821: x_results := po_validation_results_type.new_instance();

1817: IS
1818: d_mod CONSTANT VARCHAR2(100) := d_accrue_on_receipt_flag;
1819: BEGIN
1820: IF (x_results IS NULL) THEN
1821: x_results := po_validation_results_type.new_instance();
1822: END IF;
1823:
1824: x_result_type := po_validations.c_result_type_success;
1825:

Line 1866: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

1862: p_advance_tbl IN PO_TBL_NUMBER,
1863: p_amount_tbl IN PO_TBL_NUMBER,
1864: p_quantity_tbl IN PO_TBL_NUMBER,
1865: p_price_tbl IN PO_TBL_NUMBER,
1866: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1867: x_result_type OUT NOCOPY VARCHAR2)
1868: IS
1869: d_mod CONSTANT VARCHAR2(100) := d_advance_amt_le_amt;
1870: BEGIN

Line 1872: x_results := po_validation_results_type.new_instance();

1868: IS
1869: d_mod CONSTANT VARCHAR2(100) := d_advance_amt_le_amt;
1870: BEGIN
1871: IF (x_results IS NULL) THEN
1872: x_results := po_validation_results_type.new_instance();
1873: END IF;
1874:
1875: x_result_type := po_validations.c_result_type_success;
1876:

Line 2342: x_results IN OUT NOCOPY po_validation_results_type,

2338: -------------------------------------------------------------------------
2339: PROCEDURE price_break(
2340: p_id_tbl IN po_tbl_number,
2341: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
2342: x_results IN OUT NOCOPY po_validation_results_type,
2343: x_result_type OUT NOCOPY VARCHAR2)
2344: IS
2345: d_mod CONSTANT VARCHAR2(100) := d_price_break;
2346: BEGIN

Line 2348: x_results := po_validation_results_type.new_instance();

2344: IS
2345: d_mod CONSTANT VARCHAR2(100) := d_price_break;
2346: BEGIN
2347: IF (x_results IS NULL) THEN
2348: x_results := po_validation_results_type.new_instance();
2349: END IF;
2350:
2351: x_result_type := po_validations.c_result_type_success;
2352: