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

Line 33: g_pci_prg_header_id fv_facts_prc_hdr.prc_header_id%type;

29: Vl_Catb_Rc_Map_Status Varchar2(10);
30: Vl_Prn_Rc_Map_Status Varchar2(10);
31: Vl_Pci_Rc_Map_Status Varchar2(10);
32:
33: g_pci_prg_header_id fv_facts_prc_hdr.prc_header_id%type;
34: G_Prc_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
35: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
36: G_Catb_Prc_Flag Varchar2(1);
37: G_Pci_Prc_Flag Varchar2(1);

Line 34: G_Prc_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;

30: Vl_Prn_Rc_Map_Status Varchar2(10);
31: Vl_Pci_Rc_Map_Status Varchar2(10);
32:
33: g_pci_prg_header_id fv_facts_prc_hdr.prc_header_id%type;
34: G_Prc_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
35: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
36: G_Catb_Prc_Flag Varchar2(1);
37: G_Pci_Prc_Flag Varchar2(1);
38: G_Prc_Prc_Flag Varchar2(1);

Line 35: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;

31: Vl_Pci_Rc_Map_Status Varchar2(10);
32:
33: g_pci_prg_header_id fv_facts_prc_hdr.prc_header_id%type;
34: G_Prc_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
35: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
36: G_Catb_Prc_Flag Varchar2(1);
37: G_Pci_Prc_Flag Varchar2(1);
38: G_Prc_Prc_Flag Varchar2(1);
39: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;

Line 39: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;

35: G_Catb_Prg_Header_Id Fv_Facts_Prc_Hdr.Prc_Header_Id%Type;
36: G_Catb_Prc_Flag Varchar2(1);
37: G_Pci_Prc_Flag Varchar2(1);
38: G_Prc_Prc_Flag Varchar2(1);
39: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
40: g_prc_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
41: g_pci_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
42:
43: g_Treasury_Symbol_Low Varchar2(35);

Line 40: g_prc_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;

36: G_Catb_Prc_Flag Varchar2(1);
37: G_Pci_Prc_Flag Varchar2(1);
38: G_Prc_Prc_Flag Varchar2(1);
39: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
40: g_prc_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
41: g_pci_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
42:
43: g_Treasury_Symbol_Low Varchar2(35);
44: g_Treasury_Symbol_high Varchar2(35);

Line 41: g_pci_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;

37: G_Pci_Prc_Flag Varchar2(1);
38: G_Prc_Prc_Flag Varchar2(1);
39: g_catb_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
40: g_prc_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
41: g_pci_prG_SEG fv_facts_prc_hdr.program_segment%TYPE;
42:
43: g_Treasury_Symbol_Low Varchar2(35);
44: g_Treasury_Symbol_high Varchar2(35);
45:

Line 1345: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;

1341: --vl_ts_id NUMBER;
1342: vl_fund_value fv_fund_parameters.fund_value%TYPE;
1343: vl_treasury_symbol_id NUMBER;
1344: vl_fund_category VARCHAR2(1);
1345: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
1346: Vl_Prc_Header_Id Number;
1347: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
1348: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
1349: Vl_Status Varchar2(15);

Line 1347: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;

1343: vl_treasury_symbol_id NUMBER;
1344: vl_fund_category VARCHAR2(1);
1345: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
1346: Vl_Prc_Header_Id Number;
1347: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
1348: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
1349: Vl_Status Varchar2(15);
1350: --Vl_Prc_Found varchar2(1);
1351:

Line 1348: vl_code_type fv_facts_prc_hdr.code_type%TYPE;

1344: vl_fund_category VARCHAR2(1);
1345: vl_prg_seg fv_facts_prc_hdr.program_segment%TYPE;
1346: Vl_Prc_Header_Id Number;
1347: vl_prc_flag fv_facts_prc_hdr.prc_mapping_flag%TYPE;
1348: vl_code_type fv_facts_prc_hdr.code_type%TYPE;
1349: Vl_Status Varchar2(15);
1350: --Vl_Prc_Found varchar2(1);
1351:
1352: BEGIN

Line 1384: From Fv_Facts_Prc_Hdr Ffh

1380: BEGIN
1381: SELECT program_segment,
1382: prc_mapping_flag, prc_header_id
1383: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
1384: From Fv_Facts_Prc_Hdr Ffh
1385: WHERE ffh.treasury_symbol_id = vl_treasury_symbol_id
1386: AND ffh.code_type = vl_code_type
1387: AND ffh.set_of_books_id = p_sob_id
1388: AND ffh.fund_value = p_fund_value;

Line 1402: FROM fv_facts_prc_hdr ffh

1398: BEGIN
1399: SELECT program_segment,
1400: prc_mapping_flag, prc_header_id
1401: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
1402: FROM fv_facts_prc_hdr ffh
1403: WHERE ffh.treasury_symbol_id = vl_treasury_symbol_id
1404: AND ffh.code_type = vl_code_type
1405: And Ffh.Set_Of_Books_Id = P_Sob_Id
1406: AND ffh.fund_value = 'ALL-A';

Line 1421: FROM fv_facts_prc_hdr ffh

1417: BEGIN
1418: SELECT program_segment,
1419: prc_mapping_flag, prc_header_id
1420: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
1421: FROM fv_facts_prc_hdr ffh
1422: WHERE ffh.treasury_symbol_id = vl_treasury_symbol_id
1423: AND ffh.code_type = vl_code_type
1424: And Ffh.Set_Of_Books_Id = P_Sob_Id
1425: AND ffh.fund_value = 'ALL-B';

Line 1439: FROM fv_facts_prc_hdr ffh

1435: BEGIN
1436: SELECT program_segment,
1437: prc_mapping_flag, prc_header_id
1438: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
1439: FROM fv_facts_prc_hdr ffh
1440: WHERE ffh.treasury_symbol_id = vl_treasury_symbol_id
1441: AND ffh.code_type = vl_code_type
1442: AND ffh.set_of_books_id = p_sob_id
1443: AND ffh.fund_value = 'ALL-FUNDS';

Line 1457: FROM fv_facts_prc_hdr ffh

1453: BEGIN
1454: SELECT program_segment,
1455: prc_mapping_flag, prc_header_id
1456: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
1457: FROM fv_facts_prc_hdr ffh
1458: WHERE ffh.treasury_symbol_id = -1
1459: AND ffh.code_type = vl_code_type
1460: And Ffh.Set_Of_Books_Id = P_Sob_Id
1461: AND ffh.fund_value = 'ALL-A';

Line 1476: FROM fv_facts_prc_hdr ffh

1472: BEGIN
1473: SELECT program_segment,
1474: prc_mapping_flag, prc_header_id
1475: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
1476: FROM fv_facts_prc_hdr ffh
1477: WHERE ffh.treasury_symbol_id = -1
1478: AND ffh.code_type = vl_code_type
1479: And Ffh.Set_Of_Books_Id = P_Sob_Id
1480: AND ffh.fund_value = 'ALL-B';

Line 1495: FROM fv_facts_prc_hdr ffh

1491: BEGIN
1492: SELECT program_segment,
1493: prc_mapping_flag, prc_header_id
1494: INTO vl_prg_seg, vl_prc_flag, vl_prc_header_id
1495: FROM fv_facts_prc_hdr ffh
1496: WHERE ffh.treasury_symbol_id = -1
1497: AND ffh.set_of_books_id = p_sob_id
1498: AND ffh.code_type = vl_code_type
1499: AND ffh.fund_value = 'ALL-FUNDS';