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_SERVICES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 23: TYPE Inv_Lines_Tab_Type IS TABLE OF ap_invoice_lines_all%ROWTYPE;

19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_ETAX_SERVICES_PKG.';
21:
22: -- Define the structures for lines and distributions
23: TYPE Inv_Lines_Tab_Type IS TABLE OF ap_invoice_lines_all%ROWTYPE;
24: TYPE Inv_Dists_Tab_Type IS TABLE OF ap_invoice_distributions_all%ROWTYPE;
25:
26: l_inv_line_list Inv_Lines_Tab_Type;
27: l_inv_tax_list Inv_Lines_Tab_Type;

Line 281: FROM ap_invoice_lines_all

277: WHERE invoice_id = c_invoice_Id;
278:
279: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS
280: SELECT *
281: FROM ap_invoice_lines_all
282: WHERE invoice_id = c_invoice_id
283: AND (line_type_lookup_code NOT IN ('TAX', 'AWT','RETROTAX','RETROITEM') OR
284: (line_type_lookup_code = 'RETROITEM' AND match_type = 'PO_PRICE_ADJUSTMENT')) --Bug10416960
285: AND nvl(discarded_flag, 'N') <> 'Y' --Bug8811102

Line 293: FROM ap_invoice_lines_all

289: -- to calculate tax for only 1 line
290: CURSOR Invoice_Line (c_invoice_id NUMBER,
291: c_line_number NUMBER) IS
292: SELECT *
293: FROM ap_invoice_lines_all
294: WHERE invoice_id = c_invoice_id
295: AND line_number = c_line_number
296: AND (line_type_lookup_code NOT IN ('TAX', 'AWT','RETROTAX','RETROITEM') OR
297: (line_type_lookup_code = 'RETROITEM' AND match_type = 'PO_PRICE_ADJUSTMENT')) --Bug10416960

Line 303: FROM ap_invoice_lines_all

299: AND nvl(cancelled_flag, 'N') <> 'Y'; --Bug8811102
300:
301: CURSOR Tax_Lines_to_import (c_invoice_id IN NUMBER) IS
302: SELECT *
303: FROM ap_invoice_lines_all
304: WHERE invoice_id = c_invoice_id
305: AND line_type_lookup_code = 'TAX'
306: AND summary_tax_line_id IS NULL
307: AND nvl(discarded_flag, 'N') <> 'Y' --Bug8811102

Line 361: UPDATE /+ index(ail,AP_INVOICE_LINES_U1) / ap_invoice_lines_all ail

357: -----------------------------------------------------------------
358:
359: l_count := 0;
360: /* Added the following 3 hints for bug#8263883 */
361: UPDATE /*+ index(ail,AP_INVOICE_LINES_U1) */ ap_invoice_lines_all ail
362: SET tax_already_calculated_flag = NULL
363: WHERE ail.invoice_id IN (SELECT /*+ cardinality(gt 10) unnest */ DISTINCT(trx_id)
364: FROM zx_trx_headers_gt gt
365: WHERE application_id = 200

Line 387: l_debug_info := l_count ||' rows updated in ap_invoice_lines_all.';

383: AND zf.trx_line_id = ail.line_number);
384:
385: l_count := SQL%ROWCOUNT;
386: -----------------------------------------------------------------
387: l_debug_info := l_count ||' rows updated in ap_invoice_lines_all.';
388: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
389: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
390: END IF;
391: --Print(l_api_name, l_debug_info);

Line 498: UPDATE ap_invoice_lines_all ail

494:
495:
496: l_count:=0;
497:
498: UPDATE ap_invoice_lines_all ail
499: SET tax_already_calculated_flag = NULL
500: WHERE ail.invoice_id = p_invoice_id
501: AND nvl(ail.tax_already_calculated_flag, 'N') = 'Y'
502: AND NVL(ail.historical_flag, 'N') = 'N' --bug14671024

Line 514: l_debug_info := l_count ||' rows updated in ap_invoice_lines_all.';

510: and zf.trx_line_id = ail.line_number);
511:
512: l_count := SQL%ROWCOUNT;
513: -----------------------------------------------------------------
514: l_debug_info := l_count ||' rows updated in ap_invoice_lines_all.';
515: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
516: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
517: END IF;
518: --Print(l_api_name, l_debug_info);

Line 1180: FROM ap_invoice_lines_all

1176: WHERE invoice_id = P_Invoice_Id;
1177:
1178: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS
1179: SELECT *
1180: FROM ap_invoice_lines_all
1181: WHERE invoice_id = c_invoice_id
1182: AND line_type_lookup_code NOT IN ('TAX', 'AWT');
1183:
1184: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;

Line 1251: UPDATE ap_invoice_lines_all ail

1247: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1248: END IF;
1249: --Print(l_api_name, l_debug_info);
1250: -----------------------------------------------------------------
1251: UPDATE ap_invoice_lines_all ail
1252: SET ail.tax_already_calculated_flag = NULL
1253: WHERE ail.invoice_id = p_invoice_id
1254: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
1255: AND NVL(ail.tax_already_calculated_flag, 'N') = 'Y';

Line 1547: FROM ap_invoice_lines_all ail,

1543: ai.exchange_rate IS NOT NULL)); /* Bug14779241: End */
1544:
1545: CURSOR Invoice_Dists (c_invoice_id NUMBER) IS
1546: SELECT aid.*
1547: FROM ap_invoice_lines_all ail,
1548: ap_invoice_distributions_all aid,
1549: ap_invoices_all ai , --Bug14779241
1550: ap_system_parameters_all asp --Bug14779241
1551: WHERE ail.invoice_id = aid.invoice_id

Line 1581: FROM ap_invoice_lines_all ail,

1577: AND p_calling_mode <> 'DISTRIBUTE RECOUP'
1578: AND (NVL(aid.reversal_flag,'N') <> 'Y') -- bug 12419997 --Bug14383132
1579: UNION
1580: SELECT aid.*
1581: FROM ap_invoice_lines_all ail,
1582: ap_invoice_distributions_all aid,
1583: ap_invoices_all ai, --Bug14779241
1584: ap_system_parameters_all asp --Bug14779241
1585: WHERE ail.invoice_id = aid.invoice_id

Line 1609: FROM ap_invoice_lines_all ail,

1605: -- If the API is called to distribute only 1 taxable line, the following
1606: -- cursor will be used
1607: CURSOR Invoice_Dist (c_invoice_id NUMBER, c_line_number NUMBER) IS
1608: SELECT aid.*
1609: FROM ap_invoice_lines_all ail,
1610: ap_invoice_distributions_all aid,
1611: ap_invoices_all ai, --Bug14779241
1612: ap_system_parameters_all asp --Bug14779241
1613: WHERE ail.invoice_id = aid.invoice_id

Line 1641: FROM ap_invoice_lines_all ail,

1637: AND p_calling_mode <> 'DISTRIBUTE RECOUP'
1638: AND (NVL(aid.reversal_flag,'N') <> 'Y') -- bug 12419997 --Bug14383132
1639: UNION
1640: SELECT aid.*
1641: FROM ap_invoice_lines_all ail,
1642: ap_invoice_distributions_all aid,
1643: ap_invoices_all ai, --Bug14779241
1644: ap_system_parameters_all asp --Bug14779241
1645: WHERE ail.invoice_id = aid.invoice_id

Line 1680: FROM ap_invoice_lines_all

1676: NVL(included_tax_amount,0) included_tax_amount,
1677: line_number,
1678: (NVL(total_rec_tax_amt_funcl_curr,0) + NVL(total_nrec_tax_amt_funcl_curr,0)) base_included_tax_amount,
1679: discarded_flag
1680: FROM ap_invoice_lines_all
1681: WHERE invoice_id = c_invoice_id
1682: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS','PREPAY') -- bug7338249
1683: AND included_tax_amount IS NOT NULL ;--Bug6874234
1684:

Line 1691: FROM ap_invoice_lines_all

1687: NVL(included_tax_amount,0) included_tax_amount,
1688: line_number,
1689: (NVL(total_rec_tax_amt_funcl_curr,0) + NVL(total_nrec_tax_amt_funcl_curr,0)) base_included_tax_amount,
1690: discarded_flag
1691: FROM ap_invoice_lines_all
1692: WHERE invoice_id = c_invoice_id
1693: AND line_number = c_line_number
1694: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS','PREPAY') --bug7338249
1695: AND included_tax_amount IS NOT NULL ;--Bug6874234

Line 1841: FROM ap_invoice_lines_all ail

1837: AND entity_code = 'AP_INVOICES'
1838: AND event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES'))
1839: AND aid1.line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS') --bug9314506
1840: AND NOT EXISTS (SELECT /*+ nl_aj */ 1
1841: FROM ap_invoice_lines_all ail
1842: WHERE ail.invoice_id = aid1.invoice_id
1843: AND ail.line_number=aid1.invoice_line_number
1844: AND NVL(ail.discarded_flag,'N') = 'Y');
1845: END IF;

Line 1923: FROM ap_invoice_lines_all ail

1919: WHERE aid1.invoice_id = p_invoice_id
1920: AND aid1.invoice_line_number = p_line_number
1921: AND aid1.line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS') --bug9314506
1922: AND NOT EXISTS (SELECT /*+ nl_aj */ 1 --9325964
1923: FROM ap_invoice_lines_all ail
1924: WHERE ail.invoice_id = aid1.invoice_id
1925: AND ail.line_number=aid1.invoice_line_number
1926: AND NVL(ail.discarded_flag,'N') = 'Y');
1927: OPEN Invoice_Dist (p_invoice_id, p_line_number);

Line 2426: FROM ap_invoice_lines_all

2422:
2423: --BUG 16656238
2424: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS
2425: SELECT *
2426: FROM ap_invoice_lines_all
2427: WHERE invoice_id = c_invoice_id
2428: AND line_type_lookup_code = 'TAX'
2429: AND NVL(discarded_flag,'N')='N'
2430: AND NVL(cancelled_flag,'N')='N'

Line 2916: FROM ap_invoice_lines_all ail,

2912: aic.invoice_id, -- reversed_trx_id
2913: 'LINE', -- reversed_trx_level_type
2914: aic.line_number, -- reversed_trx_line_id
2915: ail.accounting_date -- trx_line_gl_date -- bug 9880212
2916: FROM ap_invoice_lines_all ail,
2917: ap_invoice_lines_all aic
2918: WHERE ail.invoice_id = l_inv_header_rec.invoice_id
2919: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
2920: AND ail.corrected_inv_id = aic.invoice_id

Line 2917: ap_invoice_lines_all aic

2913: 'LINE', -- reversed_trx_level_type
2914: aic.line_number, -- reversed_trx_line_id
2915: ail.accounting_date -- trx_line_gl_date -- bug 9880212
2916: FROM ap_invoice_lines_all ail,
2917: ap_invoice_lines_all aic
2918: WHERE ail.invoice_id = l_inv_header_rec.invoice_id
2919: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
2920: AND ail.corrected_inv_id = aic.invoice_id
2921: AND ail.corrected_line_number = aic.line_number;

Line 3169: FROM ap_invoice_lines_all

3165: WHERE invoice_id = P_Invoice_Id;
3166:
3167: CURSOR Invoice_Lines IS
3168: SELECT *
3169: FROM ap_invoice_lines_all
3170: WHERE invoice_id = P_Invoice_Id
3171: AND line_type_lookup_code NOT IN ('TAX', 'AWT');
3172:
3173: CURSOR Invoice_ex_rate_check IS --Bug14779241

Line 3199: l_debug_info := 'Step 1: Update ap_invoice_lines_all from eTax '||

3195: P_calling_sequence;
3196:
3197: IF (P_Override_Status = 'SYNCHRONIZE') THEN
3198: -----------------------------------------------------------------
3199: l_debug_info := 'Step 1: Update ap_invoice_lines_all from eTax '||
3200: 'repository';
3201: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3203: END IF;

Line 3206: UPDATE ap_invoice_lines_all ail

3202: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3203: END IF;
3204: -----------------------------------------------------------------
3205: BEGIN
3206: UPDATE ap_invoice_lines_all ail
3207: SET
3208: (-- Bug 10157751 ail.description,
3209: ail.cancelled_flag,
3210: ail.last_updated_by,

Line 3561: FROM ap_invoice_lines_all prepay

3557: SET (ai.total_tax_amount,
3558: ai.self_assessed_tax_amount) =
3559: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
3560: 'N', case when exists (SELECT 'Prepay App Exists'
3561: FROM ap_invoice_lines_all prepay
3562: WHERE prepay.invoice_id = zls.trx_id
3563: AND prepay.line_type_lookup_code = 'PREPAY'
3564: AND prepay.prepay_invoice_id = zls.applied_from_trx_id
3565: AND prepay.prepay_line_number = zls.applied_from_line_id

Line 3590: FROM ap_invoice_lines_all ail

3586:
3587: UPDATE ap_invoices_all ai
3588: SET ai.total_tax_amount = (nvl(ai.total_tax_amount,0) +
3589: (SELECT NVL(sum(NVL(ail.amount,0)),0)
3590: FROM ap_invoice_lines_all ail
3591: WHERE ail.invoice_id = ai.invoice_id
3592: AND line_type_lookup_code ='RETROTAX'))
3593: WHERE ai.invoice_id = l_inv_header_rec.invoice_id;
3594:

Line 4892: UPDATE ap_invoice_lines_all ail

4888: AND ail.control_amount IS NOT NULL ;
4889: --bug 6845888
4890: --Bug6799496
4891:
4892: UPDATE ap_invoice_lines_all ail
4893: SET control_amount= NULL --Bug6887264
4894: WHERE ail.invoice_id = p_invoice_id
4895: AND P_Calling_Mode = 'CANCEL INVOICE'
4896: AND ail.control_amount IS NOT NULL ;

Line 6967: l_default_ccid ap_invoice_lines_all.default_dist_ccid%TYPE; --Bug6908977

6963: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
6964: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
6965: l_assessable_value zx_lines_det_factors.assessable_value%type;
6966:
6967: l_default_ccid ap_invoice_lines_all.default_dist_ccid%TYPE; --Bug6908977
6968:
6969: l_return_status BOOLEAN := TRUE;
6970:
6971: l_api_name VARCHAR2(30) := 'Populate_Lines_GT';

Line 7943: FROM ap_invoice_lines_all ail

7939:
7940: BEGIN
7941: SELECT unit_price
7942: INTO trans_lines(i).unit_price
7943: FROM ap_invoice_lines_all ail
7944: WHERE ail.invoice_id = l_inv_line_list(i).Retained_invoice_id
7945: AND ail.line_number = l_inv_line_list(i).Retained_line_number;
7946: EXCEPTION
7947: WHEN OTHERS THEN

Line 11059: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;

11055: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
11056: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
11057: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
11058: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
11059: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
11060: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
11061: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
11062:
11063: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;

Line 11060: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;

11056: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
11057: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
11058: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
11059: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
11060: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
11061: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
11062:
11063: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;
11064: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;

Line 11063: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;

11059: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
11060: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
11061: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
11062:
11063: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;
11064: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;
11065:
11066: l_return_status BOOLEAN := TRUE;
11067: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Distributions_GT';

Line 11064: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;

11060: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
11061: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
11062:
11063: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;
11064: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;
11065:
11066: l_return_status BOOLEAN := TRUE;
11067: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Distributions_GT';
11068: l_intended_use ap_invoice_lines_all.primary_intended_use%TYPE; --8796484

Line 11068: l_intended_use ap_invoice_lines_all.primary_intended_use%TYPE; --8796484

11064: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;
11065:
11066: l_return_status BOOLEAN := TRUE;
11067: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Distributions_GT';
11068: l_intended_use ap_invoice_lines_all.primary_intended_use%TYPE; --8796484
11069: j NUMBER:=0; --Bug9494315
11070:
11071: --bug 10621602 Starts Added the below variables to be used
11072:

Line 11174: FROM ap_invoice_lines_all

11170: -------------------------------------------------------------------
11171: BEGIN
11172: SELECT quantity_invoiced, po_release_id, primary_intended_use --8796484
11173: INTO l_line_quantity_invoiced, l_po_release_id, l_intended_use
11174: FROM ap_invoice_lines_all
11175: WHERE invoice_id = l_inv_dist_list(i).invoice_id
11176: AND line_number = l_inv_dist_list(i).invoice_line_number;
11177: END;
11178:

Line 11832: P_Invoice_Lines_Rec IN ap_invoice_lines_all%ROWTYPE,

11828: *============================================================================*/
11829:
11830: FUNCTION CALCULATE_QUOTE(
11831: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
11832: P_Invoice_Lines_Rec IN ap_invoice_lines_all%ROWTYPE,
11833: P_Calling_Mode IN VARCHAR2,
11834: P_Tax_Amount OUT NOCOPY NUMBER,
11835: P_Tax_Amt_Included OUT NOCOPY VARCHAR2,
11836: P_Error_Code OUT NOCOPY VARCHAR2,

Line 11851: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;

11847:
11848: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
11849: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
11850: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
11851: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
11852:
11853: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
11854: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
11855: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

Line 13416: FROM ap_invoice_lines_all

13412: WHERE invoice_id = P_Invoice_Id;
13413:
13414: CURSOR Invoice_Lines IS
13415: SELECT *
13416: FROM ap_invoice_lines_all
13417: WHERE invoice_id = P_Invoice_Id
13418: AND line_type_lookup_code NOT IN ('TAX', 'AWT')
13419: AND NVL(tax_already_calculated_flag,'N') = 'Y'
13420: AND NVL(discarded_flag,'N')='N';

Line 13425: FROM ap_invoice_lines_all

13421: -- AND NVL(cancelled_flag,'N')='N'; --Bug 13714737
13422:
13423: CURSOR Invoice_Line IS
13424: SELECT *
13425: FROM ap_invoice_lines_all
13426: WHERE invoice_id = P_Invoice_Id
13427: AND line_number = P_Line_Number
13428: AND line_type_lookup_code NOT IN ('TAX', 'AWT')
13429: AND NVL(tax_already_calculated_flag,'N') = 'Y';

Line 13433: FROM ap_invoice_lines_all

13429: AND NVL(tax_already_calculated_flag,'N') = 'Y';
13430:
13431: CURSOR Invoice_Tax_OnlyLines IS
13432: SELECT *
13433: FROM ap_invoice_lines_all
13434: WHERE invoice_id = P_Invoice_Id
13435: AND line_type_lookup_code IN ('TAX')
13436: AND NVL(discarded_flag,'N')='N'
13437: AND NVL(cancelled_flag,'N')='N';

Line 14048: UPDATE ap_invoice_lines_all a

14044: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);
14045: END IF;
14046: IF P_Line_Number IS NULL THEN
14047:
14048: UPDATE ap_invoice_lines_all a
14049: SET (amount,
14050: base_amount,
14051: cancelled_flag) =
14052: (select NVL(b.tax_amt,0),

Line 14080: UPDATE ap_invoice_lines_all ail

14076: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14077: END IF;
14078:
14079: BEGIN
14080: UPDATE ap_invoice_lines_all ail
14081: SET ail.included_tax_amount =
14082: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
14083: FROM zx_lines zl
14084: WHERE zl.application_id = 200

Line 14111: UPDATE ap_invoice_lines_all a

14107: APP_EXCEPTION.RAISE_EXCEPTION;
14108: END;
14109:
14110:
14111: UPDATE ap_invoice_lines_all a
14112: SET amount = 0,
14113: base_amount=0,
14114: cancelled_flag='Y'
14115: WHERE a.invoice_id = p_invoice_id

Line 14128: UPDATE ap_invoice_lines_all a

14124: END IF;
14125:
14126: ELSIF p_line_number IS NOT NULL THEN
14127:
14128: UPDATE ap_invoice_lines_all a
14129: SET (amount,base_amount) =
14130: (select nvl(b.tax_amt,0),nvl(b.tax_amt_funcl_curr,0)
14131: from zx_lines_summary b
14132: where b.application_id = 200

Line 15900: ap_invoice_lines_all prepLine

15896: CURSOR prepay_lines IS
15897: SELECT distinct prepLine.*
15898: FROM ap_invoice_distributions_all invDist,
15899: ap_invoice_distributions_all prepDist,
15900: ap_invoice_lines_all prepLine
15901: WHERE invDist.prepay_distribution_id = prepDist.invoice_distribution_id
15902: AND prepLine.invoice_id = prepDist.invoice_id
15903: AND prepLine.line_number = prepDist.invoice_line_number
15904: AND invDist.line_type_lookup_code = 'PREPAY'

Line 16071: UPDATE ap_invoice_lines_all ail

16067: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16068: END IF;
16069: -----------------------------------------------------------------
16070:
16071: UPDATE ap_invoice_lines_all ail
16072: SET ail.tax_already_calculated_flag = 'Y'
16073: WHERE ail.invoice_id = p_invoice_id
16074: AND ail.line_number = p_invoice_line_number;
16075:

Line 16585: FROM ap_invoice_lines_all

16581: WHERE invoice_id = P_Invoice_Id;
16582:
16583: CURSOR Tax_Lines_to_import IS
16584: SELECT *
16585: FROM ap_invoice_lines_all
16586: WHERE invoice_id = P_Invoice_Id
16587: AND line_type_lookup_code = 'TAX'
16588: AND summary_tax_line_id IS NULL;
16589:

Line 17244: FROM ap_invoice_lines_all

17240: END)||
17241: DECODE(p_calling_mode,
17242: 'CALCULATE',
17243: (CASE ((SELECT 'Y'
17244: FROM ap_invoice_lines_all
17245: WHERE invoice_id = ai.invoice_id
17246: AND line_type_lookup_code <> 'AWT'
17247: AND (tax_already_calculated_flag = 'Y'
17248: OR summary_tax_line_id IS NOT NULL)

Line 17417: FROM ap_invoice_lines_all

17413: -- the included tax amount from the ITEM distributions .
17414: CURSOR c_included_tax_amount is
17415: SELECT amount,included_tax_amount,line_number,
17416: (total_rec_tax_amt_funcl_curr +total_nrec_tax_amt_funcl_curr) base_included_tax_amount,discarded_flag --Bug8717396
17417: FROM ap_invoice_lines_all
17418: WHERE invoice_id = p_invoice_header_rec.invoice_id
17419: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS','PREPAY') --/*Bug7338249*/
17420: --Bug9436217
17421: AND included_tax_amount <> 0 ; --ER CHANGES

Line 17575: UPDATE ap_invoice_lines_all ail

17571: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17572: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17573: END IF;
17574:
17575: UPDATE ap_invoice_lines_all ail
17576: SET (ail.total_rec_tax_amount,
17577: ail.total_nrec_tax_amount,
17578: ail.total_rec_tax_amt_funcl_curr,
17579: ail.total_nrec_tax_amt_funcl_curr) =

Line 17636: UPDATE ap_invoice_lines_all ail

17632: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17633: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17634: END IF;
17635:
17636: UPDATE ap_invoice_lines_all ail
17637: SET generate_dists = 'D'
17638: WHERE ail.invoice_id = p_invoice_header_rec.invoice_id
17639: AND ail.generate_dists <> 'D'
17640: AND line_type_lookup_code = 'TAX'

Line 17660: FROM ap_invoice_lines_all prepay

17656: AND nvl(tax.invoice_includes_prepay_flag,'N') <> 'Y'
17657: AND line_type_lookup_code in ('NONREC_TAX','REC_TAX','TIPV','TERV','TRV')
17658: AND exists
17659: (SELECT 1
17660: FROM ap_invoice_lines_all prepay
17661: WHERE prepay.invoice_id = tax.invoice_id
17662: AND prepay.line_number = tax.invoice_line_number
17663: AND prepay.line_type_lookup_code = 'TAX'
17664: AND prepay.prepay_line_number IS NOT NULL

Line 18016: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;

18012: l_debug_info VARCHAR2(240);
18013: l_curr_calling_sequence VARCHAR2(4000);
18014:
18015: l_period_name gl_period_statuses.period_name%TYPE;
18016: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
18017: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
18018: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
18019: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;

Line 18024: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;

18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
18022: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
18023: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
18024: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
18025: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
18026: l_payment_priority ap_batches_all.payment_priority%TYPE;
18027:
18028: l_total_tax_amount NUMBER;

Line 18034: From ap_invoice_lines_all ail

18030:
18031: -- Allocations
18032: Cursor c_item_line (c_invoice_id IN NUMBER) IS
18033: Select ail.line_number
18034: From ap_invoice_lines_all ail
18035: Where ail.invoice_id = c_invoice_id
18036: And ail.line_type_lookup_code = 'TAX'
18037: And ail.prepay_invoice_id IS NULL;
18038:

Line 18090: UPDATE ap_invoice_lines_all ail

18086: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
18087: END IF;
18088: -------------------------------------------------------------------
18089: BEGIN
18090: UPDATE ap_invoice_lines_all ail
18091: SET
18092: (-- Bug 10157751 ail.description,
18093: ail.amount,
18094: ail.base_amount,

Line 18201: INSERT INTO ap_invoice_lines_all (

18197: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
18198: END IF;
18199: -------------------------------------------------------------------
18200: BEGIN
18201: INSERT INTO ap_invoice_lines_all (
18202: invoice_id,
18203: line_number,
18204: line_type_lookup_code,
18205: requester_id,

Line 18370: FROM ap_invoice_lines_all ail2

18366: tax_code_id)
18367: SELECT
18368: P_Invoice_Header_Rec.Invoice_Id, -- invoice_id
18369: (SELECT NVL(MAX(ail2.line_number),0)
18370: FROM ap_invoice_lines_all ail2
18371: WHERE ail2.invoice_id = zls.trx_id) + ROWNUM, -- line_number
18372: 'TAX', -- line_type_lookup_code
18373: null, -- requester_id
18374: NVL( AI.description, zls.tax_regime_code||' - '||zls.tax ), -- description Bug 10157751

Line 18559: ap_invoice_lines_all prepay

18555: FROM ap_invoices_all ai,
18556: ap_suppliers ap,
18557: ap_supplier_sites_all aps,
18558: zx_lines_summary zls,
18559: ap_invoice_lines_all prepay
18560: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
18561: AND ai.vendor_id = ap.vendor_id
18562: AND ai.vendor_site_id = aps.vendor_site_id
18563: AND zls.application_id = 200

Line 18573: FROM ap_invoice_lines_all il

18569: AND NVL(zls.reporting_only_flag, 'N') = 'N'
18570: AND zls.applied_from_trx_id = prepay.invoice_id(+)
18571: AND zls.applied_from_line_id = prepay.line_number(+)
18572: AND NOT EXISTS (SELECT il.summary_tax_line_id
18573: FROM ap_invoice_lines_all il
18574: WHERE il.invoice_id = ai.invoice_id
18575: AND il.summary_tax_line_id = zls.summary_tax_line_id);
18576:
18577: EXCEPTION

Line 18603: DELETE ap_invoice_lines_all ail

18599: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
18600: END IF;
18601: -------------------------------------------------------------------
18602: BEGIN
18603: DELETE ap_invoice_lines_all ail
18604: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
18605: AND ail.line_type_lookup_code = 'TAX'
18606: AND NOT EXISTS (SELECT ls.summary_tax_line_id
18607: FROM zx_lines_summary ls

Line 18646: FROM ap_invoice_lines_all prepay

18642: SET (ai.total_tax_amount,
18643: ai.self_assessed_tax_amount) =
18644: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
18645: 'N', case when exists (SELECT 'Prepay App Exists'
18646: FROM ap_invoice_lines_all prepay
18647: WHERE prepay.invoice_id = zls.trx_id
18648: AND prepay.line_type_lookup_code = 'PREPAY'
18649: AND prepay.prepay_invoice_id = zls.applied_from_trx_id
18650: AND prepay.prepay_line_number = zls.applied_from_line_id

Line 18698: UPDATE ap_invoice_lines_all tax

18694: END IF;
18695: -----------------------------------------------------------------
18696:
18697: /*added the case for bug 8638881*/
18698: UPDATE ap_invoice_lines_all tax
18699: SET tax.invoice_includes_prepay_flag = CASE WHEN EXISTS (SELECT 'Prepay App Exists'
18700: FROM ap_invoice_lines_all prepay
18701: WHERE prepay.invoice_id = tax.invoice_id
18702: AND prepay.line_type_lookup_code = 'PREPAY'

Line 18700: FROM ap_invoice_lines_all prepay

18696:
18697: /*added the case for bug 8638881*/
18698: UPDATE ap_invoice_lines_all tax
18699: SET tax.invoice_includes_prepay_flag = CASE WHEN EXISTS (SELECT 'Prepay App Exists'
18700: FROM ap_invoice_lines_all prepay
18701: WHERE prepay.invoice_id = tax.invoice_id
18702: AND prepay.line_type_lookup_code = 'PREPAY'
18703: AND prepay.prepay_invoice_id = tax.prepay_invoice_id
18704: AND prepay.prepay_line_number = tax.prepay_line_number