APPS.CZ_PRC_CALLBACK_UTIL dependencies on CZ_PRICING_STRUCTURES

Line 16: INSERT INTO CZ_PRICING_STRUCTURES (configurator_session_key,

12:
13: BEGIN
14:
15: FOR i IN 1..p_pricing_tbl.COUNT LOOP
16: INSERT INTO CZ_PRICING_STRUCTURES (configurator_session_key,
17: seq_nbr,
18: ps_node_id,
19: item_key,
20: item_key_type,

Line 50: l_item_key cz_pricing_structures.item_key%TYPE;

46: p_config_item_id IN NUMBER,
47: p_parent_config_item_id IN NUMBER) IS
48: PRAGMA AUTONOMOUS_TRANSACTION;
49: l_item_key_type NUMBER;
50: l_item_key cz_pricing_structures.item_key%TYPE;
51:
52: BEGIN
53:
54: IF p_item_key IS NULL THEN

Line 62: INSERT INTO cz_pricing_structures (configurator_session_key,

58: l_item_key_type := G_ITEM_KEY_BOM_NODE;
59: l_item_key := p_item_key;
60: END IF;
61:
62: INSERT INTO cz_pricing_structures (configurator_session_key,
63: seq_nbr,
64: ps_node_id, item_key,
65: item_key_type, quantity,
66: uom_code, config_item_id,

Line 80: DELETE FROM CZ_PRICING_STRUCTURES

76:
77: PROCEDURE delete_pricing_recs (p_config_session_key IN VARCHAR2) IS
78: PRAGMA AUTONOMOUS_TRANSACTION;
79: BEGIN
80: DELETE FROM CZ_PRICING_STRUCTURES
81: WHERE configurator_session_key = p_config_session_key;
82: COMMIT;
83: END delete_pricing_recs;
84:

Line 142: TYPE typeItemKeyTable IS TABLE OF cz_pricing_structures.item_key%TYPE INDEX BY BINARY_INTEGER;

138: --identified by the p_config_session_id parameter.
139:
140: FUNCTION root_bom_config_item_id(p_config_session_key IN VARCHAR2) RETURN NUMBER IS
141:
142: TYPE typeItemKeyTable IS TABLE OF cz_pricing_structures.item_key%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemIdTable IS TABLE OF cz_pricing_structures.config_item_id%TYPE INDEX BY BINARY_INTEGER;
144:
145: tabItemKey typeItemKeyTable;
146: tabConfigItemId typeItemIdTable;

Line 143: TYPE typeItemIdTable IS TABLE OF cz_pricing_structures.config_item_id%TYPE INDEX BY BINARY_INTEGER;

139:
140: FUNCTION root_bom_config_item_id(p_config_session_key IN VARCHAR2) RETURN NUMBER IS
141:
142: TYPE typeItemKeyTable IS TABLE OF cz_pricing_structures.item_key%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemIdTable IS TABLE OF cz_pricing_structures.config_item_id%TYPE INDEX BY BINARY_INTEGER;
144:
145: tabItemKey typeItemKeyTable;
146: tabConfigItemId typeItemIdTable;
147: vComponentCode cz_pricing_structures.item_key%TYPE;

Line 147: vComponentCode cz_pricing_structures.item_key%TYPE;

143: TYPE typeItemIdTable IS TABLE OF cz_pricing_structures.config_item_id%TYPE INDEX BY BINARY_INTEGER;
144:
145: tabItemKey typeItemKeyTable;
146: tabConfigItemId typeItemIdTable;
147: vComponentCode cz_pricing_structures.item_key%TYPE;
148:
149: BEGIN
150:
151: --Read only the configuration lines corresponding to BOM items.

Line 154: FROM cz_pricing_structures

150:
151: --Read only the configuration lines corresponding to BOM items.
152:
153: SELECT item_key, config_item_id BULK COLLECT INTO tabItemKey, tabConfigItemId
154: FROM cz_pricing_structures
155: WHERE configurator_session_key = p_config_session_key
156: AND item_key_type = G_ITEM_KEY_BOM_NODE;
157:
158: FOR i IN 1..tabItemKey.COUNT LOOP