APPS.CZ_CONFIG_API_PVT dependencies on CZ_CONFIG_ITEMS

Line 56: TYPE config_item_tbl_type IS TABLE OF cz_config_items%ROWTYPE INDEX BY PLS_INTEGER;

52:
53: TYPE instance_tbl_type IS TABLE of instance_rec_type INDEX BY PLS_INTEGER;
54:
55: TYPE config_hdr_tbl_type IS TABLE OF cz_config_hdrs%ROWTYPE INDEX BY PLS_INTEGER;
56: TYPE config_item_tbl_type IS TABLE OF cz_config_items%ROWTYPE INDEX BY PLS_INTEGER;
57: TYPE config_input_tbl_type IS TABLE OF cz_config_inputs%ROWTYPE INDEX BY PLS_INTEGER;
58: TYPE config_attr_tbl_type IS TABLE OF cz_config_attributes%ROWTYPE INDEX BY PLS_INTEGER;
59: TYPE config_extattr_tbl_type IS TABLE OF cz_config_ext_attributes%ROWTYPE INDEX BY PLS_INTEGER;
60:

Line 106: SELECT cz_config_items_s.NEXTVAL

102: l_config_item_id NUMBER;
103: BEGIN
104: IF ((last_item_allocated IS NULL) OR
105: (next_item_to_use = last_item_allocated + id_increment)) THEN
106: SELECT cz_config_items_s.NEXTVAL
107: INTO last_item_allocated
108: FROM dual;
109: next_item_to_use := last_item_allocated;
110: END IF;

Line 256: FROM cz_config_items

252: SELECT * BULK COLLECT INTO l_instance_hdr_tbl
253: FROM cz_config_hdrs
254: WHERE deleted_flag = '0' AND (config_hdr_id, config_rev_nbr) IN
255: (SELECT instance_hdr_id, instance_rev_nbr
256: FROM cz_config_items
257: WHERE config_hdr_id = p_session_hdr_id AND config_rev_nbr = p_session_rev_nbr
258: AND component_instance_type IN (GENERIC_INSTANCE_ROOT, NETWORK_INSTANCE_ROOT)
259: AND deleted_flag = '0');
260:

Line 316: INSERT INTO CZ_CONFIG_ITEMS

312: p_new_config_rev_nbr IN NUMBER)
313: IS
314:
315: BEGIN
316: INSERT INTO CZ_CONFIG_ITEMS
317: (LAST_UPDATE_LOGIN,
318: CONFIG_HDR_ID,
319: CONFIG_REV_NBR,
320: CONFIG_ITEM_ID,

Line 411: FROM CZ_CONFIG_ITEMS

407: ,TANGIBLE_ITEM_FLAG
408: ,RETURNED_FLAG
409: ,VALUE_SOURCE
410: ,ORDERABLE_FLAG
411: FROM CZ_CONFIG_ITEMS
412: WHERE CONFIG_HDR_ID = p_old_config_hdr_id
413: AND CONFIG_REV_NBR = p_old_config_rev_nbr AND deleted_flag = '0';
414:
415: EXCEPTION

Line 445: CURSOR item_cursor IS SELECT * FROM cz_config_items

441: l_target_rev_nbr NUMBER;
442: l_index PLS_INTEGER;
443: l_config_item_tbl config_item_tbl_type;
444:
445: CURSOR item_cursor IS SELECT * FROM cz_config_items
446: WHERE config_hdr_id = p_old_config_hdr_id
447: AND config_rev_nbr = p_old_config_rev_nbr
448: AND deleted_flag = '0';
449:

Line 467: FOR id_rec IN (SELECT config_item_id FROM cz_config_items

463: IF (p_network_config AND p_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE and p_force_new_inst_rev is null) THEN
464: l_index := p_instance_hdr_map.FIRST;
465: WHILE (l_index IS NOT NULL) LOOP
466: IF p_instance_hdr_map(l_index).txn_flag = '1' THEN
467: FOR id_rec IN (SELECT config_item_id FROM cz_config_items
468: WHERE config_hdr_id = p_old_config_hdr_id
469: AND config_rev_nbr = p_old_config_rev_nbr
470: AND deleted_flag = '0' AND instance_hdr_id = l_index)
471: LOOP

Line 556: INSERT INTO cz_config_items VALUES l_config_item_tbl(i);

552: l_config_item_tbl(i).config_rev_nbr := p_new_config_rev_nbr;
553: END LOOP;
554:
555: FORALL i IN 1..l_config_item_tbl.COUNT
556: INSERT INTO cz_config_items VALUES l_config_item_tbl(i);
557:
558: END LOOP;
559:
560: CLOSE item_cursor;

Line 975: FROM cz_config_items

971: SELECT *
972: FROM cz_config_ext_attributes
973: WHERE deleted_flag = '0' AND (config_hdr_id, config_rev_nbr) IN
974: (SELECT instance_hdr_id, instance_rev_nbr
975: FROM cz_config_items
976: WHERE config_hdr_id = p_old_sess_config_hdr_id
977: AND config_rev_nbr = p_old_sess_config_rev_nbr
978: AND component_instance_type = NETWORK_INSTANCE_ROOT
979: AND deleted_flag = '0');