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_SHIPMENTS2 dependencies on PO_TBL_VARCHAR30

Line 47: p_purchase_basis_tbl IN po_tbl_varchar30,

43: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
44: -------------------------------------------------------------------------
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

Line 98: p_purchase_basis_tbl IN po_tbl_varchar30,

94: -- if purchase_basis is 'TEMP LABOR', the promised_date must be null
95: -------------------------------------------------------------------------
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

Line 149: p_shipment_type_tbl IN po_tbl_varchar30,

145: -- validate shipment type
146: -------------------------------------------------------------------------
147: PROCEDURE shipment_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)

Line 221: p_payment_type_tbl IN po_tbl_varchar30,

217: PROCEDURE payment_type(
218: p_id_tbl IN po_tbl_number,
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

Line 222: p_shipment_type_tbl IN po_tbl_varchar30,

218: p_id_tbl IN po_tbl_number,
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;

Line 431: p_shipment_type_tbl IN po_tbl_varchar30,

427: -------------------------------------------------------------------------
428: PROCEDURE shipment_num(
429: p_id_tbl IN po_tbl_number,
430: p_shipment_num_tbl IN po_tbl_number,
431: p_shipment_type_tbl IN po_tbl_varchar30,
432: p_po_header_id_tbl IN po_tbl_number,
433: p_po_line_id_tbl IN po_tbl_number,
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

Line 571: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

567: -------------------------------------------------------------------------
568: PROCEDURE quantity(
569: p_id_tbl IN po_tbl_number,
570: p_quantity_tbl IN po_tbl_number,
571: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
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

Line 572: p_shipment_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project

568: PROCEDURE quantity(
569: p_id_tbl IN po_tbl_number,
570: p_quantity_tbl IN po_tbl_number,
571: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
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,

Line 574: p_payment_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project

570: p_quantity_tbl IN po_tbl_number,
571: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
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

Line 671: p_shipment_type_tbl IN po_tbl_varchar30,

667: -------------------------------------------------------------------------
668: PROCEDURE amount(
669: p_id_tbl IN po_tbl_number,
670: p_amount_tbl IN po_tbl_number,
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,

Line 673: p_payment_type_tbl IN po_tbl_varchar30,

669: p_id_tbl IN po_tbl_number,
670: p_amount_tbl IN po_tbl_number,
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

Line 738: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

734: -------------------------------------------------------------------------
735: PROCEDURE price_override(
736: p_id_tbl IN po_tbl_number,
737: p_price_override_tbl IN po_tbl_number,
738: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
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

Line 739: p_shipment_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project

735: PROCEDURE price_override(
736: p_id_tbl IN po_tbl_number,
737: p_price_override_tbl IN po_tbl_number,
738: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
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,

Line 741: p_payment_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project

737: p_price_override_tbl IN po_tbl_number,
738: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
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

Line 836: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

832: PROCEDURE price_discount(
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;

Line 1171: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163

1167: p_to_date_tbl IN po_tbl_date,
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;

Line 1345: p_qty_rcv_exception_code_tbl IN po_tbl_varchar30,

1341: -- validate qty_rcv_exception_code against PO_LOOKUP_CODES
1342: -------------------------------------------------------------------------
1343: PROCEDURE qty_rcv_exception_code(
1344: p_id_tbl IN po_tbl_number,
1345: p_qty_rcv_exception_code_tbl IN po_tbl_varchar30,
1346: x_result_set_id IN OUT NOCOPY NUMBER,
1347: x_result_type OUT NOCOPY VARCHAR2)
1348: IS
1349: d_mod CONSTANT VARCHAR2(100) := d_qty_rcv_exception_code;

Line 1420: p_enforce_ship_to_loc_code_tbl IN po_tbl_varchar30,

1416: -- to NONE, REJECT or WARNING
1417: -------------------------------------------------------------------------
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

Line 1421: p_shipment_type_tbl IN po_tbl_varchar30,

1417: -------------------------------------------------------------------------
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;

Line 1475: p_shipment_type_tbl IN po_tbl_varchar30,

1471: -- to NONE, REJECT or WARNING
1472: -------------------------------------------------------------------------
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

Line 1528: p_shipment_type_tbl IN po_tbl_varchar30,

1524: -- and less than zero.
1525: -------------------------------------------------------------------------
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

Line 1582: p_shipment_type_tbl IN po_tbl_varchar30,

1578: -- and not 'NONE', 'REJECT' not 'WARNING'
1579: -------------------------------------------------------------------------
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

Line 1583: p_rcpt_days_exception_code_tbl IN po_tbl_varchar30,

1579: -------------------------------------------------------------------------
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;

Line 1636: p_shipment_type_tbl IN po_tbl_varchar30,

1632: -- and less than or equal to zero or greater than or equal to 100.
1633: -------------------------------------------------------------------------
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

Line 1690: p_shipment_type_tbl IN po_tbl_varchar30,

1686: -- and less than or equal to zero or greater than or equal to 100.
1687: -------------------------------------------------------------------------
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

Line 1743: p_shipment_type_tbl IN po_tbl_varchar30,

1739: -- Validate that receiving routing id exists in rcv_routing_headers
1740: -------------------------------------------------------------------------
1741: PROCEDURE receiving_routing_id(
1742: p_id_tbl IN po_tbl_number,
1743: p_shipment_type_tbl IN po_tbl_varchar30,
1744: p_receiving_routing_id_tbl IN po_tbl_number,
1745: x_result_set_id IN OUT NOCOPY NUMBER,
1746: x_result_type OUT NOCOPY VARCHAR2)
1747: IS

Line 1861: p_payment_type_tbl IN PO_TBL_VARCHAR30,

1857: -- PDOI for Complex PO Project: Validate advance amount at shipment.
1858: -------------------------------------------------------------------------
1859: PROCEDURE advance_amt_le_amt(
1860: p_id_tbl IN PO_TBL_NUMBER,
1861: p_payment_type_tbl IN PO_TBL_VARCHAR30,
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,

Line 1994: p_tax_name_tbl IN po_tbl_varchar30,

1990: -- then tax_code_id and tax_name must be a valid combination in zx_id_tcc_mapping
1991: -------------------------------------------------------------------------
1992: PROCEDURE tax_name(
1993: p_id_tbl IN po_tbl_number,
1994: p_tax_name_tbl IN po_tbl_varchar30,
1995: p_tax_code_id_tbl IN po_tbl_number,
1996: p_need_by_date_tbl IN po_tbl_date,
1997: p_allow_tax_code_override IN VARCHAR2,
1998: p_operating_unit IN NUMBER,

Line 2124: p_fob_lookup_code_tbl IN po_tbl_varchar30,

2120: -------------------------------------------------------------------------
2121: -- fob_lookup_code must be valid in PO_LOOKUP_CODES
2122: -------------------------------------------------------------------------
2123: PROCEDURE fob_lookup_code(p_id_tbl IN po_tbl_number,
2124: p_fob_lookup_code_tbl IN po_tbl_varchar30,
2125: x_result_set_id IN OUT NOCOPY NUMBER,
2126: x_result_type OUT NOCOPY VARCHAR2)
2127: IS
2128: d_mod CONSTANT VARCHAR2(100) := d_fob_lookup_code;

Line 2195: p_freight_terms_tbl IN po_tbl_varchar30,

2191: -------------------------------------------------------------------------
2192: -- freight_terms must be valid in PO_LOOKUP_CODES
2193: -------------------------------------------------------------------------
2194: PROCEDURE freight_terms(p_id_tbl IN po_tbl_number,
2195: p_freight_terms_tbl IN po_tbl_varchar30,
2196: x_result_set_id IN OUT NOCOPY NUMBER,
2197: x_result_type OUT NOCOPY VARCHAR2)
2198: IS
2199: d_mod CONSTANT VARCHAR2(100) := d_freight_terms;

Line 2266: p_freight_carrier_tbl IN po_tbl_varchar30,

2262: -------------------------------------------------------------------------
2263: -- freight_carrier must be valid in ORG_FREIGHT
2264: -------------------------------------------------------------------------
2265: PROCEDURE freight_carrier(p_id_tbl IN po_tbl_number,
2266: p_freight_carrier_tbl IN po_tbl_varchar30,
2267: p_inventory_org_id IN NUMBER,
2268: x_result_set_id IN OUT NOCOPY NUMBER,
2269: x_result_type OUT NOCOPY VARCHAR2)
2270: IS

Line 2341: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

2337: -- Blanket Purchase Agreement.
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;