APPS.GMD_COA_DATA_OM dependencies on GMD_COA_HEADERS

Line 1363: delete from gmd_coa_headers;

1359: x_return_status := FND_API.G_RET_STS_SUCCESS;
1360:
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:

Line 1384: INSERT into gmd_coa_headers (gmd_coa_id, order_id, line_id, orgn_code,

1380: /*Changed tbl_hdr.FIRST to NVL(tbl_hdr.FIRST,0) and */
1381: /*tbl_hdr.LAST to NVL(tbl_hdr.LAST,0) */
1382: FOR loop_counter IN NVL(tbl_hdr.FIRST,0) .. NVL(tbl_hdr.LAST,0) LOOP
1383: /*END BUG#1810652 */
1384: INSERT into gmd_coa_headers (gmd_coa_id, order_id, line_id, orgn_code,
1385: order_no,
1386: custpo_no,
1387: shipdate, cust_id, cust_no, cust_name,
1388: bol_id, bol_no, item_id,

Line 1542: -- If no spec data is found, the gmd_coa_headers table will be empty

1538: p_delivery_id number) IS
1539: --errbuf VARCHAR2(200);
1540: --retcode NUMBER;
1541:
1542: -- If no spec data is found, the gmd_coa_headers table will be empty
1543:
1544: CURSOR get_report_title IS
1545: select c.report_title, meaning
1546: from gem_lookups l, gmd_coa_headers c

Line 1546: from gem_lookups l, gmd_coa_headers c

1542: -- If no spec data is found, the gmd_coa_headers table will be empty
1543:
1544: CURSOR get_report_title IS
1545: select c.report_title, meaning
1546: from gem_lookups l, gmd_coa_headers c
1547: where l.lookup_type = 'GMD_COA_REPORT_TITLE'
1548: and l.lookup_code = c.report_title;
1549:
1550: CURSOR get_report_title_blank IS