DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on ZX_TAX_DIST_ID_GT

Line 3570: TYPE freeze_tax_dist_type IS TABLE OF zx_tax_dist_id_gt%ROWTYPE;

3566:
3567: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
3568: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
3569:
3570: TYPE freeze_tax_dist_type IS TABLE OF zx_tax_dist_id_gt%ROWTYPE;
3571: freeze_dist_list freeze_tax_dist_type := freeze_tax_dist_type();
3572:
3573: l_api_name CONSTANT VARCHAR2(100) := 'Freeze_Distributions';
3574:

Line 3809: delete zx_tax_dist_id_gt;--Bug7582775

3805:
3806: END LOOP;
3807: END IF;
3808:
3809: delete zx_tax_dist_id_gt;--Bug7582775
3810:
3811: l_debug_info := 'No Of Rows Deleted From zx_tax_dist_id_gt '||sql%rowcount;
3812:
3813: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3811: l_debug_info := 'No Of Rows Deleted From zx_tax_dist_id_gt '||sql%rowcount;

3807: END IF;
3808:
3809: delete zx_tax_dist_id_gt;--Bug7582775
3810:
3811: l_debug_info := 'No Of Rows Deleted From zx_tax_dist_id_gt '||sql%rowcount;
3812:
3813: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3814: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3815: END IF;

Line 3822: INSERT INTO zx_tax_dist_id_gt(tax_dist_id)

3818: LOOP
3819: IF (freeze_dist_list.exists(m)) THEN
3820:
3821: IF (freeze_dist_list(m).tax_dist_id IS NOT NULL) THEN
3822: INSERT INTO zx_tax_dist_id_gt(tax_dist_id)
3823: VALUES (freeze_dist_list(m).tax_dist_id);
3824:
3825: END IF;
3826: END IF;