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_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: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
23: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
24: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
25: , x_result_type OUT NOCOPY VARCHAR2

Line 23: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes

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: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
23: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
24: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
25: , x_result_type OUT NOCOPY VARCHAR2
26: , p_header_id_tbl IN PO_TBL_NUMBER --
27: );

Line 96: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

92:
93: PROCEDURE amount_gt_zero(
94: p_line_id_tbl IN PO_TBL_NUMBER
95: , p_amount_tbl IN PO_TBL_NUMBER
96: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
97: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
98: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
99: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
100: , x_result_type OUT NOCOPY VARCHAR2

Line 98: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes

94: p_line_id_tbl IN PO_TBL_NUMBER
95: , p_amount_tbl IN PO_TBL_NUMBER
96: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
97: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
98: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
99: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
100: , x_result_type OUT NOCOPY VARCHAR2
101: , p_header_id_tbl IN PO_TBL_NUMBER --
102: );

Line 111: , p_currency_code_tbl IN PO_TBL_VARCHAR30

107:
108: PROCEDURE amount_ge_amount_exec(
109: p_line_id_tbl IN PO_TBL_NUMBER
110: , p_amount_tbl IN PO_TBL_NUMBER
111: , p_currency_code_tbl IN PO_TBL_VARCHAR30
112: , x_result_set_id IN OUT NOCOPY NUMBER
113: , x_result_type OUT NOCOPY VARCHAR2
114: );
115:

Line 145: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

141: );
142:
143: PROCEDURE vmi_asl_exists(
144: p_line_id_tbl IN PO_TBL_NUMBER
145: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
146: , p_item_id_tbl IN PO_TBL_NUMBER
147: , p_org_id_tbl IN PO_TBL_NUMBER
148: , p_vendor_id_tbl IN PO_TBL_NUMBER
149: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

Line 179: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

175:
176: PROCEDURE unit_price_ge_zero(
177: p_line_id_tbl IN PO_TBL_NUMBER
178: , p_unit_price_tbl IN PO_TBL_NUMBER
179: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
180: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
181: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
182: , x_result_type OUT NOCOPY VARCHAR2
183: );

Line 202: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30

198:
199: PROCEDURE validate_unit_price_change(
200: p_line_id_tbl IN PO_TBL_NUMBER
201: , p_unit_price_tbl IN PO_TBL_NUMBER
202: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
203: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1 ----
204: , x_result_set_id IN OUT NOCOPY NUMBER
205: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
206: , x_result_type OUT NOCOPY VARCHAR2

Line 271: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30

267: --
268:
269: PROCEDURE unit_meas_not_null(
270: p_line_id_tbl IN PO_TBL_NUMBER
271: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
272: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
273: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
274: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
275: , x_result_type OUT NOCOPY VARCHAR2

Line 272: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

268:
269: PROCEDURE unit_meas_not_null(
270: p_line_id_tbl IN PO_TBL_NUMBER
271: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
272: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
273: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
274: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
275: , x_result_type OUT NOCOPY VARCHAR2
276: );

Line 296: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

292:
293: PROCEDURE item_id_not_null(
294: p_id_tbl IN PO_TBL_NUMBER
295: , p_item_id_tbl IN PO_TBL_NUMBER
296: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
297: , p_line_type_id_tbl IN PO_TBL_NUMBER
298: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
299: , p_message_name IN VARCHAR2
300: , x_result_set_id IN OUT NOCOPY NUMBER

Line 307: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30

303:
304: PROCEDURE temp_labor_job_id_not_null(
305: p_line_id_tbl IN PO_TBL_NUMBER
306: , p_job_id_tbl IN PO_TBL_NUMBER
307: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
308: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
309: , x_result_type OUT NOCOPY VARCHAR2
310: );
311:

Line 323: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30

319:
320: PROCEDURE temp_lbr_start_date_not_null(
321: p_line_id_tbl IN PO_TBL_NUMBER
322: , p_start_date_tbl IN PO_TBL_DATE
323: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
324: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
325: , x_result_type OUT NOCOPY VARCHAR2
326: );
327:

Line 348: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

344: PROCEDURE line_qtys_within_deviation (
345: p_line_id_tbl IN PO_TBL_NUMBER
346: , p_item_id_tbl IN PO_TBL_NUMBER
347: , p_quantity_tbl IN PO_TBL_NUMBER
348: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
349: , p_sec_quantity_tbl IN PO_TBL_NUMBER
350: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
351: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
352: , x_result_type OUT NOCOPY VARCHAR2

Line 350: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

346: , p_item_id_tbl IN PO_TBL_NUMBER
347: , p_quantity_tbl IN PO_TBL_NUMBER
348: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
349: , p_sec_quantity_tbl IN PO_TBL_NUMBER
350: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
351: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
352: , x_result_type OUT NOCOPY VARCHAR2
353: );
354: -- OPM Integration R12 End

Line 423: ,p_control_action_tbl IN PO_TBL_VARCHAR30

419: -- CLM END
420: -- Mod Project
421: PROCEDURE mod_no_cancel_shp_complt(
422: p_line_id_tbl IN PO_TBL_NUMBER
423: ,p_control_action_tbl IN PO_TBL_VARCHAR30
424: ,x_result_set_id IN OUT NOCOPY NUMBER
425: ,x_result_type OUT NOCOPY VARCHAR2
426: );
427:

Line 542: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

538: );
539:
540: PROCEDURE validate_contract_type(
541: p_intf_line_id_tbl IN PO_TBL_NUMBER
542: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
543: , p_contract_type_tbl IN PO_TBL_VARCHAR240
544: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
545: , x_result_type OUT NOCOPY VARCHAR2
546: );

Line 550: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

546: );
547:
548: PROCEDURE validate_cost_constraint(
549: p_intf_line_id_tbl IN PO_TBL_NUMBER
550: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
551: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
552: , x_result_type OUT NOCOPY VARCHAR2
553: );
554:

Line 622: , p_draft_type_tbl IN PO_TBL_VARCHAR30

618:
619: PROCEDURE validate_comments_not_null(
620: p_line_id_tbl IN PO_TBL_NUMBER
621: , p_draft_id_tbl IN PO_TBL_NUMBER
622: , p_draft_type_tbl IN PO_TBL_VARCHAR30
623: , p_comments_tbl IN PO_TBL_VARCHAR2000
624: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
625: , x_result_type OUT NOCOPY VARCHAR2
626: );

Line 640: p_order_type_lookup_code IN PO_TBL_VARCHAR30,

636: );
637: -- bug 16461105
638: PROCEDURE validate_undef_amt_le_line_amt(
639: p_po_line_id IN PO_TBL_NUMBER,
640: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
641: p_unit_price IN PO_TBL_NUMBER,
642: p_quantity IN PO_TBL_NUMBER,
643: p_old_quantity IN PO_TBL_NUMBER,
644: p_old_unit_price IN PO_TBL_NUMBER,