APPS.PO_VAL_LINES dependencies on PO_TBL_VARCHAR30

Line 21: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

17:
18: PROCEDURE quantity_gt_zero(
19: p_line_id_tbl IN PO_TBL_NUMBER
20: , p_quantity_tbl IN PO_TBL_NUMBER
21: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
22: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
23: , x_result_type OUT NOCOPY VARCHAR2
24: );
25:

Line 93: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

89:
90: PROCEDURE amount_gt_zero(
91: p_line_id_tbl IN PO_TBL_NUMBER
92: , p_amount_tbl IN PO_TBL_NUMBER
93: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
94: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
95: , x_result_type OUT NOCOPY VARCHAR2
96: );
97:

Line 105: , p_currency_code_tbl IN PO_TBL_VARCHAR30

101:
102: PROCEDURE amount_ge_amount_exec(
103: p_line_id_tbl IN PO_TBL_NUMBER
104: , p_amount_tbl IN PO_TBL_NUMBER
105: , p_currency_code_tbl IN PO_TBL_VARCHAR30
106: , x_result_set_id IN OUT NOCOPY NUMBER
107: , x_result_type OUT NOCOPY VARCHAR2
108: );
109:

Line 137: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

133: );
134:
135: PROCEDURE vmi_asl_exists(
136: p_line_id_tbl IN PO_TBL_NUMBER
137: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
138: , p_item_id_tbl IN PO_TBL_NUMBER
139: , p_org_id_tbl IN PO_TBL_NUMBER
140: , p_vendor_id_tbl IN PO_TBL_NUMBER
141: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

Line 171: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

167:
168: PROCEDURE unit_price_ge_zero(
169: p_line_id_tbl IN PO_TBL_NUMBER
170: , p_unit_price_tbl IN PO_TBL_NUMBER
171: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
172: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
173: , x_result_type OUT NOCOPY VARCHAR2
174: );
175:

Line 193: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30

189:
190: PROCEDURE validate_unit_price_change(
191: p_line_id_tbl IN PO_TBL_NUMBER
192: , p_unit_price_tbl IN PO_TBL_NUMBER
193: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
194: , x_result_set_id IN OUT NOCOPY NUMBER
195: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
196: , x_result_type OUT NOCOPY VARCHAR2
197: );

Line 246: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30

242: --
243:
244: PROCEDURE unit_meas_not_null(
245: p_line_id_tbl IN PO_TBL_NUMBER
246: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
247: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
248: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
249: , x_result_type OUT NOCOPY VARCHAR2
250: );

Line 247: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

243:
244: PROCEDURE unit_meas_not_null(
245: p_line_id_tbl IN PO_TBL_NUMBER
246: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
247: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
248: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
249: , x_result_type OUT NOCOPY VARCHAR2
250: );
251:

Line 269: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

265:
266: PROCEDURE item_id_not_null(
267: p_id_tbl IN PO_TBL_NUMBER
268: , p_item_id_tbl IN PO_TBL_NUMBER
269: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
270: , p_line_type_id_tbl IN PO_TBL_NUMBER
271: , p_message_name IN VARCHAR2
272: , x_result_set_id IN OUT NOCOPY NUMBER
273: , x_result_type OUT NOCOPY VARCHAR2

Line 279: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30

275:
276: PROCEDURE temp_labor_job_id_not_null(
277: p_line_id_tbl IN PO_TBL_NUMBER
278: , p_job_id_tbl IN PO_TBL_NUMBER
279: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
280: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
281: , x_result_type OUT NOCOPY VARCHAR2
282: );
283:

Line 294: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30

290:
291: PROCEDURE temp_lbr_start_date_not_null(
292: p_line_id_tbl IN PO_TBL_NUMBER
293: , p_start_date_tbl IN PO_TBL_DATE
294: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
295: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
296: , x_result_type OUT NOCOPY VARCHAR2
297: );
298:

Line 319: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

315: PROCEDURE line_qtys_within_deviation (
316: p_line_id_tbl IN PO_TBL_NUMBER
317: , p_item_id_tbl IN PO_TBL_NUMBER
318: , p_quantity_tbl IN PO_TBL_NUMBER
319: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
320: , p_sec_quantity_tbl IN PO_TBL_NUMBER
321: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
322: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
323: , x_result_type OUT NOCOPY VARCHAR2

Line 321: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

317: , p_item_id_tbl IN PO_TBL_NUMBER
318: , p_quantity_tbl IN PO_TBL_NUMBER
319: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
320: , p_sec_quantity_tbl IN PO_TBL_NUMBER
321: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
322: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
323: , x_result_type OUT NOCOPY VARCHAR2
324: );
325: -- OPM Integration R12 End