APPS.FV_BE_RPR_PKG dependencies on FV_BE_RPR_TRANSACTIONS

Line 27: l_rpr_rec fv_be_rpr_transactions%ROWTYPE;

23:
24: l_module_name VARCHAR2(200);
25: e_error EXCEPTION;
26:
27: l_rpr_rec fv_be_rpr_transactions%ROWTYPE;
28: l_trx_hdr_rec fv_be_trx_hdrs%ROWTYPE;
29: l_trx_dtl_rec fv_be_trx_dtls%ROWTYPE;
30: l_from_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;
31: l_to_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;

Line 52: SELECT * FROM fv_be_rpr_transactions

48:
49: -- R12 changes
50:
51: CURSOR rpr_transactions_c IS
52: SELECT * FROM fv_be_rpr_transactions
53: WHERE set_of_books_id = p_sob_id
54: AND approval_id = p_approval_id
55: AND transaction_status = 'IP'
56: ORDER BY budget_level_id;

Line 159: UPDATE fv_be_rpr_transactions

155: END LOOP; --for i in 1..2
156:
157: --Check if a lock is needed when record is fetched???????
158:
159: UPDATE fv_be_rpr_transactions
160: SET transaction_status = 'PR'
161: WHERE transaction_id = l_rpr_rec.transaction_id;
162:
163: COMMIT;

Line 297: UPDATE fv_be_rpr_transactions

293: -- Rolling back the row created in fv_be_trx_hdrs.
294: ROLLBACK ;
295:
296: --Reset transaction status to Incomplete if error encountered
297: UPDATE fv_be_rpr_transactions
298: SET transaction_status = 'IN'
299: WHERE set_of_books_id = p_sob_id
300: AND approval_id = p_approval_id
301: AND transaction_status = 'IP';

Line 321: p_rpr_rec fv_be_rpr_transactions%ROWTYPE)

317:
318:
319: PROCEDURE set_hdr_fields (p_count NUMBER,
320: p_trx_hdr_rec OUT NOCOPY fv_be_trx_hdrs%ROWTYPE,
321: p_rpr_rec fv_be_rpr_transactions%ROWTYPE)
322: IS
323: l_module_name VARCHAR2(200);
324:
325: BEGIN

Line 526: p_rpr_rec fv_be_rpr_transactions%ROWTYPE)

522: END; --procedure set_hdr_fields
523:
524: PROCEDURE set_dtl_fields (p_count NUMBER,
525: p_trx_dtl_rec OUT NOCOPY fv_be_trx_dtls%ROWTYPE,
526: p_rpr_rec fv_be_rpr_transactions%ROWTYPE)
527: IS
528: l_module_name VARCHAR2(200);
529:
530: BEGIN