DBA Data[Home] [Help]

APPS.PO_VAL_PRICE_BREAKS dependencies on PO_VALIDATION_HELPER

Line 138: PO_VALIDATION_HELPER.within_percentage_range(

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

Line 165: PO_VALIDATION_HELPER.greater_than_zero(

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

Line 192: PO_VALIDATION_HELPER.greater_or_equal_zero(

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

Line 221: PO_VALIDATION_HELPER.start_date_le_end_date(

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

Line 252: PO_VALIDATION_HELPER.start_date_le_end_date(

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

Line 259: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE

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: );

Line 283: PO_VALIDATION_HELPER.start_date_le_end_date(

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

Line 290: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE

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: );

Line 313: PO_VALIDATION_HELPER.start_date_le_end_date(

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

Line 320: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE

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: );

Line 343: PO_VALIDATION_HELPER.start_date_le_end_date(

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

Line 350: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE

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: );

Line 374: PO_VALIDATION_HELPER.start_date_le_end_date(

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

Line 381: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE

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: );

Line 405: PO_VALIDATION_HELPER.start_date_le_end_date(

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

Line 412: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE

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: );