[Home] [Help]
137:
138: ELSE --p_event_class_rec.summarization_flag = 'Y'
139:
140: -- Preserve old summary_tax_line_id in g_detail_tax_lines_gt (for UPDATE
141: -- case) if the same summarization criteria exist in zx_lines_summary
142: --
143: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
144:
145: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
305:
306: IF p_event_class_rec.summarization_flag = 'Y' THEN
307:
308: -- for create tax event, summary tax line created based on
309: -- zx_detail_tax_lines_gt, dump detail tax lines from gt to zx_lines
310: -- called after summary lines created for performance consideration.
311: --
312: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_crt_evnt (
313: p_event_class_rec => p_event_class_rec,
330: END IF;
331:
332: END IF;
333:
334: -- Dump detail tax lines from gt to zx_lines
335: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
336: p_event_class_rec => p_event_class_rec,
337: x_return_status => x_return_status);
338:
410:
411: ELSE --p_event_class_rec.summarization_flag = 'Y'
412:
413: -- Preserve old summary_tax_line_id in g_detail_tax_lines_gt (for UPDATE
414: -- case) if the same summarization criteria exist in zx_lines_summary
415: --
416: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
417:
418: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
615:
616: l_return_status VARCHAR2(1);
617:
618: --TRANSACTION TABLE HAS A NUMBER OF TRANSACTIONS TO BE PROCESSED. BASED ON THE EVENTS ,
619: --APPROPRIATE PROCEDURES WOULD BE CALLED. ZX_LINES TABLE MUST HAVE
620: --TRANSACTION LINES FOR THE GIVEN TRANSACTION FOR FURTHER PROCESSING.
621: l_error_buffer VARCHAR2(100);
622:
623: BEGIN
1021: END Freeze_TaxDistributions;
1022:
1023: /*============================================================================*
1024: | PROCEDURE Update_Taxlines: This recording service is used to update tax |
1025: | lines (ZX_LINES) with changed status for given |
1026: | transaction line distributions. |
1027: |============================================================================*/
1028: PROCEDURE Update_Taxlines
1029: (x_return_status OUT NOCOPY VARCHAR2,
1210: -- delete_tax_lines_and_dists
1211: --
1212: -- DESCRIPTION
1213: -- Delete all the detail tax lines and distributions of the passed-in
1214: -- transaction line from zx_lines and zx_rec_nrec_dist.
1215: ------------------------------------------------------------------------------
1216:
1217: PROCEDURE delete_tax_lines_and_dists
1218: (
1261: FETCH c_get_summary_flags into l_summarization_flag, l_retain_summ_tax_line_id_flag;
1262: CLOSE c_get_summary_flags;
1263:
1264: -- delete the tax detail lines
1265: DELETE FROM zx_lines
1266: WHERE application_id = p_application_id
1267: AND entity_code = p_entity_code
1268: AND event_class_code = p_event_class_code
1269: AND trx_id = p_trx_id
1275: -- for current phase, just delete all the summary tax lines
1276: -- for this transaction and recreate
1277:
1278: -- delete the summary tax lines for the transaction
1279: DELETE FROM zx_lines_summary
1280: WHERE application_id = p_application_id
1281: AND entity_code = p_entity_code
1282: AND event_class_code = p_event_class_code
1283: AND trx_id = p_trx_id;
1297: IF (g_level_error >= g_current_runtime_level ) THEN
1298: FND_LOG.STRING(g_level_error,
1299: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
1300: 'MRC Lines: Incorrect return_status after calling ' ||
1301: 'ZX_TRL_MANAGE_TAX_PKG.create_summary_from_zx_liness()');
1302: FND_LOG.STRING(g_level_error,
1303: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
1304: 'RETURN_STATUS = ' || x_return_status);
1305: FND_LOG.STRING(g_level_error,
1378: AND trx_line_id = p_trx_line_id
1379: AND trx_level_type = p_trx_level_type;
1380:
1381: IF SQL%ROWCOUNT > 0 THEN
1382: UPDATE zx_lines
1383: SET process_for_recovery_flag = 'Y', -- DECODE(L.Reporting_Only_Flag, 'N', 'Y', 'N')
1384: rec_tax_amt = NULL,
1385: rec_tax_amt_tax_curr = NULL,
1386: rec_tax_amt_funcl_curr = NULL,