APPS.PO_VAL_PRICE_DIFFS2 dependencies on PO_PRICE_DIFF_LOOKUPS_V

Line 22: -- Price type cannot be NULL and must be valid in PO_PRICE_DIFF_LOOKUPS_V

18: -- The application name of PO.
19: c_po CONSTANT VARCHAR2(2) := 'PO';
20:
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,

Line 44: -- Price type cannot be Null and must be valid in PO_PRICE_DIFF_LOOKUPS_V

40: po_log.proc_begin(d_mod, 'p_price_type_tbl', p_price_type_tbl);
41: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
42: END IF;
43:
44: -- Price type cannot be Null and must be valid in PO_PRICE_DIFF_LOOKUPS_V
45: FORALL i IN 1 .. p_id_tbl.COUNT
46: INSERT INTO po_validation_results_gt
47: (result_set_id,
48: result_type,

Line 72: FROM po_price_diff_lookups_v

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
72: FROM po_price_diff_lookups_v
73: WHERE price_differential_type = p_price_type_tbl(i)));
74:
75: IF (SQL%ROWCOUNT > 0) THEN
76: x_result_type := po_validations.c_result_type_failure;