60: , p_end_date_tbl IN PO_TBL_DATE
61: , p_quantity_tbl IN PO_TBL_NUMBER
62: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
63: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
64: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
65: , x_result_type OUT NOCOPY VARCHAR2
66: )
67: IS
68: d_mod CONSTANT VARCHAR2(100) := D_at_least_one_required_field;
79: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
80: END IF;
81:
82: IF (x_results IS NULL) THEN
83: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
84: END IF;
85:
86: l_results_count := x_results.result_type.COUNT;
87:
128: -------------------------------------------------------------------------------
129: PROCEDURE price_discount_in_percent(
130: p_line_loc_id_tbl IN PO_TBL_NUMBER
131: , p_price_discount_tbl IN PO_TBL_NUMBER
132: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
133: , x_result_type OUT NOCOPY VARCHAR2
134: )
135: IS
136: BEGIN
155: -------------------------------------------------------------------------------
156: PROCEDURE price_override_gt_zero(
157: p_line_loc_id_tbl IN PO_TBL_NUMBER
158: , p_price_override_tbl IN PO_TBL_NUMBER
159: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
160: , x_result_type OUT NOCOPY VARCHAR2
161: )
162: IS
163: BEGIN
182: -------------------------------------------------------------------------------
183: PROCEDURE quantity_ge_zero(
184: p_line_loc_id_tbl IN PO_TBL_NUMBER
185: , p_quantity_tbl IN PO_TBL_NUMBER
186: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
187: , x_result_type OUT NOCOPY VARCHAR2
188: )
189: IS
190: BEGIN
211: PROCEDURE start_date_le_end_date(
212: p_line_loc_id_tbl IN PO_TBL_NUMBER
213: , p_start_date_tbl IN PO_TBL_DATE
214: , p_end_date_tbl IN PO_TBL_DATE
215: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
216: , x_result_type OUT NOCOPY VARCHAR2
217: )
218: IS
219: BEGIN
242: PROCEDURE break_start_ge_blanket_start(
243: p_line_loc_id_tbl IN PO_TBL_NUMBER
244: , p_blanket_start_date_tbl IN PO_TBL_DATE
245: , p_price_break_start_date_tbl IN PO_TBL_DATE
246: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
247: , x_result_type OUT NOCOPY VARCHAR2
248: )
249: IS
250: BEGIN
273: PROCEDURE break_start_le_blanket_end(
274: p_line_loc_id_tbl IN PO_TBL_NUMBER
275: , p_blanket_end_date_tbl IN PO_TBL_DATE
276: , p_price_break_start_date_tbl IN PO_TBL_DATE
277: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
278: , x_result_type OUT NOCOPY VARCHAR2
279: )
280: IS
281: BEGIN
303: PROCEDURE break_start_le_expiration(
304: p_line_loc_id_tbl IN PO_TBL_NUMBER
305: , p_expiration_date_tbl IN PO_TBL_DATE
306: , p_price_break_start_date_tbl IN PO_TBL_DATE
307: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
308: , x_result_type OUT NOCOPY VARCHAR2
309: )
310: IS
311: BEGIN
333: PROCEDURE break_end_le_expiration(
334: p_line_loc_id_tbl IN PO_TBL_NUMBER
335: , p_expiration_date_tbl IN PO_TBL_DATE
336: , p_price_break_end_date_tbl IN PO_TBL_DATE
337: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
338: , x_result_type OUT NOCOPY VARCHAR2
339: )
340: IS
341: BEGIN
364: PROCEDURE break_end_ge_blanket_start(
365: p_line_loc_id_tbl IN PO_TBL_NUMBER
366: , p_blanket_start_date_tbl IN PO_TBL_DATE
367: , p_price_break_end_date_tbl IN PO_TBL_DATE
368: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
369: , x_result_type OUT NOCOPY VARCHAR2
370: )
371: IS
372: BEGIN
395: PROCEDURE break_end_le_blanket_end(
396: p_line_loc_id_tbl IN PO_TBL_NUMBER
397: , p_blanket_end_date_tbl IN PO_TBL_DATE
398: , p_price_break_end_date_tbl IN PO_TBL_DATE
399: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
400: , x_result_type OUT NOCOPY VARCHAR2
401: )
402: IS
403: BEGIN