APPS.CZ_CONFIG_API_PVT dependencies on CZ_CONFIG_ATTRIBUTES

Line 58: TYPE config_attr_tbl_type IS TABLE OF cz_config_attributes%ROWTYPE 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:
61: --------------------------------------------------------------------------------
62: FUNCTION get_next_hdr_id RETURN NUMBER

Line 761: FROM cz_config_attributes

757: IS
758: l_config_attr_tbl config_attr_tbl_type;
759:
760: CURSOR attr_cursor IS SELECT *
761: FROM cz_config_attributes
762: WHERE config_hdr_id = p_old_config_hdr_id
763: AND config_rev_nbr = p_old_config_rev_nbr
764: AND deleted_flag = '0';
765:

Line 768: INSERT INTO CZ_CONFIG_ATTRIBUTES

764: AND deleted_flag = '0';
765:
766: BEGIN
767: IF p_item_id_map.COUNT = 0 THEN
768: INSERT INTO CZ_CONFIG_ATTRIBUTES
769: (CONFIG_HDR_ID,
770: CONFIG_REV_NBR,
771: CONFIG_ITEM_ID,
772: ATTRIBUTE_CATEGORY,

Line 840: FROM CZ_CONFIG_ATTRIBUTES

836: ATTRIBUTE28,
837: ATTRIBUTE29,
838: ATTRIBUTE30,
839: LAST_UPDATE_LOGIN
840: FROM CZ_CONFIG_ATTRIBUTES
841: WHERE CONFIG_HDR_ID=p_old_config_hdr_id AND CONFIG_REV_NBR=p_old_config_rev_nbr
842: AND deleted_flag = '0';
843:
844: ELSE

Line 861: INSERT INTO CZ_CONFIG_ATTRIBUTES VALUES l_config_attr_tbl(i);

857: l_config_attr_tbl(i).config_rev_nbr := p_new_config_rev_nbr;
858: END LOOP;
859:
860: FORALL i IN l_config_attr_tbl.FIRST .. l_config_attr_tbl.LAST
861: INSERT INTO CZ_CONFIG_ATTRIBUTES VALUES l_config_attr_tbl(i);
862: END LOOP;
863:
864: CLOSE attr_cursor;
865: END IF;