APPS.PO_VAL_PRICE_BREAKS dependencies on PO_TBL_DATE

Line 59: , p_start_date_tbl IN PO_TBL_DATE

55: -- org, ship to loction. If not, return a failure.
56: ------------------------------------------------------------------------------
57: PROCEDURE at_least_one_required_field(
58: p_line_loc_id_tbl IN PO_TBL_NUMBER
59: , p_start_date_tbl IN PO_TBL_DATE
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

Line 60: , p_end_date_tbl IN PO_TBL_DATE

56: ------------------------------------------------------------------------------
57: PROCEDURE at_least_one_required_field(
58: p_line_loc_id_tbl IN PO_TBL_NUMBER
59: , p_start_date_tbl IN PO_TBL_DATE
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

Line 213: , p_start_date_tbl IN PO_TBL_DATE

209: -- the Effective End date.
210: ------------------------------------------------------------------------
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: )

Line 214: , p_end_date_tbl IN PO_TBL_DATE

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

Line 244: , p_blanket_start_date_tbl IN PO_TBL_DATE

240: -- of the Agreement.
241: -----------------------------------------------------------------------------
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: )

Line 245: , p_price_break_start_date_tbl IN PO_TBL_DATE

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

Line 275: , p_blanket_end_date_tbl IN PO_TBL_DATE

271: -- of the Agreement.
272: -----------------------------------------------------------------------------
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: )

Line 276: , p_price_break_start_date_tbl IN PO_TBL_DATE

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

Line 305: , p_expiration_date_tbl IN PO_TBL_DATE

301: -- is less than or equal to the Expiration date of the line.
302: -----------------------------------------------------------------------------
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: )

Line 306: , p_price_break_start_date_tbl IN PO_TBL_DATE

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

Line 335: , p_expiration_date_tbl IN PO_TBL_DATE

331: -- is less than or equal to the Expiration date of the line.
332: -----------------------------------------------------------------------------
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: )

Line 336: , p_price_break_end_date_tbl IN PO_TBL_DATE

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

Line 366: , p_blanket_start_date_tbl IN PO_TBL_DATE

362: -- of the Agreement.
363: -----------------------------------------------------------------------------
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: )

Line 367: , p_price_break_end_date_tbl IN PO_TBL_DATE

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

Line 397: , p_blanket_end_date_tbl IN PO_TBL_DATE

393: -- Agreement.
394: -----------------------------------------------------------------------------
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: )

Line 398: , p_price_break_end_date_tbl IN PO_TBL_DATE

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