APPS.AP_WITHHOLDING_PKG dependencies on AP_INVOICE_LINES_ALL

Line 180: FROM ap_invoice_lines_all

176:
177: CURSOR C_Current_Line (InvId IN NUMBER)
178: IS
179: SELECT MAX(line_number) curr_inv_line_number
180: FROM ap_invoice_lines_all
181: WHERE (invoice_id = InvId);
182:
183: curr_inv_line_number ap_invoice_lines_all.line_number%TYPE;
184: --bug 8266021

Line 183: curr_inv_line_number ap_invoice_lines_all.line_number%TYPE;

179: SELECT MAX(line_number) curr_inv_line_number
180: FROM ap_invoice_lines_all
181: WHERE (invoice_id = InvId);
182:
183: curr_inv_line_number ap_invoice_lines_all.line_number%TYPE;
184: --bug 8266021
185: curr_inv_dist_line_number ap_invoice_distributions_all.distribution_line_number%TYPE;
186:
187: --bug 7930936

Line 574: debug_info := 'Insert INTO ap_invoice_lines_all';

570: --bug 8726501
571:
572: --Bug 8266021 insert in ap_invoice_lines is changed to insert single line per tax code/group id
573:
574: debug_info := 'Insert INTO ap_invoice_lines_all';
575: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
576: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
577: END IF;
578:

Line 579: INSERT INTO AP_INVOICE_LINES_all (

575: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
576: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
577: END IF;
578:
579: INSERT INTO AP_INVOICE_LINES_all (
580: invoice_id,
581: line_number,
582: line_type_lookup_code,
583: description,

Line 1320: l_line_number ap_invoice_lines_all.line_number%type;

1316: l_batch_id ap_invoices_all.batch_id%type;
1317: l_org_id ap_invoices_all.org_id%type;
1318: l_period_name gl_period_statuses.period_name%type;
1319:
1320: l_line_number ap_invoice_lines_all.line_number%type;
1321: l_dist_number ap_invoice_distributions_all.distribution_line_number%type;
1322:
1323:
1324:

Line 1607: --ap_invoices_all and ap_invoice_lines_all

1603:
1604:
1605: --Bug 8266021 inv cursor called based on calling module
1606: --This cursor will fetch info required to insert into
1607: --ap_invoices_all and ap_invoice_lines_all
1608: debug_info := 'OPEN CURSOR c_awt_invs';
1609:
1610: IF (P_Calling_Module in ('CANCEL INVOICE','REVERSE DIST','VOID PAYMENT')) THEN
1611: OPEN c_awt_invs_rev (P_Invoice_Id);

Line 2002: debug_info := 'Insert INTO ap_invoice_lines_all';

1998:
1999:
2000: -- Insert Invoice Lines for each invoice inserted (bug 8266021)
2001:
2002: debug_info := 'Insert INTO ap_invoice_lines_all';
2003: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
2005: END IF;
2006:

Line 2007: INSERT INTO AP_INVOICE_LINES_all (

2003: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
2005: END IF;
2006:
2007: INSERT INTO AP_INVOICE_LINES_all (
2008: invoice_id,
2009: line_number,
2010: line_type_lookup_code,
2011: description,

Line 4595: l_old_inv_line_num ap_invoice_lines_all.line_number%TYPE;

4591: --Bug12594549
4592:
4593: l_invoice_exchange_rate ap_invoices.exchange_rate%type;
4594: l_func_currency_code ap_system_parameters.base_currency_code%TYPE;
4595: l_old_inv_line_num ap_invoice_lines_all.line_number%TYPE;
4596:
4597: l_pay_awt_invs_count NUMBER; /* Bug 10353952 */
4598:
4599: -- Ap_Undo_Withholding:

Line 5047: UPDATE ap_invoice_lines_all

5043: END IF;
5044:
5045: /* Bug 5202248. Added the Nvl */
5046: IF nvl(l_old_inv_line_num, 0) <> rec_awt_dists.invoice_line_number THEN
5047: UPDATE ap_invoice_lines_all
5048: SET discarded_flag = DECODE(p_calling_module,'CANCEL INVOICE','N','Y'),
5049: /* Bug 5299720. Comment out the following line */
5050: -- Cancelled_flag = DECODE(p_calling_module,'CANCEL INVOICE','Y','N'),
5051: Original_amount = amount,