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_DIFFS2 dependencies on PO_TBL_NUMBER

Line 25: p_id_tbl IN po_tbl_number,

21: -------------------------------------------------------------------------
22: -- Price type cannot be NULL and must be valid in PO_PRICE_DIFF_LOOKUPS_V
23: -------------------------------------------------------------------------
24: PROCEDURE price_type(
25: p_id_tbl IN po_tbl_number,
26: p_price_type_tbl IN po_tbl_varchar30,
27: x_result_set_id IN OUT NOCOPY NUMBER,
28: x_result_type OUT NOCOPY VARCHAR2)
29: IS

Line 97: p_id_tbl IN po_tbl_number,

93: -------------------------------------------------------------------------
94: -- Multiple price differential records of the same type for a line/price break record are not allowed.
95: -------------------------------------------------------------------------
96: PROCEDURE multiple_price_diff(
97: p_id_tbl IN po_tbl_number,
98: p_price_type_tbl IN po_tbl_varchar30,
99: p_entity_type_tbl IN po_tbl_varchar30,
100: p_entity_id_tbl IN PO_TBL_NUMBER,
101: x_result_set_id IN OUT NOCOPY NUMBER,

Line 100: p_entity_id_tbl IN PO_TBL_NUMBER,

96: PROCEDURE multiple_price_diff(
97: p_id_tbl IN po_tbl_number,
98: p_price_type_tbl IN po_tbl_varchar30,
99: p_entity_type_tbl IN po_tbl_varchar30,
100: p_entity_id_tbl IN PO_TBL_NUMBER,
101: x_result_set_id IN OUT NOCOPY NUMBER,
102: x_result_type OUT NOCOPY VARCHAR2)
103: IS
104: d_mod CONSTANT VARCHAR2(100) := d_multiple_price_diff;

Line 214: p_id_tbl IN po_tbl_number,

210: -- Validate price differential is tied to a valid entity type for
211: -- different document type
212: -------------------------------------------------------------------------
213: PROCEDURE entity_type(
214: p_id_tbl IN po_tbl_number,
215: p_entity_type_tbl IN po_tbl_varchar30,
216: p_doc_type IN VARCHAR2,
217: x_results IN OUT NOCOPY po_validation_results_type,
218: x_result_type OUT NOCOPY VARCHAR2)

Line 269: p_id_tbl IN po_tbl_number,

265: -- If the entity type is BLANKET LINE or PRICE BREAK, the multiplier column
266: -- must be null.
267: -------------------------------------------------------------------------
268: PROCEDURE multiplier(
269: p_id_tbl IN po_tbl_number,
270: p_entity_type_tbl IN po_tbl_varchar30,
271: p_multiplier_tbl IN po_tbl_number,
272: x_results IN OUT NOCOPY po_validation_results_type,
273: x_result_type OUT NOCOPY VARCHAR2)

Line 271: p_multiplier_tbl IN po_tbl_number,

267: -------------------------------------------------------------------------
268: PROCEDURE multiplier(
269: p_id_tbl IN po_tbl_number,
270: p_entity_type_tbl IN po_tbl_varchar30,
271: p_multiplier_tbl IN po_tbl_number,
272: x_results IN OUT NOCOPY po_validation_results_type,
273: x_result_type OUT NOCOPY VARCHAR2)
274: IS
275: d_mod CONSTANT VARCHAR2(100) := d_multiplier;

Line 329: p_id_tbl IN po_tbl_number,

325: -- If the entity type is BLANKET LINE or PRICE BREAK, the min multiplier column
326: -- must not be null.
327: -------------------------------------------------------------------------
328: PROCEDURE min_multiplier(
329: p_id_tbl IN po_tbl_number,
330: p_entity_type_tbl IN po_tbl_varchar30,
331: p_min_multiplier_tbl IN po_tbl_number,
332: x_results IN OUT NOCOPY po_validation_results_type,
333: x_result_type OUT NOCOPY VARCHAR2)

Line 331: p_min_multiplier_tbl IN po_tbl_number,

327: -------------------------------------------------------------------------
328: PROCEDURE min_multiplier(
329: p_id_tbl IN po_tbl_number,
330: p_entity_type_tbl IN po_tbl_varchar30,
331: p_min_multiplier_tbl IN po_tbl_number,
332: x_results IN OUT NOCOPY po_validation_results_type,
333: x_result_type OUT NOCOPY VARCHAR2)
334: IS
335: d_mod CONSTANT VARCHAR2(100) := d_min_multiplier;

Line 389: p_id_tbl IN po_tbl_number,

385: -- If the entity type is BLANKET LINE or PRICE BREAK, the multiplier column
386: -- must not be null.
387: -------------------------------------------------------------------------
388: PROCEDURE max_multiplier(
389: p_id_tbl IN po_tbl_number,
390: p_entity_type_tbl IN po_tbl_varchar30,
391: p_max_multiplier_tbl IN po_tbl_number,
392: x_results IN OUT NOCOPY po_validation_results_type,
393: x_result_type OUT NOCOPY VARCHAR2)

Line 391: p_max_multiplier_tbl IN po_tbl_number,

387: -------------------------------------------------------------------------
388: PROCEDURE max_multiplier(
389: p_id_tbl IN po_tbl_number,
390: p_entity_type_tbl IN po_tbl_varchar30,
391: p_max_multiplier_tbl IN po_tbl_number,
392: x_results IN OUT NOCOPY po_validation_results_type,
393: x_result_type OUT NOCOPY VARCHAR2)
394: IS
395: d_mod CONSTANT VARCHAR2(100) := d_max_multiplier;

Line 440: p_id_tbl IN po_tbl_number,

436: -------------------------------------------------------------------------------------
437: -- Validate price_differentials_flag = Y for the given style
438: -------------------------------------------------------------------------------------
439: PROCEDURE style_related_info(
440: p_id_tbl IN po_tbl_number,
441: p_style_id_tbl IN po_tbl_number,
442: x_result_set_id IN OUT NOCOPY NUMBER,
443: x_result_type OUT NOCOPY VARCHAR2)
444: IS

Line 441: p_style_id_tbl IN po_tbl_number,

437: -- Validate price_differentials_flag = Y for the given style
438: -------------------------------------------------------------------------------------
439: PROCEDURE style_related_info(
440: p_id_tbl IN po_tbl_number,
441: p_style_id_tbl IN po_tbl_number,
442: x_result_set_id IN OUT NOCOPY NUMBER,
443: x_result_type OUT NOCOPY VARCHAR2)
444: IS
445: d_mod CONSTANT VARCHAR2(100) := d_style_related_info;