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 119: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

115: c_sf133_additional_info fv_sf133_definitions_accts
116: .sf133_additional_info%TYPE;
117:
118: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
119: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
120: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
121: --
122: -- ---------- Output Report Line Column Data -------------
123: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

Line 120: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

116: .sf133_additional_info%TYPE;
117:
118: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
119: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
120: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
121: --
122: -- ---------- Output Report Line Column Data -------------
123: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
124: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;

Line 123: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

119: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
120: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
121: --
122: -- ---------- Output Report Line Column Data -------------
123: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
124: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
125: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
126: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
127: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

Line 124: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;

120: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
121: --
122: -- ---------- Output Report Line Column Data -------------
123: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
124: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
125: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
126: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
127: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
128:

Line 125: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;

121: --
122: -- ---------- Output Report Line Column Data -------------
123: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
124: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
125: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
126: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
127: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
128:
129: -- New variable declared by pkpatel to fix Bug 1575992

Line 126: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

122: -- ---------- Output Report Line Column Data -------------
123: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
124: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
125: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
126: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
127: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
128:
129: -- New variable declared by pkpatel to fix Bug 1575992
130: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

Line 127: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

123: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
124: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
125: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;
126: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
127: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
128:
129: -- New variable declared by pkpatel to fix Bug 1575992
130: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
131:

Line 658: FROM fv_sf133_definitions_cols_temp

654: END IF;
655: END IF;
656: --
657: DELETE
658: FROM fv_sf133_definitions_cols_temp
659: WHERE (sf133_line_id)
660: IN
661: (SELECT sf133_line_id
662: FROM fv_sf133_definitions_lines

Line 1382: FROM fv_sf133_definitions_cols_temp

1378: -- Get Treasury Symbol Accummulation for Total using column with true sign.
1379: -- ----------------------------------------
1380: SELECT NVL(SUM(NVL(sf133_amount_not_shown,0)),0)
1381: INTO c_sf133_amount_not_shown
1382: FROM fv_sf133_definitions_cols_temp
1383: WHERE sf133_column_number = g_column_number
1384: AND sf133_fund_value = c_sf133_ts_value
1385: AND (sf133_line_id)
1386: IN

Line 1475: INTO fv_sf133_definitions_cols_temp

1471: -- Insert into Line Column Table
1472: -- ------------------------------------
1473: -- pkpatel :Modify for 1575992
1474: INSERT
1475: INTO fv_sf133_definitions_cols_temp
1476: (sf133_fund_value,
1477: treasury_symbol_id,
1478: sf133_line_id,
1479: sf133_column_number,

Line 1882: FROM fv_sf133_definitions_cols_temp

1878: ORDER BY calc_sequence_number;
1879:
1880: CURSOR fv_sf133_temp_cur (p_line_id NUMBER) IS
1881: SELECT sf133_column_amount
1882: FROM fv_sf133_definitions_cols_temp
1883: WHERE sf133_line_id = p_line_id and
1884: treasury_symbol_id = c_sf133_treasury_symbol_id;
1885:
1886: -- Bug 9191098

Line 1898: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;

1894: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
1895: WHERE sf133_line_id = p_lineid_2 );
1896:
1897: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1898: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
1899: temp_amt_high fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
1900:
1901:
1902: TYPE amt_rec IS RECORD (

Line 1899: temp_amt_high fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;

1895: WHERE sf133_line_id = p_lineid_2 );
1896:
1897: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1898: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
1899: temp_amt_high fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
1900:
1901:
1902: TYPE amt_rec IS RECORD (
1903: calc_sequence fv_sf133_rep_line_calc.calc_sequence_number%TYPE,

Line 1904: col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0);

1900:
1901:
1902: TYPE amt_rec IS RECORD (
1903: calc_sequence fv_sf133_rep_line_calc.calc_sequence_number%TYPE,
1904: col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0);
1905:
1906:
1907: TYPE amt_table IS TABLE OF amt_rec
1908: INDEX BY BINARY_INTEGER;

Line 1912: v_col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

1908: INDEX BY BINARY_INTEGER;
1909:
1910: amt_array amt_table;
1911: amt_array_cnt BINARY_INTEGER DEFAULT 1;
1912: v_col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
1913:
1914:
1915: BEGIN
1916: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'Inside process_total_line');