DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on RCV_TRANSACTIONS

Line 435: from jai_rcv_transactions

431: where organization_id = cp_organization_id;
432:
433: cursor c_trx(cp_transaction_id in number) IS
434: select *
435: from jai_rcv_transactions
436: where transaction_id = cp_transaction_id;
437:
438: CURSOR rcv_cur IS
439: SELECT *

Line 440: FROM rcv_transactions

436: where transaction_id = cp_transaction_id;
437:
438: CURSOR rcv_cur IS
439: SELECT *
440: FROM rcv_transactions
441: WHERE transaction_id = p_transaction_id;
442:
443: CURSOR ship_rec IS
444: SELECT item_id

Line 460: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE := 'rcv_transactions' ; -- holds the table name -- ' rcv_transactions'

456: v_process_status VARCHAR2(30);
457: v_process_message VARCHAR2(200);
458: v_ref_10 GL_INTERFACE.REFERENCE10%TYPE ;
459: v_ref_23 GL_INTERFACE.REFERENCE23%TYPE := 'jai_tcs_repp_pkg.receipt_interim_accounting' ; -- holds the object name
460: v_ref_24 GL_INTERFACE.REFERENCE24%TYPE := 'rcv_transactions' ; -- holds the table name -- ' rcv_transactions'
461: v_ref_25 GL_INTERFACE.REFERENCE25%TYPE := 'transaction_id' ; -- holds the column name -- 'delivery_id'
462: v_ref_26 GL_INTERFACE.REFERENCE26%TYPE ; -- holds the column value -- eg -- 13645
463: ln_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE ;
464: lv_source_name VARCHAR2(100) := 'Receivables India' ;