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_FACTS_TRANSACTIONS dependencies on FV_FACTS_PRC_HDR

Line 306: FROM fv_facts_prc_hdr

302: -- been done for set of books. If not, then write error
303: -- message and exit process.
304: SELECT count(*)
305: INTO vl_prc_map_count
306: FROM fv_facts_prc_hdr
307: WHERE set_of_books_id = sob;
308:
309: -- Check whether code Type is updated
310: -- for the existing data. If not, error out the process.

Line 314: FROM fv_facts_prc_hdr

310: -- for the existing data. If not, error out the process.
311:
312: SELECT count(1)
313: INTO vl_prc_no_code_count
314: FROM fv_facts_prc_hdr
315: WHERE set_of_books_id = sob
316: AND code_type IS NULL ;
317:
318: IF vl_fiscalyear_count > 0 THEN

Line 4324: -- FV_FACTS_PRC_HDR table.

4320: END calc_balance;
4321: --------------------------------------------------------------------------------
4322: -- Gets the Program segment name and prc_mapping_flag from v_segs_array and
4323: -- v_prc_flag_array respectively, which in turn is derived from
4324: -- FV_FACTS_PRC_HDR table.
4325: --------------------------------------------------------------------------------
4326: PROCEDURE get_program_segment(v_fund_value VARCHAR2)
4327: IS
4328: l_module_name VARCHAR2(200);

Line 4841: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;

4837: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
4838:
4839: vl_ts_id NUMBER;
4840: vl_fund_value fv_fund_parameters.fund_value%TYPE;
4841: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4842: vl_prc_header_id NUMBER;
4843: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4844: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
4845: vl_status VARCHAR2(15);

Line 4843: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;

4839: vl_ts_id NUMBER;
4840: vl_fund_value fv_fund_parameters.fund_value%TYPE;
4841: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4842: vl_prc_header_id NUMBER;
4843: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4844: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
4845: vl_status VARCHAR2(15);
4846:
4847: BEGIN

Line 4844: vl_code_type fv_facts_prc_hdr.code_type%TYPE;

4840: vl_fund_value fv_fund_parameters.fund_value%TYPE;
4841: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4842: vl_prc_header_id NUMBER;
4843: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4844: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
4845: vl_status VARCHAR2(15);
4846:
4847: BEGIN
4848: l_module_name := g_module_name || 'check_prc_map_seg';

Line 4875: FROM fv_facts_prc_hdr ffh

4871: BEGIN
4872: SELECT program_segment,
4873: prc_mapping_flag, prc_header_id
4874: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4875: FROM fv_facts_prc_hdr ffh
4876: WHERE ffh.treasury_symbol_id = p_treasury_symbol_id
4877: AND ffh.code_type = vl_code_type
4878: AND ffh.set_of_books_id = p_sob_id
4879: AND ffh.fund_value = fund_rec.fund_value;

Line 4890: FROM fv_facts_prc_hdr ffh

4886: BEGIN
4887: SELECT program_segment,
4888: prc_mapping_flag, prc_header_id
4889: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4890: FROM fv_facts_prc_hdr ffh
4891: WHERE ffh.treasury_symbol_id = p_treasury_symbol_id
4892: AND ffh.code_type = vl_code_type
4893: AND ffh.set_of_books_id = p_sob_id
4894: AND ffh.fund_value = 'ALL-A'

Line 4906: FROM fv_facts_prc_hdr ffh

4902: BEGIN
4903: SELECT program_segment,
4904: prc_mapping_flag, prc_header_id
4905: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4906: FROM fv_facts_prc_hdr ffh
4907: WHERE ffh.treasury_symbol_id = p_treasury_symbol_id
4908: AND ffh.code_type = vl_code_type
4909: AND ffh.set_of_books_id = p_sob_id
4910: AND ffh.fund_value = 'ALL-B'

Line 4922: FROM fv_facts_prc_hdr ffh

4918: BEGIN
4919: SELECT program_segment,
4920: prc_mapping_flag, prc_header_id
4921: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4922: FROM fv_facts_prc_hdr ffh
4923: WHERE ffh.treasury_symbol_id = p_treasury_symbol_id
4924: AND ffh.code_type = vl_code_type
4925: AND ffh.set_of_books_id = p_sob_id
4926: AND ffh.fund_value = 'ALL-FUNDS';

Line 4937: FROM fv_facts_prc_hdr ffh

4933: BEGIN
4934: SELECT program_segment,
4935: prc_mapping_flag, prc_header_id
4936: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4937: FROM fv_facts_prc_hdr ffh
4938: WHERE ffh.treasury_symbol_id = -1
4939: AND ffh.code_type = vl_code_type
4940: AND ffh.set_of_books_id = p_sob_id
4941: AND ffh.fund_value = 'ALL-A'

Line 4954: FROM fv_facts_prc_hdr ffh

4950: BEGIN
4951: SELECT program_segment,
4952: prc_mapping_flag, prc_header_id
4953: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4954: FROM fv_facts_prc_hdr ffh
4955: WHERE ffh.treasury_symbol_id = -1
4956: AND ffh.code_type = vl_code_type
4957: AND ffh.set_of_books_id = p_sob_id
4958: AND ffh.fund_value = 'ALL-B'

Line 4970: FROM fv_facts_prc_hdr ffh

4966: BEGIN
4967: SELECT program_segment,
4968: prc_mapping_flag, prc_header_id
4969: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4970: FROM fv_facts_prc_hdr ffh
4971: WHERE ffh.treasury_symbol_id = -1
4972: AND ffh.set_of_books_id = p_sob_id
4973: AND ffh.code_type = vl_code_type
4974: AND ffh.fund_value = 'ALL-FUNDS';