APPS.GMD_COA_DATA_OM dependencies on GMD_COA_SPEC_TEXT

Line 1365: delete from gmd_coa_spec_text;

1361: /* ******* if db table is necessary and for debugging ***** -- */
1362:
1363: delete from gmd_coa_headers;
1364: delete from gmd_coa_details;
1365: delete from gmd_coa_spec_text;
1366: delete from gmd_coa_rslt_text;
1367:
1368: /* -- Do API standard code for savepoint, messages, initialize return status */
1369: SAVEPOINT Dump_To_Db_Tables_SAVE;

Line 1464: INSERT into gmd_coa_spec_text (gmd_coa_id, text_code,

1460: /*Changed tbl_spec_text.FIRST to NVL(tbl_spec_text.FIRST,0) */
1461: /* and tbl_spec_text.LAST to NVL(tbl_spec_text.LAST,0) */
1462: FOR loop_counter IN NVL(tbl_spec_text.FIRST,0) .. NVL(tbl_spec_text.LAST,0) LOOP
1463: /*END BUG#1810652 */
1464: INSERT into gmd_coa_spec_text (gmd_coa_id, text_code,
1465: paragraph_code, line_no, text)
1466: VALUES (tbl_spec_text(loop_counter).gmd_coa_id,
1467: tbl_spec_text(loop_counter).text_code,
1468: tbl_spec_text(loop_counter).paragraph_code,