APPS.CZ_CONFIG_API_PUB dependencies on CZ_CONFIG_ITEMS

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

35:
36: TYPE instance_tbl_type IS TABLE of instance_rec_type INDEX BY PLS_INTEGER;
37:
38: TYPE config_hdr_tbl_type IS TABLE OF cz_config_hdrs%ROWTYPE INDEX BY PLS_INTEGER;
39: TYPE config_item_tbl_type IS TABLE OF cz_config_items%ROWTYPE INDEX BY PLS_INTEGER;
40: TYPE config_input_tbl_type IS TABLE OF cz_config_inputs%ROWTYPE INDEX BY PLS_INTEGER;
41: TYPE config_attr_tbl_type IS TABLE OF cz_config_attributes%ROWTYPE INDEX BY PLS_INTEGER;
42: TYPE config_extattr_tbl_type IS TABLE OF cz_config_ext_attributes%ROWTYPE INDEX BY PLS_INTEGER;
43:

Line 89: SELECT cz_config_items_s.NEXTVAL

85: l_config_item_id NUMBER;
86: BEGIN
87: IF ((last_item_allocated IS NULL) OR
88: (next_item_to_use = last_item_allocated + id_increment)) THEN
89: SELECT cz_config_items_s.NEXTVAL
90: INTO last_item_allocated
91: FROM dual;
92: next_item_to_use := last_item_allocated;
93: END IF;

Line 237: FROM cz_config_items

233: SELECT * BULK COLLECT INTO l_instance_hdr_tbl
234: FROM cz_config_hdrs
235: WHERE deleted_flag = '0' AND (config_hdr_id, config_rev_nbr) IN
236: (SELECT instance_hdr_id, instance_rev_nbr
237: FROM cz_config_items
238: WHERE config_hdr_id = p_session_hdr_id AND config_rev_nbr = p_session_rev_nbr
239: AND component_instance_type IN (GENERIC_INSTANCE_ROOT, NETWORK_INSTANCE_ROOT)
240: AND deleted_flag = '0');
241:

Line 297: INSERT INTO CZ_CONFIG_ITEMS

293: p_new_config_rev_nbr IN NUMBER)
294: IS
295:
296: BEGIN
297: INSERT INTO CZ_CONFIG_ITEMS
298: (LAST_UPDATE_LOGIN,
299: CONFIG_HDR_ID,
300: CONFIG_REV_NBR,
301: CONFIG_ITEM_ID,

Line 392: FROM CZ_CONFIG_ITEMS

388: ,TANGIBLE_ITEM_FLAG
389: ,RETURNED_FLAG
390: ,VALUE_SOURCE
391: ,ORDERABLE_FLAG
392: FROM CZ_CONFIG_ITEMS
393: WHERE CONFIG_HDR_ID = p_old_config_hdr_id
394: AND CONFIG_REV_NBR = p_old_config_rev_nbr AND deleted_flag = '0';
395:
396: EXCEPTION

Line 424: CURSOR item_cursor IS SELECT * FROM cz_config_items

420: l_target_rev_nbr NUMBER;
421: l_index PLS_INTEGER;
422: l_config_item_tbl config_item_tbl_type;
423:
424: CURSOR item_cursor IS SELECT * FROM cz_config_items
425: WHERE config_hdr_id = p_old_config_hdr_id
426: AND config_rev_nbr = p_old_config_rev_nbr
427: AND deleted_flag = '0';
428:

Line 446: FOR id_rec IN (SELECT config_item_id FROM cz_config_items

442: IF (p_network_config AND p_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
443: l_index := p_instance_hdr_map.FIRST;
444: WHILE (l_index IS NOT NULL) LOOP
445: IF p_instance_hdr_map(l_index).txn_flag = '1' THEN
446: FOR id_rec IN (SELECT config_item_id FROM cz_config_items
447: WHERE config_hdr_id = p_old_config_hdr_id
448: AND config_rev_nbr = p_old_config_rev_nbr
449: AND deleted_flag = '0' AND instance_hdr_id = l_index)
450: LOOP

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

531: l_config_item_tbl(i).config_rev_nbr := p_new_config_rev_nbr;
532: END LOOP;
533:
534: FORALL i IN 1..l_config_item_tbl.COUNT
535: INSERT INTO cz_config_items VALUES l_config_item_tbl(i);
536:
537: END LOOP;
538:
539: CLOSE item_cursor;

Line 865: FROM cz_config_items

861: SELECT *
862: FROM cz_config_ext_attributes
863: WHERE deleted_flag = '0' AND (config_hdr_id, config_rev_nbr) IN
864: (SELECT instance_hdr_id, instance_rev_nbr
865: FROM cz_config_items
866: WHERE config_hdr_id = p_old_sess_config_hdr_id
867: AND config_rev_nbr = p_old_sess_config_rev_nbr
868: AND component_instance_type = NETWORK_INSTANCE_ROOT
869: AND deleted_flag = '0');