APPS.JAI_PO_CST_TRIGGER_PKG dependencies on RCV_TRANSACTIONS

Line 16: ln_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;

12: REM +======================================================================+
13: */
14: PROCEDURE BRI_T1 ( pr_old t_rec%type , pr_new in out t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
15:
16: ln_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE;
17: ln_accrual_amount JAI_RCV_REP_ACCRUAL_T.ACCRUAL_AMOUNT%TYPE;
18: ln_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
19: lv_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
20:

Line 38: ln_transaction_qty RCV_TRANSACTIONS.QUANTITY%TYPE;

34: SELECT accrual_amount
35: FROM jai_rcv_rep_accrual_t
36: WHERE transaction_id = cpn_transaction_id;
37:
38: ln_transaction_qty RCV_TRANSACTIONS.QUANTITY%TYPE;
39:
40: CURSOR cur_get_transaction_qty (cpn_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE)
41: IS
42: SELECT quantity

Line 40: CURSOR cur_get_transaction_qty (cpn_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE)

36: WHERE transaction_id = cpn_transaction_id;
37:
38: ln_transaction_qty RCV_TRANSACTIONS.QUANTITY%TYPE;
39:
40: CURSOR cur_get_transaction_qty (cpn_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE)
41: IS
42: SELECT quantity
43: FROM rcv_transactions
44: WHERE transaction_id = cpn_transaction_id;

Line 43: FROM rcv_transactions

39:
40: CURSOR cur_get_transaction_qty (cpn_transaction_id RCV_TRANSACTIONS.TRANSACTION_ID%TYPE)
41: IS
42: SELECT quantity
43: FROM rcv_transactions
44: WHERE transaction_id = cpn_transaction_id;
45:
46: BEGIN
47: pv_return_code := jai_constants.successful ;