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

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 456: P_Entity_code := 'AP_INVOICES';

452: -------------------------------------------------------------------
453: IF ( P_Corrected_Invoice_Id IS NOT NULL) THEN
454:
455: P_Application_Id := 200; -- Oracle Payables
456: P_Entity_code := 'AP_INVOICES';
457:
458: BEGIN
459: OPEN corrected_inv (P_Corrected_Invoice_Id);
460: FETCH corrected_inv

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 554: P_Entity_code := 'AP_INVOICES';

550: -------------------------------------------------------------------
551: IF ( P_Prepay_Invoice_Id IS NOT NULL) THEN
552:
553: P_Application_Id := 200;
554: P_Entity_code := 'AP_INVOICES';
555:
556: BEGIN
557: OPEN prepay_inv (P_Prepay_Invoice_Id);
558: FETCH prepay_inv

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 1029: AND zl.entity_code = 'AP_INVOICES'

1025: AND EXISTS
1026: (SELECT zl.summary_tax_line_id
1027: FROM zx_lines_summary zl
1028: WHERE zl.application_id = 200
1029: AND zl.entity_code = 'AP_INVOICES'
1030: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1031: AND zl.trx_id = ail.invoice_id
1032: AND zl.tax_regime_code = ail.tax_regime_code
1033: AND zl.tax = ail.tax

Line 1203: AND zl.entity_code = 'AP_INVOICES'

1199: UPDATE ap_invoice_lines_all ail
1200: SET ail.summary_tax_line_id = (SELECT zl.summary_tax_line_id
1201: FROM zx_lines zl
1202: WHERE zl.application_id = 200
1203: AND zl.entity_code = 'AP_INVOICES'
1204: AND zl.event_class_code IN
1205: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1206: AND zl.trx_id = ail.invoice_id
1207: AND zl.tax_regime_code = ail.tax_regime_code

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 1707: AND zls.entity_code = 'AP_INVOICES'

1703: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
1704: AND ai.vendor_id = ap.vendor_id
1705: AND ai.vendor_site_id = aps.vendor_site_id
1706: AND zls.application_id = 200
1707: AND zls.entity_code = 'AP_INVOICES'
1708: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1709: AND zls.trx_id = ai.invoice_id
1710: AND NVL(zls.tax_amt_included_flag, 'N') = 'N'
1711: AND NVL(zls.self_assessed_flag, 'N') = 'N'

Line 1763: AND zl.entity_code = 'AP_INVOICES'

1759: SET ail.included_tax_amount =
1760: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
1761: FROM zx_lines zl
1762: WHERE zl.application_id = 200
1763: AND zl.entity_code = 'AP_INVOICES'
1764: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1765: AND zl.trx_id = ail.invoice_id
1766: AND zl.trx_line_id = ail.line_number
1767: AND NVL(zl.self_assessed_flag, 'N') = 'N'

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 1855: AND zls.entity_code = 'AP_INVOICES'

1851: 'Y', NVL(zls.tax_amt, 0),
1852: 0))
1853: FROM zx_lines_summary zls
1854: WHERE zls.application_id = 200
1855: AND zls.entity_code = 'AP_INVOICES'
1856: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1857: AND zls.trx_id = ai.invoice_id
1858: AND NVL(zls.reporting_only_flag, 'N') = 'N')
1859: WHERE ai.invoice_id = P_Invoice_Header_Rec.invoice_id

Line 1905: AND zl.entity_code = 'AP_INVOICES'

1901: FROM zx_lines zl
1902: WHERE zl.trx_id = ail.invoice_id
1903: AND zl.trx_line_id = ail.line_number
1904: AND zl.application_id = 200
1905: AND zl.entity_code = 'AP_INVOICES'
1906: AND nvl(zl.reporting_only_flag, 'N') = 'N');
1907: */
1908:
1909: EXCEPTION

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 4800: AND gt.entity_code = 'AP_INVOICES'

4796: dist.invoice_distribution_id
4797: FROM zx_trx_headers_gt gt,
4798: ap_invoice_distributions_all dist
4799: WHERE gt.application_id = 200
4800: AND gt.entity_code = 'AP_INVOICES'
4801: AND gt.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
4802: AND gt.trx_id = dist.invoice_id
4803: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')
4804: AND dist.invoice_line_number NOT IN

Line 4910: AND ve.entity_code = 'AP_INVOICES'

4906: ail.invoice_line_id invoice_line_id
4907: FROM zx_validation_errors_gt ve,
4908: ap_invoice_lines_interface ail
4909: WHERE ve.application_id = 200
4910: AND ve.entity_code = 'AP_INVOICES'
4911: AND ve.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
4912: AND ve.trx_id = P_Invoice_Header_Rec.invoice_id
4913: AND ail.invoice_id = ve.trx_id;
4914: --AND ail.line_number = ve.trx_line_id; -- bug6255826

Line 4949: p_parent_table => 'AP_INVOICES_INTERFACE',

4945: END IF;
4946: -----------------------------------------------------------------
4947: IF (rej_lines(i).line_number IS NULL) THEN -- rejection is at invoice level
4948: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
4949: p_parent_table => 'AP_INVOICES_INTERFACE',
4950: p_parent_id => rej_lines(i).invoice_id,
4951: p_reject_code => rej_lines(i).rejection_code,
4952: p_last_updated_by => l_user_id,
4953: p_last_update_login => l_login_id,

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 5156: AND zdl.entity_code = 'AP_INVOICES'

5152: (SELECT NVL(ail.amount, 0) - SUM(NVL(zdl.tax_amt,0)),
5153: NVL(ail.base_amount,0) - SUM(NVL(zdl.tax_amt_funcl_curr,0))
5154: FROM zx_detail_tax_lines_gt zdl
5155: WHERE zdl.application_id = 200
5156: AND zdl.entity_code = 'AP_INVOICES'
5157: AND zdl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
5158: AND zdl.trx_id = ail.invoice_id
5159: AND zdl.trx_line_id = ail.line_number
5160: AND NVL(zdl.self_assessed_flag, 'N') = 'N'

Line 5316: AND entity_code = 'AP_INVOICES'

5312: --- Start for bug 6485124
5313: FROM zx_lines_det_factors
5314: WHERE trx_id = p_invoice_id
5315: AND application_id = 200
5316: AND entity_code = 'AP_INVOICES'
5317: AND event_class_code IN
5318: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
5319: AND ROWNUM=1;
5320: --- End for bug 6485124

Line 5630: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;

5626: l_parent_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
5627: l_prepay_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
5628: l_pa_addition_flag ap_invoice_distributions.pa_addition_flag%TYPE;
5629: l_match_status_flag ap_invoice_distributions.match_status_flag%TYPE;
5630: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
5631: l_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;
5632: l_parent_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;
5633: l_parent_line_number ap_invoice_lines.line_number%TYPE;
5634: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;

Line 5683: ap_invoices ai,

5679: l_parent_dist_amount,
5680: l_prepay_amount_remaining
5681: FROM ap_invoice_distributions aid,
5682: ap_invoice_distributions aid1,
5683: ap_invoices ai,
5684: ap_invoice_lines ail,
5685: ap_invoice_lines ail1
5686: WHERE ai.invoice_id = p_invoice_id
5687: AND ail.invoice_id = ai.invoice_id

Line 6469: FROM ap_invoices ai

6465: AND language = userenv ('LANG');
6466:
6467: CURSOR c_tax_rel_inv_num (c_inv_id VARCHAR2) IS
6468: SELECT ai.invoice_num tax_related_invoice_num
6469: FROM ap_invoices ai
6470: WHERE ai.invoice_id = c_inv_id;
6471:
6472: CURSOR c_doc_sub_type (c_class_code VARCHAR2,
6473: c_ctry_code VARCHAR2) IS

Line 6978: p_entity_code => 'AP_INVOICES',

6974: x_return_status => x_return_status,
6975: x_msg_count => x_msg_count,
6976: x_msg_data => x_msg_data,
6977: p_application_id => 200,
6978: p_entity_code => 'AP_INVOICES',
6979: p_event_class_code => l_event_class_code,
6980: p_org_id => p_org_id,
6981: p_item_id => p_item_id,
6982: p_country_code => p_country_code,

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,