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 246: fv_be_trx_hdrs fvh

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

Line 332: l_status fv_be_trx_hdrs.doc_status%TYPE;

328: PROCEDURE update_doc_status(p_doc_id NUMBER,
329: p_retcode NUMBER)
330: IS
331: l_module_name VARCHAR2(200);
332: l_status fv_be_trx_hdrs.doc_status%TYPE;
333:
334: BEGIN
335: l_module_name:= g_module_name || 'update_doc_status';
336: SELECT DECODE(p_retcode, 0, 'AR', 1, 'NR', 'IN')

Line 340: UPDATE fv_be_trx_hdrs

336: SELECT DECODE(p_retcode, 0, 'AR', 1, 'NR', 'IN')
337: INTO l_status
338: FROM dual;
339:
340: UPDATE fv_be_trx_hdrs
341: SET doc_status = l_status,
342: internal_revision_num = DECODE(l_status, 'AR', revision_num,
343: internal_revision_num),
344: distribution_amount = NULL

Line 355: FROM fv_be_trx_hdrs

351: approval_date = DECODE(l_status,'AR',SYSDATE,NULL)
352: WHERE doc_id = p_doc_id
353: AND transaction_status = 'IP'
354: AND revision_num IN (SELECT revision_num
355: FROM fv_be_trx_hdrs
356: WHERE doc_id = p_doc_id);
357:
358: EXCEPTION WHEN OTHERS THEN
359: g_retcode := 2;

Line 370: l_doc_id fv_be_trx_hdrs.doc_id%TYPE;

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

Line 376: FROM fv_be_trx_hdrs

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
376: FROM fv_be_trx_hdrs
377: WHERE doc_id = p_doc_id;
378: BEGIN
379: l_module_name := g_module_name || 'delete_rpr_docs';
380: log_message(l_module_name, 'Updating the RPR transaction status to ' ||

Line 403: DELETE FROM fv_be_trx_hdrs

399:
400: DELETE FROM fv_be_trx_dtls
401: WHERE doc_id = l_doc_id;
402:
403: DELETE FROM fv_be_trx_hdrs
404: WHERE doc_id = l_doc_id;
405: END LOOP;
406:
407: COMMIT;

Line 447: UPDATE Fv_Be_Trx_hdrs

443: PROCEDURE reset_doc_status(p_doc_id NUMBER) IS
444: l_module_name VARCHAR2(200);
445: BEGIN
446: l_module_name := g_module_name || 'reset_doc_status';
447: UPDATE Fv_Be_Trx_hdrs
448: SET doc_status = DECODE(revision_num,0,'IN','RA')
449: WHERE doc_id = p_doc_id
450: AND doc_status = 'IP';
451:

Line 457: FROM fv_be_trx_hdrs

453: SET transaction_status = 'IN'
454: WHERE doc_id = p_doc_id
455: AND transaction_status = 'IP'
456: AND revision_num IN(SELECT revision_num
457: FROM fv_be_trx_hdrs
458: WHERE doc_id = p_doc_id);
459: EXCEPTION WHEN OTHERS THEN
460: g_retcode := 2;
461: g_errbuf := 'Error reset_doc_status SQL Error is ' ||SQLERRM;