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_FACTS1_PKG dependencies on FV_FACTS_REPORT_T2

Line 21: gbl_prev_acct fv_facts_report_t2.account_number%TYPE;

17: gbl_acc_value_set_id NUMBER;
18: gbl_update_end_balance VARCHAR2(1);
19: gbl_currency_code gl_sets_of_books.currency_code%TYPE;
20: gbl_low_period_name gl_period_statuses.period_name%TYPE;
21: gbl_prev_acct fv_facts_report_t2.account_number%TYPE;
22: gbl_bal_segment fv_facts_report_t2.fund_value%TYPE;
23: gbl_sgl_acct_num VARCHAR2(4);
24: gbl_govt_non_govt_ind fv_facts1_period_attributes.g_ng_indicator%TYPE;
25: gbl_exch_non_exch fv_facts1_period_attributes.exch_non_exch%TYPE;

Line 22: gbl_bal_segment fv_facts_report_t2.fund_value%TYPE;

18: gbl_update_end_balance VARCHAR2(1);
19: gbl_currency_code gl_sets_of_books.currency_code%TYPE;
20: gbl_low_period_name gl_period_statuses.period_name%TYPE;
21: gbl_prev_acct fv_facts_report_t2.account_number%TYPE;
22: gbl_bal_segment fv_facts_report_t2.fund_value%TYPE;
23: gbl_sgl_acct_num VARCHAR2(4);
24: gbl_govt_non_govt_ind fv_facts1_period_attributes.g_ng_indicator%TYPE;
25: gbl_exch_non_exch fv_facts1_period_attributes.exch_non_exch%TYPE;
26: gbl_cust_non_cust fv_facts1_period_attributes.cust_non_cust%TYPE;

Line 902: INSERT INTO fv_facts_report_t2

898: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
899: 'Inserting a record in T2 for record_category :'||p_record_category||' for ccid: '||p_ccid);
900: END IF;
901:
902: INSERT INTO fv_facts_report_t2
903: ( fund_group,
904: account_number,
905: dept_id,
906: bureau_id,

Line 987: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;

983: l_reporting_type VARCHAR2(1);
984:
985: l_exists VARCHAR2(1);
986: l_row_exists VARCHAR2(1);
987: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
988: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
989: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
990: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
991: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;

Line 990: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;

986: l_row_exists VARCHAR2(1);
987: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
988: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
989: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
990: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
991: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
992: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;
993:
994: BEGIN

Line 992: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;

988: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
989: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
990: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
991: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
992: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;
993:
994: BEGIN
995:
996: l_module_name := g_module_name || 'GET_USSGL_ACCT_NUM';

Line 1679: DELETE FROM fv_facts_report_t2

1675: l_module_name := g_module_name || 'CLEANUP_PROCESS';
1676: FV_UTILITY.LOG_MESG('In '||l_module_name);
1677:
1678:
1679: DELETE FROM fv_facts_report_t2
1680: WHERE set_of_books_id = gbl_set_of_books_id;
1681:
1682: /** cleanup the line balance differrence records */
1683: FV_UTILITY.LOG_MESG('Deleting from fv_facts1_diff_balances for Period Year: '||

Line 1710: fnd_file.put_line(fnd_file.log , 'Inserting records into FV_FACTS_REPORT_T2');

1706:
1707: BEGIN
1708:
1709:
1710: fnd_file.put_line(fnd_file.log , 'Inserting records into FV_FACTS_REPORT_T2');
1711:
1712: INSERT INTO fv_facts_report_t2
1713: (fund_group,
1714: account_number,

Line 1712: INSERT INTO fv_facts_report_t2

1708:
1709:
1710: fnd_file.put_line(fnd_file.log , 'Inserting records into FV_FACTS_REPORT_T2');
1711:
1712: INSERT INTO fv_facts_report_t2
1713: (fund_group,
1714: account_number,
1715: dept_id,
1716: bureau_id,

Line 1784: fnd_file.put_line(fnd_file.log , 'Completed inserting records into FV_FACTS_REPORT_T2 ' || SQL%ROWCOUNT);

1780: ccid,
1781: account_type,
1782: period_num;
1783:
1784: fnd_file.put_line(fnd_file.log , 'Completed inserting records into FV_FACTS_REPORT_T2 ' || SQL%ROWCOUNT);
1785:
1786: commit;
1787:
1788: EXCEPTION

Line 1988: -- rollup of the trial balance records in fv_facts_report_t2 table by

1984: --------------------------------------------------------------------------------
1985: -- Rollup_Process get called from Trial_Balance_Main procedure.
1986: -- The purpose of this procedure is to build a 'group by' clause using
1987: -- segments chosen in an attribute set of RXi. This procedure also does
1988: -- rollup of the trial balance records in fv_facts_report_t2 table by
1989: -- the SEGMENTS.
1990: -- ---------------------------------------------------------------------
1991: PROCEDURE ROLLUP_PROCESS
1992: IS

Line 2019: INSERT INTO fv_facts_report_t2

2015:
2016: fv_utility.log_mesg('GROUP BY CLAUSE IS: '|| L_GROUP_BY);
2017:
2018: l_statement := '
2019: INSERT INTO fv_facts_report_t2
2020: ( fund_group,
2021: account_number,
2022: dept_id,
2023: bureau_id,

Line 2085: DELETE FROM fv_facts_report_t2

2081: END IF;
2082:
2083: EXECUTE IMMEDIATE l_statement USING gbl_set_of_books_id, gbl_set_of_books_id, gbl_period_num_high, gbl_fiscal_year, gbl_fund_range_low, gbl_fund_range_high;
2084:
2085: DELETE FROM fv_facts_report_t2
2086: WHERE record_category <> 'TRIAL_BAL'
2087: AND set_of_books_id = gbl_set_of_books_id;
2088:
2089: EXCEPTION

Line 2115: l_period_begin_bal fv_facts_report_t2.amount%TYPE;

2111: l_acct_type_condition VARCHAR2(2500);
2112:
2113: l_bal_segment VARCHAR2(30);
2114: l_bal_segment_prv VARCHAR2(30);
2115: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2116: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2117: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2118: l_begin_bal fv_facts_report_t2.amount%TYPE;
2119: l_curr_year_balance fv_facts_report_t2.amount%TYPE;

Line 2116: l_period_cy_bal fv_facts_report_t2.amount%TYPE;

2112:
2113: l_bal_segment VARCHAR2(30);
2114: l_bal_segment_prv VARCHAR2(30);
2115: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2116: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2117: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2118: l_begin_bal fv_facts_report_t2.amount%TYPE;
2119: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2120: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;

Line 2117: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;

2113: l_bal_segment VARCHAR2(30);
2114: l_bal_segment_prv VARCHAR2(30);
2115: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2116: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2117: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2118: l_begin_bal fv_facts_report_t2.amount%TYPE;
2119: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2120: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2121: l_ending_amount fv_facts_report_t2.amount%TYPE;

Line 2118: l_begin_bal fv_facts_report_t2.amount%TYPE;

2114: l_bal_segment_prv VARCHAR2(30);
2115: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2116: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2117: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2118: l_begin_bal fv_facts_report_t2.amount%TYPE;
2119: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2120: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2121: l_ending_amount fv_facts_report_t2.amount%TYPE;
2122:

Line 2119: l_curr_year_balance fv_facts_report_t2.amount%TYPE;

2115: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2116: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2117: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2118: l_begin_bal fv_facts_report_t2.amount%TYPE;
2119: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2120: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2121: l_ending_amount fv_facts_report_t2.amount%TYPE;
2122:
2123: l_exists VARCHAR2(1);

Line 2120: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;

2116: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2117: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2118: l_begin_bal fv_facts_report_t2.amount%TYPE;
2119: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2120: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2121: l_ending_amount fv_facts_report_t2.amount%TYPE;
2122:
2123: l_exists VARCHAR2(1);
2124: l_stage VARCHAR2(25);

Line 2121: l_ending_amount fv_facts_report_t2.amount%TYPE;

2117: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2118: l_begin_bal fv_facts_report_t2.amount%TYPE;
2119: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2120: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2121: l_ending_amount fv_facts_report_t2.amount%TYPE;
2122:
2123: l_exists VARCHAR2(1);
2124: l_stage VARCHAR2(25);
2125: l_fg_null VARCHAR2(1);

Line 2263: FV_UTILITY.LOG_MESG('Deleting records from fv_facts_report_t2.');

2259: when no_data_found then
2260: l_populate_flag := 'Y';
2261: End;
2262:
2263: FV_UTILITY.LOG_MESG('Deleting records from fv_facts_report_t2.');
2264: DELETE FROM fv_facts_report_t2
2265: WHERE set_of_books_id = gbl_set_of_books_id;
2266:
2267:

Line 2264: DELETE FROM fv_facts_report_t2

2260: l_populate_flag := 'Y';
2261: End;
2262:
2263: FV_UTILITY.LOG_MESG('Deleting records from fv_facts_report_t2.');
2264: DELETE FROM fv_facts_report_t2
2265: WHERE set_of_books_id = gbl_set_of_books_id;
2266:
2267:
2268: GET_SEGMENT_NAMES;

Line 2950: FROM fv_facts_report_t2

2946:
2947: -- Count the exception records
2948: SELECT COUNT(*)
2949: INTO l_exception_count
2950: FROM fv_facts_report_t2
2951: WHERE set_of_books_id = gbl_set_of_books_id
2952: AND reported_status = 'E'
2953: and record_category NOT IN ('PROP_ACCT_NOT_SETUP', 'PROP_ACCT_FACTSII',
2954: 'USSGL_DISABLED', 'NO_FUND_GROUP' )