APPS.GMD_COA_DATA_NEW dependencies on GMD_COA_SPEC_TEXT

Line 1913: delete from gmd_coa_spec_text;

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 */
1917: SAVEPOINT Dump_To_Db_Tables_SAVE;

Line 2012: INSERT into gmd_coa_spec_text (gmd_coa_id, text_code,

2008: /*Changed tbl_spec_text.FIRST to NVL(tbl_spec_text.FIRST,0) */
2009: /* and tbl_spec_text.LAST to NVL(tbl_spec_text.LAST,0) */
2010: FOR loop_counter IN NVL(tbl_spec_text.FIRST,0) .. NVL(tbl_spec_text.LAST,0) LOOP
2011: /*END BUG#1810652 */
2012: INSERT into gmd_coa_spec_text (gmd_coa_id, text_code,
2013: paragraph_code, line_no, text)
2014: VALUES (tbl_spec_text(loop_counter).gmd_coa_id,
2015: tbl_spec_text(loop_counter).text_code,
2016: tbl_spec_text(loop_counter).paragraph_code,