DBA Data[Home] [Help]

APPS.CZ_CONFIG_API_PVT dependencies on CZ_CONFIG_EXT_ATTRIBUTES

Line 59: TYPE config_extattr_tbl_type IS TABLE OF cz_config_ext_attributes%ROWTYPE INDEX BY PLS_INTEGER;

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
63: IS

Line 972: FROM cz_config_ext_attributes

968: l_ext_attr_tbl config_extattr_tbl_type;
969:
970: CURSOR attr_cursor IS
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

Line 998: INSERT INTO CZ_CONFIG_EXT_ATTRIBUTES VALUES l_ext_attr_tbl(i);

994: l_ext_attr_tbl(i).config_hdr_id := p_instance_hdr_map(l_ext_attr_tbl(i).config_hdr_id).instance_hdr_id;
995: END LOOP;
996:
997: FORALL i IN l_ext_attr_tbl.FIRST .. l_ext_attr_tbl.LAST
998: INSERT INTO CZ_CONFIG_EXT_ATTRIBUTES VALUES l_ext_attr_tbl(i);
999: END LOOP;
1000:
1001: CLOSE attr_cursor;
1002: