[Home] [Help]
1786: -- insert_temp_table_rows
1787: --
1788: -- DESCRIPTION:
1789: -- This Global temprary table gmd_qc_spec_mst_gtmp along with
1790: -- gmd_spec_mapping_gtmp is used to improve Specification migration performance.
1791: --
1792: -- PARAMETERS:
1793: -- p_spec_hdr_id - All qc_spec_mst records for spec_hdr_id are inserted in
1794: -- Global temprary table gmd_qc_spec_mst_gtmp for performance.
2076: -- 3) Changed logic for deriving l_version_end_date
2077: -- 4) Removed check-dup logic
2078: --
2079: -- PK Bug 4226263 07-June-2005 Created temporary tables gmd_qc_spec_mst_gtmp
2080: -- and gmd_spec_mapping_gtmp. These tables contain subset of
2081: -- data being migrated . These tables are used for performance
2082: -- Improvement. Varioys cusors are changed to use gmd_qc_spec_mst_gtmp
2083: -- instead of qc_spec_mst and gmd_spec_mapping_gtmp instead of gmd_spec_mapping
2084: -- Suitable code changes are made to insert data into these tables.
2079: -- PK Bug 4226263 07-June-2005 Created temporary tables gmd_qc_spec_mst_gtmp
2080: -- and gmd_spec_mapping_gtmp. These tables contain subset of
2081: -- data being migrated . These tables are used for performance
2082: -- Improvement. Varioys cusors are changed to use gmd_qc_spec_mst_gtmp
2083: -- instead of qc_spec_mst and gmd_spec_mapping_gtmp instead of gmd_spec_mapping
2084: -- Suitable code changes are made to insert data into these tables.
2085: -- Uday Phadtare Bug 5025951. Default display_precision and report_precision from
2086: -- user configured profiles. If profile is NULL precision is considered as zero.
2087: --=========================================================================== */
2402: max(print_coa_shipped) as print_coa_shipped,
2403: max(print_coa_invoiced) as print_coa_invoiced,
2404: max(vendor_coa_required) as vendor_coa_required
2405: FROM gmd_qc_spec_mst_gtmp s ,
2406: gmd_spec_mapping_gtmp m
2407: WHERE m.spec_id = l_spec_id
2408: AND s.qc_spec_id = m.qc_spec_id ;
2409: coa_rec c_get_coa_inds%ROWTYPE;
2410:
2977: l_start_date,
2978: l_version_end_date
2979: );
2980:
2981: INSERT INTO gmd_spec_mapping_gtmp
2982: (
2983: qc_spec_id,
2984: spec_id,
2985: test_id,