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

Line 292: select distinct fft.treasury_symbol_id from fv_facts_temp fft,

288: ORDER BY treasury_symbol;
289:
290: CURSOR get_ts_id_cur (p_acc_num VARCHAR2)
291: IS
292: select distinct fft.treasury_symbol_id from fv_facts_temp fft,
293: fv_treasury_symbols fts
294: where sgl_acct_number like p_acc_num||'%'
295: and fft.treasury_symbol_id= fts.treasury_symbol_id
296: and fft.fct_int_record_type='BLK_DTL'

Line 447: /Purging old data from fv_facts_temp tables/

443: AND period_year = v_period_fiscal_year;
444:
445: retcode_facts:=0;
446:
447: /*Purging old data from fv_facts_temp tables*/
448: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Purging old data before triggers facts process for Treasury Symbol-> '||parm_treasury_value);
449: purge_facts_transactions;
450:
451:

Line 477: --Purging old data from fv_facts_temp table

473: -- Commenting out the code which checks if required edit checks passed
474: /* IF (FV_FACTS_TRANSACTIONS.v_g_edit_check_code = 2)THEN
475: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Purging old data as Required Edits failed for the Treasury Symbol...'|| parm_treasury_value||errbuf_facts);
476: retcode :=1;
477: --Purging old data from fv_facts_temp table
478: purge_facts_transactions;
479: --return; bug 9191060; if edits fail for one process, the other processes should continue
480: END IF;*/
481:

Line 3134: query_fetch_bal_bud := 'select sum(nvl(amount,0)),acct.bud_col,acct.nbfa_col from fv_facts_temp fac, fv_sbr_definitions_accts acct

3130:
3131:
3132: IF( c_sbr_balance_type = 'B' OR c_sbr_balance_type = 'E') THEN
3133: IF(( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='D') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='C'))THEN
3134: query_fetch_bal_bud := 'select sum(nvl(amount,0)),acct.bud_col,acct.nbfa_col from fv_facts_temp fac, fv_sbr_definitions_accts acct
3135: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3136: AND acct.sbr_line_id = :cv_sbr_line_id
3137: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3138: AND acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3146: query_fetch_bal_bud := 'select sum(nvl(amount,0)*(-1)),acct.bud_col,acct.nbfa_col from fv_facts_temp fac, fv_sbr_definitions_accts acct

3142: AND begin_end = '''||c_sbr_balance_type||'''';
3143:
3144:
3145: elsif (( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='C') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='D') ) THEN
3146: query_fetch_bal_bud := 'select sum(nvl(amount,0)*(-1)),acct.bud_col,acct.nbfa_col from fv_facts_temp fac, fv_sbr_definitions_accts acct
3147: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3148: AND acct.sbr_line_id = :cv_sbr_line_id
3149: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3150: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3205: from fv_facts_temp fac, fv_sbr_definitions_accts acct

3201:
3202: query_fetch_bal_bud := ' select
3203: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) ),
3204: acct.bud_col,acct.nbfa_col
3205: from fv_facts_temp fac, fv_sbr_definitions_accts acct
3206: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3207: AND acct.sbr_line_id = :cv_sbr_line_id
3208: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3209: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3255: from fv_facts_temp fac, fv_sbr_definitions_accts acct

3251: elsif (( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='C') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='D'))THEN
3252: /*FOR BUD_COL*/
3253: query_fetch_bal_bud := ' select
3254: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) )*(-1),acct.bud_col,acct.nbfa_col
3255: from fv_facts_temp fac, fv_sbr_definitions_accts acct
3256: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3257: AND acct.sbr_line_id = :cv_sbr_line_id
3258: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3259: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3304: from fv_facts_temp fac, fv_sbr_definitions_accts acct

3300:
3301: elsif (( c_sbr_balance_type= 'ED') OR( c_sbr_balance_type= 'EC')) THEN -- bal type is ending debit or ending credit only
3302: /*FOR BUD COL */
3303: query_fetch_bal_bud := 'select sum(nvl(amount,0)),acct.bud_col,acct.nbfa_col
3304: from fv_facts_temp fac, fv_sbr_definitions_accts acct
3305: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3306: AND acct.sbr_line_id = :cv_sbr_line_id
3307: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3308: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3372: from fv_facts_temp fac, fv_sbr_definitions_accts acct

3368: elsif( (c_sbr_balance_type= 'E-BD') OR (c_sbr_balance_type='E-BC')) THEN -- bal type is end begin debit only
3369: /*FOR BUD_COL*/
3370: query_fetch_bal_bud := ' select
3371: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) ),acct.bud_col,acct.nbfa_col
3372: from fv_facts_temp fac, fv_sbr_definitions_accts acct
3373: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3374: AND acct.sbr_line_id = :cv_sbr_line_id
3375: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3376: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3971: DELETE FROM fv_facts_temp

3967: l_module_name VARCHAR2(200);
3968: BEGIN
3969: l_module_name := g_module_name || 'purge_facts_transactions';
3970:
3971: DELETE FROM fv_facts_temp
3972: WHERE treasury_symbol_id = v_purge_ts_id;
3973:
3974: DELETE FROM fv_facts_edit_check_status
3975: WHERE treasury_symbol_id = v_purge_ts_id;

Line 3989: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'NO DATA FOUND IN FV_FACTS_TEMP / FV_FACTS_EDIT_CHECK_STATUS tables ');

3985:
3986: EXCEPTION
3987: -- Exception Processing
3988: When NO_DATA_FOUND Then
3989: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'NO DATA FOUND IN FV_FACTS_TEMP / FV_FACTS_EDIT_CHECK_STATUS tables ');
3990: When Others Then
3991: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.final_exception',SQLERRM);
3992: END purge_facts_transactions ;
3993: