DBA Data[Home] [Help]

APPS.FV_CFS_PKG dependencies on FV_CFS_REP_LINE_CALC

Line 1180: FROM fv_cfs_rep_line_calc

1176: END IF;
1177: ELSIF lines_rec.line_type IN ('S', 'T') THEN
1178: SELECT COUNT( *)
1179: INTO l_line_cnt
1180: FROM fv_cfs_rep_line_calc
1181: WHERE line_id = v_line_id;
1182: IF l_line_cnt = 0 THEN
1183: v_retcode := -1;
1184: v_errbuf := 'SEED Data not properly Loaded. Please Verify and reinvoke the Process.';

Line 1876: FROM fv_cfs_rep_line_calc

1872: unexp_approp ,
1873: budget_col ,
1874: nbfa_col ,
1875: scnp_elim
1876: FROM fv_cfs_rep_line_calc
1877: WHERE line_id = v_line_id
1878: ORDER BY calc_sequence_number;
1879: CURSOR fv_cfs_temp_cur (p_line_id NUMBER)
1880: IS

Line 1925: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,

1921: TYPE amt_rec
1922: IS
1923: RECORD
1924: (
1925: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,
1926: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1927: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1928: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1929: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

Line 1934: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,

1930: col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1931: col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1932: col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1933: col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1934: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
1935: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
1936: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
1937: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE ,
1938: scnp_elim fv_cfs_rep_line_calc.scnp_elim%TYPE);

Line 1935: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,

1931: col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1932: col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1933: col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1934: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
1935: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
1936: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
1937: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE ,
1938: scnp_elim fv_cfs_rep_line_calc.scnp_elim%TYPE);
1939: TYPE amt_table

Line 1936: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,

1932: col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1933: col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1934: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
1935: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
1936: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
1937: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE ,
1938: scnp_elim fv_cfs_rep_line_calc.scnp_elim%TYPE);
1939: TYPE amt_table
1940: IS

Line 1937: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE ,

1933: col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1934: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
1935: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
1936: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
1937: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE ,
1938: scnp_elim fv_cfs_rep_line_calc.scnp_elim%TYPE);
1939: TYPE amt_table
1940: IS
1941: TABLE OF amt_rec INDEX BY BINARY_INTEGER;

Line 1938: scnp_elim fv_cfs_rep_line_calc.scnp_elim%TYPE);

1934: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
1935: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
1936: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
1937: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE ,
1938: scnp_elim fv_cfs_rep_line_calc.scnp_elim%TYPE);
1939: TYPE amt_table
1940: IS
1941: TABLE OF amt_rec INDEX BY BINARY_INTEGER;
1942: amt_array amt_table;

Line 2198: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,

2194: TYPE amt_rec
2195: IS
2196: RECORD
2197: (
2198: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,
2199: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2200: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2201: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2202: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

Line 2203: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,

2199: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2200: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2201: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2202: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2203: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
2204: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
2205: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
2206: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE );
2207: TYPE amt_table

Line 2204: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,

2200: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2201: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2202: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2203: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
2204: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
2205: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
2206: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE );
2207: TYPE amt_table
2208: IS

Line 2205: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,

2201: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2202: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2203: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
2204: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
2205: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
2206: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE );
2207: TYPE amt_table
2208: IS
2209: TABLE OF amt_rec INDEX BY BINARY_INTEGER;

Line 2206: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE );

2202: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
2203: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
2204: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
2205: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
2206: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE );
2207: TYPE amt_table
2208: IS
2209: TABLE OF amt_rec INDEX BY BINARY_INTEGER;
2210: amt_array amt_table;