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

Line 59: g_pci_prg_header_id fv_facts_prc_hdr.prc_header_id%type;

55: Vl_Prn_Rc_Map_Status Varchar2(10);
56: Vl_Pci_Rc_Map_Status Varchar2(10);
57: Vl_Prc_Val Varchar2(4);
58:
59: g_pci_prg_header_id fv_facts_prc_hdr.prc_header_id%type;
60: G_Prc_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
61: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
62: G_Catb_Prc_Flag Varchar2(1);
63: G_Pci_Prc_Flag Varchar2(1);

Line 60: G_Prc_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;

56: Vl_Pci_Rc_Map_Status Varchar2(10);
57: Vl_Prc_Val Varchar2(4);
58:
59: g_pci_prg_header_id fv_facts_prc_hdr.prc_header_id%type;
60: G_Prc_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
61: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
62: G_Catb_Prc_Flag Varchar2(1);
63: G_Pci_Prc_Flag Varchar2(1);
64: G_Prc_Prc_Flag Varchar2(1);

Line 61: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;

57: Vl_Prc_Val Varchar2(4);
58:
59: g_pci_prg_header_id fv_facts_prc_hdr.prc_header_id%type;
60: G_Prc_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
61: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
62: G_Catb_Prc_Flag Varchar2(1);
63: G_Pci_Prc_Flag Varchar2(1);
64: G_Prc_Prc_Flag Varchar2(1);
65: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;

Line 65: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;

61: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
62: G_Catb_Prc_Flag Varchar2(1);
63: G_Pci_Prc_Flag Varchar2(1);
64: G_Prc_Prc_Flag Varchar2(1);
65: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
66: g_prc_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
67: g_pci_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
68:
69: g_balance_type_flag VARCHAR2(1) ;

Line 66: g_prc_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;

62: G_Catb_Prc_Flag Varchar2(1);
63: G_Pci_Prc_Flag Varchar2(1);
64: G_Prc_Prc_Flag Varchar2(1);
65: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
66: g_prc_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
67: g_pci_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
68:
69: g_balance_type_flag VARCHAR2(1) ;
70: g_public_law_code_flag VARCHAR2(1) ;

Line 67: g_pci_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;

63: G_Pci_Prc_Flag Varchar2(1);
64: G_Prc_Prc_Flag Varchar2(1);
65: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
66: g_prc_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
67: g_pci_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
68:
69: g_balance_type_flag VARCHAR2(1) ;
70: g_public_law_code_flag VARCHAR2(1) ;
71: g_reimburseable_flag VARCHAR2(1) ;

Line 306: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;

302: --vl_ts_id NUMBER;
303: vl_fund_value fv_fund_parameters.fund_value%TYPE;
304: vl_treasury_symbol_id NUMBER;
305: vl_fund_category VARCHAR2(1);
306: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
307: Vl_Prc_Header_Id Number;
308: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
309: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
310: Vl_Status Varchar2(15);

Line 308: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;

304: vl_treasury_symbol_id NUMBER;
305: vl_fund_category VARCHAR2(1);
306: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
307: Vl_Prc_Header_Id Number;
308: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
309: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
310: Vl_Status Varchar2(15);
311: --Vl_Prc_Found varchar2(1);
312:

Line 309: vl_code_type fv_facts_prc_hdr.code_type%TYPE;

305: vl_fund_category VARCHAR2(1);
306: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
307: Vl_Prc_Header_Id Number;
308: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
309: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
310: Vl_Status Varchar2(15);
311: --Vl_Prc_Found varchar2(1);
312:
313: BEGIN

Line 345: From Fv_Facts_Prc_Hdr Ffh

341: BEGIN
342: SELECT program_segment,
343: prc_mapping_flag, prc_header_id
344: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
345: From Fv_Facts_Prc_Hdr Ffh
346: WHERE ffh.treasury_symbol_id = vl_treasury_symbol_id
347: AND ffh.code_type = vl_code_type
348: AND ffh.set_of_books_id = p_sob_id
349: AND ffh.fund_value = p_fund_value;

Line 363: FROM fv_facts_prc_hdr ffh

359: BEGIN
360: SELECT program_segment,
361: prc_mapping_flag, prc_header_id
362: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
363: FROM fv_facts_prc_hdr ffh
364: WHERE ffh.treasury_symbol_id = vl_treasury_symbol_id
365: AND ffh.code_type = vl_code_type
366: And Ffh.Set_Of_Books_Id = P_Sob_Id
367: AND ffh.fund_value = 'ALL-A';

Line 382: FROM fv_facts_prc_hdr ffh

378: BEGIN
379: SELECT program_segment,
380: prc_mapping_flag, prc_header_id
381: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
382: FROM fv_facts_prc_hdr ffh
383: WHERE ffh.treasury_symbol_id = vl_treasury_symbol_id
384: AND ffh.code_type = vl_code_type
385: And Ffh.Set_Of_Books_Id = P_Sob_Id
386: AND ffh.fund_value = 'ALL-B';

Line 400: FROM fv_facts_prc_hdr ffh

396: BEGIN
397: SELECT program_segment,
398: prc_mapping_flag, prc_header_id
399: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
400: FROM fv_facts_prc_hdr ffh
401: WHERE ffh.treasury_symbol_id = vl_treasury_symbol_id
402: AND ffh.code_type = vl_code_type
403: AND ffh.set_of_books_id = p_sob_id
404: AND ffh.fund_value = 'ALL-FUNDS';

Line 418: FROM fv_facts_prc_hdr ffh

414: BEGIN
415: SELECT program_segment,
416: prc_mapping_flag, prc_header_id
417: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
418: FROM fv_facts_prc_hdr ffh
419: WHERE ffh.treasury_symbol_id = -1
420: AND ffh.code_type = vl_code_type
421: And Ffh.Set_Of_Books_Id = P_Sob_Id
422: AND ffh.fund_value = 'ALL-A';

Line 437: FROM fv_facts_prc_hdr ffh

433: BEGIN
434: SELECT program_segment,
435: prc_mapping_flag, prc_header_id
436: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
437: FROM fv_facts_prc_hdr ffh
438: WHERE ffh.treasury_symbol_id = -1
439: AND ffh.code_type = vl_code_type
440: And Ffh.Set_Of_Books_Id = P_Sob_Id
441: AND ffh.fund_value = 'ALL-B';

Line 456: FROM fv_facts_prc_hdr ffh

452: BEGIN
453: SELECT program_segment,
454: prc_mapping_flag, prc_header_id
455: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
456: FROM fv_facts_prc_hdr ffh
457: WHERE ffh.treasury_symbol_id = -1
458: AND ffh.set_of_books_id = p_sob_id
459: AND ffh.code_type = vl_code_type
460: AND ffh.fund_value = 'ALL-FUNDS';

Line 703: FROM fv_facts_prc_hdr

699: -- message and exit process.
700:
701: SELECT count(*)
702: INTO l_prc_map_count
703: FROM fv_facts_prc_hdr
704: WHERE set_of_books_id = g_set_of_books_id;
705:
706: log(l_module, 'l_prc_map_count '||l_prc_map_count);
707: log(l_module, 'g_error_code '||g_error_code);