APPS.PO_VAL_LINES dependencies on PO_TBL_VARCHAR30

Line 227: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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: )
231: IS

Line 542: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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: )
546: IS

Line 579: , p_currency_code_tbl IN PO_TBL_VARCHAR30

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: )
583: IS

Line 959: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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
963: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

Line 1163: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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: )
1167: IS

Line 1288: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30

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
1292: )

Line 1298: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;

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
1302: PO_LOG.proc_begin(d_mod,'p_line_id_tbl',p_line_id_tbl);

Line 1712: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30

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
1716: )

Line 1713: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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
1716: )
1717: IS

Line 1829: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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
1833: , x_result_type OUT NOCOPY VARCHAR2

Line 1935: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30

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: )
1939: IS

Line 2084: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30

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
2087: )
2088: IS

Line 2211: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

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
2215: , x_result_type OUT NOCOPY VARCHAR2

Line 2213: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

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: )
2217: IS