APPS.AP_ETAX_SERVICES_PKG dependencies on ZX_TAX_DIST_ID_GT

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

4413:
4414: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
4415: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
4416:
4417: TYPE freeze_tax_dist_type IS TABLE OF zx_tax_dist_id_gt%ROWTYPE;
4418: freeze_dist_list freeze_tax_dist_type := freeze_tax_dist_type();
4419:
4420: l_api_name CONSTANT VARCHAR2(100) := 'Freeze_Distributions';
4421:

Line 4706: delete zx_tax_dist_id_gt;--Bug7582775

4702:
4703: END LOOP;
4704: END IF;
4705:
4706: delete zx_tax_dist_id_gt;--Bug7582775
4707:
4708: l_debug_info := 'No Of Rows Deleted From zx_tax_dist_id_gt '||sql%rowcount;
4709:
4710: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

4704: END IF;
4705:
4706: delete zx_tax_dist_id_gt;--Bug7582775
4707:
4708: l_debug_info := 'No Of Rows Deleted From zx_tax_dist_id_gt '||sql%rowcount;
4709:
4710: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4711: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4712: END IF;

Line 4719: INSERT INTO zx_tax_dist_id_gt(tax_dist_id)

4715: LOOP
4716: IF (freeze_dist_list.exists(m)) THEN
4717:
4718: IF (freeze_dist_list(m).tax_dist_id IS NOT NULL) THEN
4719: INSERT INTO zx_tax_dist_id_gt(tax_dist_id)
4720: VALUES (freeze_dist_list(m).tax_dist_id);
4721:
4722: END IF;
4723: END IF;

Line 14183: delete zx_tax_dist_id_gt; --Bug 8350132

14179: IF l_return_status THEN
14180:
14181: IF p_line_number IS NULL THEN -- Marker 4
14182:
14183: delete zx_tax_dist_id_gt; --Bug 8350132
14184:
14185: IF l_tax_distributions_exist THEN -- Marker 5
14186:
14187: -----------------------------------------------------------------

Line 14557: INSERT into ZX_TAX_DIST_ID_GT (TAX_DIST_ID) values (l_reverse_tax_dist.detail_tax_dist_id) ;

14553: l_reverse_tax_dist.pay_awt_group_id); /*BUG 10261626*/
14554:
14555: --Bug 8350132
14556:
14557: INSERT into ZX_TAX_DIST_ID_GT (TAX_DIST_ID) values (l_reverse_tax_dist.detail_tax_dist_id) ;
14558: l_inv_cancel_date := l_reverse_tax_dist.accounting_date ;
14559:
14560: --End Bug 8350132
14561:

Line 14961: INSERT into ZX_TAX_DIST_ID_GT (TAX_DIST_ID) values (l_self_assess_rev_tax_dist.detail_tax_dist_id) ;

14957: );
14958:
14959: --Bug 8350132
14960:
14961: INSERT into ZX_TAX_DIST_ID_GT (TAX_DIST_ID) values (l_self_assess_rev_tax_dist.detail_tax_dist_id) ;
14962: l_inv_cancel_date := l_self_assess_rev_tax_dist.accounting_date ;
14963:
14964: --End Bug 8350132
14965:

Line 15352: INSERT into ZX_TAX_DIST_ID_GT (TAX_DIST_ID) values (l_reverse_tax_dist.detail_tax_dist_id) ; --bug 13101979

15348: l_reverse_tax_dist.rcv_charge_addition_flag,
15349: l_reverse_tax_dist.prepay_tax_diff_amount, -- BUG 7338249
15350: l_reverse_tax_dist.pay_awt_group_id); /*BUG 10261626*/
15351:
15352: INSERT into ZX_TAX_DIST_ID_GT (TAX_DIST_ID) values (l_reverse_tax_dist.detail_tax_dist_id) ; --bug 13101979
15353: l_inv_cancel_date := l_reverse_tax_dist.accounting_date; --bug 13101979
15354:
15355: END LOOP;
15356:

Line 15705: INSERT into ZX_TAX_DIST_ID_GT (TAX_DIST_ID) values (l_self_assess_rev_tax_dist_1.detail_tax_dist_id) ; --bug 13101979

15701: l_self_assess_rev_tax_dist_1.self_assessed_tax_liab_ccid, --bug6805655
15702: l_self_assess_rev_tax_dist_1.prepay_tax_diff_amount -- BUG 7338249
15703: );
15704:
15705: INSERT into ZX_TAX_DIST_ID_GT (TAX_DIST_ID) values (l_self_assess_rev_tax_dist_1.detail_tax_dist_id) ; --bug 13101979
15706: l_inv_cancel_date := l_self_assess_rev_tax_dist_1.accounting_date ; --bug 13101979
15707:
15708: END LOOP;
15709:

Line 16301: INSERT INTO zx_tax_dist_id_gt

16297: --Bug6678578END
16298: IF (l_return_status = TRUE) THEN
16299:
16300:
16301: INSERT INTO zx_tax_dist_id_gt
16302: (Select distinct detail_tax_dist_id
16303: From ap_invoice_distributions_all
16304: Where invoice_id = p_invoice_id
16305: AND distribution_class = 'CANDIDATE'