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_INVOICE_LINES

Line 1092: -- ,ap_invoice_lines_all ail

1088:
1089: CURSOR prepay_awt_group_id (c_prepay_dist_id IN NUMBER) IS
1090: SELECT aid.awt_group_id
1091: FROM ap_invoice_distributions_all aid
1092: -- ,ap_invoice_lines_all ail
1093: WHERE aid.invoice_distribution_id = c_prepay_dist_id;
1094: -- AND aid.invoice_id = ail.invoice_id
1095: -- AND aid.invoice_line_number = ail.line_number;
1096: --Bug8334059 Awt_group_id will be retrieved from ap_invoice_distributions_all

Line 1098: l_awt_group_id ap_invoice_lines_all.awt_group_id%TYPE;

1094: -- AND aid.invoice_id = ail.invoice_id
1095: -- AND aid.invoice_line_number = ail.line_number;
1096: --Bug8334059 Awt_group_id will be retrieved from ap_invoice_distributions_all
1097:
1098: l_awt_group_id ap_invoice_lines_all.awt_group_id%TYPE;
1099:
1100: BEGIN
1101:
1102: l_curr_calling_sequence := 'AP_ETAX_UTILITY_PKG.Get_Prepay_Awt_Group_Id<-'||

Line 1173: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;

1169: l_debug_info VARCHAR2(240);
1170: l_curr_calling_sequence VARCHAR2(4000);
1171:
1172: l_period_name gl_period_statuses.period_name%TYPE;
1173: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1174: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
1175: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
1176: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;

Line 1181: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;

1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%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;

Line 1191: From ap_invoice_lines_all ail

1187:
1188: -- Allocations
1189: Cursor c_item_line (c_invoice_id IN NUMBER) IS
1190: Select ail.line_number
1191: From ap_invoice_lines_all ail
1192: Where ail.invoice_id = c_invoice_id
1193: And ail.line_type_lookup_code = 'TAX'
1194: And ail.prepay_invoice_id IS NULL;
1195:

Line 1233: FROM AP_INVOICE_LINES_ALL ail

1229: l_ap_summary_tax_line_id := NULL;
1230:
1231: SELECT ail.line_number, ail.summary_tax_line_id
1232: INTO l_invoice_line_number, l_ap_summary_tax_line_id
1233: FROM AP_INVOICE_LINES_ALL ail
1234: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1235: AND ail.line_type_lookup_code = 'TAX'
1236: AND NOT EXISTS
1237: (SELECT ls.summary_tax_line_id

Line 1372: UPDATE ap_invoice_lines_all ail

1368: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1369: END IF;
1370: -------------------------------------------------------------------
1371: BEGIN
1372: UPDATE ap_invoice_lines_all ail
1373: SET
1374: (-- Bug 10157751 ail.description,
1375: ail.amount,
1376: ail.base_amount,

Line 1445: /* Start for bug 5943074-- updating summary_tax_line_id of ap_invoice_lines_all based on zx_lines

1441:
1442: APP_EXCEPTION.RAISE_EXCEPTION;
1443: END;
1444:
1445: /* Start for bug 5943074-- updating summary_tax_line_id of ap_invoice_lines_all based on zx_lines
1446: for manual tax lines and tax only lines so that we do not delete and regenerate the tax lines . */
1447: -------------------------------------------------------------------
1448: l_debug_info := 'Update summary tax line id for manual tax lines';
1449: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1455: UPDATE ap_invoice_lines_all ail

1451: END IF;
1452: -------------------------------------------------------------------
1453: BEGIN
1454:
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'

Line 1481: FROM ap_invoice_lines_all ail2

1477: AND ail.line_source in ('MANUAL LINE ENTRY','IMPORTED')
1478: AND ail.summary_tax_line_id IS NULL
1479: AND NOT EXISTS
1480: (SELECT 1
1481: FROM ap_invoice_lines_all ail2
1482: WHERE ail2.invoice_id = ail.invoice_id
1483: AND ail2.line_number <> ail.line_number
1484: AND ail2.tax_regime_code = ail.tax_regime_code
1485: AND ail2.tax = ail.tax

Line 1519: DELETE ap_invoice_lines_all ail

1515: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1516: END IF;
1517: -------------------------------------------------------------------
1518: BEGIN
1519: DELETE ap_invoice_lines_all ail
1520: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1521: AND ail.line_type_lookup_code = 'TAX'
1522: AND NOT EXISTS (SELECT ls.summary_tax_line_id
1523: FROM zx_lines_summary ls

Line 1536: FROM ap_invoice_lines_all l

1532: DELETE FROM ap_allocation_rules ar
1533: WHERE ar.invoice_id = p_invoice_header_rec.invoice_id
1534: AND NOT EXISTS
1535: (SELECT 'y'
1536: FROM ap_invoice_lines_all l
1537: WHERE l.invoice_id = ar.invoice_id
1538: AND l.line_number = ar.chrg_invoice_line_number);
1539:
1540: DELETE FROM ap_allocation_rule_lines arl

Line 1544: FROM ap_invoice_lines_all l

1540: DELETE FROM ap_allocation_rule_lines arl
1541: WHERE arl.invoice_id = p_invoice_header_rec.invoice_id
1542: AND NOT EXISTS
1543: (SELECT 'y'
1544: FROM ap_invoice_lines_all l
1545: WHERE l.invoice_id = arl.invoice_id
1546: AND l.line_number = arl.chrg_invoice_line_number);
1547: -- Bug 7260087 ends
1548:

Line 1600: INSERT INTO ap_invoice_lines_all (

1596: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1597: END IF;
1598: -------------------------------------------------------------------
1599: BEGIN
1600: INSERT INTO ap_invoice_lines_all (
1601: invoice_id,
1602: line_number,
1603: line_type_lookup_code,
1604: requester_id,

Line 1770: FROM ap_invoice_lines_all ail2

1766: pay_awt_group_id) --Bug8345264
1767: SELECT
1768: P_Invoice_Header_Rec.Invoice_Id, -- invoice_id
1769: (SELECT NVL(MAX(ail2.line_number),0)
1770: FROM ap_invoice_lines_all ail2
1771: WHERE ail2.invoice_id = zls.trx_id) + ROWNUM, -- line_number
1772: 'TAX', -- line_type_lookup_code
1773: null, -- requester_id
1774: NVL( AI.description, zls.tax_regime_code||' - '||zls.tax ), -- description Bug 10157751

Line 1966: ap_invoice_lines_all prepay

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
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

Line 1980: FROM ap_invoice_lines_all il

1976: AND NVL(zls.reporting_only_flag, 'N') = 'N'
1977: AND zls.applied_from_trx_id = prepay.invoice_id(+)
1978: AND zls.applied_from_line_id = prepay.line_number(+)
1979: AND NOT EXISTS (SELECT il.summary_tax_line_id
1980: FROM ap_invoice_lines_all il
1981: WHERE il.invoice_id = ai.invoice_id
1982: AND il.summary_tax_line_id = zls.summary_tax_line_id)
1983: AND EXISTS
1984: (SELECT 'Recoupment Exists'

Line 2022: UPDATE ap_invoice_lines_all ail

2018: END IF;
2019: -------------------------------------------------------------------
2020: BEGIN
2021: --bug 6931461
2022: UPDATE ap_invoice_lines_all ail
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

Line 2115: FROM ap_invoice_lines_all prepay

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'
2115: FROM ap_invoice_lines_all prepay
2116: WHERE prepay.invoice_id = zls.trx_id
2117: AND prepay.line_type_lookup_code = 'PREPAY'
2118: AND prepay.prepay_invoice_id = zls.applied_from_trx_id
2119: AND prepay.prepay_line_number = zls.applied_from_line_id

Line 2146: FROM ap_invoice_lines_all ail

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
2148: AND line_type_lookup_code ='RETROTAX'))
2149:
2150: WHERE ai.invoice_id = P_Invoice_Header_Rec.invoice_id

Line 2180: UPDATE ap_invoice_lines_all ail

2176: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2177: END IF;
2178: -----------------------------------------------------------------
2179: BEGIN
2180: UPDATE ap_invoice_lines_all ail
2181: SET ail.tax_already_calculated_flag = 'Y'
2182: WHERE ail.invoice_id = P_invoice_header_rec.invoice_id
2183: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
2184: AND NVL(ail.tax_already_calculated_flag, 'N') = 'N';

Line 2213: UPDATE ap_invoice_lines_all tax

2209: END IF;
2210: -----------------------------------------------------------------
2211:
2212: /*added the case for bug 8638881*/
2213: UPDATE ap_invoice_lines_all tax
2214: SET tax.invoice_includes_prepay_flag = CASE WHEN EXISTS (SELECT 'Prepay App Exists'
2215: FROM ap_invoice_lines_all prepay
2216: WHERE prepay.invoice_id = tax.invoice_id
2217: AND prepay.line_type_lookup_code = 'PREPAY'

Line 2215: FROM ap_invoice_lines_all prepay

2211:
2212: /*added the case for bug 8638881*/
2213: UPDATE ap_invoice_lines_all tax
2214: SET tax.invoice_includes_prepay_flag = CASE WHEN EXISTS (SELECT 'Prepay App Exists'
2215: FROM ap_invoice_lines_all prepay
2216: WHERE prepay.invoice_id = tax.invoice_id
2217: AND prepay.line_type_lookup_code = 'PREPAY'
2218: AND prepay.prepay_invoice_id = tax.prepay_invoice_id
2219: AND prepay.prepay_line_number = tax.prepay_line_number

Line 2704: ap_invoice_lines_all parent_tax_line,

2700: ap_supplier_sites_all pvs,
2701: ap_system_parameters_all asp,
2702: financials_system_params_all fsp,
2703: po_distributions_all pd,
2704: ap_invoice_lines_all parent_tax_line,
2705: ap_invoice_lines_all parent_item_line,
2706: ap_invoice_distributions_all parent_taxable_dist
2707: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2708: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 2705: ap_invoice_lines_all parent_item_line,

2701: ap_system_parameters_all asp,
2702: financials_system_params_all fsp,
2703: po_distributions_all pd,
2704: ap_invoice_lines_all parent_tax_line,
2705: ap_invoice_lines_all parent_item_line,
2706: ap_invoice_distributions_all parent_taxable_dist
2707: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2708: AND gt.ENTITY_CODE = zd.ENTITY_CODE
2709: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 3051: ap_invoice_lines_all parent_tax_line,

3047: ap_supplier_sites_all pvs,
3048: ap_system_parameters_all asp,
3049: financials_system_params_all fsp,
3050: po_distributions_all pd,
3051: ap_invoice_lines_all parent_tax_line,
3052: ap_invoice_lines_all parent_item_line,
3053: ap_invoice_distributions_all parent_taxable_dist,
3054: ap_line_temp_gt dist
3055: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID

Line 3052: ap_invoice_lines_all parent_item_line,

3048: ap_system_parameters_all asp,
3049: financials_system_params_all fsp,
3050: po_distributions_all pd,
3051: ap_invoice_lines_all parent_tax_line,
3052: ap_invoice_lines_all parent_item_line,
3053: ap_invoice_distributions_all parent_taxable_dist,
3054: ap_line_temp_gt dist
3055: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3056: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 3330: ap_invoice_lines_all parent_tax_line,

3326: ap_supplier_sites_all pvs,
3327: ap_system_parameters_all asp,
3328: financials_system_params_all fsp,
3329: po_distributions_all pd,
3330: ap_invoice_lines_all parent_tax_line,
3331: ap_invoice_lines_all parent_item_line,
3332: ap_invoice_distributions_all parent_taxable_dist
3333: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3334: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 3331: ap_invoice_lines_all parent_item_line,

3327: ap_system_parameters_all asp,
3328: financials_system_params_all fsp,
3329: po_distributions_all pd,
3330: ap_invoice_lines_all parent_tax_line,
3331: ap_invoice_lines_all parent_item_line,
3332: ap_invoice_distributions_all parent_taxable_dist
3333: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3334: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3335: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 3571: ap_invoice_lines_all parent_tax_line,

3567: ap_supplier_sites_all pvs,
3568: ap_system_parameters_all asp,
3569: financials_system_params_all fsp,
3570: po_distributions_all pd,
3571: ap_invoice_lines_all parent_tax_line,
3572: ap_invoice_lines_all parent_item_line,
3573: ap_invoice_distributions_all parent_taxable_dist
3574: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3575: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 3572: ap_invoice_lines_all parent_item_line,

3568: ap_system_parameters_all asp,
3569: financials_system_params_all fsp,
3570: po_distributions_all pd,
3571: ap_invoice_lines_all parent_tax_line,
3572: ap_invoice_lines_all parent_item_line,
3573: ap_invoice_distributions_all parent_taxable_dist
3574: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3575: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3576: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 3790: ap_invoice_lines_all parent_item_line,

3786: ap_supplier_sites_all pvs,
3787: ap_system_parameters_all asp,
3788: financials_system_params_all fsp,
3789: po_distributions_all pd,
3790: ap_invoice_lines_all parent_item_line,
3791: ap_invoice_distributions_all parent_taxable_dist
3792: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3793: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3794: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 3990: ap_invoice_lines_all parent_tax_line,

3986: ap_supplier_sites_all pvs,
3987: ap_system_parameters_all asp,
3988: financials_system_params_all fsp,
3989: po_distributions_all pd,
3990: ap_invoice_lines_all parent_tax_line,
3991: ap_invoice_lines_all parent_item_line,
3992: ap_invoice_distributions_all parent_taxable_dist
3993: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3994: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 3991: ap_invoice_lines_all parent_item_line,

3987: ap_system_parameters_all asp,
3988: financials_system_params_all fsp,
3989: po_distributions_all pd,
3990: ap_invoice_lines_all parent_tax_line,
3991: ap_invoice_lines_all parent_item_line,
3992: ap_invoice_distributions_all parent_taxable_dist
3993: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3994: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3995: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 5938: FROM ap_invoice_lines_all ail

5934:
5935: BEGIN -- Bug 9777752
5936: UPDATE ap_invoice_distributions_all aid
5937: SET invoice_line_number = (SELECT line_number
5938: FROM ap_invoice_lines_all ail
5939: WHERE ail.invoice_id = aid.invoice_id
5940: AND ail.summary_tax_line_id = aid.summary_tax_line_id
5941: AND rownum = 1)
5942: WHERE aid.invoice_distribution_id IN

Line 5954: FROM ap_invoice_lines_all al

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
5953: (SELECT line_number
5954: FROM ap_invoice_lines_all al
5955: WHERE al.invoice_id = dist.invoice_id)
5956: );
5957:
5958: EXCEPTION

Line 6051: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);

6047: invoice_id zx_validation_errors_gt.trx_id%TYPE,
6048: line_number zx_validation_errors_gt.trx_line_id%TYPE,
6049: rejection_code zx_validation_errors_gt.message_name%TYPE,
6050: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,
6051: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);
6052:
6053: TYPE rej_lines_tab IS TABLE OF rej_lines_rec;
6054: rej_lines rej_lines_tab;
6055:

Line 6075: ap_invoice_lines_interface ail

6071: ve.message_name rejection_code,
6072: ve.summary_tax_line_number summary_tax_line_number,
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

Line 6127: p_parent_table => 'AP_INVOICE_LINES_INTERFACE',

6123:
6124: ELSE -- rejection is at line level
6125:
6126: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections(
6127: p_parent_table => 'AP_INVOICE_LINES_INTERFACE',
6128: p_parent_id => rej_lines(i).invoice_line_id,
6129: p_reject_code => rej_lines(i).rejection_code,
6130: p_last_updated_by => l_user_id,
6131: p_last_update_login => l_login_id,

Line 6325: UPDATE ap_invoice_lines_all ail

6321: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6322: END IF;
6323: -------------------------------------------------------------------
6324: BEGIN
6325: UPDATE ap_invoice_lines_all ail
6326: SET (ail.amount, ail.base_amount) =
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

Line 6498: /* FROM ap_invoice_lines_all

6494: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
6495: AND ROWNUM=1;
6496: --- End for bug 6485124
6497: -- commented for bug 6485124
6498: /* FROM ap_invoice_lines_all
6499: WHERE invoice_id = p_invoice_id
6500: AND line_type_lookup_code <> 'AWT'
6501: AND (tax_already_calculated_flag = 'Y'
6502: OR summary_tax_line_id IS NOT NULL)

Line 6612: FROM ap_invoice_lines_all

6608: END IF;
6609: -------------------------------------------------------------------
6610: SELECT 'Y'
6611: INTO l_tax_already_calculated_flag
6612: FROM ap_invoice_lines_all
6613: WHERE invoice_id = p_invoice_id
6614: AND line_type_lookup_code <> 'AWT'
6615: AND (tax_already_calculated_flag = 'Y'
6616: OR summary_tax_line_id IS NOT NULL)

Line 6859: l_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%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;
6863: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;

Line 6860: l_parent_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%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;
6863: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
6864: l_po_distribution_id po_distributions.po_distribution_id%TYPE;

Line 6861: l_parent_line_number ap_invoice_lines.line_number%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;
6863: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
6864: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
6865: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;

Line 6862: l_discarded_flag ap_invoice_lines.discarded_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;
6863: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
6864: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
6865: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
6866: l_parent_dist_amount ap_invoice_distributions.amount%TYPE;

Line 6912: ap_invoice_lines ail,

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
6916: AND ail.line_number = aid.invoice_line_number

Line 6913: ap_invoice_lines ail1

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
6916: AND ail.line_number = aid.invoice_line_number
6917: AND aid.invoice_id = ai.invoice_id

Line 6965: (ap_invoice_lines_utility_pkg.is_line_a_adjustment(p_invoice_id,

6961: l_debug_info := 'Checking if parent item line is a adjustment or referred by a adjustment';
6962:
6963: IF (l_parent_line_number IS NOT NULL) THEN
6964: IF (l_tax_dist_frozen = 'N' AND
6965: (ap_invoice_lines_utility_pkg.is_line_a_adjustment(p_invoice_id,
6966: l_parent_line_number,
6967: l_curr_calling_sequence) or
6968: ap_invoice_lines_utility_pkg.line_referred_by_adjustment(
6969: p_invoice_id,

Line 6968: ap_invoice_lines_utility_pkg.line_referred_by_adjustment(

6964: IF (l_tax_dist_frozen = 'N' AND
6965: (ap_invoice_lines_utility_pkg.is_line_a_adjustment(p_invoice_id,
6966: l_parent_line_number,
6967: l_curr_calling_sequence) or
6968: ap_invoice_lines_utility_pkg.line_referred_by_adjustment(
6969: p_invoice_id,
6970: l_parent_line_number,
6971: l_curr_calling_sequence))) THEN
6972:

Line 6984: (ap_invoice_lines_utility_pkg.is_line_a_correction(p_invoice_id,

6980: l_debug_info := 'Checking if parent item line is corrected or is a correction';
6981:
6982: IF (l_parent_line_number IS NOT NULL) THEN
6983: IF (l_tax_dist_frozen = 'N' AND
6984: (ap_invoice_lines_utility_pkg.is_line_a_correction(p_invoice_id,
6985: l_parent_line_number,
6986: l_curr_calling_sequence) or
6987: ap_invoice_lines_utility_pkg.line_referred_by_corr(p_invoice_id,
6988: l_parent_line_number,

Line 6987: ap_invoice_lines_utility_pkg.line_referred_by_corr(p_invoice_id,

6983: IF (l_tax_dist_frozen = 'N' AND
6984: (ap_invoice_lines_utility_pkg.is_line_a_correction(p_invoice_id,
6985: l_parent_line_number,
6986: l_curr_calling_sequence) or
6987: ap_invoice_lines_utility_pkg.line_referred_by_corr(p_invoice_id,
6988: l_parent_line_number,
6989: l_curr_calling_sequence))) THEN
6990:
6991: l_tax_dist_frozen := 'Y';

Line 9039: l_product_type ap_invoice_lines_all.product_type%type;

9035: l_tax_effective_date DATE;
9036: l_success BOOLEAN;
9037: l_error_code VARCHAR2(30);
9038: l_event_class_code VARCHAR2(100);
9039: l_product_type ap_invoice_lines_all.product_type%type;
9040:
9041: l_debug_info VARCHAR2(240);
9042: l_curr_calling_sequence VARCHAR2(4000);
9043: l_api_name CONSTANT VARCHAR2(100) := 'get_default_tax_det_attribs';

Line 9186: l_dist_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num(

9182:
9183: -- bug 7126676
9184: select ap_invoice_distributions_s.NEXTVAL into l_invoice_distribution_id from dual;
9185:
9186: l_dist_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
9187: p_inv_dist_rec.invoice_id,
9188: p_inv_dist_rec.invoice_line_number)+1; /*bug 10282701*/
9189:
9190: INSERT INTO ap_invoice_distributions_all (

Line 10055: FROM ap_invoice_lines_all

10051: l_debug_info := 'Step 2: Check Prepayment Applied ';
10052: -------------------------------------------------------------------
10053: SELECT count(line_number)
10054: INTO l_Prepay_line_count
10055: FROM ap_invoice_lines_all
10056: WHERE invoice_id = p_invoice_id
10057: AND line_type_lookup_code ='PREPAY'
10058: AND (NVL(discarded_flag,'N') <> 'Y');
10059:

Line 10130: FROM ap_invoice_lines_all

10126:
10127: IF NVL(l_Invoice_Type,'A') IN ('DEBIT','CREDIT') THEN
10128: SELECT COUNT(CORRECTED_INV_ID)
10129: INTO l_corr_inv_count
10130: FROM ap_invoice_lines_all
10131: WHERE invoice_id = p_invoice_id
10132: AND CORRECTED_INV_ID IS NOT NULL
10133: AND (NVL(discarded_flag,'N') <> 'Y');
10134:

Line 10151: FROM ap_invoice_lines_all ail

10147: --Bug8920386
10148:
10149: SELECT count(line_number)
10150: INTO l_manual_Awt_line
10151: FROM ap_invoice_lines_all ail
10152: WHERE invoice_id = p_invoice_id
10153: AND line_type_lookup_code ='AWT'
10154: AND (NVL(discarded_flag,'N') <> 'Y')
10155: AND line_source = 'MANUAL LINE ENTRY'

Line 10219: FROM ap_invoice_lines_all

10215:
10216: IF l_Po_Dist_id_count = 0 THEN
10217: SELECT COUNT(po_header_id)
10218: INTO l_Po_line_num_count
10219: FROM ap_invoice_lines_all
10220: WHERE invoice_id = p_invoice_id
10221: AND line_number = p_line_number
10222: AND po_header_id IS NOT NULL;
10223: END IF;

Line 10594: l_debug_info := 'Querying for distribution_set_id from ap_invoice_lines' ;

10590: IF p_distribution_set_id IS NULL AND
10591: p_invoice_id IS NOT NULL AND
10592: p_invoice_line_number IS NOT NULL
10593: THEN
10594: l_debug_info := 'Querying for distribution_set_id from ap_invoice_lines' ;
10595: /* Bug 12874059 begins */
10596: BEGIN
10597: SELECT distribution_set_id
10598: INTO l_distribution_set_id

Line 10599: FROM ap_invoice_lines AIL

10595: /* Bug 12874059 begins */
10596: BEGIN
10597: SELECT distribution_set_id
10598: INTO l_distribution_set_id
10599: FROM ap_invoice_lines AIL
10600: WHERE AIL.invoice_id = p_invoice_id
10601: AND AIL.line_number = p_invoice_line_number ;
10602: EXCEPTION --Bug 12874059 begin
10603: WHEN NO_DATA_FOUND THEN

Line 10833: FROM ap_invoice_lines_all

10829: --bugfix:4674194
10830: SHIP_TO_LOCATION_ID,
10831: --bug7022001
10832: PAY_AWT_GROUP_ID
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;

Line 11095: FROM ap_invoice_lines

11091: END;
11092:
11093: SELECT WEB_PARAMETER_ID
11094: INTO l_web_parameter_id
11095: FROM ap_invoice_lines
11096: WHERE invoice_id = p_invoice_id
11097: AND line_number = p_line_number;
11098:
11099: debug_info := 'Emp Id is: '||l_employee_id ||