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

Line 10: p_over_tolerance_err_flag_tbl IN po_tbl_varchar30,

6: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
7: -- This method is called only for Standard PO and quotation documents
8: -------------------------------------------------------------------------
9: PROCEDURE over_tolerance_err_flag(p_id_tbl IN po_tbl_number,
10: p_over_tolerance_err_flag_tbl IN po_tbl_varchar30,
11: x_result_set_id IN OUT NOCOPY NUMBER,
12: x_result_type OUT NOCOPY VARCHAR2);
13:
14: -------------------------------------------------------------------------

Line 32: p_purchase_basis_tbl IN po_tbl_varchar30,

28: -- cannot both be 'Y'
29: -------------------------------------------------------------------------
30: PROCEDURE global_agreement_flag(p_id_tbl IN po_tbl_number,
31: p_global_agreement_flag_tbl IN po_tbl_varchar1,
32: p_purchase_basis_tbl IN po_tbl_varchar30,
33: p_line_type_id_tbl IN PO_TBL_NUMBER,
34: x_result_set_id IN OUT NOCOPY NUMBER,
35: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
36: x_result_type OUT NOCOPY VARCHAR2);

Line 42: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

38: -------------------------------------------------------------------------
39: -- If order_type_lookup_code is 'RATE', amount has to be null
40: -------------------------------------------------------------------------
41: PROCEDURE amount_blanket(p_id_tbl IN po_tbl_number,
42: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
43: p_amount_tbl IN po_tbl_number,
44: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
45: x_result_type OUT NOCOPY VARCHAR2);
46:

Line 52: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

48: -- If services procurement is not enabled, the order_type_lookup_code cannot
49: -- be 'FIXED PRICE' or 'RATE'.
50: -------------------------------------------------------------------------
51: PROCEDURE order_type_lookup_code(p_id_tbl IN po_tbl_number,
52: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
53: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
54: x_result_type OUT NOCOPY VARCHAR2);
55:
56: -------------------------------------------------------------------------

Line 62: p_purchase_basis_tbl IN po_tbl_varchar30,

58: -- contractor first name and last name fields should be empty
59: -------------------------------------------------------------------------
60: PROCEDURE contractor_name(p_id_tbl IN po_tbl_number,
61: p_doc_type IN VARCHAR2,
62: p_purchase_basis_tbl IN po_tbl_varchar30,
63: p_contractor_last_name_tbl IN po_tbl_varchar2000,
64: p_contractor_first_name_tbl IN po_tbl_varchar2000,
65: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
66: x_result_type OUT NOCOPY VARCHAR2);

Line 74: p_purchase_basis_tbl IN po_tbl_varchar30,

70: -------------------------------------------------------------------------
71: PROCEDURE job_id(p_id_tbl IN po_tbl_number,
72: p_job_id_tbl IN po_tbl_number,
73: p_job_business_group_id_tbl IN po_tbl_number,
74: p_purchase_basis_tbl IN po_tbl_varchar30,
75: p_category_id_tbl IN po_tbl_number,
76: x_result_set_id IN OUT NOCOPY NUMBER,
77: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
78: x_result_type OUT NOCOPY VARCHAR2);

Line 87: p_purchase_basis_tbl IN po_tbl_varchar30,

83: -------------------------------------------------------------------------
84: PROCEDURE job_business_group_id(p_id_tbl IN po_tbl_number,
85: p_job_id_tbl IN po_tbl_number,
86: p_job_business_group_id_tbl IN po_tbl_number,
87: p_purchase_basis_tbl IN po_tbl_varchar30,
88: x_result_set_id IN OUT NOCOPY NUMBER,
89: x_result_type OUT NOCOPY VARCHAR2);
90:
91: -------------------------------------------------------------------------

Line 95: p_purchase_basis_tbl IN po_tbl_varchar30,

91: -------------------------------------------------------------------------
92: -- If purchase_basis = 'TEMP LABOR', then capital_expense_flag cannot = 'Y'
93: -------------------------------------------------------------------------
94: PROCEDURE capital_expense_flag(p_id_tbl IN po_tbl_number,
95: p_purchase_basis_tbl IN po_tbl_varchar30,
96: p_capital_expense_flag_tbl IN po_tbl_varchar1,
97: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
98: x_result_type OUT NOCOPY VARCHAR2);
99:

Line 104: p_purchase_basis_tbl IN po_tbl_varchar30,

100: -------------------------------------------------------------------------
101: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
102: -------------------------------------------------------------------------
103: PROCEDURE un_number_id(p_id_tbl IN po_tbl_number,
104: p_purchase_basis_tbl IN po_tbl_varchar30,
105: p_un_number_id_tbl IN po_tbl_number,
106: x_result_set_id IN OUT NOCOPY NUMBER,
107: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
108: x_result_type OUT NOCOPY VARCHAR2);

Line 114: p_purchase_basis_tbl IN po_tbl_varchar30,

110: -------------------------------------------------------------------------
111: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
112: -------------------------------------------------------------------------
113: PROCEDURE hazard_class_id(p_id_tbl IN po_tbl_number,
114: p_purchase_basis_tbl IN po_tbl_varchar30,
115: p_hazard_class_id_tbl IN po_tbl_number,
116: x_result_set_id IN OUT NOCOPY NUMBER,
117: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
118: x_result_type OUT NOCOPY VARCHAR2);

Line 125: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

121: -- If order_type_lookup_code is 'FIXED PRICE', 'RATE', or 'AMOUNT', item_id has to be null
122: -------------------------------------------------------------------------
123: PROCEDURE item_id(p_id_tbl IN po_tbl_number,
124: p_item_id_tbl IN po_tbl_number,
125: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
126: p_line_type_id_tbl IN po_tbl_number,
127: p_inventory_org_id IN NUMBER,
128: x_result_set_id IN OUT NOCOPY NUMBER,
129: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 139: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

135: -- allow_item_desc_update_flag is N.
136: -------------------------------------------------------------------------
137: PROCEDURE item_description(p_id_tbl IN po_tbl_number,
138: p_item_description_tbl IN po_tbl_varchar2000,
139: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
140: p_item_id_tbl IN po_tbl_number,
141: p_create_or_update_item IN VARCHAR2,
142: p_inventory_org_id IN NUMBER,
143: x_result_set_id IN OUT NOCOPY NUMBER,

Line 150: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,

146: -------------------------------------------------------------------------
147: -- check to see if x_item_unit_of_measure is valid in mtl_item_uoms_view
148: -------------------------------------------------------------------------
149: PROCEDURE unit_meas_lookup_code(p_id_tbl IN po_tbl_number,
150: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
151: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
152: p_item_id_tbl IN po_tbl_number,
153: p_line_type_id_tbl IN po_tbl_number,
154: p_inventory_org_id IN NUMBER,

Line 151: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

147: -- check to see if x_item_unit_of_measure is valid in mtl_item_uoms_view
148: -------------------------------------------------------------------------
149: PROCEDURE unit_meas_lookup_code(p_id_tbl IN po_tbl_number,
150: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
151: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
152: p_item_id_tbl IN po_tbl_number,
153: p_line_type_id_tbl IN po_tbl_number,
154: p_inventory_org_id IN NUMBER,
155: x_result_set_id IN OUT NOCOPY NUMBER,

Line 164: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

160: -- if order_type_lookup_code is FIXED PRICE or RATE, or item id is null, then item revision has to be NULL.
161: -- Check to see if there are x_item_revision exists in mtl_item_revisions table
162: -------------------------------------------------------------------------
163: PROCEDURE item_revision(p_id_tbl IN po_tbl_number,
164: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
165: p_item_revision_tbl IN po_tbl_varchar5,
166: p_item_id_tbl IN po_tbl_number,
167: x_result_set_id IN OUT NOCOPY NUMBER,
168: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 179: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

175: -- If No, we will just validate if the category is Enable and Active.
176: -------------------------------------------------------------------------
177: PROCEDURE category_id(p_id_tbl IN po_tbl_number,
178: p_category_id_tbl IN po_tbl_number,
179: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
180: p_item_id_tbl IN po_tbl_number,
181: p_inventory_org_id IN NUMBER,
182: x_result_set_id IN OUT NOCOPY NUMBER,
183: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 205: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

201: --If order_type_lookup_code is 'FIXED PRICE', unit_price has to be null.
202: -------------------------------------------------------------------------
203: PROCEDURE unit_price(p_id_tbl IN po_tbl_number,
204: p_unit_price_tbl IN po_tbl_number,
205: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
206: p_line_type_id_tbl IN po_tbl_number,
207: x_result_set_id IN OUT NOCOPY NUMBER,
208: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
209: x_result_type OUT NOCOPY VARCHAR2);

Line 217: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

213: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', quantity has to be null.
214: -------------------------------------------------------------------------
215: PROCEDURE quantity(p_id_tbl IN po_tbl_number,
216: p_quantity_tbl IN po_tbl_number,
217: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
218: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
219: x_result_type OUT NOCOPY VARCHAR2);
220:
221: -------------------------------------------------------------------------

Line 226: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

222: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', amount has to be null
223: -------------------------------------------------------------------------
224: PROCEDURE amount(p_id_tbl IN po_tbl_number,
225: p_amount_tbl IN po_tbl_number,
226: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
227: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
228: x_result_type OUT NOCOPY VARCHAR2);
229:
230: -------------------------------------------------------------------------

Line 234: p_rate_type_tbl IN po_tbl_varchar30,

230: -------------------------------------------------------------------------
231: -- For rate based temp labor line, the currency rate_type cannot be 'user'
232: -------------------------------------------------------------------------
233: PROCEDURE rate_type(p_id_tbl IN po_tbl_number,
234: p_rate_type_tbl IN po_tbl_varchar30,
235: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
236: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
237: x_result_type OUT NOCOPY VARCHAR2);
238:

Line 235: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

231: -- For rate based temp labor line, the currency rate_type cannot be 'user'
232: -------------------------------------------------------------------------
233: PROCEDURE rate_type(p_id_tbl IN po_tbl_number,
234: p_rate_type_tbl IN po_tbl_varchar30,
235: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
236: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
237: x_result_type OUT NOCOPY VARCHAR2);
238:
239: -------------------------------------------------------------------------

Line 246: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

242: -------------------------------------------------------------------------
243: PROCEDURE line_num(p_id_tbl IN po_tbl_number,
244: p_po_header_id_tbl IN po_tbl_number,
245: p_line_num_tbl IN po_tbl_number,
246: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
247: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug5129752
248: x_result_set_id IN OUT NOCOPY NUMBER,
249: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
250: x_result_type OUT NOCOPY VARCHAR2);

Line 275: p_purchase_basis_tbl IN po_tbl_varchar30,

271: -------------------------------------------------------------------------
272: PROCEDURE style_related_info(p_id_tbl IN po_tbl_number,
273: p_style_id_tbl IN po_tbl_number,
274: p_line_type_id_tbl IN po_tbl_number,
275: p_purchase_basis_tbl IN po_tbl_varchar30,
276: x_result_set_id IN OUT NOCOPY NUMBER,
277: x_result_type OUT NOCOPY VARCHAR2);
278:
279: -------------------------------------------------------------------------

Line 283: p_price_type_lookup_code_tbl IN PO_TBL_VARCHAR30,

279: -------------------------------------------------------------------------
280: -- If price_type_lookup_code is not null, it has to be a valid price type in po_lookup_codes
281: -------------------------------------------------------------------------
282: PROCEDURE price_type_lookup_code(p_id_tbl IN PO_TBL_NUMBER,
283: p_price_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
284: x_result_set_id IN OUT NOCOPY NUMBER,
285: x_result_type OUT NOCOPY VARCHAR2);
286:
287: -------------------------------------------------------------------------

Line 295: p_purchase_basis_tbl IN PO_TBL_VARCHAR30,

291: -------------------------------------------------------------------------
292: PROCEDURE start_date_standard(p_id_tbl IN PO_TBL_NUMBER,
293: p_start_date_tbl IN PO_TBL_DATE,
294: p_expiration_date_tbl IN PO_TBL_DATE,
295: p_purchase_basis_tbl IN PO_TBL_VARCHAR30,
296: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
297: x_result_type OUT NOCOPY VARCHAR2);
298:
299: -------------------------------------------------------------------------

Line 304: p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30,

300: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null, then bom_item_type cannot be 1 or 2.
301: -------------------------------------------------------------------------
302: PROCEDURE item_id_standard(p_id_tbl IN PO_TBL_NUMBER,
303: p_item_id_tbl IN PO_TBL_NUMBER,
304: p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
305: p_inventory_org_id IN NUMBER,
306: x_result_set_id IN OUT NOCOPY NUMBER,
307: x_result_type OUT NOCOPY VARCHAR2);
308:

Line 315: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

311: -- And quantity cannot be empty for SPO if order type is QUANTITY/AMOUNT
312: -------------------------------------------------------------------------
313: PROCEDURE quantity_standard(p_id_tbl IN PO_TBL_NUMBER,
314: p_quantity_tbl IN PO_TBL_NUMBER,
315: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
316: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
317: x_result_type OUT NOCOPY VARCHAR2);
318:
319: -------------------------------------------------------------------------

Line 324: p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30,

320: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null
321: -------------------------------------------------------------------------
322: PROCEDURE amount_standard(p_id_tbl IN PO_TBL_NUMBER,
323: p_amount_tbl IN PO_TBL_NUMBER,
324: p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
325: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
326: x_result_type OUT NOCOPY VARCHAR2);
327:
328: -- bug5016163 START

Line 334: p_price_break_lookup_code_tbl IN po_tbl_varchar30,

330: -- Price break lookup code should be valid
331: -------------------------------------------------------------------------
332: PROCEDURE price_break_lookup_code(
333: p_id_tbl IN po_tbl_number,
334: p_price_break_lookup_code_tbl IN po_tbl_varchar30,
335: p_global_agreement_flag_tbl IN po_tbl_varchar1,
336: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
337: p_purchase_basis_tbl IN po_tbl_varchar30,
338: x_result_set_id IN OUT NOCOPY NUMBER,

Line 336: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

332: PROCEDURE price_break_lookup_code(
333: p_id_tbl IN po_tbl_number,
334: p_price_break_lookup_code_tbl IN po_tbl_varchar30,
335: p_global_agreement_flag_tbl IN po_tbl_varchar1,
336: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
337: p_purchase_basis_tbl IN po_tbl_varchar30,
338: x_result_set_id IN OUT NOCOPY NUMBER,
339: x_results IN OUT NOCOPY po_validation_results_type,
340: x_result_type OUT NOCOPY VARCHAR2);

Line 337: p_purchase_basis_tbl IN po_tbl_varchar30,

333: p_id_tbl IN po_tbl_number,
334: p_price_break_lookup_code_tbl IN po_tbl_varchar30,
335: p_global_agreement_flag_tbl IN po_tbl_varchar1,
336: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
337: p_purchase_basis_tbl IN po_tbl_varchar30,
338: x_result_set_id IN OUT NOCOPY NUMBER,
339: x_results IN OUT NOCOPY po_validation_results_type,
340: x_result_type OUT NOCOPY VARCHAR2);
341:

Line 369: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,

365: -----------------------------------------------------------------------------
366: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v
367: -----------------------------------------------------------------------------
368: PROCEDURE uom_update(p_id_tbl IN po_tbl_number,
369: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
370: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
371: p_po_header_id_tbl IN po_tbl_number,
372: p_po_line_id_tbl IN po_tbl_number,
373: x_results IN OUT NOCOPY po_validation_results_type,

Line 370: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

366: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v
367: -----------------------------------------------------------------------------
368: PROCEDURE uom_update(p_id_tbl IN po_tbl_number,
369: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,
370: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
371: p_po_header_id_tbl IN po_tbl_number,
372: p_po_line_id_tbl IN po_tbl_number,
373: x_results IN OUT NOCOPY po_validation_results_type,
374: x_result_set_id IN OUT NOCOPY NUMBER,

Line 418: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

414: PROCEDURE category_id_update(
415: p_id_tbl IN po_tbl_number,
416: p_category_id_tbl IN po_tbl_number,
417: p_po_line_id_tbl IN po_tbl_number,
418: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
419: p_item_id_tbl IN po_tbl_number,
420: p_job_id_tbl IN po_tbl_number,
421: p_inventory_org_id IN NUMBER,
422: x_result_set_id IN OUT NOCOPY NUMBER,