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_sequence_number fv_cfs_rep_lines.sequence_number%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_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
39: v_line_number fv_cfs_rep_lines.line_number%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_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
39: v_line_number fv_cfs_rep_lines.line_number%TYPE;
40: v_period_fiscal_year gl_period_statuses.period_year%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_sequence_number fv_cfs_rep_lines.sequence_number%TYPE;
39: v_line_number fv_cfs_rep_lines.line_number%TYPE;
40: v_period_fiscal_year gl_period_statuses.period_year%TYPE;
41: v_period_num gl_period_statuses.period_num%TYPE;

Line 177: SELECT fv_cfs_rep_temp_s.NEXTVAL

173: WHERE ledger_id = v_sob
174: AND application_id = '101'
175: AND period_name = v_period_name;
176:
177: SELECT fv_cfs_rep_temp_s.NEXTVAL
178: INTO v_sequence_id FROM DUAL;
179:
180: get_qualifier_segments;
181:

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

894: WHERE line_id = v_line_id;
895:
896: TYPE l_recipient_rec_type IS RECORD (
897: recipient_name fv_facts_report_t2.recipient_name%TYPE,
898: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
899: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
900: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
901: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0);
902:

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

895:
896: TYPE l_recipient_rec_type IS RECORD (
897: recipient_name fv_facts_report_t2.recipient_name%TYPE,
898: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
899: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
900: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
901: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0);
902:
903: TYPE l_recipient_table IS TABLE OF l_recipient_rec_type

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

896: TYPE l_recipient_rec_type IS RECORD (
897: recipient_name fv_facts_report_t2.recipient_name%TYPE,
898: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
899: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
900: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
901: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0);
902:
903: TYPE l_recipient_table IS TABLE OF l_recipient_rec_type
904: INDEX BY BINARY_INTEGER;

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

897: recipient_name fv_facts_report_t2.recipient_name%TYPE,
898: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
899: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
900: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0,
901: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE := 0);
902:
903: TYPE l_recipient_table IS TABLE OF l_recipient_rec_type
904: INDEX BY BINARY_INTEGER;
905:

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

908: l_found BOOLEAN;
909: l_temp_str fv_cfs_rep_lines.line_label%TYPE;
910:
911: l_ignore INTEGER;
912: l_prev_year_amount fv_cfs_rep_temp.col_1_amt%TYPE := 0;
913: l_begin_balance NUMBER;
914: l_end_balance NUMBER;
915: l_period_name_1 gl_period_statuses.period_name%TYPE;
916: l_period_name_2 gl_period_statuses.period_name%TYPE;

Line 1362: FROM fv_cfs_rep_temp

1358:
1359: CURSOR fv_cfs_temp_cur (p_line_id NUMBER) IS
1360: SELECT col_1_amt, col_2_amt,
1361: col_3_amt, col_4_amt
1362: FROM fv_cfs_rep_temp
1363: WHERE line_id = p_line_id
1364: AND sequence_id = v_sequence_id;
1365:
1366: CURSOR fv_cfs_lines_cur(p_lineid_1 NUMBER, p_lineid_2 NUMBER) IS

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

1374: WHERE line_id = p_lineid_2 )
1375: AND report_type = v_report_type;
1376:
1377: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1378: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1379: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1380: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1381: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1382: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

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

1375: AND report_type = v_report_type;
1376:
1377: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1378: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1379: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1380: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1381: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1382: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1383: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

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

1376:
1377: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1378: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1379: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1380: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1381: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1382: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1383: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1384: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

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

1377: l_line_id fv_cfs_rep_lines.line_id%TYPE;
1378: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1379: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1380: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1381: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1382: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1383: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1384: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1385: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;

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

1378: temp_amt_low1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1379: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1380: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1381: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1382: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1383: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1384: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1385: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1386:

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

1379: temp_amt_low2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1380: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1381: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1382: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1383: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1384: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1385: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1386:
1387: TYPE amt_rec IS RECORD (

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

1380: temp_amt_low3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1381: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1382: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1383: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1384: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1385: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1386:
1387: TYPE amt_rec IS RECORD (
1388: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,

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

1381: temp_amt_low4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1382: temp_amt_high1 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1383: temp_amt_high2 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1384: temp_amt_high3 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1385: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1386:
1387: TYPE amt_rec IS RECORD (
1388: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,
1389: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,

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

1385: temp_amt_high4 fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0;
1386:
1387: TYPE amt_rec IS RECORD (
1388: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,
1389: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1390: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1391: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1392: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1393: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,

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

1386:
1387: TYPE amt_rec IS RECORD (
1388: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,
1389: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1390: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1391: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1392: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1393: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
1394: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,

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

1387: TYPE amt_rec IS RECORD (
1388: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,
1389: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1390: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1391: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1392: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1393: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
1394: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
1395: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,

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

1388: calc_sequence fv_cfs_rep_line_calc.calc_sequence_number%TYPE,
1389: col_1_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1390: col_2_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1391: col_3_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1392: col_4_amt fv_cfs_rep_temp.col_1_amt%TYPE DEFAULT 0,
1393: cum_res fv_cfs_rep_line_calc.cum_res%TYPE ,
1394: unexp_approp fv_cfs_rep_line_calc.unexp_approp%TYPE ,
1395: budget_col fv_cfs_rep_line_calc.budget_col%TYPE ,
1396: nbfa_col fv_cfs_rep_line_calc.nbfa_col%TYPE );

Line 1533: INSERT INTO fv_cfs_rep_temp(sequence_id, line_id, line_label, col_1_amt,

1529: -- Bug 5491457. If the report type is SF and natural balance type is Net Increase or
1530: -- Net Decrease, then drop the sign from the amounts.
1531: IF (v_report_type = 'SF' AND v_balance_type IN ('I', 'J')) THEN
1532: IF gbl_units <> 'Dollars and Cents' THEN
1533: INSERT INTO fv_cfs_rep_temp(sequence_id, line_id, line_label, col_1_amt,
1534: col_2_amt, col_3_amt, col_4_amt)
1535: VALUES(v_sequence_id, v_line_id, v_line_label,
1536: ABS(ROUND(v_col_1_amt/v_units)),
1537: ABS(ROUND(v_col_2_amt/v_units)),

Line 1541: INSERT INTO fv_cfs_rep_temp(sequence_id, line_id, line_label, col_1_amt,

1537: ABS(ROUND(v_col_2_amt/v_units)),
1538: ABS(ROUND(v_col_3_amt/v_units)),
1539: ABS(ROUND(v_col_4_amt/v_units)));
1540: ELSE
1541: INSERT INTO fv_cfs_rep_temp(sequence_id, line_id, line_label, col_1_amt,
1542: col_2_amt, col_3_amt, col_4_amt)
1543: VALUES(v_sequence_id, v_line_id, v_line_label,
1544: ABS(v_col_1_amt),
1545: ABS(v_col_2_amt),

Line 1553: INSERT INTO fv_cfs_rep_temp(sequence_id, line_id, line_label, col_1_amt,

1549:
1550: ELSE
1551:
1552: IF gbl_units <> 'Dollars and Cents' THEN
1553: INSERT INTO fv_cfs_rep_temp(sequence_id, line_id, line_label, col_1_amt,
1554: col_2_amt, col_3_amt, col_4_amt)
1555: VALUES(v_sequence_id, v_line_id, v_line_label,
1556: DECODE(v_natural_balance_type, 'C', ROUND(v_col_1_amt/v_units) * -1, ROUND(v_col_1_amt/v_units)),
1557: DECODE(v_natural_balance_type, 'C', ROUND(v_col_2_amt/v_units) * -1, ROUND(v_col_2_amt/v_units)),

Line 1562: INSERT INTO fv_cfs_rep_temp(sequence_id, line_id, line_label, col_1_amt,

1558: DECODE(v_natural_balance_type, 'C', ROUND(v_col_3_amt/v_units) * -1, ROUND(v_col_3_amt/v_units)),
1559: DECODE(v_natural_balance_type, 'C', ROUND(v_col_4_amt/v_units) * -1, ROUND(v_col_4_amt/v_units)));
1560: ELSE
1561:
1562: INSERT INTO fv_cfs_rep_temp(sequence_id, line_id, line_label, col_1_amt,
1563: col_2_amt, col_3_amt, col_4_amt)
1564: VALUES(v_sequence_id, v_line_id, v_line_label,
1565: DECODE(v_natural_balance_type, 'C', v_col_1_amt * -1, v_col_1_amt),
1566: DECODE(v_natural_balance_type, 'C', v_col_2_amt * -1, v_col_2_amt),