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_SF133_ONEYEAR dependencies on FV_TREASURY_SYMBOLS

Line 20: parm_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

16:
17: -- New Variable declared by Surya on 04/30/98 to receive the value of
18: -- the passed quarter number
19: parm_gl_period_name gl_period_statuses.period_name%TYPE;
20: parm_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
21:
22: -- ------------------------------------
23: -- All Pre-build Query Variables
24: -- ------------------------------------

Line 31: g_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

27: --
28: -- ------------------------------------
29: -- Stored Global Variables
30: -- ------------------------------------
31: g_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
32: g_federal_acct_symbol_id number(15);
33: g_insert_count NUMBER;
34: g_error_code NUMBER;
35: g_error_message VARCHAR2(400);

Line 55: c_resource_type fv_treasury_symbols.resource_type%TYPE;

51: c_end_period VARCHAR2(40);
52:
53: -- New variables declared by Narsimha to get the resource type from fv_treasury_sybols.
54:
55: c_resource_type fv_treasury_symbols.resource_type%TYPE;
56: c_rescission_flag varchar2(10);
57:
58: -- New variables declared by Narsimha Balakkari on 04/07/99 to capture
59: -- Established Year and Cancellation Year for given treasury symbol

Line 80: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

76: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
77: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
78:
79: -- New variable declared by pkpatel to fix Bug 1575992
80: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
81: --sf133 begin
82: c_acct_number fv_sf133_definitions_accts.acct_number%TYPE;
83: c_direct_or_reimb_code fv_sf133_definitions_accts.direct_or_reimb_code%TYPE;
84: c_apportionment_category_code fv_sf133_definitions_accts.apportionment_category_code%TYPE;

Line 169: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

165: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
166: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
167:
168: -- New variable declared by pkpatel to fix Bug 1575992
169: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
170: -- New Variables for using dynamic SQL
171: v_select VARCHAR2(30000);
172: v_cursor_id INTEGER;
173: v_cursor_id_ind INTEGER;

Line 193: FROM fv_treasury_symbols

189: --Added ts_range_cursor as part of Enh #2129123
190: /* Cursor to select treasury symbols which fall in specified range */
191: CURSOR ts_range_cursor(tsymbol_r1 VARCHAR2,tsymbol_r2 VARCHAR2) IS
192: SELECT treasury_symbol,treasury_symbol_id
193: FROM fv_treasury_symbols
194: WHERE treasury_symbol BETWEEN tsymbol_r1 AND tsymbol_r2
195: AND time_frame ='A' --CGAC
196: AND (fund_group_code NOT BETWEEN '3800' AND '3899')
197: AND (fund_group_code NOT BETWEEN '6001' AND '6999')

Line 221: -- FV_TREASURY_SYMBOLS

217: ORDER BY glflex.application_column_name;
218: --
219: -- ---------- Define Report Treasury Symbol Line Cursor -------------
220: -- MODIFIED BY SURYA ON 5/6/98 TO REPLACE FV_FUND_PARAMETERS WITH
221: -- FV_TREASURY_SYMBOLS
222:
223: -- Modified by Surya on 1/20/99 to add another join for SOB to fix
224: -- data duplication
225: --pkpatel :Changed to fix Bug 1575992

Line 238: FV_TREASURY_SYMBOLS FTS

234: line.sf133_natural_balance_type sf133_natural_balance_type,
235: line.sf133_fund_category sf133_line_category,
236: line.sf133_report_line_number sf133_report_line_number
237: FROM fv_sf133_definitions_lines line,
238: FV_TREASURY_SYMBOLS FTS
239: WHERE FTS.Treasury_symbol = parm_treasury_value_r1
240: AND FTS.set_of_books_id = parm_set_of_books_id
241: AND (line.sf133_line_type_code) IN ('T', 'D', 'D2')
242: AND line.set_of_books_id = FTS.set_of_books_id

Line 407: FROM fv_treasury_symbols

403: --populate_gtt_with_ccid (parm_treasury_symbol_id);
404:
405: SELECT established_fiscal_yr, substr(cancellation_date,8,4)
406: INTO g_established_year, g_cancellation_year
407: FROM fv_treasury_symbols
408: WHERE treasury_symbol = parm_treasury_value_r1
409: AND set_of_books_id = parm_set_of_books_id ;
410:
411: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 419: FROM fv_treasury_symbols

415: --Fetch the Federal Acct Symbol Id for the TS
416:
417: SELECT federal_acct_symbol_id
418: INTO g_federal_acct_symbol_id
419: FROM fv_treasury_symbols
420: WHERE set_of_books_id = parm_set_of_books_id
421: AND treasury_symbol_id = parm_treasury_symbol_id;
422: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'g_federal_acct_symbol_id.......'|| g_federal_acct_symbol_id);
423:

Line 445: from fv_treasury_symbols

441: --Fetch the Treasury symbol for previous year
442: begin
443: select treasury_symbol,treasury_symbol_id
444: into c_sf133_ts_value,g_treasury_symbol_id
445: from fv_treasury_symbols
446: WHERE set_of_books_id = parm_set_of_books_id
447: and federal_acct_symbol_id = g_federal_acct_symbol_id
448: and established_fiscal_yr = l_loop_year
449: and time_frame = 'A'; --CGAC

Line 920: from fv_treasury_symbols

916: -- added time frame condition - 1633861
917: begin
918: select treasury_symbol,treasury_symbol_id
919: into c_sf133_ts_value,g_treasury_symbol_id
920: from fv_treasury_symbols
921: WHERE set_of_books_id = parm_set_of_books_id
922: and federal_acct_symbol_id = g_federal_acct_symbol_id
923: and established_fiscal_yr = l_loop_year
924: and time_frame = 'A';--CGAC

Line 1056: financing_account_treas fv_treasury_symbols.financing_account%TYPE;

1052: query_fetch_bal VARCHAR2(8600);
1053: where_clause VARCHAR2(8600);
1054:
1055: --CGAC
1056: financing_account_treas fv_treasury_symbols.financing_account%TYPE;
1057: availability_type_treas fv_treasury_symbols.availability_type_code%TYPE;
1058: fund_type_treas fv_treasury_symbols.fund_type%TYPE;
1059:
1060: -- ----------------------------------------------

Line 1057: availability_type_treas fv_treasury_symbols.availability_type_code%TYPE;

1053: where_clause VARCHAR2(8600);
1054:
1055: --CGAC
1056: financing_account_treas fv_treasury_symbols.financing_account%TYPE;
1057: availability_type_treas fv_treasury_symbols.availability_type_code%TYPE;
1058: fund_type_treas fv_treasury_symbols.fund_type%TYPE;
1059:
1060: -- ----------------------------------------------
1061: BEGIN

Line 1058: fund_type_treas fv_treasury_symbols.fund_type%TYPE;

1054:
1055: --CGAC
1056: financing_account_treas fv_treasury_symbols.financing_account%TYPE;
1057: availability_type_treas fv_treasury_symbols.availability_type_code%TYPE;
1058: fund_type_treas fv_treasury_symbols.fund_type%TYPE;
1059:
1060: -- ----------------------------------------------
1061: BEGIN
1062: l_module_name := g_module_name || 'build_fiscal_line_columns';

Line 1123: from fv_treasury_symbols

1119: c_rescission_flag := 'FALSE';
1120: IF upper(c_sf133_additional_info) = 'RESCISSION' THEN
1121:
1122: select upper(resource_type) into c_resource_type
1123: from fv_treasury_symbols
1124: where treasury_symbol = parm_treasury_value_r1
1125: and set_of_books_id = parm_set_of_books_id;
1126:
1127: IF c_resource_type like '%APPROPRIATION%' THEN

Line 1170: FROM fv_treasury_symbols

1166:
1167: --CGAC
1168: SELECT availability_type_code, fund_type, expiration_Date
1169: INTO availability_type_treas, fund_type_treas, exp_date
1170: FROM fv_treasury_symbols
1171: WHERE treasury_symbol_id = c_sf133_treasury_symbol_id
1172: AND set_of_books_id = parm_set_of_books_id;
1173:
1174:

Line 1191: from fv_treasury_symbols where treasury_symbol_id=c_sf133_treasury_symbol_id;--g_treasury_symbol_id;

1187: end if;
1188:
1189: IF (exp_date is not null) then
1190: select extract ( year from expiration_date)into expiring_year
1191: from fv_treasury_symbols where treasury_symbol_id=c_sf133_treasury_symbol_id;--g_treasury_symbol_id;
1192: if (expiring_year is not null and expiring_year = parm_gl_period_year) then
1193: whether_Exp_SameYear := 'Y';
1194: elsif ( expiring_year > parm_gl_period_year) then
1195: whether_Exp_SameYear := 'N';

Line 1202: FROM fv_treasury_symbols

1198:
1199: --CGAC
1200: SELECT financing_account
1201: INTO financing_account_treas
1202: FROM fv_treasury_symbols
1203: WHERE treasury_symbol_id = c_sf133_treasury_symbol_id
1204: AND set_of_books_id = parm_set_of_books_id;
1205:
1206: query_fetch_bal:=null;