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_NOYEAR dependencies on FV_SF133_DEFINITIONS_COLS_TEMP

Line 89: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

85: c_sf133_additional_info fv_sf133_definitions_accts
86: .sf133_additional_info%TYPE;
87:
88: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
89: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
90: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
91: --
92: -- ---------- Output Report Line Column Data -------------
93: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

Line 90: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

86: .sf133_additional_info%TYPE;
87:
88: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
89: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
90: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
91: --
92: -- ---------- Output Report Line Column Data -------------
93: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
94: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;

Line 93: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

89: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
90: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
91: --
92: -- ---------- Output Report Line Column Data -------------
93: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
94: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
95: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
96: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

Line 94: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;

90: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
91: --
92: -- ---------- Output Report Line Column Data -------------
93: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
94: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
95: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
96: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
98:

Line 95: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;

91: --
92: -- ---------- Output Report Line Column Data -------------
93: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
94: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
95: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
96: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
98:
99: -- New variable declared by pkpatel to fix Bug 1575992

Line 96: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

92: -- ---------- Output Report Line Column Data -------------
93: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
94: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
95: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
96: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
98:
99: -- New variable declared by pkpatel to fix Bug 1575992
100: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

Line 97: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

93: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
94: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
95: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
96: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
98:
99: -- New variable declared by pkpatel to fix Bug 1575992
100: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
101:

Line 542: FROM fv_sf133_definitions_cols_temp

538: END IF;
539: END IF;
540: --
541: DELETE
542: FROM fv_sf133_definitions_cols_temp
543: WHERE (sf133_line_id)
544: IN
545: (SELECT sf133_line_id
546: FROM fv_sf133_definitions_lines

Line 907: FROM fv_sf133_definitions_cols_temp

903: -- Get Treasury Symbol Accummulation for Total using column with true sign.
904: -- ----------------------------------------
905: SELECT NVL(SUM(NVL(sf133_amount_not_shown,0)),0)
906: INTO c_sf133_amount_not_shown
907: FROM fv_sf133_definitions_cols_temp
908: WHERE sf133_column_number = g_column_number
909: AND sf133_fund_value = c_sf133_ts_value
910: AND (sf133_line_id)
911: IN

Line 999: INTO fv_sf133_definitions_cols_temp

995: -- Insert into Line Column Table
996: -- ------------------------------------
997: -- pkpatel :Modify for 1575992
998: INSERT
999: INTO fv_sf133_definitions_cols_temp
1000: (sf133_fund_value,
1001: treasury_symbol_id,
1002: sf133_line_id,
1003: sf133_column_number,