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 318: FROM fv_facts_prc_hdr

314: -- been done for set of books. If not, then write error
315: -- message and exit process.
316: SELECT count(*)
317: INTO vl_prc_map_count
318: FROM fv_facts_prc_hdr
319: WHERE set_of_books_id = sob;
320:
321: -- Check whether code Type is updated
322: -- for the existing data. If not, error out the process.

Line 326: FROM fv_facts_prc_hdr

322: -- for the existing data. If not, error out the process.
323:
324: SELECT count(1)
325: INTO vl_prc_no_code_count
326: FROM fv_facts_prc_hdr
327: WHERE set_of_books_id = sob
328: AND code_type IS NULL ;
329:
330: IF vl_fiscalyear_count > 0 THEN

Line 4396: -- FV_FACTS_PRC_HDR table.

4392: END calc_balance;
4393: --------------------------------------------------------------------------------
4394: -- Gets the Program segment name and prc_mapping_flag from v_segs_array and
4395: -- v_prc_flag_array respectively, which in turn is derived from
4396: -- FV_FACTS_PRC_HDR table.
4397: --------------------------------------------------------------------------------
4398: PROCEDURE get_program_segment(v_fund_value VARCHAR2)
4399: IS
4400: l_module_name VARCHAR2(200);

Line 4916: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;

4912: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
4913:
4914: vl_ts_id NUMBER;
4915: vl_fund_value fv_fund_parameters.fund_value%TYPE;
4916: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4917: vl_prc_header_id NUMBER;
4918: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4919: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
4920: vl_status VARCHAR2(15);

Line 4918: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;

4914: vl_ts_id NUMBER;
4915: vl_fund_value fv_fund_parameters.fund_value%TYPE;
4916: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4917: vl_prc_header_id NUMBER;
4918: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4919: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
4920: vl_status VARCHAR2(15);
4921:
4922: BEGIN

Line 4919: vl_code_type fv_facts_prc_hdr.code_type%TYPE;

4915: vl_fund_value fv_fund_parameters.fund_value%TYPE;
4916: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
4917: vl_prc_header_id NUMBER;
4918: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
4919: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
4920: vl_status VARCHAR2(15);
4921:
4922: BEGIN
4923: l_module_name := g_module_name || 'check_prc_map_seg';

Line 4950: FROM fv_facts_prc_hdr ffh

4946: BEGIN
4947: SELECT program_segment,
4948: prc_mapping_flag, prc_header_id
4949: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4950: FROM fv_facts_prc_hdr ffh
4951: WHERE ffh.treasury_symbol_id = p_treasury_symbol_id
4952: AND ffh.code_type = vl_code_type
4953: AND ffh.set_of_books_id = p_sob_id
4954: AND ffh.fund_value = fund_rec.fund_value;

Line 4965: FROM fv_facts_prc_hdr ffh

4961: BEGIN
4962: SELECT program_segment,
4963: prc_mapping_flag, prc_header_id
4964: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4965: FROM fv_facts_prc_hdr ffh
4966: WHERE ffh.treasury_symbol_id = p_treasury_symbol_id
4967: AND ffh.code_type = vl_code_type
4968: AND ffh.set_of_books_id = p_sob_id
4969: AND ffh.fund_value = 'ALL-A'

Line 4981: FROM fv_facts_prc_hdr ffh

4977: BEGIN
4978: SELECT program_segment,
4979: prc_mapping_flag, prc_header_id
4980: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4981: FROM fv_facts_prc_hdr ffh
4982: WHERE ffh.treasury_symbol_id = p_treasury_symbol_id
4983: AND ffh.code_type = vl_code_type
4984: AND ffh.set_of_books_id = p_sob_id
4985: AND ffh.fund_value = 'ALL-B'

Line 4997: FROM fv_facts_prc_hdr ffh

4993: BEGIN
4994: SELECT program_segment,
4995: prc_mapping_flag, prc_header_id
4996: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
4997: FROM fv_facts_prc_hdr ffh
4998: WHERE ffh.treasury_symbol_id = p_treasury_symbol_id
4999: AND ffh.code_type = vl_code_type
5000: AND ffh.set_of_books_id = p_sob_id
5001: AND ffh.fund_value = 'ALL-FUNDS';

Line 5012: FROM fv_facts_prc_hdr ffh

5008: BEGIN
5009: SELECT program_segment,
5010: prc_mapping_flag, prc_header_id
5011: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5012: FROM fv_facts_prc_hdr ffh
5013: WHERE ffh.treasury_symbol_id = -1
5014: AND ffh.code_type = vl_code_type
5015: AND ffh.set_of_books_id = p_sob_id
5016: AND ffh.fund_value = 'ALL-A'

Line 5029: FROM fv_facts_prc_hdr ffh

5025: BEGIN
5026: SELECT program_segment,
5027: prc_mapping_flag, prc_header_id
5028: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5029: FROM fv_facts_prc_hdr ffh
5030: WHERE ffh.treasury_symbol_id = -1
5031: AND ffh.code_type = vl_code_type
5032: AND ffh.set_of_books_id = p_sob_id
5033: AND ffh.fund_value = 'ALL-B'

Line 5045: FROM fv_facts_prc_hdr ffh

5041: BEGIN
5042: SELECT program_segment,
5043: prc_mapping_flag, prc_header_id
5044: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
5045: FROM fv_facts_prc_hdr ffh
5046: WHERE ffh.treasury_symbol_id = -1
5047: AND ffh.set_of_books_id = p_sob_id
5048: AND ffh.code_type = vl_code_type
5049: AND ffh.fund_value = 'ALL-FUNDS';