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 206: FROM ap_invoice_lines_all

202: WHERE invoice_id = c_invoice_Id;
203:
204: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS
205: SELECT *
206: FROM ap_invoice_lines_all
207: WHERE invoice_id = c_invoice_id
208: AND line_type_lookup_code NOT IN ('TAX', 'AWT');
209:
210: -- This cursor will be used in the case the API is call

Line 215: FROM ap_invoice_lines_all

211: -- to calculate tax for only 1 line
212: CURSOR Invoice_Line (c_invoice_id NUMBER,
213: c_line_number NUMBER) IS
214: SELECT *
215: FROM ap_invoice_lines_all
216: WHERE invoice_id = c_invoice_id
217: AND line_number = c_line_number
218: AND line_type_lookup_code NOT IN ('TAX', 'AWT');
219:

Line 222: FROM ap_invoice_lines_all

218: AND line_type_lookup_code NOT IN ('TAX', 'AWT');
219:
220: CURSOR Tax_Lines_to_import (c_invoice_id IN NUMBER) IS
221: SELECT *
222: FROM ap_invoice_lines_all
223: WHERE invoice_id = c_invoice_id
224: AND line_type_lookup_code = 'TAX'
225: AND summary_tax_line_id IS NULL;
226:

Line 268: UPDATE ap_invoice_lines_all ail

264: Print(l_api_name, l_debug_info);
265: -----------------------------------------------------------------
266:
267: l_count := 0;
268: UPDATE ap_invoice_lines_all ail
269: SET tax_already_calculated_flag = NULL
270: WHERE ail.invoice_id IN (SELECT DISTINCT(trx_id)
271: FROM zx_trx_headers_gt
272: WHERE application_id = 200

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

289: AND zf.trx_line_id = ail.line_number);
290:
291: l_count := SQL%ROWCOUNT;
292: -----------------------------------------------------------------
293: l_debug_info := l_count ||' rows updated in ap_invoice_lines_all.';
294: Print(l_api_name, l_debug_info);
295: -----------------------------------------------------------------
296: --Bug 6922266 End
297:

Line 372: UPDATE ap_invoice_lines_all ail

368: --
369:
370: l_count:=0; --Bug 6922266
371:
372: UPDATE ap_invoice_lines_all ail
373: SET tax_already_calculated_flag = NULL
374: WHERE ail.invoice_id = p_invoice_id
375: AND nvl(ail.tax_already_calculated_flag, 'N') = 'Y'
376: AND NOT EXISTS

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: Print(l_api_name, l_debug_info);
389: -----------------------------------------------------------------
390: --Bug 6922266
391:

Line 874: FROM ap_invoice_lines_all

870: WHERE invoice_id = P_Invoice_Id;
871:
872: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS
873: SELECT *
874: FROM ap_invoice_lines_all
875: WHERE invoice_id = c_invoice_id
876: AND line_type_lookup_code NOT IN ('TAX', 'AWT');
877:
878: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;

Line 919: UPDATE ap_invoice_lines_all ail

915: -----------------------------------------------------------------
916: l_debug_info := 'Reset Tax Calculation Flag';
917: Print(l_api_name, l_debug_info);
918: -----------------------------------------------------------------
919: UPDATE ap_invoice_lines_all ail
920: SET ail.tax_already_calculated_flag = NULL
921: WHERE ail.invoice_id = p_invoice_id
922: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
923: AND NVL(ail.tax_already_calculated_flag, 'N') = 'Y';

Line 1180: FROM ap_invoice_lines_all ail,

1176: WHERE invoice_id = c_invoice_id;
1177:
1178: CURSOR Invoice_Dists (c_invoice_id NUMBER) IS
1179: SELECT aid.*
1180: FROM ap_invoice_lines_all ail,
1181: ap_invoice_distributions_all aid
1182: WHERE ail.invoice_id = aid.invoice_id
1183: AND ail.line_number = aid.invoice_line_number
1184: AND ail.invoice_id = c_invoice_id

Line 1199: FROM ap_invoice_lines_all ail,

1195: AND nvl(ail.discarded_flag, 'N') <> 'Y'
1196: AND p_calling_mode <> 'DISTRIBUTE RECOUP'
1197: UNION
1198: SELECT aid.*
1199: FROM ap_invoice_lines_all ail,
1200: ap_invoice_distributions_all aid
1201: WHERE ail.invoice_id = aid.invoice_id
1202: AND ail.line_number = aid.invoice_line_number
1203: AND ail.invoice_id = c_invoice_id

Line 1218: FROM ap_invoice_lines_all ail,

1214: -- If the API is called to distribute only 1 taxable line, the following
1215: -- cursor will be used
1216: CURSOR Invoice_Dist (c_invoice_id NUMBER, c_line_number NUMBER) IS
1217: SELECT aid.*
1218: FROM ap_invoice_lines_all ail,
1219: ap_invoice_distributions_all aid
1220: WHERE ail.invoice_id = aid.invoice_id
1221: AND ail.line_number = aid.invoice_line_number
1222: AND ail.invoice_id = c_invoice_id

Line 1235: FROM ap_invoice_lines_all ail,

1231: AND nvl(ail.discarded_flag, 'N') <> 'Y'
1232: AND p_calling_mode <> 'DISTRIBUTE RECOUP'
1233: UNION
1234: SELECT aid.*
1235: FROM ap_invoice_lines_all ail,
1236: ap_invoice_distributions_all aid
1237: WHERE ail.invoice_id = aid.invoice_id
1238: AND ail.line_number = aid.invoice_line_number
1239: AND ail.invoice_id = c_invoice_id

Line 1262: FROM ap_invoice_lines_all

1258: SELECT amount,
1259: NVL(included_tax_amount,0) included_tax_amount,
1260: line_number,
1261: (NVL(total_rec_tax_amt_funcl_curr,0) + NVL(total_nrec_tax_amt_funcl_curr,0)) base_included_tax_amount
1262: FROM ap_invoice_lines_all
1263: WHERE invoice_id = c_invoice_id
1264: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS','PREPAY') -- bug7338249
1265: AND included_tax_amount IS NOT NULL ;--Bug6874234
1266:

Line 1272: FROM ap_invoice_lines_all

1268: SELECT amount,
1269: NVL(included_tax_amount,0) included_tax_amount,
1270: line_number,
1271: (NVL(total_rec_tax_amt_funcl_curr,0) + NVL(total_nrec_tax_amt_funcl_curr,0)) base_included_tax_amount
1272: FROM ap_invoice_lines_all
1273: WHERE invoice_id = c_invoice_id
1274: AND line_number = c_line_number
1275: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS','PREPAY') --bug7338249
1276: AND included_tax_amount IS NOT NULL ;--Bug6874234

Line 1389: FROM ap_invoice_lines_all ail

1385: IF (l_tax_only_invoice = 0) THEN
1386:
1387: SELECT count(1)
1388: INTO l_tax_only_invoice
1389: FROM ap_invoice_lines_all ail
1390: WHERE ail.invoice_id = ap_etax_pkg.g_inv_id_list(i)
1391: AND ail.line_type_lookup_code = 'TAX'
1392: AND NOT EXISTS --To Make Sure We do not call Determine Recovery If we do not have any lines to process
1393: (SELECT 'No Non Tax Line'

Line 1394: FROM ap_invoice_lines_all ail2

1390: WHERE ail.invoice_id = ap_etax_pkg.g_inv_id_list(i)
1391: AND ail.line_type_lookup_code = 'TAX'
1392: AND NOT EXISTS --To Make Sure We do not call Determine Recovery If we do not have any lines to process
1393: (SELECT 'No Non Tax Line'
1394: FROM ap_invoice_lines_all ail2
1395: WHERE ail2.invoice_id = ail.Invoice_id
1396: AND ail2.line_type_lookup_code <> 'TAX');
1397: END IF;
1398: --Bug7110987

Line 1407: FROM ap_invoice_lines_all ail

1403: IF (l_tax_only_invoice = 0) THEN
1404:
1405: SELECT count(1)
1406: INTO l_tax_only_invoice
1407: FROM ap_invoice_lines_all ail
1408: WHERE ail.invoice_id = l_inv_header_rec.Invoice_id
1409: AND ail.line_type_lookup_code = 'TAX'
1410: AND NOT EXISTS --To Make Sure We do not call Determine Recovery If we do not have any lines to process
1411: (SELECT 'No Non Tax Line'

Line 1412: FROM ap_invoice_lines_all ail2

1408: WHERE ail.invoice_id = l_inv_header_rec.Invoice_id
1409: AND ail.line_type_lookup_code = 'TAX'
1410: AND NOT EXISTS --To Make Sure We do not call Determine Recovery If we do not have any lines to process
1411: (SELECT 'No Non Tax Line'
1412: FROM ap_invoice_lines_all ail2
1413: WHERE ail2.invoice_id = ail.Invoice_id
1414: AND ail2.line_type_lookup_code <> 'TAX');
1415: END IF;
1416: --Bug7110987

Line 2232: FROM ap_invoice_lines_all ail,

2228: l_event_class_code_credited, -- reversed_evnt_cls_code
2229: aic.invoice_id, -- reversed_trx_id
2230: 'LINE', -- reversed_trx_level_type
2231: aic.line_number -- reversed_trx_line_id
2232: FROM ap_invoice_lines_all ail,
2233: ap_invoice_lines_all aic
2234: WHERE ail.invoice_id = l_inv_header_rec.invoice_id
2235: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
2236: AND ail.corrected_inv_id = aic.invoice_id

Line 2233: ap_invoice_lines_all aic

2229: aic.invoice_id, -- reversed_trx_id
2230: 'LINE', -- reversed_trx_level_type
2231: aic.line_number -- reversed_trx_line_id
2232: FROM ap_invoice_lines_all ail,
2233: ap_invoice_lines_all aic
2234: WHERE ail.invoice_id = l_inv_header_rec.invoice_id
2235: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
2236: AND ail.corrected_inv_id = aic.invoice_id
2237: AND ail.corrected_line_number = aic.line_number;

Line 2478: FROM ap_invoice_lines_all

2474: WHERE invoice_id = P_Invoice_Id;
2475:
2476: CURSOR Invoice_Lines IS
2477: SELECT *
2478: FROM ap_invoice_lines_all
2479: WHERE invoice_id = P_Invoice_Id
2480: AND line_type_lookup_code NOT IN ('TAX', 'AWT');
2481:
2482: l_return_status_service VARCHAR2(4000);

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

2494: P_calling_sequence;
2495:
2496: IF (P_Override_Status = 'SYNCHRONIZE') THEN
2497: -----------------------------------------------------------------
2498: l_debug_info := 'Step 1: Update ap_invoice_lines_all from eTax '||
2499: 'repository';
2500: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2501: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2502: END IF;

Line 2505: UPDATE ap_invoice_lines_all ail

2501: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2502: END IF;
2503: -----------------------------------------------------------------
2504: BEGIN
2505: UPDATE ap_invoice_lines_all ail
2506: SET
2507: (ail.description,
2508: ail.cancelled_flag,
2509: ail.last_updated_by,

Line 3986: UPDATE ap_invoice_lines_all ail

3982: AND ail.control_amount IS NOT NULL ;
3983: --bug 6845888
3984: --Bug6799496
3985:
3986: UPDATE ap_invoice_lines_all ail
3987: SET control_amount= NULL --Bug6887264
3988: WHERE ail.invoice_id = p_invoice_id
3989: AND P_Calling_Mode = 'CANCEL INVOICE'
3990: AND ail.control_amount IS NOT NULL ;

Line 4155: UPDATE ap_invoice_lines_all a

4151: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4152: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Update the tax only line amount to 0');
4153: END IF;
4154:
4155: UPDATE ap_invoice_lines_all a
4156: SET amount = 0
4157: WHERE a.invoice_id = p_invoice_id
4158: AND a.line_type_lookup_code = 'TAX'
4159: AND exists

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

5951: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
5952: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
5953: l_assessable_value zx_lines_det_factors.assessable_value%type;
5954:
5955: l_default_ccid ap_invoice_lines_all.default_dist_ccid%TYPE; --Bug6908977
5956:
5957: l_return_status BOOLEAN := TRUE;
5958:
5959: l_api_name VARCHAR2(30) := 'Populate_Lines_GT';

Line 8679: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;

8675: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
8676: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
8677: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
8678: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
8679: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
8680: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
8681: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
8682:
8683: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;

Line 8680: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;

8676: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
8677: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
8678: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
8679: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
8680: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
8681: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
8682:
8683: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;
8684: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;

Line 8683: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;

8679: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
8680: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
8681: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
8682:
8683: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;
8684: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;
8685:
8686: l_return_status BOOLEAN := TRUE;
8687: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Distributions_GT';

Line 8684: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;

8680: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
8681: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
8682:
8683: l_prepay_inv_id ap_invoice_lines_all.invoice_id%TYPE;
8684: l_prepay_line_num ap_invoice_lines_all.line_number%TYPE;
8685:
8686: l_return_status BOOLEAN := TRUE;
8687: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Distributions_GT';
8688:

Line 8750: FROM ap_invoice_lines_all

8746: -------------------------------------------------------------------
8747: BEGIN
8748: SELECT quantity_invoiced, po_release_id
8749: INTO l_line_quantity_invoiced, l_po_release_id
8750: FROM ap_invoice_lines_all
8751: WHERE invoice_id = l_inv_dist_list(i).invoice_id
8752: AND line_number = l_inv_dist_list(i).invoice_line_number;
8753: END;
8754:

Line 9244: P_Invoice_Lines_Rec IN ap_invoice_lines_all%ROWTYPE,

9240: *============================================================================*/
9241:
9242: FUNCTION CALCULATE_QUOTE(
9243: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
9244: P_Invoice_Lines_Rec IN ap_invoice_lines_all%ROWTYPE,
9245: P_Calling_Mode IN VARCHAR2,
9246: P_Tax_Amount OUT NOCOPY NUMBER,
9247: P_Tax_Amt_Included OUT NOCOPY VARCHAR2,
9248: P_Error_Code OUT NOCOPY VARCHAR2,

Line 9263: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;

9259:
9260: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
9261: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
9262: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
9263: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
9264:
9265: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
9266: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;
9267: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;

Line 12176: UPDATE ap_invoice_lines_all a

12172:
12173:
12174: IF p_line_number IS NOT NULL THEN
12175:
12176: UPDATE ap_invoice_lines_all a
12177: SET amount = (select nvl(tax_amt, 0)
12178: from zx_lines_summary b
12179: where b.summary_tax_line_id = a.summary_tax_line_id)
12180: WHERE a.invoice_id = p_invoice_id

Line 12344: ap_invoice_lines_all prepLine

12340: CURSOR prepay_lines IS
12341: SELECT distinct prepLine.*
12342: FROM ap_invoice_distributions_all invDist,
12343: ap_invoice_distributions_all prepDist,
12344: ap_invoice_lines_all prepLine
12345: WHERE invDist.prepay_distribution_id = prepDist.invoice_distribution_id
12346: AND prepLine.invoice_id = prepDist.invoice_id
12347: AND prepLine.line_number = prepDist.invoice_line_number
12348: AND invDist.line_type_lookup_code = 'PREPAY'

Line 12500: UPDATE ap_invoice_lines_all ail

12496: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
12497: END IF;
12498: -----------------------------------------------------------------
12499:
12500: UPDATE ap_invoice_lines_all ail
12501: SET ail.tax_already_calculated_flag = 'Y'
12502: WHERE ail.invoice_id = p_invoice_id
12503: AND ail.line_number = p_invoice_line_number;
12504:

Line 12956: FROM ap_invoice_lines_all

12952: WHERE invoice_id = P_Invoice_Id;
12953:
12954: CURSOR Tax_Lines_to_import IS
12955: SELECT *
12956: FROM ap_invoice_lines_all
12957: WHERE invoice_id = P_Invoice_Id
12958: AND line_type_lookup_code = 'TAX'
12959: AND summary_tax_line_id IS NULL;
12960:

Line 13598: FROM ap_invoice_lines_all

13594: END)||
13595: DECODE(p_calling_mode,
13596: 'CALCULATE',
13597: (CASE ((SELECT 'Y'
13598: FROM ap_invoice_lines_all
13599: WHERE invoice_id = ai.invoice_id
13600: AND line_type_lookup_code <> 'AWT'
13601: AND (tax_already_calculated_flag = 'Y'
13602: OR summary_tax_line_id IS NOT NULL)

Line 13748: FROM ap_invoice_lines_all

13744: -- the included tax amount from the ITEM distributions .
13745: CURSOR c_included_tax_amount is
13746: SELECT amount,included_tax_amount,line_number,
13747: (total_rec_tax_amt_funcl_curr + total_nrec_tax_amt_funcl_curr) base_included_tax_amount
13748: FROM ap_invoice_lines_all
13749: WHERE invoice_id = p_invoice_header_rec.invoice_id
13750: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS','PREPAY') --/*Bug7338249*/
13751: AND included_tax_amount <> 0 ;
13752:

Line 13871: UPDATE ap_invoice_lines_all ail

13867: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13868: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13869: END IF;
13870:
13871: UPDATE ap_invoice_lines_all ail
13872: SET (ail.total_rec_tax_amount,
13873: ail.total_nrec_tax_amount,
13874: ail.total_rec_tax_amt_funcl_curr,
13875: ail.total_nrec_tax_amt_funcl_curr) =

Line 13931: UPDATE ap_invoice_lines_all ail

13927: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13929: END IF;
13930:
13931: UPDATE ap_invoice_lines_all ail
13932: SET generate_dists = 'D'
13933: WHERE ail.invoice_id = p_invoice_header_rec.invoice_id
13934: AND ail.generate_dists <> 'D'
13935: AND line_type_lookup_code = 'TAX'

Line 13952: FROM ap_invoice_lines_all prepay

13948: AND nvl(tax.invoice_includes_prepay_flag,'N') <> 'Y'
13949: AND line_type_lookup_code in ('NONREC_TAX','REC_TAX','TIPV','TERV','TRV')
13950: AND exists
13951: (SELECT 1
13952: FROM ap_invoice_lines_all prepay
13953: WHERE prepay.invoice_id = tax.invoice_id
13954: AND prepay.line_number = tax.invoice_line_number
13955: AND prepay.line_type_lookup_code = 'TAX'
13956: AND prepay.prepay_line_number IS NOT NULL

Line 14192: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;

14188: l_debug_info VARCHAR2(240);
14189: l_curr_calling_sequence VARCHAR2(4000);
14190:
14191: l_period_name gl_period_statuses.period_name%TYPE;
14192: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
14193: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
14194: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
14195: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
14196: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;

Line 14200: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;

14196: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
14197: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
14198: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
14199: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
14200: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
14201: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
14202: l_payment_priority ap_batches_all.payment_priority%TYPE;
14203:
14204: l_total_tax_amount NUMBER;

Line 14210: From ap_invoice_lines_all ail

14206:
14207: -- Allocations
14208: Cursor c_item_line (c_invoice_id IN NUMBER) IS
14209: Select ail.line_number
14210: From ap_invoice_lines_all ail
14211: Where ail.invoice_id = c_invoice_id
14212: And ail.line_type_lookup_code = 'TAX'
14213: And ail.prepay_invoice_id IS NULL;
14214:

Line 14266: UPDATE ap_invoice_lines_all ail

14262: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14263: END IF;
14264: -------------------------------------------------------------------
14265: BEGIN
14266: UPDATE ap_invoice_lines_all ail
14267: SET
14268: (ail.description,
14269: ail.amount,
14270: ail.base_amount,

Line 14370: INSERT INTO ap_invoice_lines_all (

14366: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14367: END IF;
14368: -------------------------------------------------------------------
14369: BEGIN
14370: INSERT INTO ap_invoice_lines_all (
14371: invoice_id,
14372: line_number,
14373: line_type_lookup_code,
14374: requester_id,

Line 14539: FROM ap_invoice_lines_all ail2

14535: tax_code_id)
14536: SELECT
14537: P_Invoice_Header_Rec.Invoice_Id, -- invoice_id
14538: (SELECT NVL(MAX(ail2.line_number),0)
14539: FROM ap_invoice_lines_all ail2
14540: WHERE ail2.invoice_id = zls.trx_id) + ROWNUM, -- line_number
14541: 'TAX', -- line_type_lookup_code
14542: null, -- requester_id
14543: zls.tax_regime_code||' - '||zls.tax, -- description

Line 14728: ap_invoice_lines_all prepay

14724: FROM ap_invoices_all ai,
14725: ap_suppliers ap,
14726: ap_supplier_sites_all aps,
14727: zx_lines_summary zls,
14728: ap_invoice_lines_all prepay
14729: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
14730: AND ai.vendor_id = ap.vendor_id
14731: AND ai.vendor_site_id = aps.vendor_site_id
14732: AND zls.application_id = 200

Line 14742: FROM ap_invoice_lines_all il

14738: AND NVL(zls.reporting_only_flag, 'N') = 'N'
14739: AND zls.applied_from_trx_id = prepay.invoice_id(+)
14740: AND zls.applied_from_line_id = prepay.line_number(+)
14741: AND NOT EXISTS (SELECT il.summary_tax_line_id
14742: FROM ap_invoice_lines_all il
14743: WHERE il.invoice_id = ai.invoice_id
14744: AND il.summary_tax_line_id = zls.summary_tax_line_id);
14745:
14746: EXCEPTION

Line 14772: DELETE ap_invoice_lines_all ail

14768: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14769: END IF;
14770: -------------------------------------------------------------------
14771: BEGIN
14772: DELETE ap_invoice_lines_all ail
14773: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
14774: AND ail.line_type_lookup_code = 'TAX'
14775: AND NOT EXISTS (SELECT ls.summary_tax_line_id
14776: FROM zx_lines_summary ls

Line 14854: UPDATE ap_invoice_lines_all tax

14850: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14851: END IF;
14852: -----------------------------------------------------------------
14853:
14854: UPDATE ap_invoice_lines_all tax
14855: SET tax.invoice_includes_prepay_flag = 'Y'
14856: WHERE tax.invoice_id = P_Invoice_Header_Rec.Invoice_Id
14857: AND tax.line_type_lookup_code = 'TAX'
14858: AND EXISTS

Line 14860: FROM ap_invoice_lines_all prepay

14856: WHERE tax.invoice_id = P_Invoice_Header_Rec.Invoice_Id
14857: AND tax.line_type_lookup_code = 'TAX'
14858: AND EXISTS
14859: (SELECT 'Prepay App Exists'
14860: FROM ap_invoice_lines_all prepay
14861: WHERE prepay.invoice_id = tax.invoice_id
14862: AND prepay.line_type_lookup_code = 'PREPAY'
14863: AND prepay.prepay_invoice_id = tax.prepay_invoice_id
14864: AND prepay.prepay_line_number = tax.prepay_line_number