APPS.FV_BE_FUND_PKG dependencies on FV_BE_TRX_HDRS

Line 46: FROM fv_be_trx_hdrs

42: l_event_type VARCHAR2(30);
43:
44: CURSOR fetch_doc_id IS
45: SELECT doc_id, transaction_date, budget_level_id, source
46: FROM fv_be_trx_hdrs
47: WHERE approval_id = p_approval_id
48: AND doc_status = DECODE(p_mode, 'C', doc_status, 'IP')
49: AND NVL(approved_by_user_id,g_user_id) = g_user_id;
50:

Line 250: fv_be_trx_hdrs fvh

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:
254: BEGIN

Line 337: l_status fv_be_trx_hdrs.doc_status%TYPE;

333: PROCEDURE update_doc_status(p_doc_id NUMBER,
334: p_retcode NUMBER)
335: IS
336: l_module_name VARCHAR2(200);
337: l_status fv_be_trx_hdrs.doc_status%TYPE;
338:
339: BEGIN
340: l_module_name:= g_module_name || 'update_doc_status';
341: SELECT DECODE(p_retcode, 0, 'AR', 1, 'NR', 'IN')

Line 345: UPDATE fv_be_trx_hdrs

341: SELECT DECODE(p_retcode, 0, 'AR', 1, 'NR', 'IN')
342: INTO l_status
343: FROM dual;
344:
345: UPDATE fv_be_trx_hdrs
346: SET doc_status = l_status,
347: internal_revision_num = DECODE(l_status, 'AR', revision_num,
348: internal_revision_num),
349: distribution_amount = NULL

Line 361: FROM fv_be_trx_hdrs

357: WHERE doc_id = p_doc_id
358: --AND transaction_status = 'IP'
359: AND transaction_status IN ('IP', 'RD')
360: AND revision_num IN (SELECT revision_num
361: FROM fv_be_trx_hdrs
362: WHERE doc_id = p_doc_id);
363:
364: EXCEPTION WHEN OTHERS THEN
365: g_retcode := 2;

Line 376: l_doc_id fv_be_trx_hdrs.doc_id%TYPE;

372: PROCEDURE delete_rpr_docs (p_doc_id NUMBER,
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,

Line 382: FROM fv_be_trx_hdrs

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
382: FROM fv_be_trx_hdrs
383: WHERE doc_id = p_doc_id;
384: BEGIN
385: l_module_name := g_module_name || 'delete_rpr_docs';
386: log_message(l_module_name, 'Updating the RPR transaction status to ' ||

Line 409: DELETE FROM fv_be_trx_hdrs

405:
406: DELETE FROM fv_be_trx_dtls
407: WHERE doc_id = l_doc_id;
408:
409: DELETE FROM fv_be_trx_hdrs
410: WHERE doc_id = l_doc_id;
411: END LOOP;
412:
413: COMMIT;

Line 453: UPDATE Fv_Be_Trx_hdrs

449: PROCEDURE reset_doc_status(p_doc_id NUMBER) IS
450: l_module_name VARCHAR2(200);
451: BEGIN
452: l_module_name := g_module_name || 'reset_doc_status';
453: UPDATE Fv_Be_Trx_hdrs
454: SET doc_status = DECODE(revision_num,0,'IN','RA')
455: WHERE doc_id = p_doc_id
456: AND doc_status = 'IP';
457:

Line 463: FROM fv_be_trx_hdrs

459: SET transaction_status = 'IN'
460: WHERE doc_id = p_doc_id
461: AND transaction_status = 'IP'
462: AND revision_num IN(SELECT revision_num
463: FROM fv_be_trx_hdrs
464: WHERE doc_id = p_doc_id);
465: EXCEPTION WHEN OTHERS THEN
466: g_retcode := 2;
467: g_errbuf := 'Error reset_doc_status SQL Error is ' ||SQLERRM;