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.179.12020000.10 2013/02/15 12:31:04 cmaredup 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; /*Bug10101457: Commented the global variable and used sysdate where applicable*/
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.179.12020000.10 2013/02/15 12:31:04 cmaredup 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; /*Bug10101457: Commented the global variable and used sysdate where applicable*/
7:
8: Global_Exception EXCEPTION; -- bug 7126676
9:

Line 146: (p_invoice_header_rec IN ap_invoices_all%ROWTYPE,

142: p_line_number IN ap_invoice_distributions_all.invoice_line_number%TYPE,
143: p_ccid OUT NOCOPY AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE ) RETURN BOOLEAN; */
144:
145: PROCEDURE insert_tax_distributions
146: (p_invoice_header_rec IN ap_invoices_all%ROWTYPE,
147: p_inv_dist_rec IN r_ins_tax_dist_info,
148: p_dist_code_combination_id IN NUMBER,
149: p_user_id IN NUMBER,
150: p_sysdate IN DATE,

Line 524: l_corrected_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

520: IS
521:
522: l_debug_info VARCHAR2(2000);
523: l_curr_calling_sequence VARCHAR2(4000);
524: l_corrected_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
525:
526: l_api_name CONSTANT VARCHAR2(100) := 'Get_Corrected_Invoice_Info';
527:
528:

Line 531: FROM ap_invoices_all

527:
528:
529: CURSOR corrected_inv( c_corrected_inv_id IN NUMBER) IS
530: SELECT invoice_num, invoice_date, invoice_type_lookup_code
531: FROM ap_invoices_all
532: WHERE invoice_id = c_corrected_inv_id;
533:
534: BEGIN
535:

Line 646: l_prepay_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;

642: IS
643:
644: l_debug_info VARCHAR2(2000);
645: l_curr_calling_sequence VARCHAR2(4000);
646: l_prepay_invoice_type ap_invoices_all.invoice_type_lookup_code%TYPE;
647:
648: l_api_name CONSTANT VARCHAR2(100) := 'Get_Prepay_Invoice_Info';
649:
650: CURSOR prepay_inv (c_prepay_inv_id IN NUMBER) IS

Line 652: FROM ap_invoices_all

648: l_api_name CONSTANT VARCHAR2(100) := 'Get_Prepay_Invoice_Info';
649:
650: CURSOR prepay_inv (c_prepay_inv_id IN NUMBER) IS
651: SELECT invoice_num, invoice_date, invoice_type_lookup_code
652: FROM ap_invoices_all
653: WHERE invoice_id = c_prepay_inv_id;
654:
655: BEGIN
656:

Line 1164: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

1160: | 15-OCT-2003 SYIDNER Created
1161: |
1162: *============================================================================*/
1163: FUNCTION Return_Tax_Lines(
1164: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
1165: P_Error_Code OUT NOCOPY VARCHAR2,
1166: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
1167: IS
1168:

Line 1182: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;

1178: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
1179: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
1180: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
1181: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
1182: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
1183: l_payment_priority ap_batches_all.payment_priority%TYPE;
1184:
1185: l_total_tax_amount NUMBER;
1186: l_self_assessed_tax_amt NUMBER;

Line 1962: FROM ap_invoices_all ai,

1958: 'N', null,
1959: DECODE(zls.applied_from_trx_id,
1960: null, P_Invoice_Header_Rec.pay_awt_group_id,
1961: prepay.pay_awt_group_id)) -- pay_awt_group_id Bug8345264 */
1962: FROM ap_invoices_all ai,
1963: ap_suppliers ap,
1964: ap_supplier_sites_all aps,
1965: zx_lines_summary zls,
1966: ap_invoice_lines_all prepay

Line 2110: UPDATE ap_invoices_all ai

2106: -------------------------------------------------------------------
2107:
2108: /*Bug 8638881 added CASE in the below SQL to consider the case of invoice includes prepay*/
2109: BEGIN
2110: UPDATE ap_invoices_all ai
2111: SET (ai.total_tax_amount,
2112: ai.self_assessed_tax_amount) =
2113: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
2114: 'N', case when exists (SELECT 'Prepay App Exists'

Line 2143: UPDATE ap_invoices_all ai

2139:
2140: --Bug#16022947. Introduced below UPDATE to consider
2141: --Retro Tax amounts which will not be in ZLS tables.
2142:
2143: UPDATE ap_invoices_all ai
2144: SET ai.total_tax_amount = (nvl(ai.total_tax_amount,0) +
2145: (SELECT NVL(sum(NVL(ail.amount,0)),0)
2146: FROM ap_invoice_lines_all ail
2147: WHERE ail.invoice_id = ai.invoice_id

Line 2282: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

2278: | distributions
2279: *============================================================================*/
2280:
2281: FUNCTION Return_Tax_Distributions(
2282: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
2283: P_All_Error_Messages IN VARCHAR2,
2284: P_Error_Code OUT NOCOPY VARCHAR2,
2285: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
2286: IS

Line 2699: ap_invoices_all ai,

2695: zd.account_source_tax_rate_id account_source_tax_rate_id
2696: FROM zx_trx_headers_gt gt,
2697: zx_rec_nrec_dist zd,
2698: zx_lines zl,
2699: ap_invoices_all ai,
2700: ap_supplier_sites_all pvs,
2701: ap_system_parameters_all asp,
2702: financials_system_params_all fsp,
2703: po_distributions_all pd,

Line 3046: ap_invoices_all ai,

3042: zd.account_source_tax_rate_id account_source_tax_rate_id
3043: FROM zx_trx_headers_gt gt,
3044: zx_rec_nrec_dist zd,
3045: zx_lines zl,
3046: ap_invoices_all ai,
3047: ap_supplier_sites_all pvs,
3048: ap_system_parameters_all asp,
3049: financials_system_params_all fsp,
3050: po_distributions_all pd,

Line 3324: ap_invoices_all ai,

3320: zd.account_source_tax_rate_id
3321: FROM zx_trx_headers_gt gt,
3322: zx_rec_nrec_dist zd,
3323: zx_lines zl,
3324: ap_invoices_all ai,
3325: ap_invoice_distributions_all aid,
3326: ap_supplier_sites_all pvs,
3327: ap_system_parameters_all asp,
3328: financials_system_params_all fsp,

Line 3565: ap_invoices_all ai,

3561: zd.account_source_tax_rate_id account_source_tax_rate_id
3562: FROM zx_trx_headers_gt gt,
3563: zx_rec_nrec_dist zd,
3564: zx_lines zl,
3565: ap_invoices_all ai,
3566: ap_invoice_distributions_all aid,
3567: ap_supplier_sites_all pvs,
3568: ap_system_parameters_all asp,
3569: financials_system_params_all fsp,

Line 3785: ap_invoices_all ai,

3781: zd.account_source_tax_rate_id account_source_tax_rate_id
3782: FROM zx_trx_headers_gt gt,
3783: zx_rec_nrec_dist zd,
3784: zx_lines zl,
3785: ap_invoices_all ai,
3786: ap_supplier_sites_all pvs,
3787: ap_system_parameters_all asp,
3788: financials_system_params_all fsp,
3789: po_distributions_all pd,

Line 3984: ap_invoices_all ai,

3980: zd.account_source_tax_rate_id
3981: FROM zx_trx_headers_gt gt,
3982: zx_rec_nrec_dist zd,
3983: zx_lines zl,
3984: ap_invoices_all ai,
3985: ap_self_assessed_tax_dist_all aid,
3986: ap_supplier_sites_all pvs,
3987: ap_system_parameters_all asp,
3988: financials_system_params_all fsp,

Line 6299: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

6295: | 03-NOV-2003 SYIDNER Created
6296: |
6297: *============================================================================*/
6298: FUNCTION Return_Tax_Quote(
6299: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
6300: P_Error_Code OUT NOCOPY VARCHAR2,
6301: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
6302:
6303: IS

Line 9151: p_invoice_header_rec IN ap_invoices_all%ROWTYPE,

9147: END get_default_tax_det_attribs;
9148:
9149:
9150: PROCEDURE insert_tax_distributions(
9151: p_invoice_header_rec IN ap_invoices_all%ROWTYPE,
9152: p_inv_dist_rec IN r_ins_tax_dist_info,
9153: p_dist_code_combination_id IN NUMBER,
9154: p_user_id IN NUMBER,
9155: p_sysdate IN DATE,

Line 10097: FROM ap_invoices_all

10093: INTO l_Hist_Flag,
10094: l_Awt_Computed,
10095: l_quick_credit,
10096: l_Invoice_Type
10097: FROM ap_invoices_all
10098: WHERE invoice_id = p_invoice_id;
10099:
10100: SELECT count(invoice_id)
10101: INTO l_Payment_Stat_Flag

Line 10572: ap_invoices_all ai

10568: SELECT aerd.code_combination_id
10569: INTO l_default_ccid
10570: FROM ap_exp_report_dists_all aerd,
10571: ap_expense_report_lines_all aerl,
10572: ap_invoices_all ai
10573: WHERE aerd.report_header_id = p_reference_key1
10574: AND aerd.report_line_id = p_reference_key2
10575: AND aerd.report_line_id = aerl.report_line_id
10576: AND aerd.report_header_id = aerl.report_header_id

Line 10843: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

10839: debug_info VARCHAR2(2000);
10840: debug_context VARCHAR2(2000);
10841: l_dist_code_concat VARCHAR2(2000);
10842: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec;
10843: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
10844: l_invoice_currency ap_invoices_all.invoice_currency_code%TYPE;
10845: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
10846: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
10847: l_error_found VARCHAR2(1) := 'N';

Line 10844: l_invoice_currency ap_invoices_all.invoice_currency_code%TYPE;

10840: debug_context VARCHAR2(2000);
10841: l_dist_code_concat VARCHAR2(2000);
10842: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec;
10843: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
10844: l_invoice_currency ap_invoices_all.invoice_currency_code%TYPE;
10845: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
10846: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
10847: l_error_found VARCHAR2(1) := 'N';
10848: l_pa_allows_overrides VARCHAR2(1) := 'N';

Line 10850: l_invoice_date AP_INVOICES_ALL.INVOICE_DATE%TYPE;

10846: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
10847: l_error_found VARCHAR2(1) := 'N';
10848: l_pa_allows_overrides VARCHAR2(1) := 'N';
10849: l_employee_id NUMBER;
10850: l_invoice_date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
10851: l_vendor_id NUMBER;
10852: l_employee_ccid NUMBER;
10853: l_web_parameter_id NUMBER;
10854: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;

Line 10854: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;

10850: l_invoice_date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
10851: l_vendor_id NUMBER;
10852: l_employee_ccid NUMBER;
10853: l_web_parameter_id NUMBER;
10854: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
10855: l_exchange_date ap_invoices_all.exchange_date%TYPE;
10856: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
10857: l_sys_link_function VARCHAR2(2);
10858: l_msg_application VARCHAR2(25);

Line 10855: l_exchange_date ap_invoices_all.exchange_date%TYPE;

10851: l_vendor_id NUMBER;
10852: l_employee_ccid NUMBER;
10853: l_web_parameter_id NUMBER;
10854: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
10855: l_exchange_date ap_invoices_all.exchange_date%TYPE;
10856: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
10857: l_sys_link_function VARCHAR2(2);
10858: l_msg_application VARCHAR2(25);
10859: l_msg_type VARCHAR2(25);

Line 10856: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;

10852: l_employee_ccid NUMBER;
10853: l_web_parameter_id NUMBER;
10854: l_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
10855: l_exchange_date ap_invoices_all.exchange_date%TYPE;
10856: l_exchange_rate ap_invoices_all.exchange_rate%TYPE;
10857: l_sys_link_function VARCHAR2(2);
10858: l_msg_application VARCHAR2(25);
10859: l_msg_type VARCHAR2(25);
10860: l_msg_token1 VARCHAR2(30);

Line 10927: FROM ap_invoices_all

10923: l_invoice_attribute_rec.attribute12,
10924: l_invoice_attribute_rec.attribute13,
10925: l_invoice_attribute_rec.attribute14,
10926: l_invoice_attribute_rec.attribute15
10927: FROM ap_invoices_all
10928: WHERE invoice_id = l_invoice_line_rec.invoice_id;
10929: EXCEPTION
10930: WHEN NO_DATA_FOUND THEN
10931: debug_info := 'Step 3 b - Get the Invoice and Line DFF Info: Failed to fetch Invoice header DFF info.';

Line 10999: FROM ap_invoices_all

10995: SELECT invoice_date, vendor_id , invoice_type_lookup_code , invoice_currency_code ,
10996: exchange_rate_type , exchange_date , exchange_rate
10997: INTO l_invoice_date , l_vendor_id , l_invoice_type_lookup_code , l_invoice_currency ,
10998: l_exchange_rate_type , l_exchange_date , l_exchange_rate
10999: FROM ap_invoices_all
11000: WHERE invoice_id = p_invoice_id;
11001:
11002: EXCEPTION
11003: WHEN NO_DATA_FOUND THEN