APPS.PO_VAL_PRICE_DIFFS dependencies on PO_TBL_NUMBER

Line 67: p_price_differential_id_tbl IN PO_TBL_NUMBER

63: -- This procedure determines if max mulitipliers are greater than or equal to
64: -- zero. If not, return a failure.
65: -------------------------------------------------------------------------------
66: PROCEDURE max_mul_ge_zero(
67: p_price_differential_id_tbl IN PO_TBL_NUMBER
68: , p_max_multiplier_tbl IN PO_TBL_NUMBER
69: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
70: , x_result_type OUT NOCOPY VARCHAR2
71: )

Line 68: , p_max_multiplier_tbl IN PO_TBL_NUMBER

64: -- zero. If not, return a failure.
65: -------------------------------------------------------------------------------
66: PROCEDURE max_mul_ge_zero(
67: p_price_differential_id_tbl IN PO_TBL_NUMBER
68: , p_max_multiplier_tbl IN PO_TBL_NUMBER
69: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
70: , x_result_type OUT NOCOPY VARCHAR2
71: )
72: IS

Line 94: p_price_differential_id_tbl IN PO_TBL_NUMBER

90: -- This procedure determines if max multiplier is greater than or equal to
91: -- min multiplier. If not, return a failure.
92: -------------------------------------------------------------------------------
93: PROCEDURE max_mul_ge_min_mul(
94: p_price_differential_id_tbl IN PO_TBL_NUMBER
95: , p_min_multiplier_tbl IN PO_TBL_NUMBER
96: , p_max_multiplier_tbl IN PO_TBL_NUMBER
97: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
98: , x_result_type OUT NOCOPY VARCHAR2

Line 95: , p_min_multiplier_tbl IN PO_TBL_NUMBER

91: -- min multiplier. If not, return a failure.
92: -------------------------------------------------------------------------------
93: PROCEDURE max_mul_ge_min_mul(
94: p_price_differential_id_tbl IN PO_TBL_NUMBER
95: , p_min_multiplier_tbl IN PO_TBL_NUMBER
96: , p_max_multiplier_tbl IN PO_TBL_NUMBER
97: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
98: , x_result_type OUT NOCOPY VARCHAR2
99: )

Line 96: , p_max_multiplier_tbl IN PO_TBL_NUMBER

92: -------------------------------------------------------------------------------
93: PROCEDURE max_mul_ge_min_mul(
94: p_price_differential_id_tbl IN PO_TBL_NUMBER
95: , p_min_multiplier_tbl IN PO_TBL_NUMBER
96: , p_max_multiplier_tbl IN PO_TBL_NUMBER
97: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
98: , x_result_type OUT NOCOPY VARCHAR2
99: )
100: IS

Line 122: p_price_differential_id_tbl IN PO_TBL_NUMBER

118: -- This procedure determines if min mulitipliers are greater than or
119: -- equal to zero. If not, return a failure.
120: -------------------------------------------------------------------------------
121: PROCEDURE min_mul_ge_zero(
122: p_price_differential_id_tbl IN PO_TBL_NUMBER
123: , p_min_multiplier_tbl IN PO_TBL_NUMBER
124: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
125: , x_result_type OUT NOCOPY VARCHAR2
126: )

Line 123: , p_min_multiplier_tbl IN PO_TBL_NUMBER

119: -- equal to zero. If not, return a failure.
120: -------------------------------------------------------------------------------
121: PROCEDURE min_mul_ge_zero(
122: p_price_differential_id_tbl IN PO_TBL_NUMBER
123: , p_min_multiplier_tbl IN PO_TBL_NUMBER
124: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
125: , x_result_type OUT NOCOPY VARCHAR2
126: )
127: IS

Line 149: p_price_differential_id_tbl IN PO_TBL_NUMBER

145: -- This procedure determines if mulitipliers are greater than or
146: -- equal to zero. If not, return a failure.
147: -------------------------------------------------------------------------------
148: PROCEDURE mul_ge_zero(
149: p_price_differential_id_tbl IN PO_TBL_NUMBER
150: , p_multiplier_tbl IN PO_TBL_NUMBER
151: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
152: , x_result_type OUT NOCOPY VARCHAR2
153: )

Line 150: , p_multiplier_tbl IN PO_TBL_NUMBER

146: -- equal to zero. If not, return a failure.
147: -------------------------------------------------------------------------------
148: PROCEDURE mul_ge_zero(
149: p_price_differential_id_tbl IN PO_TBL_NUMBER
150: , p_multiplier_tbl IN PO_TBL_NUMBER
151: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
152: , x_result_type OUT NOCOPY VARCHAR2
153: )
154: IS

Line 179: p_price_differential_id_tbl IN PO_TBL_NUMBER

175: -- Assumption:
176: -- All of the unposted data will be passed in
177: -- to this routine in order to get accurate results.
178: PROCEDURE unique_price_diff_num(
179: p_price_differential_id_tbl IN PO_TBL_NUMBER
180: , p_entity_id_tbl IN PO_TBL_NUMBER
181: , p_entity_type_tbl IN PO_TBL_VARCHAR30
182: , p_price_differential_num_tbl IN PO_TBL_NUMBER
183: , x_result_set_id IN OUT NOCOPY NUMBER

Line 180: , p_entity_id_tbl IN PO_TBL_NUMBER

176: -- All of the unposted data will be passed in
177: -- to this routine in order to get accurate results.
178: PROCEDURE unique_price_diff_num(
179: p_price_differential_id_tbl IN PO_TBL_NUMBER
180: , p_entity_id_tbl IN PO_TBL_NUMBER
181: , p_entity_type_tbl IN PO_TBL_VARCHAR30
182: , p_price_differential_num_tbl IN PO_TBL_NUMBER
183: , x_result_set_id IN OUT NOCOPY NUMBER
184: , x_result_type OUT NOCOPY VARCHAR2

Line 182: , p_price_differential_num_tbl IN PO_TBL_NUMBER

178: PROCEDURE unique_price_diff_num(
179: p_price_differential_id_tbl IN PO_TBL_NUMBER
180: , p_entity_id_tbl IN PO_TBL_NUMBER
181: , p_entity_type_tbl IN PO_TBL_VARCHAR30
182: , p_price_differential_num_tbl IN PO_TBL_NUMBER
183: , x_result_set_id IN OUT NOCOPY NUMBER
184: , x_result_type OUT NOCOPY VARCHAR2
185: )
186: IS

Line 208: p_price_differential_id_tbl IN PO_TBL_NUMBER

204: -- This procedure determines if price differential number are greater than
205: -- zero. If not, return a failure.
206: -------------------------------------------------------------------------------
207: PROCEDURE price_diff_num_gt_zero(
208: p_price_differential_id_tbl IN PO_TBL_NUMBER
209: , p_price_differential_num_tbl IN PO_TBL_NUMBER
210: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
211: , x_result_type OUT NOCOPY VARCHAR2
212: )

Line 209: , p_price_differential_num_tbl IN PO_TBL_NUMBER

205: -- zero. If not, return a failure.
206: -------------------------------------------------------------------------------
207: PROCEDURE price_diff_num_gt_zero(
208: p_price_differential_id_tbl IN PO_TBL_NUMBER
209: , p_price_differential_num_tbl IN PO_TBL_NUMBER
210: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
211: , x_result_type OUT NOCOPY VARCHAR2
212: )
213: IS

Line 238: p_price_differential_id_tbl IN PO_TBL_NUMBER

234: -- Assumption:
235: -- All of the unposted data will be passed in
236: -- to this routine in order to get accurate results.
237: PROCEDURE unique_price_type(
238: p_price_differential_id_tbl IN PO_TBL_NUMBER
239: , p_entity_id_tbl IN PO_TBL_NUMBER
240: , p_entity_type_tbl IN PO_TBL_VARCHAR30
241: , p_price_type_tbl IN PO_TBL_VARCHAR30
242: , x_result_set_id IN OUT NOCOPY NUMBER

Line 239: , p_entity_id_tbl IN PO_TBL_NUMBER

235: -- All of the unposted data will be passed in
236: -- to this routine in order to get accurate results.
237: PROCEDURE unique_price_type(
238: p_price_differential_id_tbl IN PO_TBL_NUMBER
239: , p_entity_id_tbl IN PO_TBL_NUMBER
240: , p_entity_type_tbl IN PO_TBL_VARCHAR30
241: , p_price_type_tbl IN PO_TBL_VARCHAR30
242: , x_result_set_id IN OUT NOCOPY NUMBER
243: , x_result_type OUT NOCOPY VARCHAR2

Line 268: p_price_differential_id_tbl IN PO_TBL_NUMBER

264: -- price type on the referenced BPA line or price break.
265: -- If not, return a failure.
266: -------------------------------------------------------------------------------
267: PROCEDURE spo_price_type_on_src_doc(
268: p_price_differential_id_tbl IN PO_TBL_NUMBER
269: , p_entity_type_tbl IN PO_TBL_VARCHAR30
270: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
271: , p_from_line_id_tbl IN PO_TBL_NUMBER
272: , p_price_type_tbl IN PO_TBL_VARCHAR30

Line 270: , p_from_line_location_id_tbl IN PO_TBL_NUMBER

266: -------------------------------------------------------------------------------
267: PROCEDURE spo_price_type_on_src_doc(
268: p_price_differential_id_tbl IN PO_TBL_NUMBER
269: , p_entity_type_tbl IN PO_TBL_VARCHAR30
270: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
271: , p_from_line_id_tbl IN PO_TBL_NUMBER
272: , p_price_type_tbl IN PO_TBL_VARCHAR30
273: , x_result_set_id IN OUT NOCOPY NUMBER
274: , x_result_type OUT NOCOPY VARCHAR2

Line 271: , p_from_line_id_tbl IN PO_TBL_NUMBER

267: PROCEDURE spo_price_type_on_src_doc(
268: p_price_differential_id_tbl IN PO_TBL_NUMBER
269: , p_entity_type_tbl IN PO_TBL_VARCHAR30
270: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
271: , p_from_line_id_tbl IN PO_TBL_NUMBER
272: , p_price_type_tbl IN PO_TBL_VARCHAR30
273: , x_result_set_id IN OUT NOCOPY NUMBER
274: , x_result_type OUT NOCOPY VARCHAR2
275: )

Line 353: p_price_differential_id_tbl IN PO_TBL_NUMBER

349: -- the min and max multiplier specified on the price differential of the
350: -- referenced BPA line or price break. If not, return a failure.
351: -------------------------------------------------------------------------------
352: PROCEDURE spo_mul_btwn_min_max(
353: p_price_differential_id_tbl IN PO_TBL_NUMBER
354: , p_entity_type_tbl IN PO_TBL_VARCHAR30
355: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
356: , p_from_line_id_tbl IN PO_TBL_NUMBER
357: , p_multiplier_tbl IN PO_TBL_NUMBER

Line 355: , p_from_line_location_id_tbl IN PO_TBL_NUMBER

351: -------------------------------------------------------------------------------
352: PROCEDURE spo_mul_btwn_min_max(
353: p_price_differential_id_tbl IN PO_TBL_NUMBER
354: , p_entity_type_tbl IN PO_TBL_VARCHAR30
355: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
356: , p_from_line_id_tbl IN PO_TBL_NUMBER
357: , p_multiplier_tbl IN PO_TBL_NUMBER
358: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
359: , x_result_set_id IN OUT NOCOPY NUMBER

Line 356: , p_from_line_id_tbl IN PO_TBL_NUMBER

352: PROCEDURE spo_mul_btwn_min_max(
353: p_price_differential_id_tbl IN PO_TBL_NUMBER
354: , p_entity_type_tbl IN PO_TBL_VARCHAR30
355: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
356: , p_from_line_id_tbl IN PO_TBL_NUMBER
357: , p_multiplier_tbl IN PO_TBL_NUMBER
358: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
359: , x_result_set_id IN OUT NOCOPY NUMBER
360: , x_result_type OUT NOCOPY VARCHAR2

Line 357: , p_multiplier_tbl IN PO_TBL_NUMBER

353: p_price_differential_id_tbl IN PO_TBL_NUMBER
354: , p_entity_type_tbl IN PO_TBL_VARCHAR30
355: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
356: , p_from_line_id_tbl IN PO_TBL_NUMBER
357: , p_multiplier_tbl IN PO_TBL_NUMBER
358: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
359: , x_result_set_id IN OUT NOCOPY NUMBER
360: , x_result_type OUT NOCOPY VARCHAR2
361: )

Line 450: p_price_differential_id_tbl IN PO_TBL_NUMBER

446: -- BPA line or price break (when the max multiplier is null).
447: -- If not, return a failure.
448: -------------------------------------------------------------------------------
449: PROCEDURE spo_mul_ge_min(
450: p_price_differential_id_tbl IN PO_TBL_NUMBER
451: , p_entity_type_tbl IN PO_TBL_VARCHAR30
452: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
453: , p_from_line_id_tbl IN PO_TBL_NUMBER
454: , p_multiplier_tbl IN PO_TBL_NUMBER

Line 452: , p_from_line_location_id_tbl IN PO_TBL_NUMBER

448: -------------------------------------------------------------------------------
449: PROCEDURE spo_mul_ge_min(
450: p_price_differential_id_tbl IN PO_TBL_NUMBER
451: , p_entity_type_tbl IN PO_TBL_VARCHAR30
452: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
453: , p_from_line_id_tbl IN PO_TBL_NUMBER
454: , p_multiplier_tbl IN PO_TBL_NUMBER
455: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
456: , x_result_set_id IN OUT NOCOPY NUMBER

Line 453: , p_from_line_id_tbl IN PO_TBL_NUMBER

449: PROCEDURE spo_mul_ge_min(
450: p_price_differential_id_tbl IN PO_TBL_NUMBER
451: , p_entity_type_tbl IN PO_TBL_VARCHAR30
452: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
453: , p_from_line_id_tbl IN PO_TBL_NUMBER
454: , p_multiplier_tbl IN PO_TBL_NUMBER
455: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
456: , x_result_set_id IN OUT NOCOPY NUMBER
457: , x_result_type OUT NOCOPY VARCHAR2

Line 454: , p_multiplier_tbl IN PO_TBL_NUMBER

450: p_price_differential_id_tbl IN PO_TBL_NUMBER
451: , p_entity_type_tbl IN PO_TBL_VARCHAR30
452: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
453: , p_from_line_id_tbl IN PO_TBL_NUMBER
454: , p_multiplier_tbl IN PO_TBL_NUMBER
455: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
456: , x_result_set_id IN OUT NOCOPY NUMBER
457: , x_result_type OUT NOCOPY VARCHAR2
458: )