APPS.FV_BE_FUND_PKG dependencies on FV_BE_RPR_TRANSACTIONS

Line 245: from fv_be_rpr_transactions fvr,

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

Line 371: l_doc_num fv_be_rpr_transactions.doc_number%TYPE;

367: p_rpr_to_doc_id NUMBER)
368: IS
369: l_module_name VARCHAR2(200) ;
370: l_doc_id fv_be_trx_hdrs.doc_id%TYPE;
371: l_doc_num fv_be_rpr_transactions.doc_number%TYPE;
372:
373: CURSOR get_docnum_c IS
374: SELECT SUBSTR(doc_number,1,INSTR(doc_number,'-RPF') - 1) doc_num,
375: set_of_books_id sob,budget_level_id id

Line 384: UPDATE fv_be_rpr_transactions

380: log_message(l_module_name, 'Updating the RPR transaction status to ' ||
381: ' Not Reserved');
382:
383: FOR l_getdoc IN get_docnum_c LOOP
384: UPDATE fv_be_rpr_transactions
385: SET transaction_status = 'NR'
386: WHERE doc_number = l_getdoc.doc_num
387: AND set_of_books_id = l_getdoc.sob
388: AND budget_level_id = l_getdoc.id;