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

Line 2701: -- Gets the Program segment name from FV_FACTS_PRC_HDR table

2697: END CREATE_FACTS_RECORD ;
2698: -- -------------------------------------------------------------------
2699: -- PROCEDURE GET_PROGRAM_SEGMENT
2700: -- -------------------------------------------------------------------
2701: -- Gets the Program segment name from FV_FACTS_PRC_HDR table
2702: -- -------------------------------------------------------------------
2703: PROCEDURE GET_PROGRAM_SEGMENT(v_fund_value Varchar2)
2704: IS
2705: l_module_name VARCHAR2(200) := g_module_name || 'GET_PROGRAM_SEGMENT';

Line 2707: vl_prg_seg_name fv_facts_prc_hdr.program_segment%TYPE;

2703: PROCEDURE GET_PROGRAM_SEGMENT(v_fund_value Varchar2)
2704: IS
2705: l_module_name VARCHAR2(200) := g_module_name || 'GET_PROGRAM_SEGMENT';
2706: vl_seg_found VARCHAR2(1) := 'N';
2707: vl_prg_seg_name fv_facts_prc_hdr.program_segment%TYPE;
2708: vl_prc_header_id NUMBER(15);
2709: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
2710: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
2711: vl_prg_val_set_id NUMBER(15);

Line 2709: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;

2705: l_module_name VARCHAR2(200) := g_module_name || 'GET_PROGRAM_SEGMENT';
2706: vl_seg_found VARCHAR2(1) := 'N';
2707: vl_prg_seg_name fv_facts_prc_hdr.program_segment%TYPE;
2708: vl_prc_header_id NUMBER(15);
2709: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
2710: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
2711: vl_prg_val_set_id NUMBER(15);
2712:
2713: BEGIN

Line 2710: vl_code_type fv_facts_prc_hdr.code_type%TYPE;

2706: vl_seg_found VARCHAR2(1) := 'N';
2707: vl_prg_seg_name fv_facts_prc_hdr.program_segment%TYPE;
2708: vl_prc_header_id NUMBER(15);
2709: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
2710: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
2711: vl_prg_val_set_id NUMBER(15);
2712:
2713: BEGIN
2714:

Line 2739: FROM fv_facts_prc_hdr

2735: SELECT program_segment, prc_mapping_flag,
2736: prc_header_id
2737: INTO vl_prg_seg_name, vl_prc_flag,
2738: vl_prc_header_id
2739: FROM fv_facts_prc_hdr
2740: WHERE treasury_symbol_id = v_treasury_symbol_id
2741: AND code_type = vl_code_type
2742: AND fund_value = v_fund_value
2743: AND set_of_books_id = vp_set_of_books_id;

Line 2756: FROM fv_facts_prc_hdr

2752: SELECT program_segment, prc_mapping_flag,
2753: prc_header_id
2754: INTO vl_prg_seg_name, vl_prc_flag,
2755: vl_prc_header_id
2756: FROM fv_facts_prc_hdr
2757: WHERE treasury_symbol_id = v_treasury_symbol_id
2758: AND fund_value = 'ALL-A'
2759: AND code_type = vl_code_type
2760: AND va_appor_cat_val = 'A'

Line 2775: FROM fv_facts_prc_hdr

2771: SELECT program_segment, prc_mapping_flag,
2772: prc_header_id
2773: INTO vl_prg_seg_name, vl_prc_flag,
2774: vl_prc_header_id
2775: FROM fv_facts_prc_hdr
2776: WHERE treasury_symbol_id = v_treasury_symbol_id
2777: AND fund_value = 'ALL-B'
2778: AND code_type = vl_code_type
2779: AND va_appor_cat_val = 'B'

Line 2794: FROM fv_facts_prc_hdr

2790: SELECT program_segment, prc_mapping_flag,
2791: prc_header_id
2792: INTO vl_prg_seg_name, vl_prc_flag,
2793: vl_prc_header_id
2794: FROM fv_facts_prc_hdr
2795: WHERE treasury_symbol_id = v_treasury_symbol_id
2796: AND code_type = vl_code_type
2797: AND fund_value = 'ALL-FUNDS'
2798: AND set_of_books_id = vp_set_of_books_id;

Line 2812: FROM fv_facts_prc_hdr

2808: SELECT program_segment, prc_mapping_flag,
2809: prc_header_id
2810: INTO vl_prg_seg_name, vl_prc_flag,
2811: vl_prc_header_id
2812: FROM fv_facts_prc_hdr
2813: WHERE treasury_symbol_id = -1
2814: AND code_type = vl_code_type
2815: AND fund_value = 'ALL-A'
2816: AND va_appor_cat_val = 'A'

Line 2831: FROM fv_facts_prc_hdr

2827: SELECT program_segment, prc_mapping_flag,
2828: prc_header_id
2829: INTO vl_prg_seg_name, vl_prc_flag,
2830: vl_prc_header_id
2831: FROM fv_facts_prc_hdr
2832: WHERE treasury_symbol_id = -1
2833: AND fund_value = 'ALL-B'
2834: AND code_type = vl_code_type
2835: AND va_appor_cat_val = 'B'

Line 2851: FROM fv_facts_prc_hdr

2847: SELECT program_segment, prc_mapping_flag,
2848: prc_header_id
2849: INTO vl_prg_seg_name, vl_prc_flag,
2850: vl_prc_header_id
2851: FROM fv_facts_prc_hdr
2852: WHERE treasury_symbol_id = -1
2853: AND fund_value = 'ALL-FUNDS'
2854: AND code_type = vl_code_type
2855: AND set_of_books_id = vp_set_of_books_id;