APPS.FV_BE_FUND_PKG dependencies on FV_BE_RPR_TRANSACTIONS

Line 249: from fv_be_rpr_transactions fvr,

245:
246: cursor c_doc_id is
247: select fvr.transaction_id
248: into l_doc_id
249: from fv_be_rpr_transactions fvr,
250: fv_be_trx_hdrs fvh
251: where substr(fvh.doc_number, 1, length(fvh.doc_number) -4) = fvr.doc_number
252: and fvh.doc_id = p_doc_id;
253:

Line 377: l_doc_num fv_be_rpr_transactions.doc_number%TYPE;

373: p_rpr_to_doc_id NUMBER)
374: IS
375: l_module_name VARCHAR2(200) ;
376: l_doc_id fv_be_trx_hdrs.doc_id%TYPE;
377: l_doc_num fv_be_rpr_transactions.doc_number%TYPE;
378:
379: CURSOR get_docnum_c IS
380: SELECT SUBSTR(doc_number,1,INSTR(doc_number,'-RPF') - 1) doc_num,
381: set_of_books_id sob,budget_level_id id

Line 390: UPDATE fv_be_rpr_transactions

386: log_message(l_module_name, 'Updating the RPR transaction status to ' ||
387: ' Not Reserved');
388:
389: FOR l_getdoc IN get_docnum_c LOOP
390: UPDATE fv_be_rpr_transactions
391: SET transaction_status = 'NR'
392: WHERE doc_number = l_getdoc.doc_num
393: AND set_of_books_id = l_getdoc.sob
394: AND budget_level_id = l_getdoc.id;