APPS.JAI_OPEN_API_PKG dependencies on AP_INVOICES_ALL

Line 1218: FROM AP_INVOICES_ALL

1214: IS
1215: SELECT invoice_amount,
1216: payment_status_flag,
1217: invoice_type_lookup_code
1218: FROM AP_INVOICES_ALL
1219: WHERE INVOICE_ID = pn_trx_id;
1220:
1221: CURSOR chk_ar_apply
1222: IS

Line 1239: FROM ap_invoices_all ai, ap_invoice_payments_all aip

1235: where check_id
1236: in(
1237: SELECT
1238: AIP.CHECK_ID
1239: FROM ap_invoices_all ai, ap_invoice_payments_all aip
1240: WHERE ai.invoice_id = aip.invoice_id
1241: AND AI.INVOICE_ID = pn_trx_id
1242: );
1243:

Line 1438: cd_gl_date IN AP_INVOICES_ALL.GL_DATE%TYPE,

1434: AND dis.LATEST_REC_FLAG = 'Y';
1435:
1436: CURSOR chk_period_cur(
1437: cn_application_id IN NUMBER,
1438: cd_gl_date IN AP_INVOICES_ALL.GL_DATE%TYPE,
1439: cn_book_id IN AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE
1440: )
1441: IS
1442: SELECT

Line 1439: cn_book_id IN AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE

1435:
1436: CURSOR chk_period_cur(
1437: cn_application_id IN NUMBER,
1438: cd_gl_date IN AP_INVOICES_ALL.GL_DATE%TYPE,
1439: cn_book_id IN AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE
1440: )
1441: IS
1442: SELECT
1443: CLOSING_STATUS

Line 1454: FROM AP_INVOICES_ALL

1450: IS
1451: SELECT
1452: set_of_books_id ,
1453: gl_date
1454: FROM AP_INVOICES_ALL
1455: WHERE INVOICE_ID = pn_trx_id;
1456:
1457: --Variable define here
1458: lv_return_mess VARCHAR2(1000);

Line 3572: ap_invoices_all

3568: , invoice_currency_code
3569: , exchange_rate
3570: , batch_id
3571: FROM
3572: ap_invoices_all
3573: WHERE invoice_id = pn_invoice_id;
3574: BEGIN
3575: --log for debug
3576: IF ( ln_proc_level >= ln_dbg_level)

Line 4052: from ap_invoices_all

4048: AND reference_key2 = TO_CHAR(pn_transaction_line_num)
4049: and invoice_id in
4050: (
4051: select invoice_id
4052: from ap_invoices_all
4053: where vendor_id = pn_party_id
4054: and vendor_site_id = pn_party_site_id
4055: )
4056: order by 1,2

Line 4439: FROM AP_INVOICES_ALL

4435: IS
4436: SELECT
4437: vendor_id,
4438: vendor_site_id
4439: FROM AP_INVOICES_ALL
4440: WHERE invoice_id = pn_trx_id;
4441:
4442: CURSOR get_service_type_code(
4443: cn_vendor_id IN NUMBER,

Line 11050: FROM ap_invoices_all

11046: IF lv_module = 'AP' THEN
11047: SELECT vendor_id, vendor_site_id
11048: INTO ln_vendor_id
11049: , ln_vendor_site_id
11050: FROM ap_invoices_all
11051: WHERE invoice_id = ln_header_id;
11052:
11053: SELECT amount
11054: ,nvl(quantity_invoiced,1) --Added by zhiwei for Bug#12604133 on 20110623

Line 11974: UPDATE ap_invoices_all

11970: FROM ap_invoice_lines_all
11971: WHERE invoice_id = rec_trx_id.trx_id;
11972:
11973: --Invoice amount should be updated after all invoice lines are generated.
11974: UPDATE ap_invoices_all
11975: SET invoice_amount = ln_total_amount
11976: WHERE invoice_id = rec_trx_id.trx_id;
11977:
11978: --Ap_payment_schedules_all should be updated with correct amount.