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 2490: -- Gets the Program segment name from FV_FACTS_PRC_HDR table

2486: END CREATE_FACTS_RECORD ;
2487: -- -------------------------------------------------------------------
2488: -- PROCEDURE GET_PROGRAM_SEGMENT
2489: -- -------------------------------------------------------------------
2490: -- Gets the Program segment name from FV_FACTS_PRC_HDR table
2491: -- -------------------------------------------------------------------
2492: PROCEDURE GET_PROGRAM_SEGMENT(v_fund_value Varchar2)
2493: IS
2494: l_module_name VARCHAR2(200) := g_module_name || 'GET_PROGRAM_SEGMENT';

Line 2496: vl_prg_seg_name fv_facts_prc_hdr.program_segment%TYPE;

2492: PROCEDURE GET_PROGRAM_SEGMENT(v_fund_value Varchar2)
2493: IS
2494: l_module_name VARCHAR2(200) := g_module_name || 'GET_PROGRAM_SEGMENT';
2495: vl_seg_found VARCHAR2(1) := 'N';
2496: vl_prg_seg_name fv_facts_prc_hdr.program_segment%TYPE;
2497: vl_prc_header_id NUMBER(15);
2498: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
2499: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
2500: vl_prg_val_set_id NUMBER(15);

Line 2498: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;

2494: l_module_name VARCHAR2(200) := g_module_name || 'GET_PROGRAM_SEGMENT';
2495: vl_seg_found VARCHAR2(1) := 'N';
2496: vl_prg_seg_name fv_facts_prc_hdr.program_segment%TYPE;
2497: vl_prc_header_id NUMBER(15);
2498: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
2499: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
2500: vl_prg_val_set_id NUMBER(15);
2501:
2502: BEGIN

Line 2499: vl_code_type fv_facts_prc_hdr.code_type%TYPE;

2495: vl_seg_found VARCHAR2(1) := 'N';
2496: vl_prg_seg_name fv_facts_prc_hdr.program_segment%TYPE;
2497: vl_prc_header_id NUMBER(15);
2498: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
2499: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
2500: vl_prg_val_set_id NUMBER(15);
2501:
2502: BEGIN
2503:

Line 2528: FROM fv_facts_prc_hdr

2524: SELECT program_segment, prc_mapping_flag,
2525: prc_header_id
2526: INTO vl_prg_seg_name, vl_prc_flag,
2527: vl_prc_header_id
2528: FROM fv_facts_prc_hdr
2529: WHERE treasury_symbol_id = v_treasury_symbol_id
2530: AND code_type = vl_code_type
2531: AND fund_value = v_fund_value
2532: AND set_of_books_id = vp_set_of_books_id;

Line 2545: FROM fv_facts_prc_hdr

2541: SELECT program_segment, prc_mapping_flag,
2542: prc_header_id
2543: INTO vl_prg_seg_name, vl_prc_flag,
2544: vl_prc_header_id
2545: FROM fv_facts_prc_hdr
2546: WHERE treasury_symbol_id = v_treasury_symbol_id
2547: AND fund_value = 'ALL-A'
2548: AND code_type = vl_code_type
2549: AND va_appor_cat_val = 'A'

Line 2564: FROM fv_facts_prc_hdr

2560: SELECT program_segment, prc_mapping_flag,
2561: prc_header_id
2562: INTO vl_prg_seg_name, vl_prc_flag,
2563: vl_prc_header_id
2564: FROM fv_facts_prc_hdr
2565: WHERE treasury_symbol_id = v_treasury_symbol_id
2566: AND fund_value = 'ALL-B'
2567: AND code_type = vl_code_type
2568: AND va_appor_cat_val = 'B'

Line 2583: FROM fv_facts_prc_hdr

2579: SELECT program_segment, prc_mapping_flag,
2580: prc_header_id
2581: INTO vl_prg_seg_name, vl_prc_flag,
2582: vl_prc_header_id
2583: FROM fv_facts_prc_hdr
2584: WHERE treasury_symbol_id = v_treasury_symbol_id
2585: AND code_type = vl_code_type
2586: AND fund_value = 'ALL-FUNDS'
2587: AND set_of_books_id = vp_set_of_books_id;

Line 2601: FROM fv_facts_prc_hdr

2597: SELECT program_segment, prc_mapping_flag,
2598: prc_header_id
2599: INTO vl_prg_seg_name, vl_prc_flag,
2600: vl_prc_header_id
2601: FROM fv_facts_prc_hdr
2602: WHERE treasury_symbol_id = -1
2603: AND code_type = vl_code_type
2604: AND fund_value = 'ALL-A'
2605: AND va_appor_cat_val = 'A'

Line 2620: FROM fv_facts_prc_hdr

2616: SELECT program_segment, prc_mapping_flag,
2617: prc_header_id
2618: INTO vl_prg_seg_name, vl_prc_flag,
2619: vl_prc_header_id
2620: FROM fv_facts_prc_hdr
2621: WHERE treasury_symbol_id = -1
2622: AND fund_value = 'ALL-B'
2623: AND code_type = vl_code_type
2624: AND va_appor_cat_val = 'B'

Line 2640: FROM fv_facts_prc_hdr

2636: SELECT program_segment, prc_mapping_flag,
2637: prc_header_id
2638: INTO vl_prg_seg_name, vl_prc_flag,
2639: vl_prc_header_id
2640: FROM fv_facts_prc_hdr
2641: WHERE treasury_symbol_id = -1
2642: AND fund_value = 'ALL-FUNDS'
2643: AND code_type = vl_code_type
2644: AND set_of_books_id = vp_set_of_books_id;