APPS.FV_GTAS_INTERFACE dependencies on FV_FACTS_PRC_DTL

Line 1574: l_prg_val FV_FACTS_PRC_DTL.PROGRAM_VALUE%TYPE;

1570: Select_Stmt varchar2(100);
1571:
1572: k varchar2(150);
1573: l_module_name VARCHAR2(200) := g_module_name||'Get_Prc_Map_Val';
1574: l_prg_val FV_FACTS_PRC_DTL.PROGRAM_VALUE%TYPE;
1575: Begin
1576:
1577: Select_Stmt := 'SELECT ' || p_Segment_Name ||
1578: ' from gl_code_combinations where code_combination_id=' || p_Ccid;

Line 1588: From Fv_Facts_Prc_Dtl

1584: -- IF l_prg_val IS NOT NULL THEN
1585: begin
1586: SELECT reporting_code
1587: INTO p_prc_val
1588: From Fv_Facts_Prc_Dtl
1589: WHERE prc_header_id = P_Prc_Header_Id
1590: And Program_Value = l_prg_val
1591: And Set_Of_Books_Id = Gbl_Set_Of_Books_Id;
1592:

Line 1600: FROM fv_facts_prc_dtl

1596:
1597: begin
1598: SELECT reporting_code
1599: INTO p_prc_val
1600: FROM fv_facts_prc_dtl
1601: WHERE prc_header_id = P_Prc_Header_Id
1602: And Program_Value = 'ALL'
1603: And Set_Of_Books_Id = Gbl_Set_Of_Books_Id;
1604: exception

Line 1830: --fv_facts_prc_Dtl.reporting_code%type;

1826: --fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1827: TYPE l_APPOR_CAT_CODE_t is table of varchar2(1);
1828: --fv_fund_parameters.fund_category%type;
1829: TYPE l_APPOR_CAT_B_CODE_t is table of varchar2(4);
1830: --fv_facts_prc_Dtl.reporting_code%type;
1831: TYPE l_PROGRAM_REPT_CODE_t is table of varchar2(4);
1832: --fv_facts_prc_Dtl.reporting_code%type;
1833: TYPE l_BEA_CAT_CODE_t is table of varchar2(1);
1834: --fv_fund_parameters.BEA_CATEGORY%type;

Line 1832: --fv_facts_prc_Dtl.reporting_code%type;

1828: --fv_fund_parameters.fund_category%type;
1829: TYPE l_APPOR_CAT_B_CODE_t is table of varchar2(4);
1830: --fv_facts_prc_Dtl.reporting_code%type;
1831: TYPE l_PROGRAM_REPT_CODE_t is table of varchar2(4);
1832: --fv_facts_prc_Dtl.reporting_code%type;
1833: TYPE l_BEA_CAT_CODE_t is table of varchar2(1);
1834: --fv_fund_parameters.BEA_CATEGORY%type;
1835: TYPE l_BORR_SRC_CODE_t is table of varchar2(1);
1836: --fv_fund_parameters.BORROWING_SOURCE_CODE%type;

Line 1842: --fv_facts_prc_Dtl.reporting_code%type;

1838: TYPE l_CUR_SUBSEQUENT_CODE_t is table of VARCHAR2(4) ;
1839: TYPE l_PYA_CODE_t is table of VARCHAR2(4) ;
1840: TYPE l_CREDIT_COHORT_YR_t is table of VARCHAR2(150);
1841: TYPE l_PROGRAM_COST_IND_t is table of VARCHAR2(4) ;
1842: --fv_facts_prc_Dtl.reporting_code%type;
1843: TYPE l_TREASURY_SYMBOL_ID_t is table of number(15);
1844: --fv_treasury_symbols.treasury_symbol_id%type;
1845:
1846: -- individual entries

Line 1921: l_APPOR_CAT_B_CODE fv_facts_prc_Dtl.reporting_code%type;

1917: l_curr_year_bal number;
1918: l_ccid number(15);
1919: l_DIRECT_OR_REIMB_CODE fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1920: l_APPOR_CAT_CODE fv_fund_parameters.fund_category%type;
1921: l_APPOR_CAT_B_CODE fv_facts_prc_Dtl.reporting_code%type;
1922: l_PROGRAM_REPT_CODE fv_facts_prc_Dtl.reporting_code%type;
1923: l_BEA_CAT_CODE fv_fund_parameters.BEA_CATEGORY%type;
1924: l_BORR_SRC_CODE fv_fund_parameters.BORROWING_SOURCE_CODE%type;
1925: l_NEW_BAL_CODE VARCHAR2(3) ;

Line 1922: l_PROGRAM_REPT_CODE fv_facts_prc_Dtl.reporting_code%type;

1918: l_ccid number(15);
1919: l_DIRECT_OR_REIMB_CODE fv_fund_parameters.DIRECT_OR_REIMB_CODE%type;
1920: l_APPOR_CAT_CODE fv_fund_parameters.fund_category%type;
1921: l_APPOR_CAT_B_CODE fv_facts_prc_Dtl.reporting_code%type;
1922: l_PROGRAM_REPT_CODE fv_facts_prc_Dtl.reporting_code%type;
1923: l_BEA_CAT_CODE fv_fund_parameters.BEA_CATEGORY%type;
1924: l_BORR_SRC_CODE fv_fund_parameters.BORROWING_SOURCE_CODE%type;
1925: l_NEW_BAL_CODE VARCHAR2(3) ;
1926: l_CUR_SUBSEQUENT_CODE VARCHAR2(4) ;

Line 1929: l_PROGRAM_COST_IND fv_facts_prc_Dtl.reporting_code%type;

1925: l_NEW_BAL_CODE VARCHAR2(3) ;
1926: l_CUR_SUBSEQUENT_CODE VARCHAR2(4) ;
1927: l_PYA_CODE VARCHAR2(4) ;
1928: l_CREDIT_COHORT_YR VARCHAR2(150);
1929: l_PROGRAM_COST_IND fv_facts_prc_Dtl.reporting_code%type;
1930: l_tREASURY_SYMBOL_ID fv_treasury_symbols.treasury_symbol_id%type;
1931: l_account_number_prv VARCHAR2(30);
1932: l_t2_detail_amount NUMBER;
1933: l_fed_account VARCHAR2(1);