[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 . |
194: -- Bug # 4260445 Added this procedure to populate data into gmd_coa_spec_hdr_text
195:
196: PROCEDURE populate_hdr_text (tbl_hdr IN t_coa_hdr_rec,
197: x_return_status OUT NOCOPY VARCHAR2) IS
198: CURSOR get_text_info (c_text_code qc_text_tbl.text_code%TYPE) IS
199: select paragraph_code,
200: line_no,
201: text
202: from qc_text_tbl
198: CURSOR get_text_info (c_text_code qc_text_tbl.text_code%TYPE) IS
199: select paragraph_code,
200: line_no,
201: text
202: from qc_text_tbl
203: where text_code = c_text_code
204: and line_no > 0
205: order by paragraph_code, line_no ;
206:
237:
238: PROCEDURE populate_text (tbl_dtl IN t_coa_dtl_rec,
239: x_return_status OUT NOCOPY VARCHAR2) IS
240:
241: CURSOR get_text_info (c_text_code qc_text_tbl.text_code%TYPE) IS
242: select paragraph_code,
243: line_no,
244: text
245: from qc_text_tbl
241: CURSOR get_text_info (c_text_code qc_text_tbl.text_code%TYPE) IS
242: select paragraph_code,
243: line_no,
244: text
245: from qc_text_tbl
246: where text_code = c_text_code
247: and line_no > 0
248: order by paragraph_code, line_no ;
249: