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

154: -- c_sf133_apportion_amt number;
155: c_sf133_additional_info fv_sf133_definitions_accts.sf133_additional_info%TYPE;
156:
157: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
158: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
159: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
160: --
161: -- ---------- Output Report Line Column Data -------------
162: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

Line 159: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

155: c_sf133_additional_info fv_sf133_definitions_accts.sf133_additional_info%TYPE;
156:
157: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
158: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
159: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
160: --
161: -- ---------- Output Report Line Column Data -------------
162: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
163: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;

Line 162: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

158: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
159: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
160: --
161: -- ---------- Output Report Line Column Data -------------
162: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
163: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
164: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%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;

Line 163: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;

159: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
160: --
161: -- ---------- Output Report Line Column Data -------------
162: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
163: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
164: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%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:

Line 164: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%TYPE;

160: --
161: -- ---------- Output Report Line Column Data -------------
162: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
163: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
164: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%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

Line 165: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

161: -- ---------- Output Report Line Column Data -------------
162: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
163: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
164: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%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;

Line 166: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

162: o_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
163: o_sf133_line_id fv_sf133_definitions_cols_temp.sf133_line_id%TYPE;
164: o_sf133_column_number fv_sf133_definitions_cols_temp.sf133_column_number%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

Line 755: FROM fv_sf133_definitions_cols_temp

751: END IF;
752: END IF;
753: --
754: DELETE
755: FROM fv_sf133_definitions_cols_temp
756: WHERE (sf133_line_id)
757: IN
758: (SELECT sf133_line_id
759: FROM fv_sf133_definitions_lines

Line 792: l_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;

788: -- L_BEG_PERIOD_PREV NUMBER ; -- Beginning Period-Previous Year
789: -- L_END_PERIOD_PREV NUMBER ; -- Ending period-previous year
790: -- L_LOOP_YEAR NUMBER;
791: -- l_federal_acct_symbol_id number(15);
792: l_sf133_ts_value fv_sf133_definitions_cols_temp.sf133_fund_value%TYPE;
793: l_line_cnt number;
794: -- ---------------------------------------------------------
795: BEGIN
796: l_module_name := g_module_name || 'build_report_lines';

Line 962: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP

958:
959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: 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)) ;
961: END IF;
962: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP
963: SET
964: SF133_COLUMN_2_AMOUNT = DECODE(L_YEAR_COUNTER, 1,
965: O_SF133_COLUMN_AMOUNT, SF133_COLUMN_2_AMOUNT),
966: SF133_COLUMN_3_AMOUNT = DECODE(L_YEAR_COUNTER, 2,

Line 995: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP

991:
992: End Loop ;
993:
994: -- Update the Current Row with the total.
995: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP
996: SET
997: SF133_AMT_TOTAL_NOT_SHOWN =
998: SF133_AMOUNT_NOT_SHOWN + SF133_AMT_2_NOT_SHOWN +
999: SF133_AMT_3_NOT_SHOWN + SF133_AMT_4_NOT_SHOWN +

Line 1668: FROM fv_sf133_definitions_cols_temp

1664: c_sf133_amt5_not_shown ,
1665: c_sf133_amt6_not_shown ,
1666: c_sf133_amt_total_not_shown
1667:
1668: FROM fv_sf133_definitions_cols_temp
1669: WHERE sf133_column_number = g_column_number
1670: AND sf133_fund_value = c_sf133_ts_value
1671: AND (sf133_line_id)
1672: IN

Line 1742: INTO fv_sf133_definitions_cols_temp

1738: -- ------------------------------------
1739: -- Insert the Values into Report
1740: -- ------------------------------------
1741: INSERT
1742: INTO fv_sf133_definitions_cols_temp
1743: ( sf133_fund_value,
1744: treasury_symbol_id,--Bug 1575992
1745: sf133_line_id,
1746: sf133_column_number,

Line 1822: INTO fv_sf133_definitions_cols_temp

1818: -- ------------------------------------
1819: -- Insert into Line Column Table
1820: -- ------------------------------------
1821: INSERT
1822: INTO fv_sf133_definitions_cols_temp
1823: (sf133_fund_value,
1824: treasury_symbol_id, --Bug 1575992
1825: sf133_line_id,
1826: sf133_column_number,

Line 2268: FROM fv_sf133_definitions_cols_temp

2264:
2265: CURSOR fv_sf133_temp_cur (p_line_id NUMBER) IS
2266: SELECT sf133_column_amount, sf133_column_2_amount, sf133_column_3_amount, sf133_column_4_amount, sf133_column_5_amount,
2267: sf133_column_6_amount
2268: FROM fv_sf133_definitions_cols_temp
2269: WHERE sf133_line_id = p_line_id and
2270: treasury_symbol_id = c_sf133_treasury_symbol_id;
2271:
2272: -- Bug 9183877

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

2280: (SELECT sf133_line_number FROM fv_sf133_definitions_lines
2281: WHERE sf133_line_id = p_lineid_2 );
2282:
2283: l_line_id fv_cfs_rep_lines.line_id%TYPE;
2284: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2285: temp_amt_high fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2286: temp_amt_low_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2287: temp_amt_high_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;

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

2281: WHERE sf133_line_id = p_lineid_2 );
2282:
2283: l_line_id fv_cfs_rep_lines.line_id%TYPE;
2284: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2285: temp_amt_high fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2286: temp_amt_low_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2287: temp_amt_high_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;

Line 2286: temp_amt_low_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;

2282:
2283: l_line_id fv_cfs_rep_lines.line_id%TYPE;
2284: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2285: temp_amt_high fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2286: temp_amt_low_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2287: temp_amt_high_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;

Line 2287: temp_amt_high_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;

2283: l_line_id fv_cfs_rep_lines.line_id%TYPE;
2284: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2285: temp_amt_high fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2286: temp_amt_low_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2287: temp_amt_high_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;

Line 2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;

2284: temp_amt_low fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2285: temp_amt_high fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2286: temp_amt_low_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2287: temp_amt_high_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2292: temp_amt_low_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;

Line 2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;

2285: temp_amt_high fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0;
2286: temp_amt_low_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2287: temp_amt_high_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2292: temp_amt_low_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2293: temp_amt_high_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;

Line 2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;

2286: temp_amt_low_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2287: temp_amt_high_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2292: temp_amt_low_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2293: temp_amt_high_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2294: temp_amt_low_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;

Line 2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;

2287: temp_amt_high_2 fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0;
2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2292: temp_amt_low_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2293: temp_amt_high_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2294: temp_amt_low_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;
2295: temp_amt_high_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;

Line 2292: temp_amt_low_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;

2288: temp_amt_low_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2292: temp_amt_low_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2293: temp_amt_high_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2294: temp_amt_low_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;
2295: temp_amt_high_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;
2296: /*

Line 2293: temp_amt_high_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;

2289: temp_amt_high_3 fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0;
2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2292: temp_amt_low_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2293: temp_amt_high_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2294: temp_amt_low_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;
2295: temp_amt_high_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;
2296: /*
2297: c_sf133_amt2_not_shown Number ;

Line 2294: temp_amt_low_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;

2290: temp_amt_low_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2292: temp_amt_low_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2293: temp_amt_high_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2294: temp_amt_low_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;
2295: temp_amt_high_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;
2296: /*
2297: c_sf133_amt2_not_shown Number ;
2298: c_sf133_amt3_not_shown Number ;

Line 2295: temp_amt_high_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;

2291: temp_amt_high_4 fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0;
2292: temp_amt_low_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2293: temp_amt_high_5 fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0;
2294: temp_amt_low_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;
2295: temp_amt_high_6 fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0;
2296: /*
2297: c_sf133_amt2_not_shown Number ;
2298: c_sf133_amt3_not_shown Number ;
2299: c_sf133_amt4_not_shown Number ;

Line 2311: col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0,

2307: c_sf133_column_amount6 Number ;
2308: */
2309: TYPE amt_rec IS RECORD (
2310: calc_sequence fv_sf133_rep_line_calc.calc_sequence_number%TYPE,
2311: col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0,
2312: col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0,
2313: col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0,
2314: col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0,
2315: col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0,

Line 2312: col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0,

2308: */
2309: TYPE amt_rec IS RECORD (
2310: calc_sequence fv_sf133_rep_line_calc.calc_sequence_number%TYPE,
2311: col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0,
2312: col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0,
2313: col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0,
2314: col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0,
2315: col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0,
2316: col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0);

Line 2313: col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0,

2309: TYPE amt_rec IS RECORD (
2310: calc_sequence fv_sf133_rep_line_calc.calc_sequence_number%TYPE,
2311: col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0,
2312: col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0,
2313: col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0,
2314: col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0,
2315: col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0,
2316: col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0);
2317:

Line 2314: col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0,

2310: calc_sequence fv_sf133_rep_line_calc.calc_sequence_number%TYPE,
2311: col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0,
2312: col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0,
2313: col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0,
2314: col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0,
2315: col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0,
2316: col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0);
2317:
2318: TYPE amt_table IS TABLE OF amt_rec

Line 2315: col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0,

2311: col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE DEFAULT 0,
2312: col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0,
2313: col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0,
2314: col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0,
2315: col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0,
2316: col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0);
2317:
2318: TYPE amt_table IS TABLE OF amt_rec
2319: INDEX BY BINARY_INTEGER;

Line 2316: col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0);

2312: col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE DEFAULT 0,
2313: col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE DEFAULT 0,
2314: col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE DEFAULT 0,
2315: col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE DEFAULT 0,
2316: col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE DEFAULT 0);
2317:
2318: TYPE amt_table IS TABLE OF amt_rec
2319: INDEX BY BINARY_INTEGER;
2320:

Line 2323: v_col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

2319: INDEX BY BINARY_INTEGER;
2320:
2321: amt_array amt_table;
2322: amt_array_cnt BINARY_INTEGER DEFAULT 1;
2323: v_col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
2324: v_col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE;
2325: v_col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE;
2326: v_col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE;
2327: v_col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE;

Line 2324: v_col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE;

2320:
2321: amt_array amt_table;
2322: amt_array_cnt BINARY_INTEGER DEFAULT 1;
2323: v_col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
2324: v_col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE;
2325: v_col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE;
2326: v_col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE;
2327: v_col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE;
2328: v_col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE;

Line 2325: v_col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE;

2321: amt_array amt_table;
2322: amt_array_cnt BINARY_INTEGER DEFAULT 1;
2323: v_col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
2324: v_col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE;
2325: v_col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE;
2326: v_col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE;
2327: v_col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE;
2328: v_col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE;
2329:

Line 2326: v_col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE;

2322: amt_array_cnt BINARY_INTEGER DEFAULT 1;
2323: v_col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
2324: v_col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE;
2325: v_col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE;
2326: v_col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE;
2327: v_col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE;
2328: v_col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE;
2329:
2330:

Line 2327: v_col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE;

2323: v_col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
2324: v_col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE;
2325: v_col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE;
2326: v_col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE;
2327: v_col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE;
2328: v_col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE;
2329:
2330:
2331: BEGIN

Line 2328: v_col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE;

2324: v_col_2_amt fv_sf133_definitions_cols_temp.sf133_column_2_amount%TYPE;
2325: v_col_3_amt fv_sf133_definitions_cols_temp.sf133_column_3_amount%TYPE;
2326: v_col_4_amt fv_sf133_definitions_cols_temp.sf133_column_4_amount%TYPE;
2327: v_col_5_amt fv_sf133_definitions_cols_temp.sf133_column_5_amount%TYPE;
2328: v_col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE;
2329:
2330:
2331: BEGIN
2332: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'Inside process_total_line');

Line 2459: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP

2455:
2456: populate_temp_table;
2457:
2458: -- Bug 9183877
2459: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP
2460: SET
2461: SF133_AMT_TOTAL_NOT_SHOWN =
2462: o_sf133_amt_not_shown + c_sf133_amt2_not_shown +
2463: c_sf133_amt3_not_shown + c_sf133_amt4_not_shown +