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

548: -------------------------------------------------------------------
549: IF ( P_Corrected_Invoice_Id IS NOT NULL) THEN
550:
551: P_Application_Id := 200; -- Oracle Payables
552: P_Entity_code := 'AP_INVOICES';
553:
554: BEGIN
555: OPEN corrected_inv (P_Corrected_Invoice_Id);
556: FETCH corrected_inv

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

669: -------------------------------------------------------------------
670: IF ( P_Prepay_Invoice_Id IS NOT NULL) THEN
671:
672: P_Application_Id := 200;
673: P_Entity_code := 'AP_INVOICES';
674:
675: BEGIN
676: OPEN prepay_inv (P_Prepay_Invoice_Id);
677: FETCH prepay_inv

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

1260: /* AND EXISTS
1261: (SELECT zl.summary_tax_line_id
1262: FROM zx_lines_summary zl
1263: WHERE zl.application_id = 200
1264: AND zl.entity_code = 'AP_INVOICES'
1265: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1266: AND zl.trx_id = ail.invoice_id
1267: AND zl.tax_regime_code = ail.tax_regime_code
1268: AND zl.tax = ail.tax

Line 1459: AND zl.entity_code = 'AP_INVOICES'

1455: UPDATE ap_invoice_lines_all ail
1456: SET ail.summary_tax_line_id = (SELECT zl.summary_tax_line_id
1457: FROM zx_lines zl
1458: WHERE zl.application_id = 200
1459: AND zl.entity_code = 'AP_INVOICES'
1460: AND zl.event_class_code IN
1461: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1462: AND zl.trx_id = ail.invoice_id
1463: AND zl.tax_regime_code = ail.tax_regime_code

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

1967: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
1968: AND ai.vendor_id = ap.vendor_id
1969: AND ai.vendor_site_id = aps.vendor_site_id
1970: AND zls.application_id = 200
1971: AND zls.entity_code = 'AP_INVOICES'
1972: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1973: AND zls.trx_id = ai.invoice_id
1974: AND NVL(zls.tax_amt_included_flag, 'N') = 'N'
1975: AND NVL(zls.self_assessed_flag, 'N') = 'N'

Line 2027: AND zl.entity_code = 'AP_INVOICES'

2023: SET ail.included_tax_amount =
2024: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
2025: FROM zx_lines zl
2026: WHERE zl.application_id = 200
2027: AND zl.entity_code = 'AP_INVOICES'
2028: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
2029: AND zl.trx_id = ail.invoice_id
2030: AND zl.trx_line_id = ail.line_number
2031: AND NVL(zl.self_assessed_flag, 'N') = 'N'

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

2127: 'Y', NVL(zls.tax_amt, 0),
2128: 0))
2129: FROM zx_lines_summary zls
2130: WHERE zls.application_id = 200
2131: AND zls.entity_code = 'AP_INVOICES'
2132: AND zls.event_class_code IN
2133: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
2134: AND zls.trx_id = ai.invoice_id
2135: AND NVL(zls.reporting_only_flag, 'N') = 'N')

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

2192: FROM zx_lines zl
2193: WHERE zl.trx_id = ail.invoice_id
2194: AND zl.trx_line_id = ail.line_number
2195: AND zl.application_id = 200
2196: AND zl.entity_code = 'AP_INVOICES'
2197: AND nvl(zl.reporting_only_flag, 'N') = 'N');
2198: */
2199:
2200: EXCEPTION

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

5944: dist.invoice_distribution_id
5945: FROM zx_trx_headers_gt gt,
5946: ap_invoice_distributions_all dist
5947: WHERE gt.application_id = 200
5948: AND gt.entity_code = 'AP_INVOICES'
5949: AND gt.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
5950: AND gt.trx_id = dist.invoice_id
5951: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')
5952: AND dist.invoice_line_number NOT IN

Line 6077: AND ve.entity_code = 'AP_INVOICES'

6073: ail.invoice_line_id invoice_line_id
6074: FROM zx_validation_errors_gt ve,
6075: ap_invoice_lines_interface ail
6076: WHERE ve.application_id = 200
6077: AND ve.entity_code = 'AP_INVOICES'
6078: AND ve.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
6079: AND ve.trx_id = P_Invoice_Header_Rec.invoice_id
6080: AND ail.invoice_id = ve.trx_id;
6081: --AND ail.line_number = ve.trx_line_id; -- bug6255826

Line 6114: p_parent_table => 'AP_INVOICES_INTERFACE',

6110: END IF;
6111: -----------------------------------------------------------------
6112: IF (rej_lines(i).line_number IS NULL) THEN -- rejection is at invoice level
6113: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
6114: p_parent_table => 'AP_INVOICES_INTERFACE',
6115: p_parent_id => rej_lines(i).invoice_id,
6116: p_reject_code => rej_lines(i).rejection_code,
6117: p_last_updated_by => l_user_id,
6118: p_last_update_login => l_login_id,

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

6327: (SELECT NVL(ail.amount, 0) - SUM(NVL(zdl.tax_amt,0)),
6328: NVL(ail.base_amount,0) - SUM(NVL(zdl.tax_amt_funcl_curr,0))
6329: FROM zx_detail_tax_lines_gt zdl
6330: WHERE zdl.application_id = 200
6331: AND zdl.entity_code = 'AP_INVOICES'
6332: AND zdl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
6333: AND zdl.trx_id = ail.invoice_id
6334: AND zdl.trx_line_id = ail.line_number
6335: AND NVL(zdl.self_assessed_flag, 'N') = 'N'

Line 6492: AND entity_code = 'AP_INVOICES'

6488: --- Start for bug 6485124
6489: FROM zx_lines_det_factors
6490: WHERE trx_id = p_invoice_id
6491: AND application_id = 200
6492: AND entity_code = 'AP_INVOICES'
6493: AND event_class_code IN
6494: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
6495: AND ROWNUM=1;
6496: --- End for bug 6485124

Line 6858: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;

6854: l_parent_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6855: l_prepay_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6856: l_pa_addition_flag ap_invoice_distributions.pa_addition_flag%TYPE;
6857: l_match_status_flag ap_invoice_distributions.match_status_flag%TYPE;
6858: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
6859: l_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;
6860: l_parent_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;
6861: l_parent_line_number ap_invoice_lines.line_number%TYPE;
6862: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;

Line 6911: ap_invoices ai,

6907: l_parent_dist_amount,
6908: l_prepay_amount_remaining
6909: FROM ap_invoice_distributions aid,
6910: ap_invoice_distributions aid1,
6911: ap_invoices ai,
6912: ap_invoice_lines ail,
6913: ap_invoice_lines ail1
6914: WHERE ai.invoice_id = p_invoice_id
6915: AND ail.invoice_id = ai.invoice_id

Line 8542: FROM ap_invoices ai

8538: AND language = userenv ('LANG');
8539:
8540: CURSOR c_tax_rel_inv_num (c_inv_id VARCHAR2) IS
8541: SELECT ai.invoice_num tax_related_invoice_num
8542: FROM ap_invoices ai
8543: WHERE ai.invoice_id = c_inv_id;
8544:
8545: CURSOR c_doc_sub_type (c_class_code VARCHAR2,
8546: c_ctry_code VARCHAR2) IS

Line 9114: p_entity_code => 'AP_INVOICES',

9110: x_return_status => x_return_status,
9111: x_msg_count => x_msg_count,
9112: x_msg_data => x_msg_data,
9113: p_application_id => 200,
9114: p_entity_code => 'AP_INVOICES',
9115: p_event_class_code => l_event_class_code,
9116: p_org_id => p_org_id,
9117: p_item_id => p_item_id,
9118: p_country_code => p_country_code,

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 10305: AND ZD.entity_code = 'AP_INVOICES'

10301: SELECT COUNT('INCLUSIVE TAX CALC ON POSTED DISTS')
10302: INTO l_allow_update
10303: FROM zx_rec_nrec_dist ZD
10304: WHERE ZD.application_id = 200
10305: AND ZD.entity_code = 'AP_INVOICES'
10306: AND ZD.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
10307: AND ZD.trx_id = p_invoice_id
10308: AND ZD.inclusive_flag = 'Y'
10309: AND ZD.rec_nrec_tax_dist_id IN

Line 10333: AND ZD.entity_code = 'AP_INVOICES'

10329: SELECT COUNT('INCLUSIVE TAX CALC ON POSTED DISTS')
10330: INTO l_allow_update
10331: FROM zx_rec_nrec_dist ZD
10332: WHERE ZD.application_id = 200
10333: AND ZD.entity_code = 'AP_INVOICES'
10334: AND ZD.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
10335: AND ZD.trx_id = p_invoice_id
10336: AND ZD.inclusive_flag = 'Y'
10337: AND ZD.rec_nrec_tax_dist_id IN

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 10819: --of ap_invoices_pkg.r_invoice_line_rec

10815: GLOBAL_ATTRIBUTE18,
10816: GLOBAL_ATTRIBUTE19,
10817: GLOBAL_ATTRIBUTE20,
10818: --ETAX: Invwkb, added included_tax_amount as modified the def
10819: --of ap_invoices_pkg.r_invoice_line_rec
10820: INCLUDED_TAX_AMOUNT,
10821: PRIMARY_INTENDED_USE,
10822: APPLICATION_ID,
10823: PRODUCT_TABLE,

Line 10837: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;

10833: FROM ap_invoice_lines_all
10834: WHERE invoice_id = p_invoice_id
10835: AND line_number = p_line_number;
10836:
10837: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
10838: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
10839: debug_info VARCHAR2(2000);
10840: debug_context VARCHAR2(2000);
10841: l_dist_code_concat VARCHAR2(2000);

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

Line 11026: AP_INVOICES_PKG.get_expenditure_item_date(

11022: END IF;
11023: IF (l_invoice_line_rec.project_id is not null) THEN
11024: IF (l_invoice_line_rec.expenditure_item_date is null) THEN
11025: l_invoice_line_rec.expenditure_item_date :=
11026: AP_INVOICES_PKG.get_expenditure_item_date(
11027: l_invoice_line_rec.invoice_id,
11028: l_invoice_date,
11029: l_invoice_line_rec.accounting_date,
11030: NULL,