[Home] [Help]
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:
61: --------------------------------------------------------------------------------
577:
578: l_config_input_tbl config_input_tbl_type;
579:
580: CURSOR input_cursor IS SELECT *
581: FROM cz_config_inputs
582: WHERE config_hdr_id = p_old_config_hdr_id
583: AND config_rev_nbr = p_old_config_rev_nbr
584: AND deleted_flag = '0';
585:
586: BEGIN
587:
588: IF ( p_instance_hdr_map.COUNT = 0 ) THEN
589:
590: INSERT INTO CZ_CONFIG_INPUTS
591: (LAST_UPDATE_LOGIN,
592: CONFIG_HDR_ID,
593: CONFIG_REV_NBR,
594: CONFIG_INPUT_ID,
630: TARGET_CONFIG_ITEM_ID,
631: TARGET_CONFIG_INPUT_ID,
632: FLOAT_TYPE,
633: INPUT_SOURCE
634: FROM CZ_CONFIG_INPUTS
635: WHERE CONFIG_HDR_ID = p_old_config_hdr_id
636: AND CONFIG_REV_NBR = p_old_config_rev_nbr
637: AND deleted_flag = '0';
638:
660: END IF;
661: END LOOP;
662:
663: FORALL i IN 1..l_config_input_tbl.COUNT
664: INSERT INTO cz_config_inputs VALUES l_config_input_tbl(i);
665:
666: END LOOP;
667:
668: CLOSE input_cursor;
686: IS
687: l_config_input_tbl config_input_tbl_type;
688:
689: CURSOR input_cursor IS SELECT *
690: FROM cz_config_inputs
691: WHERE config_hdr_id = p_old_config_hdr_id
692: AND config_rev_nbr = p_old_config_rev_nbr
693: AND deleted_flag = '0';
694:
734: END IF;
735: END LOOP;
736:
737: FORALL i IN 1..l_config_input_tbl.COUNT
738: INSERT INTO cz_config_inputs VALUES l_config_input_tbl(i);
739:
740: END LOOP;
741:
742: CLOSE input_cursor;