[Home] [Help]
3743: -- PRIVATE PROCEDURE
3744: -- insert_detail_tax_lines_gt
3745: --
3746: -- DESCRIPTION
3747: -- Insert into zx_detail_tax_lines_gt for partners
3748: --
3749: -- CALLED BY
3750: -- override_tax_lines
3751: -- reverse_document
3768: /*Set the return status to Success */
3769: x_return_status := FND_API.G_RET_STS_SUCCESS;
3770:
3771: BEGIN
3772: INSERT INTO ZX_DETAIL_TAX_LINES_GT(
3773: tax_line_id,
3774: internal_organization_id,
3775: application_id,
3776: entity_code,
9569: AND entity_code = p_event_class_rec.entity_code
9570: AND event_class_code = p_event_class_rec.event_class_code
9571: AND trx_id = p_event_class_rec.trx_id;
9572:
9573: delete from zx_detail_tax_lines_gt
9574: WHERE application_id = p_event_class_rec.application_id
9575: AND entity_code = p_event_class_rec.entity_code
9576: AND event_class_code = p_event_class_rec.event_class_code
9577: AND trx_id = p_event_class_rec.trx_id;
13104: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
13105: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
13106: END IF;
13107:
13108: DELETE FROM zx_detail_tax_lines_gt
13109: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_ID(l_trx_line_index)
13110: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ENTITY_CODE(l_trx_line_index)
13111: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_CLASS_CODE(l_trx_line_index)
13112: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID(l_trx_line_index);
14152: zdtlg.tax_regime_code,
14153: zdtlg.tax_provider_id,
14154: regimes.effective_from,
14155: regimes.effective_to
14156: FROM ZX_DETAIL_TAX_LINES_GT zdtlg,
14157: ZX_REGIMES_B regimes
14158: WHERE zdtlg.application_id = p_event_class_rec.application_id
14159: AND zdtlg.entity_code = p_event_class_rec.entity_code
14160: AND zdtlg.event_class_code = p_event_class_rec.event_class_code
14209: IF p_event_class_rec.record_flag ='Y' AND
14210: p_event_class_rec.record_for_partners_flag = 'Y' THEN
14211:
14212: /*Commented due to GSCC error - need to provide all column names for insert
14213: INSERT INTO ZX_DETAIL_TAX_LINES_GT
14214: SELECT * from ZX_LINES
14215: WHERE application_id = p_event_class_rec.application_id
14216: AND entity_code = p_event_class_rec.entity_code
14217: AND event_class_code = p_event_class_rec.event_class_code
14345: END IF;
14346: RETURN;
14347: END IF;
14348:
14349: /* The deleted tax lines are inserted into ZX_DETAIL_TAX_LINES_GT
14350: for tax lines synchronization view needed for partner service.
14351: But, eBTax service ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines
14352: creates tax lines for the records remaining in the
14353: ZX_DETAIL_TAX_LINES_GT. This results in tax line not getting
14349: /* The deleted tax lines are inserted into ZX_DETAIL_TAX_LINES_GT
14350: for tax lines synchronization view needed for partner service.
14351: But, eBTax service ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines
14352: creates tax lines for the records remaining in the
14353: ZX_DETAIL_TAX_LINES_GT. This results in tax line not getting
14354: deleted from zx_lines when partner created tax line is deleted.
14355: Hence, following delete is being issued. */
14356:
14357: BEGIN
14354: deleted from zx_lines when partner created tax line is deleted.
14355: Hence, following delete is being issued. */
14356:
14357: BEGIN
14358: DELETE FROM ZX_DETAIL_TAX_LINES_GT
14359: WHERE application_id = p_event_class_rec.application_id
14360: AND entity_code = p_event_class_rec.entity_code
14361: AND event_class_code = p_event_class_rec.event_class_code
14362: AND trx_id = p_event_class_rec.trx_id