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_VALIDATION_RESULTS_TYPE

Line 22: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

18: PROCEDURE expiration_date_blanket(p_id_tbl IN po_tbl_number,
19: p_expiration_date_tbl IN po_tbl_date,
20: p_header_start_date_tbl IN po_tbl_date,
21: p_header_end_date_tbl IN po_tbl_date,
22: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
23: x_result_type OUT NOCOPY VARCHAR2);
24:
25: -------------------------------------------------------------------------
26: -- For blanket document with purchase type 'TEMP LABOR', the global agreement

Line 35: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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);
37:
38: -------------------------------------------------------------------------
39: -- If order_type_lookup_code is 'RATE', amount has to be null

Line 44: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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:
47: -------------------------------------------------------------------------
48: -- If services procurement is not enabled, the order_type_lookup_code cannot

Line 53: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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: -------------------------------------------------------------------------
57: -- If purchase basis is not 'TEMP LABOR' or document type is not STANDARD ,

Line 65: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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);
67:
68: -------------------------------------------------------------------------
69: -- If purchase basis is TEMP LABOR, then job id must be null

Line 77: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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);
79:
80: -------------------------------------------------------------------------
81: -- If services procurement not enabled, order_type_lookup_code cannot be

Line 97: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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:
100: -------------------------------------------------------------------------
101: -- If purchase_basis = 'TEMP LABOR', then un_number must be null

Line 107: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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);
109:
110: -------------------------------------------------------------------------
111: -- If purchase_basis = 'TEMP LABOR', then un_number must be null

Line 117: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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);
119:
120: -------------------------------------------------------------------------
121: -- If order_type_lookup_code is 'FIXED PRICE', 'RATE', or 'AMOUNT', item_id has to be null

Line 129: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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,
130: x_result_type OUT NOCOPY VARCHAR2);
131:
132: -------------------------------------------------------------------------
133: -- Make sure that the item_description is populated, and also need to find out if it is different

Line 156: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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,
156: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
157: x_result_type OUT NOCOPY VARCHAR2);
158:
159: -------------------------------------------------------------------------
160: -- if order_type_lookup_code is FIXED PRICE or RATE, or item id is null, then item revision has to be NULL.

Line 168: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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,
169: x_result_type OUT NOCOPY VARCHAR2);
170:
171: -------------------------------------------------------------------------
172: -- validate and make sure category_id is a valid category within the default category set for Purchasing.

Line 183: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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,
184: x_result_type OUT NOCOPY VARCHAR2);
185:
186: -------------------------------------------------------------------------
187: -- Validate ip_category_id is not empty for Blanket and Quotation;

Line 194: x_results IN OUT NOCOPY po_validation_results_type,

190: PROCEDURE ip_category_id(
191: p_id_tbl IN po_tbl_number,
192: p_ip_category_id_tbl IN po_tbl_number,
193: x_result_set_id IN OUT NOCOPY NUMBER,
194: x_results IN OUT NOCOPY po_validation_results_type,
195: x_result_type OUT NOCOPY VARCHAR2);
196:
197: -------------------------------------------------------------------------
198: --If order_type_lookup_code is not 'FIXED PRICE', unit_price cannot be null and cannot be less than zero.

Line 208: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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);
210:
211: -------------------------------------------------------------------------
212: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', quantity cannot be less than zero

Line 218: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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: -------------------------------------------------------------------------
222: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', amount has to be null

Line 227: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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: -------------------------------------------------------------------------
231: -- For rate based temp labor line, the currency rate_type cannot be 'user'

Line 236: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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: -------------------------------------------------------------------------
240: -- Line num must be populated and cannot be <= 0.

Line 249: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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);
251:
252: -------------------------------------------------------------------------
253: -- Po_line_id must be populated and unique.

Line 296: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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: -------------------------------------------------------------------------
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.

Line 316: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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: -------------------------------------------------------------------------
320: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null

Line 325: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

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
329: -------------------------------------------------------------------------

Line 339: x_results IN OUT NOCOPY po_validation_results_type,

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:
342: -- bug5016163 END
343:

Line 352: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

348: PROCEDURE not_to_exceed_price(p_id_tbl IN PO_TBL_NUMBER,
349: p_not_to_exceed_price_tbl IN PO_TBL_NUMBER,
350: p_allow_price_override_tbl IN PO_TBL_VARCHAR1,
351: p_unit_price_tbl IN PO_TBL_NUMBER,
352: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
353: x_result_type OUT NOCOPY VARCHAR2);
354:
355: -------------------------------------------------------------------------
356: -- Validate ip_category_id is valid if not empty

Line 362: x_results IN OUT NOCOPY po_validation_results_type,

358: PROCEDURE ip_category_id_update(
359: p_id_tbl IN po_tbl_number,
360: p_ip_category_id_tbl IN po_tbl_number,
361: x_result_set_id IN OUT NOCOPY NUMBER,
362: x_results IN OUT NOCOPY po_validation_results_type,
363: x_result_type OUT NOCOPY VARCHAR2);
364:
365: -----------------------------------------------------------------------------
366: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v

Line 373: x_results IN OUT NOCOPY po_validation_results_type,

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,
375: x_result_type OUT NOCOPY VARCHAR2);
376:
377: -------------------------------------------------------------------------

Line 388: x_results IN OUT NOCOPY po_validation_results_type,

384: p_item_id_tbl IN po_tbl_number,
385: p_inventory_org_id IN NUMBER,
386: p_po_header_id_tbl IN po_tbl_number,
387: p_po_line_id_tbl IN po_tbl_number,
388: x_results IN OUT NOCOPY po_validation_results_type,
389: x_result_set_id IN OUT NOCOPY NUMBER,
390: x_result_type OUT NOCOPY VARCHAR2);
391:
392: ----------------------------------------------------------------------------------------

Line 398: x_results IN OUT NOCOPY po_validation_results_type,

394: ----------------------------------------------------------------------------------------
395: PROCEDURE negotiated_by_preparer(
396: p_id_tbl IN po_tbl_number,
397: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
398: x_results IN OUT NOCOPY po_validation_results_type,
399: x_result_type OUT NOCOPY VARCHAR2);
400:
401: --------------------------------------------------------------------------------------
402: -- Called in update case for Blanket, negotiated_by_preparer must be NULL, 'Y' or 'N'.

Line 407: x_results IN OUT NOCOPY po_validation_results_type,

403: --------------------------------------------------------------------------------------
404: PROCEDURE negotiated_by_prep_update(
405: p_id_tbl IN po_tbl_number,
406: p_negotiated_by_preparer_tbl IN po_tbl_varchar1,
407: x_results IN OUT NOCOPY po_validation_results_type,
408: x_result_type OUT NOCOPY VARCHAR2);
409:
410: -------------------------------------------------------------------------
411: -- If either item_id or job_id are populated, then you are not allowed to change the po_category_id

Line 423: x_results IN OUT NOCOPY po_validation_results_type,

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,
423: x_results IN OUT NOCOPY po_validation_results_type,
424: x_result_type OUT NOCOPY VARCHAR2);
425:
426: -------------------------------------------------------------------------
427: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.

Line 434: x_results IN OUT NOCOPY po_validation_results_type,

430: p_id_tbl IN po_tbl_number,
431: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
432: p_draft_id_tbl IN po_tbl_number, -- bug5258790
433: p_unit_price_tbl IN po_tbl_number,
434: x_results IN OUT NOCOPY po_validation_results_type,
435: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
436: x_result_type OUT NOCOPY VARCHAR2);
437:
438: -- bug5258790 START

Line 444: x_results IN OUT NOCOPY po_validation_results_type,

440: ( p_id_tbl IN po_tbl_number,
441: p_po_line_id_tbl IN po_tbl_number, -- bug5008206
442: p_draft_id_tbl IN po_tbl_number,
443: p_amount_tbl IN po_tbl_number,
444: x_results IN OUT NOCOPY po_validation_results_type,
445: x_result_set_id IN OUT NOCOPY NUMBER, -- bug5008206
446: x_result_type OUT NOCOPY VARCHAR2
447: );
448: -- bug5258790 END