[Home] [Help]
2873: l_ignore INTEGER;
2874: query_fetch_bal_bud VARCHAR2(8600);
2875: query_fetch_bal_nbfa VARCHAR2(8600);
2876: where_clause VARCHAR2(8600);
2877: financing_account_treas FV_FACTS_FEDERAL_ACCOUNTS.financing_account%TYPE;
2878: availability_type_treas fv_sbr_definitions_accts.availability_type%TYPE;
2879: fund_type_treas fv_treasury_symbols.fund_group_code%TYPE;
2880: group_by_clause VARCHAR2(50):= 'group by bud_col,nbfa_col';
2881:
3049: END IF;
3050:
3051: SELECT fed.financing_account
3052: INTO financing_account_treas
3053: FROM FV_FACTS_FEDERAL_ACCOUNTS fed,
3054: fv_treasury_symbols treas
3055: WHERE fed.federal_acct_symbol_id = treas.federal_acct_symbol_id
3056: AND treas.treasury_symbol_id =get_ts_id_rec.treasury_symbol_id
3057: AND treas.set_of_books_id = v_sob;
3062: g_error_message := SQLERRM;
3063: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, '.exception','For Treasury symbol '||get_ts_id_rec.treasury_symbol_id||' '||G_ERROR_MESSAGE);
3064:
3065: END;
3066: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After FV_FACTS_FEDERAL_ACCOUNTS');
3067: query_fetch_bal_bud :=NULL;
3068: query_fetch_bal_nbfa :=NULL;
3069: where_clause := ' ';
3070:
3125: IF (c_financing_account_code IS NOT NULL ) THEN
3126: where_clause := where_clause||' '||'and trim(financing_account_code) = '''||financing_account_treas||''' ';
3127: END IF;
3128:
3129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After FV_FACTS_FEDERAL_ACCOUNTS');
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