DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_COA_SPEC_HDR_TEXT

Line 194: -- Bug # 4260445 Added this procedure to populate data into gmd_coa_spec_hdr_text

190: log_msg('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
192: END insert_hdr_rec;
193:
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

Line 213: PrintLn('In gmd_coa_spec_hdr_text LOOP');

209: PrintLn('Begin procedure populate_hdr_text');
210:
211: FOR text_cur_rec IN get_text_info (tbl_hdr.spec_hdr_text_code)
212: LOOP
213: PrintLn('In gmd_coa_spec_hdr_text LOOP');
214: PrintLn('Inserting into gmd_coa_spec_hdr_text');
215: INSERT into gmd_coa_spec_hdr_text (gmd_coa_id, text_code,
216: paragraph_code, line_no, text)
217: VALUES (tbl_hdr.gmd_coa_id,

Line 214: PrintLn('Inserting into gmd_coa_spec_hdr_text');

210:
211: FOR text_cur_rec IN get_text_info (tbl_hdr.spec_hdr_text_code)
212: LOOP
213: PrintLn('In gmd_coa_spec_hdr_text LOOP');
214: PrintLn('Inserting into gmd_coa_spec_hdr_text');
215: INSERT into gmd_coa_spec_hdr_text (gmd_coa_id, text_code,
216: paragraph_code, line_no, text)
217: VALUES (tbl_hdr.gmd_coa_id,
218: tbl_hdr.spec_hdr_text_code,

Line 215: INSERT into gmd_coa_spec_hdr_text (gmd_coa_id, text_code,

211: FOR text_cur_rec IN get_text_info (tbl_hdr.spec_hdr_text_code)
212: LOOP
213: PrintLn('In gmd_coa_spec_hdr_text LOOP');
214: PrintLn('Inserting into gmd_coa_spec_hdr_text');
215: INSERT into gmd_coa_spec_hdr_text (gmd_coa_id, text_code,
216: paragraph_code, line_no, text)
217: VALUES (tbl_hdr.gmd_coa_id,
218: tbl_hdr.spec_hdr_text_code,
219: text_cur_rec.paragraph_code,