[Home] [Help]
132:
133: ELSE --p_event_class_rec.summarization_flag = 'Y'
134:
135: -- Preserve old summary_tax_line_id in g_detail_tax_lines_gt (for UPDATE
136: -- case) if the same summarization criteria exist in zx_lines_summary
137: --
138: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
139:
140: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
300:
301: IF p_event_class_rec.summarization_flag = 'Y' THEN
302:
303: -- for create tax event, summary tax line created based on
304: -- zx_detail_tax_lines_gt, dump detail tax lines from gt to zx_lines
305: -- called after summary lines created for performance consideration.
306: --
307: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_crt_evnt (
308: p_event_class_rec => p_event_class_rec,
325: END IF;
326:
327: END IF;
328:
329: -- Dump detail tax lines from gt to zx_lines
330: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
331: p_event_class_rec => p_event_class_rec,
332: x_return_status => x_return_status);
333:
405:
406: ELSE --p_event_class_rec.summarization_flag = 'Y'
407:
408: -- Preserve old summary_tax_line_id in g_detail_tax_lines_gt (for UPDATE
409: -- case) if the same summarization criteria exist in zx_lines_summary
410: --
411: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
412:
413: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
610:
611: l_return_status VARCHAR2(1);
612:
613: --TRANSACTION TABLE HAS A NUMBER OF TRANSACTIONS TO BE PROCESSED. BASED ON THE EVENTS ,
614: --APPROPRIATE PROCEDURES WOULD BE CALLED. ZX_LINES TABLE MUST HAVE
615: --TRANSACTION LINES FOR THE GIVEN TRANSACTION FOR FURTHER PROCESSING.
616: l_error_buffer VARCHAR2(100);
617:
618: BEGIN
1000: END Freeze_TaxDistributions;
1001:
1002: /*============================================================================*
1003: | PROCEDURE Update_Taxlines: This recording service is used to update tax |
1004: | lines (ZX_LINES) with changed status for given |
1005: | transaction line distributions. |
1006: |============================================================================*/
1007: PROCEDURE Update_Taxlines
1008: (x_return_status OUT NOCOPY VARCHAR2,
1189: -- delete_tax_lines_and_dists
1190: --
1191: -- DESCRIPTION
1192: -- Delete all the detail tax lines and distributions of the passed-in
1193: -- transaction line from zx_lines and zx_rec_nrec_dist.
1194: ------------------------------------------------------------------------------
1195:
1196: PROCEDURE delete_tax_lines_and_dists
1197: (
1240: FETCH c_get_summary_flags into l_summarization_flag, l_retain_summ_tax_line_id_flag;
1241: CLOSE c_get_summary_flags;
1242:
1243: -- delete the tax detail lines
1244: DELETE FROM zx_lines
1245: WHERE application_id = p_application_id
1246: AND entity_code = p_entity_code
1247: AND event_class_code = p_event_class_code
1248: AND trx_id = p_trx_id
1254: -- for current phase, just delete all the summary tax lines
1255: -- for this transaction and recreate
1256:
1257: -- delete the summary tax lines for the transaction
1258: DELETE FROM zx_lines_summary
1259: WHERE application_id = p_application_id
1260: AND entity_code = p_entity_code
1261: AND event_class_code = p_event_class_code
1262: AND trx_id = p_trx_id;
1276: IF (g_level_error >= g_current_runtime_level ) THEN
1277: FND_LOG.STRING(g_level_error,
1278: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
1279: 'MRC Lines: Incorrect return_status after calling ' ||
1280: 'ZX_TRL_MANAGE_TAX_PKG.create_summary_from_zx_liness()');
1281: FND_LOG.STRING(g_level_error,
1282: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
1283: 'RETURN_STATUS = ' || x_return_status);
1284: FND_LOG.STRING(g_level_error,
1357: AND trx_line_id = p_trx_line_id
1358: AND trx_level_type = p_trx_level_type;
1359:
1360: IF SQL%ROWCOUNT > 0 THEN
1361: UPDATE zx_lines
1362: SET process_for_recovery_flag = 'Y', -- DECODE(L.Reporting_Only_Flag, 'N', 'Y', 'N')
1363: rec_tax_amt = NULL,
1364: rec_tax_amt_tax_curr = NULL,
1365: rec_tax_amt_funcl_curr = NULL,