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_CFS_PKG dependencies on FV_CFS_REP_TEMP

Line 28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;

24: v_line_type fv_cfs_rep_lines.line_type%TYPE;
25: v_line_label fv_cfs_rep_lines.line_label%TYPE;
26: v_by_recipient fv_cfs_rep_lines.by_recipient%TYPE;
27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;
28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;
29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;

Line 29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;

25: v_line_label fv_cfs_rep_lines.line_label%TYPE;
26: v_by_recipient fv_cfs_rep_lines.by_recipient%TYPE;
27: v_natural_balance_type fv_cfs_rep_lines.natural_balance_type%TYPE;
28: v_amount fv_cfs_rep_temp.col_1_amt%TYPE;
29: v_exception_amount fv_cfs_rep_temp.col_1_amt%TYPE;
30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;

Line 34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;

30: v_recipient_name fv_facts_report_t2.recipient_name%TYPE;
31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;

31: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;
39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;

32: v_account gl_code_combinations.segment1%TYPE;
33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;
39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;
40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;

33: v_fund gl_code_combinations.segment1%TYPE;
34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;
39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;
40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;
41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;

Line 38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;

34: v_col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE;
35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;
39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;
40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;
41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;
42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;

Line 39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;

35: v_col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE;
36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;
39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;
40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;
41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;
42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
43: v_line_number fv_cfs_rep_lines.line_number%TYPE;

Line 40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;

36: v_col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE;
37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;
39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;
40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;
41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;
42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
43: v_line_number fv_cfs_rep_lines.line_number%TYPE;
44: v_period_fiscal_year gl_period_statuses.period_year%TYPE;

Line 41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;

37: v_col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE;
38: v_col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE;
39: v_col_6_amt fv_cfs_rep_temp.col_1_amt%TYPE;
40: v_col_7_amt fv_cfs_rep_temp.col_1_amt%TYPE;
41: v_col_8_amt fv_cfs_rep_temp.col_1_amt%TYPE;
42: v_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
43: v_line_number fv_cfs_rep_lines.line_number%TYPE;
44: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
45: v_period_num gl_period_statuses.period_num%TYPE;

Line 394: /Sequence for fv_cfs_rep_temp table /

390: FROM gl_period_statuses
391: WHERE ledger_id = v_sob
392: AND application_id = parm_application_id
393: AND period_name = v_period_name;
394: /*Sequence for fv_cfs_rep_temp table */
395: SELECT fv_cfs_rep_temp_s.NEXTVAL
396: INTO v_sequence_id
397: FROM DUAL;
398:

Line 395: SELECT fv_cfs_rep_temp_s.NEXTVAL

391: WHERE ledger_id = v_sob
392: AND application_id = parm_application_id
393: AND period_name = v_period_name;
394: /*Sequence for fv_cfs_rep_temp table */
395: SELECT fv_cfs_rep_temp_s.NEXTVAL
396: INTO v_sequence_id
397: FROM DUAL;
398:
399: get_qualifier_segments;

Line 1424: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,

1420: IS
1421: RECORD
1422: (
1423: recipient_name fv_facts_report_t2.recipient_name%TYPE,
1424: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1425: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1426: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1427: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0);
1428: TYPE l_recipient_table

Line 1425: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,

1421: RECORD
1422: (
1423: recipient_name fv_facts_report_t2.recipient_name%TYPE,
1424: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1425: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1426: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1427: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0);
1428: TYPE l_recipient_table
1429: IS

Line 1426: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,

1422: (
1423: recipient_name fv_facts_report_t2.recipient_name%TYPE,
1424: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1425: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1426: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1427: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0);
1428: TYPE l_recipient_table
1429: IS
1430: TABLE OF l_recipient_rec_type INDEX BY BINARY_INTEGER;

Line 1427: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0);

1423: recipient_name fv_facts_report_t2.recipient_name%TYPE,
1424: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1425: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1426: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
1427: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0);
1428: TYPE l_recipient_table
1429: IS
1430: TABLE OF l_recipient_rec_type INDEX BY BINARY_INTEGER;
1431: l_recipient_rec l_recipient_table;

Line 1436: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;

1432: l_recipient_cnt BINARY_INTEGER := 1;
1433: l_found BOOLEAN;
1434: l_temp_str fv_cfs_rep_lines.line_label%TYPE;
1435: l_ignore INTEGER;
1436: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
1437: l_begin_balance NUMBER;
1438: l_end_balance NUMBER;
1439: l_period_name_1 gl_period_statuses.period_name%TYPE;
1440: l_period_name_2 gl_period_statuses.period_name%TYPE;

Line 1889: FROM fv_cfs_rep_temp

1885: col_5_amt ,
1886: col_6_amt ,
1887: col_7_amt ,
1888: col_8_amt
1889: FROM fv_cfs_rep_temp
1890: WHERE line_id = p_line_id
1891: AND sequence_id = v_sequence_id;
1892: CURSOR fv_cfs_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER)
1893: IS

Line 1905: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1901: )
1902: AND report_type = v_report_type;
1903:
1904: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1905: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1906: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1907: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1906: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1902: AND report_type = v_report_type;
1903:
1904: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1905: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1906: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1907: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1907: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1903:
1904: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1905: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1906: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1907: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1904: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1905: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1906: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1907: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1905: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1906: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1907: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1906: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1907: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1907: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1908: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1909: temp_amt_low5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1917: temp_amt_high5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1910: temp_amt_low6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1917: temp_amt_high5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1918: temp_amt_high6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1911: temp_amt_low7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1917: temp_amt_high5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1918: temp_amt_high6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1919: temp_amt_high7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1912: temp_amt_low8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1917: temp_amt_high5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1918: temp_amt_high6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1919: temp_amt_high7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1920: temp_amt_high8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 1917: temp_amt_high5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1913: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1917: temp_amt_high5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1918: temp_amt_high6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1919: temp_amt_high7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1920: temp_amt_high8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1921: TYPE amt_rec

Line 1918: temp_amt_high6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1914: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1917: temp_amt_high5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1918: temp_amt_high6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1919: temp_amt_high7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1920: temp_amt_high8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1921: TYPE amt_rec
1922: IS

Line 1919: temp_amt_high7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1915: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1917: temp_amt_high5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1918: temp_amt_high6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1919: temp_amt_high7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1920: temp_amt_high8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1921: TYPE amt_rec
1922: IS
1923: RECORD

Line 1920: temp_amt_high8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

1916: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1917: temp_amt_high5 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1918: temp_amt_high6 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1919: temp_amt_high7 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1920: temp_amt_high8 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1921: TYPE amt_rec
1922: IS
1923: RECORD
1924: (

Line 1926: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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,
1930: col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

Line 1927: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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,
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,

Line 1928: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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,
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,

Line 1929: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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,
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,

Line 1930: col_5_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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,
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 ,

Line 1931: col_6_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,
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 ,

Line 1932: col_7_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,
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 ,

Line 1933: col_8_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,
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 ,

Line 2166: FROM fv_cfs_rep_temp

2162: SELECT col_1_amt,
2163: col_2_amt ,
2164: col_3_amt ,
2165: col_4_amt
2166: FROM fv_cfs_rep_temp
2167: WHERE line_id = p_line_id
2168: AND sequence_id = v_sequence_id;
2169: -- Bug 9191098
2170: CURSOR fv_sbr_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER)

Line 2186: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

2182: WHERE sbr_line_id = p_lineid_2
2183: );
2184:
2185: l_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
2186: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2187: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2188: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2190: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 2187: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

2183: );
2184:
2185: l_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
2186: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2187: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2188: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2190: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2191: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 2188: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

2184:
2185: l_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
2186: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2187: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2188: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2190: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2191: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2192: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

2185: l_line_id fv_sbr_definitions_lines.sbr_line_id%TYPE;
2186: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2187: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2188: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2190: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2191: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2192: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2193: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

Line 2190: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

2186: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2187: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2188: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2190: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2191: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2192: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2193: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2194: TYPE amt_rec

Line 2191: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

2187: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2188: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2190: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2191: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2192: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2193: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2194: TYPE amt_rec
2195: IS

Line 2192: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

2188: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2190: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2191: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2192: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2193: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2194: TYPE amt_rec
2195: IS
2196: RECORD

Line 2193: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

2189: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2190: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2191: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2192: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2193: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
2194: TYPE amt_rec
2195: IS
2196: RECORD
2197: (

Line 2199: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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,
2203: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,

Line 2200: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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,
2203: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
2204: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,

Line 2201: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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,
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 ,

Line 2202: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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,
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 );

Line 2336: INTO fv_cfs_rep_temp

2332: IF (v_report_type = 'SF' AND v_balance_type IN ('I', 'J')) THEN
2333: IF gbl_units <> 'Dollars and Cents' THEN
2334: IF istotal_cal=0 THEN
2335: INSERT
2336: INTO fv_cfs_rep_temp
2337: (
2338: sequence_id,
2339: line_id ,
2340: line_label ,

Line 2366: INTO fv_cfs_rep_temp

2362: v_sob
2363: );
2364: ELSE
2365: INSERT
2366: INTO fv_cfs_rep_temp
2367: (
2368: sequence_id,
2369: line_id ,
2370: line_label ,

Line 2397: INTO fv_cfs_rep_temp

2393: );
2394: END IF;
2395: ELSE
2396: INSERT
2397: INTO fv_cfs_rep_temp
2398: (
2399: sequence_id,
2400: line_id ,
2401: line_label ,

Line 2430: INTO fv_cfs_rep_temp

2426: ELSE
2427: IF gbl_units <> 'Dollars and Cents' THEN
2428: IF istotal_cal=0 THEN
2429: INSERT
2430: INTO fv_cfs_rep_temp
2431: (
2432: sequence_id,
2433: line_id ,
2434: line_label ,

Line 2468: INTO fv_cfs_rep_temp

2464: v_sob
2465: );
2466: ELSE
2467: INSERT
2468: INTO fv_cfs_rep_temp
2469: (
2470: sequence_id,
2471: line_id ,
2472: line_label ,

Line 2513: INTO fv_cfs_rep_temp

2509: )
2510: ;
2511: ELSE
2512: INSERT
2513: INTO fv_cfs_rep_temp
2514: (
2515: sequence_id,
2516: line_id ,
2517: line_label ,

Line 2560: UPDATE fv_cfs_rep_temp SET col_4_amt = NVL(col_1_amt,0) + NVL(col_2_amt,0) - NVL(col_3_amt,0),

2556: END IF;
2557: END IF;
2558:
2559: IF v_report_type = 'SCNP' THEN
2560: UPDATE fv_cfs_rep_temp SET col_4_amt = NVL(col_1_amt,0) + NVL(col_2_amt,0) - NVL(col_3_amt,0),
2561: col_8_amt = NVL(col_5_amt,0) + NVL(col_6_amt,0) - NVL(col_7_amt,0)
2562: WHERE sequence_id = v_sequence_id AND line_id = v_line_id;
2563:
2564: fnd_file.put_line

Line 2753: INTO fv_cfs_rep_temp

2749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before cursor.....sbr_report_line_cursor');
2750: END IF;
2751: /*INSERTING ALL LABELS TO Report table*/
2752: INSERT
2753: INTO fv_cfs_rep_temp
2754: (
2755: SEQUENCE_ID,
2756: LINE_ID ,
2757: LINE_LABEL,

Line 2818: FROM fv_cfs_rep_temp

2814: v_col_4_amt:=0;
2815: BEGIN
2816: SELECT col_1_amt, col_2_amt
2817: INTO v_col_3_amt,v_col_4_amt
2818: FROM fv_cfs_rep_temp
2819: WHERE line_id=v_line_id
2820: AND ledger_id=v_sob
2821: AND reporty_type='SBR'
2822: AND period_num=v_period_num

Line 2826: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES:Either fv_cfs_rep_temp table does not have data or some unknown error');

2822: AND period_num=v_period_num
2823: AND period_year=v_period_fiscal_year-1;
2824: EXCEPTION
2825: WHEN OTHERS THEN
2826: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES:Either fv_cfs_rep_temp table does not have data or some unknown error');
2827: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',SQLERRM);
2828: END;
2829:
2830: populate_temp_table;

Line 3498: FROM fv_cfs_rep_temp

3494: /*Populating previous fiscal year amount */
3495: BEGIN
3496: SELECT col_1_amt, col_2_amt
3497: INTO v_col_3_amt,v_col_4_amt
3498: FROM fv_cfs_rep_temp
3499: WHERE line_id=v_line_id
3500: AND ledger_id=v_sob
3501: AND reporty_type='SBR'
3502: AND period_num=v_period_num

Line 3508: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:Either fv_cfs_rep_temp table does not have data or some unknown error');

3504: EXCEPTION
3505: WHEN OTHERS THEN
3506: --g_error_code := SQLCODE;
3507: g_error_message := SQLERRM;
3508: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:Either fv_cfs_rep_temp table does not have data or some unknown error');
3509: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);
3510: END;
3511:
3512: populate_temp_table;

Line 3549: FROM fv_cfs_rep_temp

3545: END IF;
3546: --
3547:
3548: DELETE
3549: FROM fv_cfs_rep_temp
3550: WHERE (line_id) IN
3551: (SELECT sbr_line_id
3552: FROM fv_sbr_definitions_lines
3553: WHERE set_of_books_id = v_sob

Line 3753: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;

3749: WHERE sbr_line_id = v_line_id
3750: and set_of_books_id = v_sob;
3751:
3752: l_ignore INTEGER;
3753: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
3754: l_begin_balance NUMBER;
3755: l_end_balance NUMBER;
3756: l_period_name_1 gl_period_statuses.period_name%TYPE;
3757: l_period_name_2 gl_period_statuses.period_name%TYPE;

Line 3977: DELETE FROM fv_cfs_rep_temp

3973:
3974: DELETE FROM fv_facts_edit_check_status
3975: WHERE treasury_symbol_id = v_purge_ts_id;
3976:
3977: DELETE FROM fv_cfs_rep_temp
3978: WHERE ledger_id=v_sob
3979: AND reporty_type='SBR'
3980: AND period_num=v_period_num
3981: AND period_year=v_period_fiscal_year;