[Home] [Help]
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:
44: --------------------------------------------------------------------------------
556:
557: l_config_input_tbl config_input_tbl_type;
558:
559: CURSOR input_cursor IS SELECT *
560: FROM cz_config_inputs
561: WHERE config_hdr_id = p_old_config_hdr_id
562: AND config_rev_nbr = p_old_config_rev_nbr
563: AND deleted_flag = '0';
564:
565: BEGIN
566:
567: IF ( p_instance_hdr_map.COUNT = 0 ) THEN
568:
569: INSERT INTO CZ_CONFIG_INPUTS
570: (LAST_UPDATE_LOGIN,
571: CONFIG_HDR_ID,
572: CONFIG_REV_NBR,
573: CONFIG_INPUT_ID,
609: TARGET_CONFIG_ITEM_ID,
610: TARGET_CONFIG_INPUT_ID,
611: FLOAT_TYPE,
612: INPUT_SOURCE
613: FROM CZ_CONFIG_INPUTS
614: WHERE CONFIG_HDR_ID = p_old_config_hdr_id
615: AND CONFIG_REV_NBR = p_old_config_rev_nbr
616: AND deleted_flag = '0';
617:
639: END IF;
640: END LOOP;
641:
642: FORALL i IN 1..l_config_input_tbl.COUNT
643: INSERT INTO cz_config_inputs VALUES l_config_input_tbl(i);
644:
645: END LOOP;
646:
647: CLOSE input_cursor;
665: IS
666: l_config_input_tbl config_input_tbl_type;
667:
668: CURSOR input_cursor IS SELECT *
669: FROM cz_config_inputs
670: WHERE config_hdr_id = p_old_config_hdr_id
671: AND config_rev_nbr = p_old_config_rev_nbr
672: AND deleted_flag = '0';
673:
713: END IF;
714: END LOOP;
715:
716: FORALL i IN 1..l_config_input_tbl.COUNT
717: INSERT INTO cz_config_inputs VALUES l_config_input_tbl(i);
718:
719: END LOOP;
720:
721: CLOSE input_cursor;