eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_PRICE_BREAKS dependencies on PO_TBL_NUMBER

Line 58: p_line_loc_id_tbl IN PO_TBL_NUMBER

54: -- the following fields is filled out: start date, end date, quantity, ship to
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

Line 61: , p_quantity_tbl IN PO_TBL_NUMBER

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
65: , x_result_type OUT NOCOPY VARCHAR2

Line 62: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

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
65: , x_result_type OUT NOCOPY VARCHAR2
66: )

Line 63: , p_ship_to_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
65: , x_result_type OUT NOCOPY VARCHAR2
66: )
67: IS

Line 130: p_line_loc_id_tbl IN PO_TBL_NUMBER

126: -- This procedure determines if Price Discounts is a number between 0 and 100.
127: -- If not, return a failure.
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: )

Line 131: , p_price_discount_tbl IN PO_TBL_NUMBER

127: -- If not, return a failure.
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

Line 157: p_line_loc_id_tbl IN PO_TBL_NUMBER

153: -- This procedure determines if Price Override('Break Price') is greater
154: -- than zero. If not, return a failure.
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: )

Line 158: , p_price_override_tbl IN PO_TBL_NUMBER

154: -- than zero. If not, return a failure.
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

Line 184: p_line_loc_id_tbl IN PO_TBL_NUMBER

180: -- This procedure determines if Quantity is greater than or equal to zero.
181: -- If not, return a failure.
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: )

Line 185: , p_quantity_tbl IN PO_TBL_NUMBER

181: -- If not, return a failure.
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

Line 212: p_line_loc_id_tbl IN PO_TBL_NUMBER

208: -- Validates that the Effective From date is less than or equal to
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

Line 243: p_line_loc_id_tbl IN PO_TBL_NUMBER

239: -- is greater than or equal to the Effective From 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

Line 274: p_line_loc_id_tbl IN PO_TBL_NUMBER

270: -- is less than or equal to the Effective To 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

Line 304: p_line_loc_id_tbl IN PO_TBL_NUMBER

300: -- Validates that the Effective From date of the price break
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

Line 334: p_line_loc_id_tbl IN PO_TBL_NUMBER

330: -- Validates that the Effective To date of the price break
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

Line 365: p_line_loc_id_tbl IN PO_TBL_NUMBER

361: -- is greater than or equal to the Effective From 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

Line 396: p_line_loc_id_tbl IN PO_TBL_NUMBER

392: -- is less than or equal to the Effective To date of the
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