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_FACTS_TRANSACTIONS dependencies on FV_FACTS_TEMP

Line 102: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;

98: v_cohort_select VARCHAR2(20) ;
99: v_fiscal_yr VARCHAR2(25);
100: v_dummy_cohort VARCHAR2(25);
101: v_acct_attr_flag VARCHAR2(1) ;
102: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;
103: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;
104: v_amount NUMBER ;
105: v_year_budget_auth VARCHAR2(3);
106: v_tbal_fund_value fv_fund_parameters.fund_value%TYPE ;

Line 108: v_tbal_indicator fv_facts_temp.tbal_indicator%TYPE ;

104: v_amount NUMBER ;
105: v_year_budget_auth VARCHAR2(3);
106: v_tbal_fund_value fv_fund_parameters.fund_value%TYPE ;
107: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;
108: v_tbal_indicator fv_facts_temp.tbal_indicator%TYPE ;
109: v_period_activity NUMBER;
110: v_edit_check_code NUMBER ;
111: v_g_edit_check_code NUMBER(15);
112: v_cohort_where VARCHAR2(120) ;

Line 765: -- Purges all FACTS transactions from the FV_FACTS_TEMP table for

761: l_module_name||'.final_exception',vp_errbuf);
762: RAISE;
763: END load_treasury_symbol_id ;
764: --------------------------------------------------------------------------------------
765: -- Purges all FACTS transactions from the FV_FACTS_TEMP table for
766: -- the passed Treasaury Symbol.
767: --------------------------------------------------------------------------------------
768: PROCEDURE purge_facts_transactions
769: IS

Line 775: DELETE FROM fv_facts_temp

771: BEGIN
772: l_module_name := g_module_name || 'purge_facts_transactions';
773: -- Delete from the temp table based on the treasury_symbol_id
774:
775: DELETE FROM fv_facts_temp
776: WHERE treasury_symbol_id = v_treasury_symbol_id ;
777:
778: DELETE FROM fv_facts_edit_check_status
779: WHERE treasury_symbol_id = v_treasury_symbol_id ;

Line 1127: -- It populates the table FV_FACTS_TEMP for edit check process to

1123: -- analyzed for reporting in the FACTS output file. After getting the
1124: -- list of transactions that needs to be reported, it applies all the
1125: -- FACTS attributes for the account number and performs further
1126: -- processing for Legislative Indicator and Apportionment Category.
1127: -- It populates the table FV_FACTS_TEMP for edit check process to
1128: -- perform edit checks.
1129: --------------------------------------------------------------------------------
1130: PROCEDURE process_facts_transactions
1131: IS

Line 1206: FROM fv_facts_temp

1202: (p_tsymbol_id fv_treasury_symbols.treasury_symbol_id%TYPE)
1203: IS
1204: SELECT treasury_symbol_id,
1205: sgl_acct_number
1206: FROM fv_facts_temp
1207: WHERE fct_int_record_type = 'BLK_DTL'
1208: AND fct_int_record_category = 'REPORTED_NEW'
1209: AND document_number = 'Y'
1210: AND treasury_symbol_id = p_tsymbol_id ;

Line 3051: DELETE FROM FV_FACTS_TEMP

3047: p_ledger_id => vp_set_of_books_id) ;
3048:
3049:
3050: -- Deleting zero amount records after edit check process
3051: DELETE FROM FV_FACTS_TEMP
3052: WHERE (fct_int_record_category = 'REPORTED' OR
3053: fct_int_record_category = 'REPORTED_NEW')
3054: AND amount = 0
3055: AND sgl_acct_number like '4%'

Line 3127: UPDATE fv_facts_temp

3123: END IF;
3124:
3125: -- Create Concatenated FACTS Record in the Temp table Column
3126:
3127: UPDATE fv_facts_temp
3128: SET facts_report_info =
3129: vc_dept_regular || vc_dept_transfer || vc_fiscal_yr ||
3130: vc_main_account|| vc_sub_acct_symbol||lpad(vc_maf_seq_num,3,'0')||
3131: RPAD(NVL(program_rpt_cat_num, ' '), 3, ' ') ||

Line 3162: INSERT INTO FV_FACTS_TEMP

3158: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3159: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3160: 'Creating Contact Header Record.....FACTS II ') ;
3161: END IF;
3162: INSERT INTO FV_FACTS_TEMP
3163: (treasury_symbol_id,
3164: fct_int_record_category,
3165: fct_int_record_type,
3166: facts_report_info)

Line 3565: -- Inserts a new record into FV_FACTS_TEMP table with the current

3561: l_module_name||'.final_exception', vp_errbuf) ;
3562: RETURN;
3563: END get_ussgl_acct_num ;
3564: --------------------------------------------------------------------------------
3565: -- Inserts a new record into FV_FACTS_TEMP table with the current
3566: -- values from the global variables.
3567: --------------------------------------------------------------------------------
3568: PROCEDURE create_facts_record
3569: IS

Line 3571: vl_parent_sgl_acct_num fv_facts_temp.parent_sgl_acct_number%TYPE;

3567: --------------------------------------------------------------------------------
3568: PROCEDURE create_facts_record
3569: IS
3570: l_module_name VARCHAR2(200);
3571: vl_parent_sgl_acct_num fv_facts_temp.parent_sgl_acct_number%TYPE;
3572: l_year_budget_auth VARCHAR2(3);
3573: BEGIN
3574: l_module_name := g_module_name || 'create_facts_record';
3575: IF v_year_gtn2001

Line 3590: INSERT INTO FV_FACTS_TEMP

3586: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3587: 'Creating FACTS Record') ;
3588: END IF ;
3589:
3590: INSERT INTO FV_FACTS_TEMP
3591: (SGL_ACCT_NUMBER ,
3592: COHORT ,
3593: BEGIN_END ,
3594: INDEF_DEF_FLAG ,

Line 4641: FROM fv_facts_temp

4637: CURSOR facts_temp IS
4638: SELECT rowid, sgl_acct_number, tbal_fund_value,
4639: fct_int_record_category, begin_end,
4640: treasury_symbol_id
4641: FROM fv_facts_temp
4642: WHERE (fct_int_record_category = 'REPORTED'
4643: OR fct_int_record_category = 'REPORTED_NEW')
4644: AND AMOUNT = 0
4645: AND NVL(PERIOD_ACTIVITY,0) = 0

Line 4652: INSERT INTO FV_FACTS_TEMP

4648: l_account_type VARCHAR2(1);
4649:
4650: BEGIN
4651: l_module_name := g_module_name || 'facts_rollup_records';
4652: INSERT INTO FV_FACTS_TEMP
4653: (TREASURY_SYMBOL_ID ,
4654: SGL_ACCT_NUMBER ,
4655: PARENT_SGL_ACCT_NUMBER ,
4656: COHORT ,

Line 4731: FROM fv_facts_temp

4727: PROGRAM_RPT_CAT_NUM,
4728: PROGRAM_RPT_CAT_TXT
4729: -- SEGMENT1,
4730: -- SEGMENT2
4731: FROM fv_facts_temp
4732: WHERE fct_int_record_category = 'REPORTED'
4733: AND fct_int_record_type = 'BLK_DTL'
4734: AND treasury_symbol_id = v_treasury_symbol_id
4735: GROUP BY TREASURY_SYMBOL_ID,

Line 4777: FROM fv_facts_temp

4773: THEN
4774: IF (facts_temp_rec.fct_int_record_category = 'REPORTED_NEW'
4775: AND facts_temp_rec.begin_end = 'E') THEN
4776: SELECT count(*) INTO l_count
4777: FROM fv_facts_temp
4778: WHERE begin_end = 'B'
4779: AND sgl_acct_number = facts_temp_rec.sgl_acct_number
4780: AND tbal_fund_value = facts_temp_rec.tbal_fund_value
4781: AND treasury_symbol_id = facts_temp_rec.treasury_symbol_id

Line 4786: DELETE FROM fv_facts_temp

4782: AND fct_int_record_category = 'REPORTED_NEW'
4783: AND amount <> 0;
4784:
4785: IF l_count = 0 THEN
4786: DELETE FROM fv_facts_temp
4787: WHERE rowid = facts_temp_rec.rowid;
4788: END IF;
4789: END IF;
4790:

Line 4800: UPDATE fv_facts_temp

4796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
4797: 'Setting up Debit/Credit Indicator') ;
4798: END IF;
4799:
4800: UPDATE fv_facts_temp
4801: SET debit_credit = 'C'
4802: WHERE amount < 0
4803: AND fct_int_record_category = 'REPORTED_NEW'
4804: AND treasury_symbol_id = v_treasury_symbol_id ;

Line 4806: UPDATE fv_facts_temp

4802: WHERE amount < 0
4803: AND fct_int_record_category = 'REPORTED_NEW'
4804: AND treasury_symbol_id = v_treasury_symbol_id ;
4805:
4806: UPDATE fv_facts_temp
4807: SET debit_credit = 'D'
4808: WHERE amount >= 0
4809: AND fct_int_record_category = 'REPORTED_NEW'
4810: AND treasury_symbol_id = v_treasury_symbol_id ;