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 908: INSERT INTO fv_facts_report_t2

904: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
905: 'Inserting a record in T2 for record_category :'||p_record_category||' for ccid: '||p_ccid);
906: END IF;
907:
908: INSERT INTO fv_facts_report_t2
909: ( fund_group,
910: account_number,
911: dept_id,
912: bureau_id,

Line 993: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;

989: l_reporting_type VARCHAR2(1);
990:
991: l_exists VARCHAR2(1);
992: l_row_exists VARCHAR2(1);
993: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
994: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
995: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
996: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
997: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;

Line 996: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;

992: l_row_exists VARCHAR2(1);
993: l_g_ng_ind Fv_Facts_Report_T2.g_ng_indicator%TYPE;
994: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
995: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
996: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
997: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
998: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;
999:
1000: BEGIN

Line 998: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;

994: l_e_ne_ind Fv_Facts_Attributes.exch_non_exch%TYPE;
995: l_c_nc_ind Fv_Facts_Attributes.cust_non_cust%TYPE;
996: l_c_nc Fv_Facts_Report_T2.cust_non_cust%TYPE;
997: l_budget_sub_ind Fv_Facts_Attributes.budget_subfunction%TYPE;
998: l_budget_sub Fv_Facts_Report_T2.budget_subfunction%TYPE;
999:
1000: BEGIN
1001:
1002: l_module_name := g_module_name || 'GET_USSGL_ACCT_NUM';

Line 1719: DELETE FROM fv_facts_report_t2

1715: l_module_name := g_module_name || 'CLEANUP_PROCESS';
1716: FV_UTILITY.LOG_MESG('In '||l_module_name);
1717:
1718:
1719: DELETE FROM fv_facts_report_t2
1720: WHERE set_of_books_id = gbl_set_of_books_id;
1721:
1722: /** cleanup the line balance differrence records */
1723: FV_UTILITY.LOG_MESG('Deleting from fv_facts1_diff_balances for Period Year: '||

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

1747:
1748: BEGIN
1749:
1750:
1751: fnd_file.put_line(fnd_file.log , 'Inserting records into FV_FACTS_REPORT_T2');
1752:
1753: INSERT INTO fv_facts_report_t2
1754: (fund_group,
1755: account_number,

Line 1753: INSERT INTO fv_facts_report_t2

1749:
1750:
1751: fnd_file.put_line(fnd_file.log , 'Inserting records into FV_FACTS_REPORT_T2');
1752:
1753: INSERT INTO fv_facts_report_t2
1754: (fund_group,
1755: account_number,
1756: dept_id,
1757: bureau_id,

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

1821: ccid,
1822: account_type,
1823: period_num;
1824:
1825: fnd_file.put_line(fnd_file.log , 'Completed inserting records into FV_FACTS_REPORT_T2 ' || SQL%ROWCOUNT);
1826:
1827: commit;
1828:
1829: EXCEPTION

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

2037: --------------------------------------------------------------------------------
2038: -- Rollup_Process get called from Trial_Balance_Main procedure.
2039: -- The purpose of this procedure is to build a 'group by' clause using
2040: -- segments chosen in an attribute set of RXi. This procedure also does
2041: -- rollup of the trial balance records in fv_facts_report_t2 table by
2042: -- the SEGMENTS.
2043: -- ---------------------------------------------------------------------
2044: PROCEDURE ROLLUP_PROCESS
2045: IS

Line 2072: INSERT INTO fv_facts_report_t2

2068:
2069: fv_utility.log_mesg('GROUP BY CLAUSE IS: '|| L_GROUP_BY);
2070:
2071: l_statement := '
2072: INSERT INTO fv_facts_report_t2
2073: ( fund_group,
2074: account_number,
2075: dept_id,
2076: bureau_id,

Line 2139: DELETE FROM fv_facts_report_t2

2135: END IF;
2136:
2137: 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;
2138:
2139: DELETE FROM fv_facts_report_t2
2140: WHERE record_category <> 'TRIAL_BAL'
2141: AND set_of_books_id = gbl_set_of_books_id;
2142:
2143: EXCEPTION

Line 2169: l_period_begin_bal fv_facts_report_t2.amount%TYPE;

2165: l_acct_type_condition VARCHAR2(2500);
2166:
2167: l_bal_segment VARCHAR2(30);
2168: l_bal_segment_prv VARCHAR2(30);
2169: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2170: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2171: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2172: l_begin_bal fv_facts_report_t2.amount%TYPE;
2173: l_curr_year_balance fv_facts_report_t2.amount%TYPE;

Line 2170: l_period_cy_bal fv_facts_report_t2.amount%TYPE;

2166:
2167: l_bal_segment VARCHAR2(30);
2168: l_bal_segment_prv VARCHAR2(30);
2169: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2170: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2171: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2172: l_begin_bal fv_facts_report_t2.amount%TYPE;
2173: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2174: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;

Line 2171: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;

2167: l_bal_segment VARCHAR2(30);
2168: l_bal_segment_prv VARCHAR2(30);
2169: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2170: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2171: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2172: l_begin_bal fv_facts_report_t2.amount%TYPE;
2173: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2174: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2175: l_ending_amount fv_facts_report_t2.amount%TYPE;

Line 2172: l_begin_bal fv_facts_report_t2.amount%TYPE;

2168: l_bal_segment_prv VARCHAR2(30);
2169: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2170: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2171: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2172: l_begin_bal fv_facts_report_t2.amount%TYPE;
2173: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2174: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2175: l_ending_amount fv_facts_report_t2.amount%TYPE;
2176:

Line 2173: l_curr_year_balance fv_facts_report_t2.amount%TYPE;

2169: l_period_begin_bal fv_facts_report_t2.amount%TYPE;
2170: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2171: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2172: l_begin_bal fv_facts_report_t2.amount%TYPE;
2173: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2174: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2175: l_ending_amount fv_facts_report_t2.amount%TYPE;
2176:
2177: l_exists VARCHAR2(1);

Line 2174: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;

2170: l_period_cy_bal fv_facts_report_t2.amount%TYPE;
2171: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2172: l_begin_bal fv_facts_report_t2.amount%TYPE;
2173: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2174: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2175: l_ending_amount fv_facts_report_t2.amount%TYPE;
2176:
2177: l_exists VARCHAR2(1);
2178: l_stage VARCHAR2(25);

Line 2175: l_ending_amount fv_facts_report_t2.amount%TYPE;

2171: l_period_cy_cr_bal fv_facts_report_t2.amount%TYPE;
2172: l_begin_bal fv_facts_report_t2.amount%TYPE;
2173: l_curr_year_balance fv_facts_report_t2.amount%TYPE;
2174: l_t2_deail_amount fv_facts_report_t2.amount%TYPE;
2175: l_ending_amount fv_facts_report_t2.amount%TYPE;
2176:
2177: l_exists VARCHAR2(1);
2178: l_stage VARCHAR2(25);
2179: l_fg_null VARCHAR2(1);

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

2313: when no_data_found then
2314: l_populate_flag := 'Y';
2315: End;
2316:
2317: FV_UTILITY.LOG_MESG('Deleting records from fv_facts_report_t2.');
2318: DELETE FROM fv_facts_report_t2
2319: WHERE set_of_books_id = gbl_set_of_books_id;
2320:
2321:

Line 2318: DELETE FROM fv_facts_report_t2

2314: l_populate_flag := 'Y';
2315: End;
2316:
2317: FV_UTILITY.LOG_MESG('Deleting records from fv_facts_report_t2.');
2318: DELETE FROM fv_facts_report_t2
2319: WHERE set_of_books_id = gbl_set_of_books_id;
2320:
2321:
2322: GET_SEGMENT_NAMES;

Line 3028: FROM fv_facts_report_t2

3024:
3025: -- Count the exception records
3026: SELECT COUNT(*)
3027: INTO l_exception_count
3028: FROM fv_facts_report_t2
3029: WHERE set_of_books_id = gbl_set_of_books_id
3030: AND reported_status = 'E'
3031: and record_category NOT IN ('PROP_ACCT_NOT_SETUP', 'PROP_ACCT_FACTSII',
3032: 'USSGL_DISABLED', 'NO_FUND_GROUP' )