[Home] [Help]
1137: gl_xfr_led_map_periods lmper, gl_row_multipliers mult, ';
1138:
1139: IF (g_coa_mapping_id IS NOT NULL) THEN
1140: l_sqlbuf := l_sqlbuf || '
1141: gl_xfr_ccid_mappings map,
1142: gl_code_combinations fromcc, ';
1143: END IF;
1144:
1145: IF (g_cal_mapping_id IS NOT NULL) THEN
1457: --- reason for them to rerun in batch mode.
1458: ---
1459: IF (g_transfer_mode = C_INCREMENTAL) THEN
1460: l_sqlbuf :=
1461: 'INSERT into gl_xfr_ccid_mappings
1462: (ledger_mapping_id, from_ccid, to_ccid, period_name,
1463: creation_date, created_by, last_update_date, last_updated_by,
1464: last_update_login)
1465: SELECT DISTINCT :g_lgr_mapping_id, map.from_ccid, map.to_ccid, int.reference23,
1471: AND int.status = ''MAP''
1472: AND map.coa_mapping_id = :coa_map_id ';
1473:
1474: IF (g_debug_mode) THEN
1475: print_logfile('SQL Statement to insert into gl_xfr_ccid_mappings');
1476: gl_fusion_transfer_pkg.print_sql_logfile(l_sqlbuf);
1477: END IF;
1478:
1479: EXECUTE IMMEDIATE l_sqlbuf
1480: USING g_lgr_mapping_id, g_user_id, g_user_id, g_login_id,
1481: g_request_id, g_coa_mapping_id;
1482:
1483: ELSE
1484: DELETE gl_xfr_ccid_mappings
1485: WHERE ledger_mapping_id = g_lgr_mapping_id
1486: AND period_name = g_from_period;
1487:
1488: INSERT into gl_xfr_ccid_mappings
1484: DELETE gl_xfr_ccid_mappings
1485: WHERE ledger_mapping_id = g_lgr_mapping_id
1486: AND period_name = g_from_period;
1487:
1488: INSERT into gl_xfr_ccid_mappings
1489: (ledger_mapping_id, from_ccid, to_ccid, period_name,
1490: creation_date, created_by, last_update_date, last_updated_by,
1491: last_update_login)
1492: SELECT g_lgr_mapping_id, from_ccid, to_ccid, g_from_period,
1497: l_row_count := SQL%ROWCOUNT;
1498:
1499: gl_message.write_log('GLFUXFR001', 2,
1500: 'ROW_COUNT', l_row_count,
1501: 'TABLE', 'gl_xfr_ccid_mappings');
1502:
1503:
1504: ---
1505: --- Since there weren't any errors, go ahead and update the