eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_WF_BE_APPROVAL dependencies on FV_BE_TRX_HDRS

Line 24: vg_doc_id Fv_Be_Trx_Hdrs.doc_id%TYPE;

20: vg_itemtype wf_items.item_type%TYPE;
21: vg_itemkey wf_items.item_key%TYPE;
22:
23: vg_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE;
24: vg_doc_id Fv_Be_Trx_Hdrs.doc_id%TYPE;
25: vg_to_rpr_doc_id Fv_Be_Trx_Hdrs.doc_id%TYPE;
26: vg_user_id fnd_user.user_id%TYPE;
27: vg_resp_id fnd_responsibility.responsibility_id%TYPE;
28: vg_response_note VARCHAR2(240);

Line 25: vg_to_rpr_doc_id Fv_Be_Trx_Hdrs.doc_id%TYPE;

21: vg_itemkey wf_items.item_key%TYPE;
22:
23: vg_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE;
24: vg_doc_id Fv_Be_Trx_Hdrs.doc_id%TYPE;
25: vg_to_rpr_doc_id Fv_Be_Trx_Hdrs.doc_id%TYPE;
26: vg_user_id fnd_user.user_id%TYPE;
27: vg_resp_id fnd_responsibility.responsibility_id%TYPE;
28: vg_response_note VARCHAR2(240);
29: vg_doc_type VARCHAR2(40);

Line 63: vl_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;

59:
60: l_module_name VARCHAR2(200) := g_module_name || 'Main';
61: vg_itemtype VARCHAR2(30);
62: vg_itemkey VARCHAR2(80);
63: vl_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;
64: vl_revision_num Fv_Be_Trx_Hdrs.revision_num%TYPE;
65: vl_ts_id Fv_Be_Trx_Hdrs.treasury_symbol_id%TYPE;
66: vl_fund_value Fv_Be_Trx_Hdrs.fund_value%TYPE;
67: vl_fund_dist Fv_Be_Trx_Hdrs.budgeting_segments%TYPE;

Line 64: vl_revision_num Fv_Be_Trx_Hdrs.revision_num%TYPE;

60: l_module_name VARCHAR2(200) := g_module_name || 'Main';
61: vg_itemtype VARCHAR2(30);
62: vg_itemkey VARCHAR2(80);
63: vl_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;
64: vl_revision_num Fv_Be_Trx_Hdrs.revision_num%TYPE;
65: vl_ts_id Fv_Be_Trx_Hdrs.treasury_symbol_id%TYPE;
66: vl_fund_value Fv_Be_Trx_Hdrs.fund_value%TYPE;
67: vl_fund_dist Fv_Be_Trx_Hdrs.budgeting_segments%TYPE;
68: vl_budlevel_id Fv_Be_Trx_Hdrs.budget_level_id%TYPE;

Line 65: vl_ts_id Fv_Be_Trx_Hdrs.treasury_symbol_id%TYPE;

61: vg_itemtype VARCHAR2(30);
62: vg_itemkey VARCHAR2(80);
63: vl_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;
64: vl_revision_num Fv_Be_Trx_Hdrs.revision_num%TYPE;
65: vl_ts_id Fv_Be_Trx_Hdrs.treasury_symbol_id%TYPE;
66: vl_fund_value Fv_Be_Trx_Hdrs.fund_value%TYPE;
67: vl_fund_dist Fv_Be_Trx_Hdrs.budgeting_segments%TYPE;
68: vl_budlevel_id Fv_Be_Trx_Hdrs.budget_level_id%TYPE;
69: vl_budget_desc Fv_Budget_Levels.description%TYPE;

Line 66: vl_fund_value Fv_Be_Trx_Hdrs.fund_value%TYPE;

62: vg_itemkey VARCHAR2(80);
63: vl_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;
64: vl_revision_num Fv_Be_Trx_Hdrs.revision_num%TYPE;
65: vl_ts_id Fv_Be_Trx_Hdrs.treasury_symbol_id%TYPE;
66: vl_fund_value Fv_Be_Trx_Hdrs.fund_value%TYPE;
67: vl_fund_dist Fv_Be_Trx_Hdrs.budgeting_segments%TYPE;
68: vl_budlevel_id Fv_Be_Trx_Hdrs.budget_level_id%TYPE;
69: vl_budget_desc Fv_Budget_Levels.description%TYPE;
70: vl_treasury_symbol Fv_Treasury_symbols.treasury_symbol%TYPE;

Line 67: vl_fund_dist Fv_Be_Trx_Hdrs.budgeting_segments%TYPE;

63: vl_doc_number Fv_Be_Trx_Hdrs.doc_number%TYPE;
64: vl_revision_num Fv_Be_Trx_Hdrs.revision_num%TYPE;
65: vl_ts_id Fv_Be_Trx_Hdrs.treasury_symbol_id%TYPE;
66: vl_fund_value Fv_Be_Trx_Hdrs.fund_value%TYPE;
67: vl_fund_dist Fv_Be_Trx_Hdrs.budgeting_segments%TYPE;
68: vl_budlevel_id Fv_Be_Trx_Hdrs.budget_level_id%TYPE;
69: vl_budget_desc Fv_Budget_Levels.description%TYPE;
70: vl_treasury_symbol Fv_Treasury_symbols.treasury_symbol%TYPE;
71: vl_form_name VARCHAR2(20);

Line 68: vl_budlevel_id Fv_Be_Trx_Hdrs.budget_level_id%TYPE;

64: vl_revision_num Fv_Be_Trx_Hdrs.revision_num%TYPE;
65: vl_ts_id Fv_Be_Trx_Hdrs.treasury_symbol_id%TYPE;
66: vl_fund_value Fv_Be_Trx_Hdrs.fund_value%TYPE;
67: vl_fund_dist Fv_Be_Trx_Hdrs.budgeting_segments%TYPE;
68: vl_budlevel_id Fv_Be_Trx_Hdrs.budget_level_id%TYPE;
69: vl_budget_desc Fv_Budget_Levels.description%TYPE;
70: vl_treasury_symbol Fv_Treasury_symbols.treasury_symbol%TYPE;
71: vl_form_name VARCHAR2(20);
72: vl_submitter_username VARCHAR2(30);

Line 87: FROM Fv_Be_Trx_Hdrs

83:
84: CURSOR get_otherattr_cur IS
85: SELECT doc_number, revision_num, treasury_symbol_id,
86: fund_value, budgeting_segments, budget_level_id
87: FROM Fv_Be_Trx_Hdrs
88: WHERE doc_id = p_doc_id
89: AND set_of_books_id = p_sob_id;
90:
91: CURSOR get_tsymbol_cur IS

Line 411: FROM Fv_Be_Trx_Hdrs

407: vl_doc_status_desc VARCHAR2(80);
408:
409: CURSOR get_transtat_cur IS
410: SELECT doc_status
411: FROM Fv_Be_Trx_Hdrs
412: WHERE set_of_books_id = vg_sob_id
413: AND doc_id = vg_doc_id;
414:
415: CURSOR get_desc_cur IS

Line 648: UPDATE Fv_Be_Trx_Hdrs

644:
645: BEGIN
646:
647: -- Update the Headers table
648: UPDATE Fv_Be_Trx_Hdrs
649: SET doc_status = p_doc_status
650: WHERE doc_id = p_doc_id
651: AND set_of_books_id = p_sob_id;
652:

Line 723: FROM fv_be_trx_hdrs

719: ------****** Code suggested by Rani Shergil *****************
720: /*
721: CURSOR fetch_doc_info IS
722: SELECT doc_id, transaction_date, budget_level_id, source
723: FROM fv_be_trx_hdrs
724: WHERE doc_id = p_doc_id
725:
726: FOR doc_rec IN fetch_doc_info LOOP
727:

Line 767: FROM fv_be_trx_hdrs

763: ----------------------*/*******************************
764:
765: SELECT transaction_date, budget_level_id, source
766: INTO vg_gl_date, vg_budget_level_id, vg_source
767: FROM fv_be_trx_hdrs
768: WHERE doc_id = vg_doc_id;
769:
770: IF vg_source = 'RPR' then
771: vg_doc_type := 'BE_RPR_TRANSACTIONS';

Line 1113: FROM Fv_Be_Trx_Hdrs

1109: WHERE D.set_of_books_id = vg_sob_id
1110: AND D.doc_id = vg_doc_id
1111: AND D.transaction_type_id = T.be_tt_id
1112: AND D.revision_num = (SELECT MAX(revision_num)
1113: FROM Fv_Be_Trx_Hdrs
1114: WHERE doc_id = vg_doc_id
1115: AND set_of_books_id = vg_sob_id)
1116: ORDER BY D.gl_date ;
1117: