eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_INVOICE_LINES_PKG dependencies on ZX_REVERSE_DIST_GT

Line 1899: l_zx_reverse_dist_gt_count NUMBER; --Bug14383132

1895: prob_dist_count NUMBER :=0; --9100425
1896: l_cancel_proactive_flag varchar2(1); --9100425
1897: l_return_status_service VARCHAR2(4000); --Bug14383132
1898: l_msg_count NUMBER; --Bug14383132
1899: l_zx_reverse_dist_gt_count NUMBER; --Bug14383132
1900: l_return_status BOOLEAN := TRUE; --Bug14383132
1901: l_tax_distributions_exist BOOLEAN := FALSE ; --Bug14383132
1902: l_self_assess_tax_dist_exist BOOLEAN := FALSE ; --Bug14383132
1903: l_inv_cancel_date DATE ; --Bug14383132

Line 2784: DELETE zx_reverse_dist_gt; --Bug14383132

2780: where arl.invoice_id = p_line_rec.invoice_id
2781: and arl.to_invoice_line_number = p_line_rec.line_number
2782: and arl.chrg_invoice_line_number = ail.line_number);
2783:
2784: DELETE zx_reverse_dist_gt; --Bug14383132
2785:
2786: open c_charge_lines (p_line_rec.invoice_id,
2787: p_line_rec.line_number);
2788: loop

Line 2888: DELETE zx_reverse_dist_gt;

2884: END IF;
2885: DELETE zx_transaction_lines_gt;
2886: DELETE zx_import_tax_lines_gt;
2887: DELETE zx_trx_tax_link_gt;
2888: DELETE zx_reverse_dist_gt;
2889: RETURN l_return_status;
2890: ELSE -- update the tax only line amount to 0
2891:
2892: IF l_return_status THEN

Line 3704: DELETE zx_reverse_dist_gt;

3700:
3701: DELETE zx_transaction_lines_gt;
3702: DELETE zx_import_tax_lines_gt;
3703: DELETE zx_trx_tax_link_gt;
3704: DELETE zx_reverse_dist_gt;
3705:
3706:
3707: --Bug14383132 : End
3708:

Line 5455: --INTO zx_reverse_dist_gt. Once distributions are inserted CALL

5451: --------------------------------------------------------------
5452: Print(l_api_name,'Reverse_Charge_Distributions (-)');
5453: --------------------------------------------------------------
5454: --Bug14383132 : Call New API To INSERT above REVERSED CHARGE DISTRIBUTIONS
5455: --INTO zx_reverse_dist_gt. Once distributions are inserted CALL
5456: --ZX_API_PUB.Reverse_Distributions(). Parameter list to this
5457: --Function is listed in update *** PGAYEN 07/31/12 12:00 am *** on
5458: --bug14383132
5459: --Similar code is present in AP_ETAX_SERVICES_PKG.CANCEL_INVOICe

Line 5476: l_debug_info := 'Insert into zx_reverse_dist_gt';

5472: p_line_number=>p_inv_line_rec.line_number);
5473:
5474: IF l_tax_distributions_exist THEN
5475: ---------------------------------------------------------------
5476: l_debug_info := 'Insert into zx_reverse_dist_gt';
5477: Print (l_api_name,l_debug_info);
5478: ---------------------------------------------------------------
5479: INSERT INTO zx_reverse_dist_gt(
5480: internal_organization_id,

Line 5479: INSERT INTO zx_reverse_dist_gt(

5475: ---------------------------------------------------------------
5476: l_debug_info := 'Insert into zx_reverse_dist_gt';
5477: Print (l_api_name,l_debug_info);
5478: ---------------------------------------------------------------
5479: INSERT INTO zx_reverse_dist_gt(
5480: internal_organization_id,
5481: reversing_appln_id,
5482: reversing_entity_code,
5483: reversing_evnt_cls_code,

Line 5531: l_debug_info := 'Row Count inserted into zx_reverse_dist_gt: ' || l_reverse_dist_count;

5527: and item_dist.invoice_line_number = p_inv_line_rec.line_number;
5528:
5529: l_reverse_dist_count := l_reverse_dist_count+SQL%ROWCOUNT;
5530: --------------------------------------------------------------------------------------------
5531: l_debug_info := 'Row Count inserted into zx_reverse_dist_gt: ' || l_reverse_dist_count;
5532: Print (l_api_name,l_debug_info);
5533: --------------------------------------------------------------------------------------------
5534:
5535: END IF;

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

5535: END IF;
5536:
5537: IF l_self_assess_tax_dist_exist THEN
5538: ---------------------------------------------------------------
5539: l_debug_info := 'Inserting self assessed tax entries into zx_reverse_dist_gt';
5540: Print (l_api_name,l_debug_info);
5541: ---------------------------------------------------------------
5542: INSERT INTO zx_reverse_dist_gt(
5543: internal_organization_id,

Line 5542: INSERT INTO zx_reverse_dist_gt(

5538: ---------------------------------------------------------------
5539: l_debug_info := 'Inserting self assessed tax entries into zx_reverse_dist_gt';
5540: Print (l_api_name,l_debug_info);
5541: ---------------------------------------------------------------
5542: INSERT INTO zx_reverse_dist_gt(
5543: internal_organization_id,
5544: reversing_appln_id,
5545: reversing_entity_code,
5546: reversing_evnt_cls_code,

Line 5594: l_debug_info := 'Row Count inserted into zx_reverse_dist_gt: ' || l_sa_reverse_dist_count;

5590: and item_dist.invoice_line_number = p_inv_line_rec.line_number;
5591:
5592: l_sa_reverse_dist_count := l_sa_reverse_dist_count+SQL%ROWCOUNT;
5593: --------------------------------------------------------------------------------------------
5594: l_debug_info := 'Row Count inserted into zx_reverse_dist_gt: ' || l_sa_reverse_dist_count;
5595: Print (l_api_name,l_debug_info);
5596: --------------------------------------------------------------------------------------------
5597:
5598: END IF;