APPS.CZ_ATP_CALLBACK_UTIL dependencies on CZ_ATP_REQUESTS

Line 30: DELETE FROM cz_atp_requests WHERE configurator_session_key = p_config_session_key;

26: ------------------------------------------------------------------------------
27: PROCEDURE delete_atp_recs (p_config_session_key IN VARCHAR2) IS
28: PRAGMA AUTONOMOUS_TRANSACTION;
29: BEGIN
30: DELETE FROM cz_atp_requests WHERE configurator_session_key = p_config_session_key;
31: COMMIT;
32: END delete_atp_recs;
33:
34: PROCEDURE insert_atp_rec (p_config_session_key IN VARCHAR2,

Line 75: INSERT INTO CZ_ATP_REQUESTS (atp_request_id,

71: 'inventory item ' || l_item_id || ' with organization_id ' || l_org_id);
72: END;
73: END IF;
74:
75: INSERT INTO CZ_ATP_REQUESTS (atp_request_id,
76: configurator_session_key,
77: seq_no,
78: ps_node_id,
79: item_key, item_key_type,

Line 84: VALUES (cz_atp_requests_s.nextval, p_config_session_key, p_seq_nbr,

80: quantity, uom_code,
81: config_item_id, parent_config_item_id,
82: ato_config_item_id,
83: component_sequence_id)
84: VALUES (cz_atp_requests_s.nextval, p_config_session_key, p_seq_nbr,
85: p_ps_node_id, p_item_key, l_item_key_type, p_quantity, p_uom_code,
86: p_config_item_id,
87: decode(p_parent_config_item_id, NO_PARENT_VALUE, NULL,
88: p_parent_config_item_id),

Line 138: l_item_id_str cz_atp_requests.item_key%TYPE;

134: -- Returns null if item_id can't be found
135: FUNCTION inv_item_id_from_item_key(p_item_key IN VARCHAR2)
136: RETURN NUMBER IS
137:
138: l_item_id_str cz_atp_requests.item_key%TYPE;
139:
140: BEGIN
141:
142: IF p_item_key IS NULL THEN

Line 241: l_item_key cz_atp_requests.item_key%TYPE;

237: RETURN NUMBER IS
238:
239: l_temp VARCHAR2(100);
240: l_result VARCHAR2(100);
241: l_item_key cz_atp_requests.item_key%TYPE;
242:
243: BEGIN
244: begin
245: select item_key into l_item_key from cz_atp_requests where

Line 245: select item_key into l_item_key from cz_atp_requests where

241: l_item_key cz_atp_requests.item_key%TYPE;
242:
243: BEGIN
244: begin
245: select item_key into l_item_key from cz_atp_requests where
246: configurator_session_key = p_config_session_key and seq_no = 1;
247: exception
248: when others then
249: return NULL;

Line 261: TYPE typeItemKeyTable IS TABLE OF cz_atp_requests.item_key%TYPE INDEX BY BINARY_INTEGER;

257: --identified by the p_config_session_id parameter.
258:
259: FUNCTION root_bom_config_item_id(p_config_session_key IN VARCHAR2) RETURN NUMBER IS
260:
261: TYPE typeItemKeyTable IS TABLE OF cz_atp_requests.item_key%TYPE INDEX BY BINARY_INTEGER;
262: TYPE typeItemIdTable IS TABLE OF cz_atp_requests.config_item_id%TYPE INDEX BY BINARY_INTEGER;
263:
264: tabItemKey typeItemKeyTable;
265: tabConfigItemId typeItemIdTable;

Line 262: TYPE typeItemIdTable IS TABLE OF cz_atp_requests.config_item_id%TYPE INDEX BY BINARY_INTEGER;

258:
259: FUNCTION root_bom_config_item_id(p_config_session_key IN VARCHAR2) RETURN NUMBER IS
260:
261: TYPE typeItemKeyTable IS TABLE OF cz_atp_requests.item_key%TYPE INDEX BY BINARY_INTEGER;
262: TYPE typeItemIdTable IS TABLE OF cz_atp_requests.config_item_id%TYPE INDEX BY BINARY_INTEGER;
263:
264: tabItemKey typeItemKeyTable;
265: tabConfigItemId typeItemIdTable;
266: vComponentCode cz_atp_requests.item_key%TYPE;

Line 266: vComponentCode cz_atp_requests.item_key%TYPE;

262: TYPE typeItemIdTable IS TABLE OF cz_atp_requests.config_item_id%TYPE INDEX BY BINARY_INTEGER;
263:
264: tabItemKey typeItemKeyTable;
265: tabConfigItemId typeItemIdTable;
266: vComponentCode cz_atp_requests.item_key%TYPE;
267:
268: BEGIN
269:
270: --Read only the configuration lines corresponding to BOM items.

Line 273: FROM cz_atp_requests

269:
270: --Read only the configuration lines corresponding to BOM items.
271:
272: SELECT item_key, config_item_id BULK COLLECT INTO tabItemKey, tabConfigItemId
273: FROM cz_atp_requests
274: WHERE configurator_session_key = p_config_session_key
275: AND item_key_type = G_ITEM_KEY_BOM_NODE;
276:
277: FOR i IN 1..tabItemKey.COUNT LOOP