DBA Data[Home] [Help]

APPS.JAI_PO_CST_TRIGGER_PKG dependencies on JAI_RCV_REP_ACCRUAL_T

Line 17: ln_accrual_amount JAI_RCV_REP_ACCRUAL_T.ACCRUAL_AMOUNT%TYPE;

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:
21: CURSOR cur_get_setOfBooksId

Line 32: (cpn_transaction_id JAI_RCV_REP_ACCRUAL_T.TRANSACTION_ID%TYPE)

28: WHERE organization_id = cpn_operating_unit_id
29: AND o3.org_information_context = cpv_information_context;
30:
31: CURSOR cur_get_accrual_amount
32: (cpn_transaction_id JAI_RCV_REP_ACCRUAL_T.TRANSACTION_ID%TYPE)
33: IS
34: SELECT accrual_amount
35: FROM jai_rcv_rep_accrual_t
36: WHERE transaction_id = cpn_transaction_id;

Line 35: FROM jai_rcv_rep_accrual_t

31: CURSOR cur_get_accrual_amount
32: (cpn_transaction_id JAI_RCV_REP_ACCRUAL_T.TRANSACTION_ID%TYPE)
33: IS
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: