DBA Data[Home] [Help]

APPS.PO_VAL_LINES dependencies on PO_VALIDATION_RESULTS_TYPE

Line 7: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

3:
4: PROCEDURE amt_agreed_ge_zero(
5: p_line_id_tbl IN PO_TBL_NUMBER
6: , p_committed_amount_tbl IN PO_TBL_NUMBER
7: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8: , x_result_type OUT NOCOPY VARCHAR2
9: );
10:
11: PROCEDURE min_rel_amt_ge_zero(

Line 14: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

10:
11: PROCEDURE min_rel_amt_ge_zero(
12: p_line_id_tbl IN PO_TBL_NUMBER
13: , p_min_release_amount_tbl IN PO_TBL_NUMBER
14: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
15: , x_result_type OUT NOCOPY VARCHAR2
16: );
17:
18: PROCEDURE quantity_gt_zero(

Line 22: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 39: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

35:
36: PROCEDURE recoupment_rate_range_check (
37: p_line_id_tbl IN PO_TBL_NUMBER
38: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
39: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
40: , x_result_type OUT NOCOPY VARCHAR2
41: );
42:
43: PROCEDURE retainage_rate_range_check (

Line 46: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

42:
43: PROCEDURE retainage_rate_range_check (
44: p_line_id_tbl IN PO_TBL_NUMBER
45: , p_retainage_rate_tbl IN PO_TBL_NUMBER
46: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
47: , x_result_type OUT NOCOPY VARCHAR2
48: );
49:
50: PROCEDURE prog_pay_rate_range_check (

Line 53: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

49:
50: PROCEDURE prog_pay_rate_range_check (
51: p_line_id_tbl IN PO_TBL_NUMBER
52: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
53: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
54: , x_result_type OUT NOCOPY VARCHAR2
55: );
56:
57: --Bug 5221843

Line 61: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

57: --Bug 5221843
58: PROCEDURE max_retain_amt_ge_zero (
59: p_line_id_tbl IN PO_TBL_NUMBER
60: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
61: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
62: , x_result_type OUT NOCOPY VARCHAR2
63: );
64:
65: --Bug 5453079

Line 94: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 116: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

112:
113: PROCEDURE amount_ge_timecard(
114: p_line_id_tbl IN PO_TBL_NUMBER
115: , p_amount_tbl IN PO_TBL_NUMBER
116: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
117: , x_result_type OUT NOCOPY VARCHAR2
118: );
119:
120: PROCEDURE line_num_unique(

Line 131: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

127:
128: PROCEDURE line_num_gt_zero(
129: p_line_id_tbl IN PO_TBL_NUMBER
130: , p_line_num_tbl IN PO_TBL_NUMBER
131: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
132: , x_result_type OUT NOCOPY VARCHAR2
133: );
134:
135: PROCEDURE vmi_asl_exists(

Line 150: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

146: PROCEDURE start_date_le_end_date(
147: p_line_id_tbl IN PO_TBL_NUMBER
148: , p_start_date_tbl IN PO_TBL_DATE
149: , p_expiration_date_tbl IN PO_TBL_DATE
150: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
151: , x_result_type OUT NOCOPY VARCHAR2
152: );
153:
154: PROCEDURE otl_invalid_start_date_change(

Line 157: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

153:
154: PROCEDURE otl_invalid_start_date_change(
155: p_line_id_tbl IN PO_TBL_NUMBER
156: , p_start_date_tbl IN PO_TBL_DATE
157: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
158: , x_result_type OUT NOCOPY VARCHAR2
159: );
160:
161: PROCEDURE otl_invalid_end_date_change(

Line 164: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

160:
161: PROCEDURE otl_invalid_end_date_change(
162: p_line_id_tbl IN PO_TBL_NUMBER
163: , p_expiration_date_tbl IN PO_TBL_DATE
164: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
165: , x_result_type OUT NOCOPY VARCHAR2
166: );
167:
168: PROCEDURE unit_price_ge_zero(

Line 172: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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:
176: PROCEDURE list_price_ge_zero(

Line 179: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

175:
176: PROCEDURE list_price_ge_zero(
177: p_line_id_tbl IN PO_TBL_NUMBER
178: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
179: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
180: , x_result_type OUT NOCOPY VARCHAR2
181: );
182:
183: PROCEDURE market_price_ge_zero(

Line 186: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

182:
183: PROCEDURE market_price_ge_zero(
184: p_line_id_tbl IN PO_TBL_NUMBER
185: , p_market_price_tbl IN PO_TBL_NUMBER
186: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
187: , x_result_type OUT NOCOPY VARCHAR2
188: );
189:
190: PROCEDURE validate_unit_price_change(

Line 195: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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: );
198:
199: PROCEDURE expiration_ge_blanket_start(

Line 203: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

199: PROCEDURE expiration_ge_blanket_start(
200: p_line_id_tbl IN PO_TBL_NUMBER
201: , p_blanket_start_date_tbl IN PO_TBL_DATE
202: , p_expiration_date_tbl IN PO_TBL_DATE
203: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
204: , x_result_type OUT NOCOPY VARCHAR2
205: );
206:
207: PROCEDURE expiration_le_blanket_end(

Line 211: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

207: PROCEDURE expiration_le_blanket_end(
208: p_line_id_tbl IN PO_TBL_NUMBER
209: , p_blanket_end_date_tbl IN PO_TBL_DATE
210: , p_expiration_date_tbl IN PO_TBL_DATE
211: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
212: , x_result_type OUT NOCOPY VARCHAR2
213: );
214:
215: --

Line 238: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

234: , p_advance_tbl IN PO_TBL_NUMBER
235: , p_amount_tbl IN PO_TBL_NUMBER
236: , p_quantity_tbl IN PO_TBL_NUMBER
237: , p_price_tbl IN PO_TBL_NUMBER
238: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
239: , x_result_type OUT NOCOPY VARCHAR2
240: );
241: -- Bug 5070210 End
242: --

Line 248: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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:
252: PROCEDURE item_description_not_null(

Line 255: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

251:
252: PROCEDURE item_description_not_null(
253: p_line_id_tbl IN PO_TBL_NUMBER
254: , p_item_description_tbl IN PO_TBL_VARCHAR2000
255: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
256: , x_result_type OUT NOCOPY VARCHAR2
257: );
258:
259: PROCEDURE category_id_not_null(

Line 262: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

258:
259: PROCEDURE category_id_not_null(
260: p_line_id_tbl IN PO_TBL_NUMBER
261: , p_category_id_tbl IN PO_TBL_NUMBER
262: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
263: , x_result_type OUT NOCOPY VARCHAR2
264: );
265:
266: PROCEDURE item_id_not_null(

Line 280: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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:
284: PROCEDURE line_type_id_not_null(

Line 287: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

283:
284: PROCEDURE line_type_id_not_null(
285: p_line_id_tbl IN PO_TBL_NUMBER
286: , p_line_type_id_tbl IN PO_TBL_NUMBER
287: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
288: , x_result_type OUT NOCOPY VARCHAR2
289: );
290:
291: PROCEDURE temp_lbr_start_date_not_null(

Line 295: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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:
299: PROCEDURE src_doc_line_not_null(

Line 303: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

299: PROCEDURE src_doc_line_not_null(
300: p_line_id_tbl IN PO_TBL_NUMBER
301: , p_from_header_id_tbl IN PO_TBL_NUMBER
302: , p_from_line_id_tbl IN PO_TBL_NUMBER
303: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
304: , x_result_type OUT NOCOPY VARCHAR2
305: );
306: -- OPM Integration R12 Start
307: PROCEDURE line_sec_quantity_gt_zero(

Line 311: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

307: PROCEDURE line_sec_quantity_gt_zero(
308: p_line_id_tbl IN PO_TBL_NUMBER
309: , p_item_id_tbl IN PO_TBL_NUMBER
310: , p_sec_quantity_tbl IN PO_TBL_NUMBER
311: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
312: , x_result_type OUT NOCOPY VARCHAR2
313: );
314:
315: PROCEDURE line_qtys_within_deviation (

Line 322: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

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

Line 331: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

327: PROCEDURE from_line_id_not_null (
328: p_line_id_tbl IN PO_TBL_NUMBER
329: , p_from_header_id_tbl IN PO_TBL_NUMBER
330: , p_from_line_id_tbl IN PO_TBL_NUMBER
331: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
332: , x_result_type OUT NOCOPY VARCHAR2
333: );
334:
335: END PO_VAL_LINES;