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_VAL_CONSTANTS

Line 66: DECODE(p_price_type_tbl(i), NULL, PO_VAL_CONSTANTS.c_price_type_not_null,

62: 'PRICE_TYPE',
63: p_price_type_tbl(i),
64: 'PRICE_TYPE',
65: p_price_type_tbl(i),
66: DECODE(p_price_type_tbl(i), NULL, PO_VAL_CONSTANTS.c_price_type_not_null,
67: PO_VAL_CONSTANTS.c_price_type_valid)
68: FROM DUAL
69: WHERE p_price_type_tbl(i) IS NULL
70: OR(p_price_type_tbl(i) IS NOT NULL AND

Line 67: PO_VAL_CONSTANTS.c_price_type_valid)

63: p_price_type_tbl(i),
64: 'PRICE_TYPE',
65: p_price_type_tbl(i),
66: DECODE(p_price_type_tbl(i), NULL, PO_VAL_CONSTANTS.c_price_type_not_null,
67: PO_VAL_CONSTANTS.c_price_type_valid)
68: FROM DUAL
69: WHERE p_price_type_tbl(i) IS NULL
70: OR(p_price_type_tbl(i) IS NOT NULL AND
71: NOT EXISTS(SELECT 1

Line 161: PO_VAL_CONSTANTS.c_multiple_price_diff

157: 'PRICE_TYPE',
158: p_price_type_tbl(i),
159: NULL,
160: NULL,
161: PO_VAL_CONSTANTS.c_multiple_price_diff
162: FROM DUAL
163: WHERE p_price_type_tbl(i) IS NOT NULL
164: AND p_entity_type_tbl(i) IS NOT NULL
165: AND p_entity_id_tbl(i) IS NOT NULL

Line 245: p_validation_id => PO_VAL_CONSTANTS.c_entity_type);

241: p_entity_id => p_id_tbl(i),
242: p_column_name => 'ENTITY_TYPE',
243: p_column_val => p_entity_type_tbl(i),
244: p_message_name => 'PO_PDOI_SVC_INVALID_ENT_TYPE',
245: p_validation_id => PO_VAL_CONSTANTS.c_entity_type);
246: x_result_type := po_validations.c_result_type_failure;
247: END IF;
248: END LOOP;
249:

Line 297: p_validation_id => PO_VAL_CONSTANTS.c_multiplier_not_null);

293: p_entity_id => p_id_tbl(i),
294: p_column_name => 'MUTLIPLIER',
295: p_column_val => p_multiplier_tbl(i),
296: p_message_name => 'PO_PDOI_SVC_MUST_MULTIPLIER',
297: p_validation_id => PO_VAL_CONSTANTS.c_multiplier_not_null);
298: x_result_type := po_validations.c_result_type_failure;
299: ELSIF p_entity_type_tbl(i) IN('BLANKET LINE', 'PRICE BREAK') AND p_multiplier_tbl(i) IS NOT NULL THEN
300: x_results.add_result(p_entity_type => c_entity_type_price_diff,
301: p_entity_id => p_id_tbl(i),

Line 305: p_validation_id => PO_VAL_CONSTANTS.c_multiplier_null);

301: p_entity_id => p_id_tbl(i),
302: p_column_name => 'MULTIPLIER',
303: p_column_val => p_multiplier_tbl(i),
304: p_message_name => 'PO_PDOI_SVC_NO_MULTIPLIER',
305: p_validation_id => PO_VAL_CONSTANTS.c_multiplier_null);
306: x_result_type := po_validations.c_result_type_failure;
307: END IF;
308: END LOOP;
309:

Line 357: p_validation_id => PO_VAL_CONSTANTS.c_min_multiplier_null);

353: p_entity_id => p_id_tbl(i),
354: p_column_name => 'MIN_MULTIPLIER',
355: p_column_val => p_min_multiplier_tbl(i),
356: p_message_name => 'PO_PDOI_SVC_NO_MIN_MULT',
357: p_validation_id => PO_VAL_CONSTANTS.c_min_multiplier_null);
358: x_result_type := po_validations.c_result_type_failure;
359: ELSIF p_entity_type_tbl(i) IN('BLANKET LINE', 'PRICE BREAK') AND p_min_multiplier_tbl(i) IS NULL THEN
360: x_results.add_result(p_entity_type => c_entity_type_price_diff,
361: p_entity_id => p_id_tbl(i),

Line 365: p_validation_id => PO_VAL_CONSTANTS.c_min_multiplier_not_null);

361: p_entity_id => p_id_tbl(i),
362: p_column_name => 'MIN_MULTIPLIER',
363: p_column_val => p_min_multiplier_tbl(i),
364: p_message_name => 'PO_PDOI_SVC_MUST_MIN_MULT',
365: p_validation_id => PO_VAL_CONSTANTS.c_min_multiplier_not_null);
366: x_result_type := po_validations.c_result_type_failure;
367: END IF;
368: END LOOP;
369:

Line 417: p_validation_id => PO_VAL_CONSTANTS.c_max_multiplier_null);

413: p_entity_id => p_id_tbl(i),
414: p_column_name => 'MAX_MULTIPLIER',
415: p_column_val => p_max_multiplier_tbl(i),
416: p_message_name => 'PO_PDOI_SVC_NO_MAX_MULT',
417: p_validation_id => PO_VAL_CONSTANTS.c_max_multiplier_null);
418: x_result_type := po_validations.c_result_type_failure;
419: END IF;
420: END LOOP;
421:

Line 482: PO_VAL_CONSTANTS.c_price_diff_style_info

478: 'STYLE_ID',
479: p_style_id_tbl(i),
480: 'STYLE_ID',
481: p_style_id_tbl(i),
482: PO_VAL_CONSTANTS.c_price_diff_style_info
483: FROM DUAL
484: WHERE EXISTS(SELECT 1
485: FROM po_doc_style_headers pdsh
486: WHERE pdsh.style_id = p_style_id_tbl(i) AND