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_TREASURY_SYMBOLS

Line 46: v_purge_ts_id fv_treasury_symbols.TREASURY_SYMBOL_ID%TYPE;

42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
43: v_line_number fv_cfs_rep_lines.line_number%TYPE;
44: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
45: v_period_num gl_period_statuses.period_num%TYPE;
46: v_purge_ts_id fv_treasury_symbols.TREASURY_SYMBOL_ID%TYPE;
47: v_select1 VARCHAR2(32000);
48: v_select2 VARCHAR2(32000);
49: v_select3 VARCHAR2(32000);
50: v_select4 VARCHAR2(32000);

Line 132: c_resource_type fv_treasury_symbols.resource_type%TYPE;

128: c_end_select VARCHAR2(200);
129: c_begin_period VARCHAR2(40);
130: c_end_period VARCHAR2(40);
131: -- New Variables declared by Narsimha Balakkari.
132: c_resource_type fv_treasury_symbols.resource_type%TYPE;
133: c_rescission_flag VARCHAR2(10);
134: -- ---------- Flex Segment Name Cursor Variables ---------
135: c_segment_name fnd_id_flex_segments.segment_name%TYPE;
136: c_flex_column_name fnd_id_flex_segments.application_column_name%TYPE;

Line 149: c_sbr_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

145: c_sbr_line_type_code fv_sbr_definitions_lines.sbr_line_type_code%TYPE;
146: c_sbr_natural_bal_type fv_sbr_definitions_lines.sbr_natural_balance_type%TYPE;
147: c_sbr_line_category fv_sbr_definitions_lines.sbr_fund_category%TYPE;
148: -- New variable declared by pkpatel to fix Bug 1575992
149: c_sbr_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
150: --
151: -- New variable declared by Narsimha.
152: c_sbr_report_line_number fv_sbr_definitions_lines.sbr_report_line_number%TYPE;
153: c_sbr_gl_balance fv_sbr_definitions_lines.SBR_GL_BALANCE%TYPE;

Line 282: FROM fv_treasury_symbols

278: CURSOR ts_cursor(p_sob NUMBER)
279: IS
280: SELECT treasury_symbol,
281: treasury_symbol_id
282: FROM fv_treasury_symbols
283: WHERE TIME_FRAME IN ('A','M', 'X')
284: AND (FUND_GROUP_CODE NOT BETWEEN '3800' AND '3899')
285: AND (FUND_GROUP_CODE NOT BETWEEN '6001' AND '6999')
286: -- AND treasury_symbol IN ('33-X-3333','11-08-0110','11-04-0100','03-X-0366','03-06-0333')

Line 293: fv_treasury_symbols fts

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'
297: and fts.set_of_books_id=v_sob;

Line 2879: fund_type_treas fv_treasury_symbols.fund_group_code%TYPE;

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:
2882:
2883: BEGIN

Line 2970: FROM fv_treasury_symbols

2966: c_rescission_flag := 'FALSE';
2967: IF upper(c_sbr_additional_info) = 'RESCISSION' THEN
2968: SELECT upper(resource_type)
2969: INTO c_resource_type
2970: FROM fv_treasury_symbols
2971: WHERE treasury_symbol_id = get_ts_id_rec.treasury_symbol_id
2972: AND set_of_books_id = v_sob;
2973: IF c_resource_type LIKE '%APPROPRIATION%' THEN
2974: IF ltrim(rtrim(c_sbr_report_line_number)) = '1A' THEN

Line 3003: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'before fv_treasury_symbols');

2999:
3000: /*Avialability type and Treasury symbol */
3001: BEGIN
3002:
3003: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'before fv_treasury_symbols');
3004:
3005: -- Bug 13355766. Modified query to use the new values for Authority Type Code
3006: -- (TIME_FRAME)
3007: --SELECT DECODE(time_frame,'NO_YEAR','X',NULL) ,

Line 3014: FROM fv_treasury_symbols fts,

3010: expiration_Date
3011: INTO availability_type_treas,
3012: fund_type_treas ,
3013: exp_date
3014: FROM fv_treasury_symbols fts,
3015: fv_fund_groups ffg
3016: WHERE fts.treasury_symbol_id=get_ts_id_rec.treasury_symbol_id
3017: AND fts.set_of_books_id = v_sob
3018: AND fts.set_of_books_id = ffg.set_of_books_id

Line 3021: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After fv_treasury_symbols/fv_fund_groups');

3017: AND fts.set_of_books_id = v_sob
3018: AND fts.set_of_books_id = ffg.set_of_books_id
3019: AND ffg.fund_group_code = fts.fund_group_code;
3020:
3021: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After fv_treasury_symbols/fv_fund_groups');
3022: -- Extract expiration date of treasury symbol and determine if the TS expired
3023: -- or will it expire in the year for which the process is run
3024: IF(exp_date < close_date ) THEN
3025: whether_Exp := 'E';

Line 3038: FROM fv_treasury_symbols

3034:
3035: IF (exp_date IS NOT NULL) THEN
3036: SELECT extract ( YEAR FROM expiration_date)
3037: INTO expiring_year
3038: FROM fv_treasury_symbols
3039: WHERE treasury_symbol_id=get_ts_id_rec.treasury_symbol_id
3040: AND set_of_books_id=v_sob;
3041:
3042: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After expiring_year');

Line 3054: fv_treasury_symbols treas

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;
3058:

Line 3140: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols

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
3139: AND fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''
3140: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols
3141: where set_of_books_id='||v_sob||' AND treasury_symbol_id='||get_ts_id_rec.treasury_symbol_id||')
3142: AND begin_end = '''||c_sbr_balance_type||'''';
3143:
3144:

Line 3152: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols

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
3151: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''
3152: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols
3153: where set_of_books_id='||v_sob||' AND treasury_symbol_id='||get_ts_id_rec.treasury_symbol_id||')
3154: AND begin_end = '''||c_sbr_balance_type||'''';
3155:
3156:

Line 3210: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols

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
3210: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols
3211: where set_of_books_id='||v_sob||' AND treasury_symbol_id='||get_ts_id_rec.treasury_symbol_id||')
3212: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''';
3213:
3214: v_cursor_id := dbms_sql.open_cursor;

Line 3260: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols

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
3260: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols
3261: where set_of_books_id='||v_sob||' AND treasury_symbol_id='||get_ts_id_rec.treasury_symbol_id||')
3262: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''';
3263:
3264: v_cursor_id := dbms_sql.open_cursor;

Line 3309: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols

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
3309: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols
3310: where set_of_books_id='||v_sob||' AND treasury_symbol_id='||get_ts_id_rec.treasury_symbol_id||')
3311: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''
3312: AND begin_end = ''E''';
3313:

Line 3377: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols

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
3377: AND fac.treasury_symbol_id = (select treasury_symbol_id from fv_treasury_symbols
3378: where set_of_books_id='||v_sob||' AND treasury_symbol_id='||get_ts_id_rec.treasury_symbol_id||')
3379: and fac.fct_int_record_category = ''REPORTED_NEW'' and fac.fct_int_record_tYPE = ''BLK_DTL''';
3380:
3381: v_cursor_id := dbms_sql.open_cursor;