134: )
135: IS
136: BEGIN
137:
138: PO_VALIDATION_HELPER.within_percentage_range(
139: p_calling_module => D_price_discount_in_percent
140: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
141: , p_value_tbl => p_price_discount_tbl
142: , p_entity_id_tbl => p_line_loc_id_tbl
161: )
162: IS
163: BEGIN
164:
165: PO_VALIDATION_HELPER.greater_than_zero(
166: p_calling_module => D_price_override_gt_zero
167: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
168: , p_value_tbl => p_price_override_tbl
169: , p_entity_id_tbl => p_line_loc_id_tbl
188: )
189: IS
190: BEGIN
191:
192: PO_VALIDATION_HELPER.greater_or_equal_zero(
193: p_calling_module => D_quantity_ge_zero
194: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
195: , p_value_tbl => p_quantity_tbl
196: , p_entity_id_tbl => p_line_loc_id_tbl
217: )
218: IS
219: BEGIN
220:
221: PO_VALIDATION_HELPER.start_date_le_end_date(
222: p_calling_module => D_start_date_le_end_date
223: , p_start_date_tbl => p_start_date_tbl
224: , p_end_date_tbl => p_end_date_tbl
225: , p_entity_id_tbl => p_line_loc_id_tbl
248: )
249: IS
250: BEGIN
251:
252: PO_VALIDATION_HELPER.start_date_le_end_date(
253: p_calling_module => D_break_start_ge_blanket_start
254: , p_start_date_tbl => p_blanket_start_date_tbl
255: , p_end_date_tbl => p_price_break_start_date_tbl
256: , p_entity_id_tbl => p_line_loc_id_tbl
255: , p_end_date_tbl => p_price_break_start_date_tbl
256: , p_entity_id_tbl => p_line_loc_id_tbl
257: , p_entity_type => c_entity_type_LINE_LOCATION
258: , p_column_name => c_START_DATE
259: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE
260: , p_message_name => PO_MESSAGE_S.POX_EFFECTIVE_DATES1
261: , x_results => x_results
262: , x_result_type => x_result_type
263: );
279: )
280: IS
281: BEGIN
282:
283: PO_VALIDATION_HELPER.start_date_le_end_date(
284: p_calling_module => D_break_start_le_blanket_end
285: , p_start_date_tbl => p_price_break_start_date_tbl
286: , p_end_date_tbl => p_blanket_end_date_tbl
287: , p_entity_id_tbl => p_line_loc_id_tbl
286: , p_end_date_tbl => p_blanket_end_date_tbl
287: , p_entity_id_tbl => p_line_loc_id_tbl
288: , p_entity_type => c_entity_type_LINE_LOCATION
289: , p_column_name => c_START_DATE
290: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE
291: , p_message_name => PO_MESSAGE_S.POX_EFFECTIVE_DATES4
292: , x_results => x_results
293: , x_result_type => x_result_type
294: );
309: )
310: IS
311: BEGIN
312:
313: PO_VALIDATION_HELPER.start_date_le_end_date(
314: p_calling_module => D_break_start_le_expiration
315: , p_start_date_tbl => p_price_break_start_date_tbl
316: , p_end_date_tbl => p_expiration_date_tbl
317: , p_entity_id_tbl => p_line_loc_id_tbl
316: , p_end_date_tbl => p_expiration_date_tbl
317: , p_entity_id_tbl => p_line_loc_id_tbl
318: , p_entity_type => c_entity_type_LINE_LOCATION
319: , p_column_name => c_START_DATE
320: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE
321: , p_message_name => PO_MESSAGE_S.POX_EFFECTIVE_DATES6
322: , x_results => x_results
323: , x_result_type => x_result_type
324: );
339: )
340: IS
341: BEGIN
342:
343: PO_VALIDATION_HELPER.start_date_le_end_date(
344: p_calling_module => D_break_end_le_expiration
345: , p_start_date_tbl => p_price_break_end_date_tbl
346: , p_end_date_tbl => p_expiration_date_tbl
347: , p_entity_id_tbl => p_line_loc_id_tbl
346: , p_end_date_tbl => p_expiration_date_tbl
347: , p_entity_id_tbl => p_line_loc_id_tbl
348: , p_entity_type => c_entity_type_LINE_LOCATION
349: , p_column_name => c_END_DATE
350: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE
351: , p_message_name => PO_MESSAGE_S.POX_EFFECTIVE_DATES2
352: , x_results => x_results
353: , x_result_type => x_result_type
354: );
370: )
371: IS
372: BEGIN
373:
374: PO_VALIDATION_HELPER.start_date_le_end_date(
375: p_calling_module => D_break_end_ge_blanket_start
376: , p_start_date_tbl => p_blanket_start_date_tbl
377: , p_end_date_tbl => p_price_break_end_date_tbl
378: , p_entity_id_tbl => p_line_loc_id_tbl
377: , p_end_date_tbl => p_price_break_end_date_tbl
378: , p_entity_id_tbl => p_line_loc_id_tbl
379: , p_entity_type => c_entity_type_LINE_LOCATION
380: , p_column_name => c_END_DATE
381: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE
382: , p_message_name => PO_MESSAGE_S.POX_EFFECTIVE_DATES5
383: , x_results => x_results
384: , x_result_type => x_result_type
385: );
401: )
402: IS
403: BEGIN
404:
405: PO_VALIDATION_HELPER.start_date_le_end_date(
406: p_calling_module => D_break_end_le_blanket_end
407: , p_start_date_tbl => p_price_break_end_date_tbl
408: , p_end_date_tbl => p_blanket_end_date_tbl
409: , p_entity_id_tbl => p_line_loc_id_tbl
408: , p_end_date_tbl => p_blanket_end_date_tbl
409: , p_entity_id_tbl => p_line_loc_id_tbl
410: , p_entity_type => c_entity_type_LINE_LOCATION
411: , p_column_name => c_END_DATE
412: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE
413: , p_message_name => PO_MESSAGE_S.POX_EFFECTIVE_DATES
414: , x_results => x_results
415: , x_result_type => x_result_type
416: );