[Home] [Help]
PACKAGE: APPS.PO_VAL_LINES
Source
1 PACKAGE PO_VAL_LINES AS
2 -- $Header: PO_VAL_LINES.pls 120.16 2006/11/15 00:11:15 vinokris noship $
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(
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(
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 -- <Complex Work R12 Start>
27 -- Removed: quantity_ge_quantity_billed, quantity_ge_quantity_rcvd,
28 -- Added: quantity_ge_quantity_exec
29 PROCEDURE quantity_ge_quantity_exec(
30 p_line_id_tbl IN PO_TBL_NUMBER
31 , p_quantity_tbl IN PO_TBL_NUMBER
32 , x_result_set_id IN OUT NOCOPY NUMBER
33 , x_result_type OUT NOCOPY VARCHAR2
34 );
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 (
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 (
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
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
66 PROCEDURE max_retain_amt_ge_retained (
67 p_line_id_tbl IN PO_TBL_NUMBER
68 , p_max_retain_amt_tbl IN PO_TBL_NUMBER
69 , x_result_set_id IN OUT NOCOPY NUMBER
70 , x_result_type OUT NOCOPY VARCHAR2
71 );
72
73
74 -- <Complex Work R12 End>
75
76 PROCEDURE quantity_ge_quantity_enc(
77 p_line_id_tbl IN PO_TBL_NUMBER
78 , p_quantity_tbl IN PO_TBL_NUMBER
79 , x_result_set_id IN OUT NOCOPY NUMBER
80 , x_result_type OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE quantity_notif_change(
84 p_line_id_tbl IN PO_TBL_NUMBER
85 , p_quantity_tbl IN PO_TBL_NUMBER
86 , x_result_set_id IN OUT NOCOPY NUMBER
87 , x_result_type OUT NOCOPY VARCHAR2
88 );
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
98 -- <Complex Work R12 Start>
99 -- Removed: amount_ge_amount_billed, amount_ge_amount_rcvd,
100 -- Added: amount_ge_amount_exec
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
110 -- <Complex Work R12 End>
111
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(
121 p_line_id_tbl IN PO_TBL_NUMBER
122 , p_header_id_tbl IN PO_TBL_NUMBER
123 , p_line_num_tbl IN PO_TBL_NUMBER
124 , x_result_set_id IN OUT NOCOPY NUMBER
125 , x_result_type OUT NOCOPY VARCHAR2
126 );
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(
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
142 , x_result_set_id IN OUT NOCOPY NUMBER
143 , x_result_type OUT NOCOPY VARCHAR2
144 );
145
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(
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(
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(
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(
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(
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(
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(
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(
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 -- <Complex Work R12 Start>
216
217 PROCEDURE qty_ge_qty_milestone_exec(
218 p_line_id_tbl IN PO_TBL_NUMBER
219 , p_quantity_tbl IN PO_TBL_NUMBER
220 , x_result_set_id IN OUT NOCOPY NUMBER
221 , x_result_type OUT NOCOPY VARCHAR2
222 );
223
224 PROCEDURE price_ge_price_milestone_exec(
225 p_line_id_tbl IN PO_TBL_NUMBER
226 , p_price_tbl IN PO_TBL_NUMBER
227 , x_result_set_id IN OUT NOCOPY NUMBER
228 , x_result_type OUT NOCOPY VARCHAR2
229 );
230
231 -- Bug 5070210 Start
232 PROCEDURE advance_amt_le_amt(
233 p_line_id_tbl IN PO_TBL_NUMBER
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 -- <Complex Work R12 End>
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
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(
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(
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
274 );
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
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(
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(
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(
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 (
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
324 );
325 -- OPM Integration R12 End
326
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;