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_SF133_DEFINITIONS_COLS_TEMP

Line 96: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

92: -- c_sf133_apportion_amt number;
93: c_sf133_additional_info fv_sf133_definitions_accts.sf133_additional_info%TYPE;
94:
95: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
96: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
98: --
99: -- ---------- Output Report Line Column Data -------------
100: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

Line 97: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

93: c_sf133_additional_info fv_sf133_definitions_accts.sf133_additional_info%TYPE;
94:
95: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
96: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
98: --
99: -- ---------- Output Report Line Column Data -------------
100: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
101: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;

Line 100: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

96: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
98: --
99: -- ---------- Output Report Line Column Data -------------
100: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
101: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
102: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
103: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
104: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

Line 101: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;

97: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
98: --
99: -- ---------- Output Report Line Column Data -------------
100: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
101: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
102: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
103: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
104: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
105:

Line 102: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;

98: --
99: -- ---------- Output Report Line Column Data -------------
100: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
101: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
102: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
103: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
104: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
105:
106: -- New variable declared by pkpatel to fix Bug 1575992

Line 103: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

99: -- ---------- Output Report Line Column Data -------------
100: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
101: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
102: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
103: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
104: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
105:
106: -- New variable declared by pkpatel to fix Bug 1575992
107: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

Line 104: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

100: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
101: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
102: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
103: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
104: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
105:
106: -- New variable declared by pkpatel to fix Bug 1575992
107: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
108: -- New Variables for using dynamic SQL

Line 584: FROM fv_sf133_definitions_cols_temp

580: END IF;
581: END IF;
582: --
583: DELETE
584: FROM fv_sf133_definitions_cols_temp
585: WHERE (sf133_line_id)
586: IN
587: (SELECT sf133_line_id
588: FROM fv_sf133_definitions_lines

Line 622: l_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

618: L_END_PERIOD_PREV NUMBER ; -- Ending period-previous year
619: L_LOOP_YEAR NUMBER;
620: l_federal_acct_symbol_id number(15);
621: -- l_treasury_symbol_id NUMBER(15);
622: l_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
623: -- ---------------------------------------------------------
624: BEGIN
625: l_module_name := g_module_name || 'build_report_lines';
626: --

Line 800: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP

796:
797: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LOOP COUNTER ' || TO_CHAR(L_YEAR_COUNTER) || ' AMOUNT VALUE ' || TO_CHAR(O_SF133_COLUMN_AMOUNT)) ;
799: END IF;
800: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP
801: SET
802: SF133_COLUMN_2_AMOUNT = DECODE(L_YEAR_COUNTER, 1,
803: O_SF133_COLUMN_AMOUNT, SF133_COLUMN_2_AMOUNT),
804: SF133_COLUMN_3_AMOUNT = DECODE(L_YEAR_COUNTER, 2,

Line 832: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP

828: L_LOOP_YEAR := L_LOOP_YEAR - 1;
829: End Loop ;
830:
831: -- Update the Current Row with the total.
832: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP
833: SET
834: SF133_AMT_TOTAL_NOT_SHOWN =
835: SF133_AMOUNT_NOT_SHOWN + SF133_AMT_2_NOT_SHOWN +
836: SF133_AMT_3_NOT_SHOWN + SF133_AMT_4_NOT_SHOWN +

Line 1183: FROM fv_sf133_definitions_cols_temp

1179: c_sf133_amt5_not_shown ,
1180: c_sf133_amt6_not_shown ,
1181: c_sf133_amt_total_not_shown
1182:
1183: FROM fv_sf133_definitions_cols_temp
1184: WHERE sf133_column_number = g_column_number
1185: AND sf133_fund_value = c_sf133_ts_value
1186: AND (sf133_line_id)
1187: IN

Line 1257: INTO fv_sf133_definitions_cols_temp

1253: -- ------------------------------------
1254: -- Insert the Values into Report
1255: -- ------------------------------------
1256: INSERT
1257: INTO fv_sf133_definitions_cols_temp
1258: ( sf133_fund_value,
1259: treasury_symbol_id,--Bug 1575992
1260: sf133_line_id,
1261: sf133_column_number,

Line 1336: INTO fv_sf133_definitions_cols_temp

1332: -- ------------------------------------
1333: -- Insert into Line Column Table
1334: -- ------------------------------------
1335: INSERT
1336: INTO fv_sf133_definitions_cols_temp
1337: (sf133_fund_value,
1338: treasury_symbol_id, --Bug 1575992
1339: sf133_line_id,
1340: sf133_column_number,