DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM dependencies on GMD_COA_RSLT_TEXT

Line 1366: delete from gmd_coa_rslt_text;

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;
1370: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 1480: INSERT into gmd_coa_rslt_text (gmd_coa_id, text_code,

1476: /*Changed tbl_rslt_text.FIRST to NVL(tbl_rslt_text.FIRST,0) and */
1477: /*tbl_rslt_text.LAST to NVL(tbl_rslt_text.LAST,0) */
1478: FOR loop_counter IN NVL(tbl_rslt_text.FIRST,0) .. NVL(tbl_rslt_text.LAST,0) LOOP
1479: /*END BUG#1810652 */
1480: INSERT into gmd_coa_rslt_text (gmd_coa_id, text_code,
1481: paragraph_code, line_no, text)
1482: VALUES (tbl_rslt_text(loop_counter).gmd_coa_id,
1483: tbl_rslt_text(loop_counter).text_code,
1484: tbl_rslt_text(loop_counter).paragraph_code,