APPS.JAI_AP_STND_TAX_PROCESS dependencies on AP_INVOICES_ALL

Line 272: AP_INVOICES_ALL aila

268: CURSOR get_invoice_id_cur IS
269: SELECT
270: aila.invoice_id
271: FROM
272: AP_INVOICES_ALL aila
273: WHERE aila.invoice_id = pn_invoice_id
274: AND aila.invoice_type_lookup_code ='PREPAYMENT';
275:
276: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;

Line 276: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;

272: AP_INVOICES_ALL aila
273: WHERE aila.invoice_id = pn_invoice_id
274: AND aila.invoice_type_lookup_code ='PREPAYMENT';
275:
276: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
277: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
278: ln_proc_level NUMBER := FND_LOG.level_procedure;
279: lv_proc_name VARCHAR2 (100) := 'Validate_Prepayment_Invoice';
280: BEGIN

Line 363: AP_INVOICES_ALL aila

359: CURSOR get_invoice_id_cur IS
360: SELECT
361: aila.invoice_id
362: FROM
363: AP_INVOICES_ALL aila
364: WHERE aila.invoice_id = pn_invoice_id
365: AND aila.INVOICE_NUM LIKE 'ITP-CM/%'
366: AND aila.description LIKE 'Credit Memo for inclusive 3rd party taxes for receipt%'
367: AND aila.SOURCE = 'INDIA TAX INVOICE'

Line 370: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;

366: AND aila.description LIKE 'Credit Memo for inclusive 3rd party taxes for receipt%'
367: AND aila.SOURCE = 'INDIA TAX INVOICE'
368: AND aila.invoice_type_lookup_code ='CREDIT';
369:
370: ln_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
371: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
372: ln_proc_level NUMBER := FND_LOG.level_procedure;
373: lv_proc_name VARCHAR2 (100) := 'Validate_3rd_party_cm_Invoice';
374: BEGIN

Line 1743: FROM ap_invoices_all

1739: --Add by Xiao for POT changes, reg bug#12533434, begin
1740: ---------------------------------------------------------------
1741: CURSOR get_invoice_type_cur IS
1742: SELECT invoice_type_lookup_code
1743: FROM ap_invoices_all
1744: WHERE invoice_id = pn_invoice_id;
1745: lv_invoice_type VARCHAR2(30);
1746: lv_account_name VARCHAR2(30);
1747: ---------------------------------------------------------------

Line 2419: ap_invoices_all

2415: , invoice_currency_code
2416: , exchange_rate
2417: , batch_id
2418: FROM
2419: ap_invoices_all
2420: WHERE invoice_id = pn_invoice_id;
2421: BEGIN
2422: --log for debug
2423: IF ( ln_proc_level >= ln_dbg_level)

Line 3337: FROM ap_invoices_all

3333:
3334: -- Get the details of supplier id
3335: CURSOR jai_get_supplier_id (pn_invoice_id NUMBER) IS
3336: SELECT vendor_id
3337: FROM ap_invoices_all
3338: WHERE invoice_id = pn_invoice_id;
3339:
3340:
3341: -- Get the tax category_id of supplier id

Line 3399: from AP_INVOICES_ALL

3395: --Added by Qiong for bug15875609 end
3396: --Added for bug#9237446 by JMEENA
3397: CURSOR cur_credit_memo_check( p_invoice_id number) IS
3398: Select invoice_amount, source
3399: from AP_INVOICES_ALL
3400: where invoice_id = p_invoice_id;
3401:
3402: CURSOR c_invoice_id IS -- for bug 14681650 by anupgupt
3403: SELECT invoice_id

Line 4003: AP_INVOICES_ALL

3999: --Added by Chong for ZX investigation 20120816 end
4000: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
4001: /* Error msg will be populated AP Invoice workbench when changing the data in header
4002: UPDATE
4003: AP_INVOICES_ALL
4004: SET
4005: invoice_amount = (SELECT SUM(amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id ),
4006: base_amount = (SELECT SUM(base_amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id )
4007: WHERE invoice_id =pn_invoice_id;