[Home] [Help]
34: p_cc_header_id IN NUMBER
35: ) RETURN BOOLEAN
36: IS
37: l_cc_headers_rec igc_cc_headers%ROWTYPE;
38: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
39: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
40:
41: /* Contract Commitment detail payment forecast */
42: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
95: CURSOR c_account_lines(t_cc_header_id NUMBER) IS
96: -- Replaced the folllowing query with the one below for
97: -- performance tuning fixes.
98: -- The record definition of l_cc_acct_lines_rec is still based on
99: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
100: -- select is being done from the base table, but all the columns
101: -- as defined in the view are retained even though they are not used.
102: -- This is just so that minimal change is made to the code.
103: /*
101: -- as defined in the view are retained even though they are not used.
102: -- This is just so that minimal change is made to the code.
103: /*
104: SELECT *
105: FROM igc_cc_acct_lines_v ccac
106: WHERE ccac.cc_header_id = t_cc_header_id;
107: */
108:
109: SELECT ccal.ROWID,
626: IS
627:
628: l_cc_headers_rec igc_cc_headers%ROWTYPE;
629: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
630: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
631: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
632: l_exception igc_cc_process_exceptions.exception_reason%TYPE;
633: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
634:
637: IS
638: -- Replaced the folllowing query with the one below for
639: -- performance tuning fixes.
640: -- The record definition of l_cc_acct_lines_rec is still based on
641: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
642: -- select is being done from the base table, but all the columns
643: -- as defined in the view are retained even though they are not used.
644: -- This is just so that minimal change is made to the code.
645:
643: -- as defined in the view are retained even though they are not used.
644: -- This is just so that minimal change is made to the code.
645:
646: -- SELECT *
647: -- FROM igc_cc_acct_lines_v
648: -- WHERE cc_header_id = p_cc_header_id;
649:
650:
651: SELECT ccal.ROWID,
1607: p_revalue_fix_date IN VARCHAR2)
1608: IS
1609: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1610: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1611: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1612: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1613: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1614: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1615:
1608: IS
1609: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1610: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1611: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1612: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1613: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1614: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1615:
1616: /*Bug No : 6341012. MOAC Uptake. Local variables for SOB_ID,ORG_ID,SOB_NAME */
1731: IS
1732: -- Replaced the folllowing query with the one below for
1733: -- performance tuning fixes.
1734: -- The record definition of l_cc_acct_lines_rec is still based on
1735: -- view igc_cc_acct_lines_v. Instead of selecting from the view,
1736: -- select is being done from the base table, but all the columns
1737: -- as defined in the view are retained even though they are not used.
1738: -- This is just so that minimal change is made to the code.
1739: /*
1737: -- as defined in the view are retained even though they are not used.
1738: -- This is just so that minimal change is made to the code.
1739: /*
1740: SELECT *
1741: FROM igc_cc_acct_lines_v
1742: WHERE cc_header_id = p_cc_header_id;
1743: */
1744:
1745: SELECT ccal.ROWID,