[Home] [Help]
31: --| Added code to get the value of text_code from gmd_spe- |
32: --| -cifications table and inserted that value to gmd_coa_ |
33: --| headers table corresponding to the spec_id.Added the |
34: --| procedure populate_hdr_text to insert values into gmd_ |
35: --| coa_spec_hdr_text table from qc_text_tbl. |
36: --| Saikiran 27-Sep-2005 Made Inventory Convergence changes |
37: --| Saikiran 03-Nov-2005 Bug# 4662469 |
38: --| RLNAGARA 21-Feb-2006 Bug 4916856 Modified the cursors in the proc |
39: --| get_order_params by replacing the decode statement by OR . |
155: -- Bug # 4260445 Added this procedure to populate data into gmd_coa_spec_hdr_text
156:
157: PROCEDURE populate_hdr_text (tbl_hdr IN t_coa_hdr_rec,
158: x_return_status OUT NOCOPY VARCHAR2) IS
159: CURSOR get_text_info (c_text_code qc_text_tbl.text_code%TYPE) IS
160: select paragraph_code,
161: line_no,
162: text
163: from qc_text_tbl
159: CURSOR get_text_info (c_text_code qc_text_tbl.text_code%TYPE) IS
160: select paragraph_code,
161: line_no,
162: text
163: from qc_text_tbl
164: where text_code = c_text_code
165: and line_no > 0
166: order by paragraph_code, line_no ;
167:
198:
199: PROCEDURE populate_text (tbl_dtl IN t_coa_dtl_rec,
200: x_return_status OUT NOCOPY VARCHAR2) IS
201:
202: CURSOR get_text_info (c_text_code qc_text_tbl.text_code%TYPE) IS
203: select paragraph_code,
204: line_no,
205: text
206: from qc_text_tbl
202: CURSOR get_text_info (c_text_code qc_text_tbl.text_code%TYPE) IS
203: select paragraph_code,
204: line_no,
205: text
206: from qc_text_tbl
207: where text_code = c_text_code
208: and line_no > 0
209: order by paragraph_code, line_no ;
210: