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_ETAX_UTILITY_PKG dependencies on AP_INVOICES_ALL

Line 4: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;

1: PACKAGE BODY AP_ETAX_UTILITY_PKG AS
2: /* $Header: apetxutb.pls 120.102.12010000.16 2008/12/12 01:03:27 hchaudha ship $*/
3: -- Create global variables to maintain the session info
4: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;
5: l_login_id ap_invoices_all.last_update_login%TYPE := FND_GLOBAL.login_id;
6: l_sysdate DATE := sysdate;
7:
8: Global_Exception EXCEPTION; -- bug 7126676

Line 5: l_login_id ap_invoices_all.last_update_login%TYPE := FND_GLOBAL.login_id;

1: PACKAGE BODY AP_ETAX_UTILITY_PKG AS
2: /* $Header: apetxutb.pls 120.102.12010000.16 2008/12/12 01:03:27 hchaudha ship $*/
3: -- Create global variables to maintain the session info
4: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;
5: l_login_id ap_invoices_all.last_update_login%TYPE := FND_GLOBAL.login_id;
6: l_sysdate DATE := sysdate;
7:
8: Global_Exception EXCEPTION; -- bug 7126676
9:

Line 131: (p_invoice_header_rec IN ap_invoices_all%ROWTYPE,

127: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE
128: );
129:
130: PROCEDURE insert_tax_distributions
131: (p_invoice_header_rec IN ap_invoices_all%ROWTYPE,
132: p_inv_dist_rec IN r_ins_tax_dist_info,
133: p_dist_code_combination_id IN NUMBER,
134: p_user_id IN NUMBER,
135: p_sysdate IN DATE,

Line 437: l_corrected_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

433: IS
434:
435: l_debug_info VARCHAR2(240);
436: l_curr_calling_sequence VARCHAR2(4000);
437: l_corrected_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
438:
439:
440: CURSOR corrected_inv( c_corrected_inv_id IN NUMBER) IS
441: SELECT invoice_num, invoice_date, invoice_type_lookup_code

Line 442: FROM ap_invoices_all

438:
439:
440: CURSOR corrected_inv( c_corrected_inv_id IN NUMBER) IS
441: SELECT invoice_num, invoice_date, invoice_type_lookup_code
442: FROM ap_invoices_all
443: WHERE invoice_id = c_corrected_inv_id;
444:
445: BEGIN
446:

Line 536: l_prepay_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

532: IS
533:
534: l_debug_info VARCHAR2(240);
535: l_curr_calling_sequence VARCHAR2(4000);
536: l_prepay_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
537:
538: CURSOR prepay_inv (c_prepay_inv_id IN NUMBER) IS
539: SELECT invoice_num, invoice_date, invoice_type_lookup_code
540: FROM ap_invoices_all

Line 540: FROM ap_invoices_all

536: l_prepay_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
537:
538: CURSOR prepay_inv (c_prepay_inv_id IN NUMBER) IS
539: SELECT invoice_num, invoice_date, invoice_type_lookup_code
540: FROM ap_invoices_all
541: WHERE invoice_id = c_prepay_inv_id;
542:
543: BEGIN
544:

Line 937: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

933: | 15-OCT-2003 SYIDNER Created
934: |
935: *============================================================================*/
936: FUNCTION Return_Tax_Lines(
937: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
938: P_Error_Code OUT NOCOPY VARCHAR2,
939: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
940: IS
941:

Line 955: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;

951: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
952: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
953: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
954: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
955: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
956: l_payment_priority ap_batches_all.payment_priority%TYPE;
957:
958: l_total_tax_amount NUMBER;
959: l_self_assessed_tax_amt NUMBER;

Line 1698: FROM ap_invoices_all ai,

1694: zls.tax_rate_id, -- tax_rate_id
1695: zls.tax_rate_code, -- tax_rate_code
1696: zls.tax_rate, -- tax_rate
1697: null -- tax_code_id
1698: FROM ap_invoices_all ai,
1699: ap_suppliers ap,
1700: ap_supplier_sites_all aps,
1701: zx_lines_summary zls,
1702: ap_invoice_lines_all prepay

Line 1844: UPDATE ap_invoices_all ai

1840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1841: END IF;
1842: -------------------------------------------------------------------
1843: BEGIN
1844: UPDATE ap_invoices_all ai
1845: SET (ai.total_tax_amount,
1846: ai.self_assessed_tax_amount) =
1847: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
1848: 'N', NVL(zls.tax_amt, 0),

Line 1985: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

1981: | distributions
1982: *============================================================================*/
1983:
1984: FUNCTION Return_Tax_Distributions(
1985: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
1986: P_All_Error_Messages IN VARCHAR2,
1987: P_Error_Code OUT NOCOPY VARCHAR2,
1988: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
1989: IS

Line 2310: ap_invoices_all ai,

2306: zd.account_source_tax_rate_id account_source_tax_rate_id
2307: FROM zx_trx_headers_gt gt,
2308: zx_rec_nrec_dist zd,
2309: zx_lines zl,
2310: ap_invoices_all ai,
2311: ap_supplier_sites_all pvs,
2312: ap_system_parameters_all asp,
2313: financials_system_params_all fsp,
2314: po_distributions_all pd,

Line 2623: ap_invoices_all ai,

2619: zd.account_source_tax_rate_id account_source_tax_rate_id
2620: FROM zx_trx_headers_gt gt,
2621: zx_rec_nrec_dist zd,
2622: zx_lines zl,
2623: ap_invoices_all ai,
2624: ap_supplier_sites_all pvs,
2625: ap_system_parameters_all asp,
2626: financials_system_params_all fsp,
2627: po_distributions_all pd,

Line 2881: ap_invoices_all ai,

2877: zd.account_source_tax_rate_id
2878: FROM zx_trx_headers_gt gt,
2879: zx_rec_nrec_dist zd,
2880: zx_lines zl,
2881: ap_invoices_all ai,
2882: ap_invoice_distributions_all aid,
2883: ap_supplier_sites_all pvs,
2884: ap_system_parameters_all asp,
2885: financials_system_params_all fsp,

Line 3111: ap_invoices_all ai,

3107: zd.account_source_tax_rate_id account_source_tax_rate_id
3108: FROM zx_trx_headers_gt gt,
3109: zx_rec_nrec_dist zd,
3110: zx_lines zl,
3111: ap_invoices_all ai,
3112: ap_invoice_distributions_all aid,
3113: ap_supplier_sites_all pvs,
3114: ap_system_parameters_all asp,
3115: financials_system_params_all fsp,

Line 3314: ap_invoices_all ai,

3310: zd.account_source_tax_rate_id account_source_tax_rate_id
3311: FROM zx_trx_headers_gt gt,
3312: zx_rec_nrec_dist zd,
3313: zx_lines zl,
3314: ap_invoices_all ai,
3315: ap_supplier_sites_all pvs,
3316: ap_system_parameters_all asp,
3317: financials_system_params_all fsp,
3318: po_distributions_all pd,

Line 3509: ap_invoices_all ai,

3505: zd.account_source_tax_rate_id
3506: FROM zx_trx_headers_gt gt,
3507: zx_rec_nrec_dist zd,
3508: zx_lines zl,
3509: ap_invoices_all ai,
3510: ap_self_assessed_tax_dist_all aid,
3511: ap_supplier_sites_all pvs,
3512: ap_system_parameters_all asp,
3513: financials_system_params_all fsp,

Line 5131: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

5127: | 03-NOV-2003 SYIDNER Created
5128: |
5129: *============================================================================*/
5130: FUNCTION Return_Tax_Quote(
5131: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
5132: P_Error_Code OUT NOCOPY VARCHAR2,
5133: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
5134:
5135: IS

Line 7015: p_invoice_header_rec IN ap_invoices_all%ROWTYPE,

7011: END get_default_tax_det_attribs;
7012:
7013:
7014: PROCEDURE insert_tax_distributions(
7015: p_invoice_header_rec IN ap_invoices_all%ROWTYPE,
7016: p_inv_dist_rec IN r_ins_tax_dist_info,
7017: p_dist_code_combination_id IN NUMBER,
7018: p_user_id IN NUMBER,
7019: p_sysdate IN DATE,