DBA Data[Home] [Help]

APPS.GMD_COA_DATA_NEW dependencies on GMD_COA_RSLT_TEXT

Line 1914: delete from gmd_coa_rslt_text;

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

Line 2028: INSERT into gmd_coa_rslt_text (gmd_coa_id, text_code,

2024: /*Changed tbl_rslt_text.FIRST to NVL(tbl_rslt_text.FIRST,0) and */
2025: /*tbl_rslt_text.LAST to NVL(tbl_rslt_text.LAST,0) */
2026: FOR loop_counter IN NVL(tbl_rslt_text.FIRST,0) .. NVL(tbl_rslt_text.LAST,0) LOOP
2027: /*END BUG#1810652 */
2028: INSERT into gmd_coa_rslt_text (gmd_coa_id, text_code,
2029: paragraph_code, line_no, text)
2030: VALUES (tbl_rslt_text(loop_counter).gmd_coa_id,
2031: tbl_rslt_text(loop_counter).text_code,
2032: tbl_rslt_text(loop_counter).paragraph_code,