DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on ZX_REVERSE_DIST_GT

Line 2927: l_debug_info := 'Step 6: Populate zx_reverse_dist_gt';

2923:
2924: END IF;
2925:
2926: -----------------------------------------------------------------
2927: l_debug_info := 'Step 6: Populate zx_reverse_dist_gt';
2928: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2929: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2930: END IF;
2931: -----------------------------------------------------------------

Line 2933: INSERT INTO zx_reverse_dist_gt(

2929: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2930: END IF;
2931: -----------------------------------------------------------------
2932: IF (l_return_status = TRUE) THEN
2933: INSERT INTO zx_reverse_dist_gt(
2934: internal_organization_id,
2935: reversing_appln_id,
2936: reversing_entity_code,
2937: reversing_evnt_cls_code,

Line 13463: DELETE zx_reverse_dist_gt;

13459:
13460: DELETE zx_transaction_lines_gt;
13461: DELETE zx_import_tax_lines_gt;
13462: DELETE zx_trx_tax_link_gt;
13463: DELETE zx_reverse_dist_gt;
13464:
13465: AP_ETAX_SERVICES_PKG.G_SITE_ATTRIBUTES.DELETE;
13466: AP_ETAX_SERVICES_PKG.G_ORG_ATTRIBUTES.DELETE;
13467:

Line 13659: l_debug_info := 'Step 1: Insert into zx_reverse_dist_gt';

13655:
13656: IF l_tax_distributions_exist THEN -- Marker 1
13657:
13658: -----------------------------------------------------------------
13659: l_debug_info := 'Step 1: Insert into zx_reverse_dist_gt';
13660: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13661: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13662: END IF;
13663: -----------------------------------------------------------------

Line 13665: INSERT INTO zx_reverse_dist_gt(

13661: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13662: END IF;
13663: -----------------------------------------------------------------
13664:
13665: INSERT INTO zx_reverse_dist_gt(
13666: internal_organization_id,
13667: reversing_appln_id,
13668: reversing_entity_code,
13669: reversing_evnt_cls_code,

Line 13721: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Row Count inserted into zx_reverse_dist_gt: ' || l_reverse_dist_count);

13717: l_reverse_dist_count := SQL%ROWCOUNT;
13718:
13719: -----------------------------------------------------------------
13720: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13721: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Row Count inserted into zx_reverse_dist_gt: ' || l_reverse_dist_count);
13722: END IF;
13723: -----------------------------------------------------------------
13724:
13725: -- Bug 10140793 Begin

Line 13783: l_debug_info := 'Inserting self assessed tax entries into zx_reverse_dist_gt';

13779:
13780:
13781: IF l_self_assess_tax_dist_exist THEN -- Marker 2
13782:
13783: l_debug_info := 'Inserting self assessed tax entries into zx_reverse_dist_gt';
13784: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13785: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13786: END IF;
13787:

Line 13788: -- Populating zx_reverse_dist_gt with self assessed entries that has to be

13784: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13785: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13786: END IF;
13787:
13788: -- Populating zx_reverse_dist_gt with self assessed entries that has to be
13789: -- reversed. Fetched tax distributions from ap_self_assessed_tax_dist_all.
13790: -- ITEM line is already reversed in Discard method. reverse_dist refers to
13791: -- the reversed item line.
13792:

Line 13793: INSERT INTO zx_reverse_dist_gt(

13789: -- reversed. Fetched tax distributions from ap_self_assessed_tax_dist_all.
13790: -- ITEM line is already reversed in Discard method. reverse_dist refers to
13791: -- the reversed item line.
13792:
13793: INSERT INTO zx_reverse_dist_gt(
13794: internal_organization_id,
13795: reversing_appln_id,
13796: reversing_entity_code,
13797: reversing_evnt_cls_code,

Line 13849: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Row Count inserted into zx_reverse_dist_gt: ' || SQL%ROWCOUNT);

13845: l_rev_sa_dist_count := SQL%ROWCOUNT ; -- Bug 10140793
13846:
13847: -----------------------------------------------------------------
13848: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13849: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Row Count inserted into zx_reverse_dist_gt: ' || SQL%ROWCOUNT);
13850: END IF;
13851: -----------------------------------------------------------------
13852:
13853: -- Bug 10140793 Begin

Line 14037: DELETE zx_reverse_dist_gt;

14033: END IF;
14034: DELETE zx_transaction_lines_gt;
14035: DELETE zx_import_tax_lines_gt;
14036: DELETE zx_trx_tax_link_gt;
14037: DELETE zx_reverse_dist_gt;
14038: RETURN l_return_status;
14039: ELSE -- update the tax only line amount to 0
14040: -----------------------------------------------------------------
14041: l_debug_info := 'Update the tax line amount to 0';