APPS.GMD_COA_DATA_NEW dependencies on GMD_COA_DETAILS

Line 1912: delete from gmd_coa_details;

1908:
1909: /* ******* if db table is necessary and for debugging ***** -- */
1910:
1911: delete from gmd_coa_headers;
1912: delete from gmd_coa_details;
1913: delete from gmd_coa_spec_text;
1914: delete from gmd_coa_rslt_text;
1915:
1916: /* -- Do API standard code for savepoint, messages, initialize return status */

Line 1984: INSERT into gmd_coa_details (gmd_coa_id, qc_result_id, result_date,

1980: /*Changed tbl_dtl.FIRST to NVL(tbl_dtl.FIRST,0) and */
1981: /*tbl_dtl.LAST to NVL(tbl_dtl.LAST,0) */
1982: FOR loop_counter IN NVL(tbl_dtl.FIRST,0) .. NVL(tbl_dtl.LAST,0) LOOP
1983: /*END BUG#1810652 */
1984: INSERT into gmd_coa_details (gmd_coa_id, qc_result_id, result_date,
1985: qc_spec_id, assay_code, assay_desc,
1986: result, specification, uom,
1987: rslt_text_code, spec_text_code,
1988: created_by, creation_date,