APPS.FV_CFS_PKG dependencies on FV_CFS_REP_TEMP_S

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