DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_COA_SPEC_HDR_TEXT

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

151: log_msg('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
153: END insert_hdr_rec;
154:
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

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

170: PrintLn('Begin procedure populate_hdr_text');
171:
172: FOR text_cur_rec IN get_text_info (tbl_hdr.spec_hdr_text_code)
173: LOOP
174: PrintLn('In gmd_coa_spec_hdr_text LOOP');
175: PrintLn('Inserting into gmd_coa_spec_hdr_text');
176: INSERT into gmd_coa_spec_hdr_text (gmd_coa_id, text_code,
177: paragraph_code, line_no, text)
178: VALUES (tbl_hdr.gmd_coa_id,

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

171:
172: FOR text_cur_rec IN get_text_info (tbl_hdr.spec_hdr_text_code)
173: LOOP
174: PrintLn('In gmd_coa_spec_hdr_text LOOP');
175: PrintLn('Inserting into gmd_coa_spec_hdr_text');
176: INSERT into gmd_coa_spec_hdr_text (gmd_coa_id, text_code,
177: paragraph_code, line_no, text)
178: VALUES (tbl_hdr.gmd_coa_id,
179: tbl_hdr.spec_hdr_text_code,

Line 176: INSERT into gmd_coa_spec_hdr_text (gmd_coa_id, text_code,

172: FOR text_cur_rec IN get_text_info (tbl_hdr.spec_hdr_text_code)
173: LOOP
174: PrintLn('In gmd_coa_spec_hdr_text LOOP');
175: PrintLn('Inserting into gmd_coa_spec_hdr_text');
176: INSERT into gmd_coa_spec_hdr_text (gmd_coa_id, text_code,
177: paragraph_code, line_no, text)
178: VALUES (tbl_hdr.gmd_coa_id,
179: tbl_hdr.spec_hdr_text_code,
180: text_cur_rec.paragraph_code,