1290: from IGC_CBC_SUMMARY_TEMPLATES
1291: where set_of_books_id = g_sob_id
1292: and nvl(MIG_RESULT_CODE,'F') <> 'T';
1293:
1294: gl_temp_rec GL_SUMMARY_TEMPLATES%rowtype;
1295:
1296: /* cursor to get all budget records for which budgetroy control is set up for each template */
1297: Cursor bcoptions_cur(c_template_id IN NUMBER) is
1298: Select * from GL_SUMMARY_BC_OPTIONS
1311: l_full_path := g_path || 'migrate_sum_templates';
1312:
1313: select chart_of_accounts_id into v_chart_of_accounts_id from gl_ledgers where ledger_id = g_cbc_ledger_id;
1314:
1315: /* Inserting template information in GL_SUMMARY_TEMPLATES for which setup is made in CBC */
1316:
1317: For i in template_cur
1318: loop
1319: v_template_id := GL_SUMMARY_TEMPLATES_PKG.get_unique_id;
1315: /* Inserting template information in GL_SUMMARY_TEMPLATES for which setup is made in CBC */
1316:
1317: For i in template_cur
1318: loop
1319: v_template_id := GL_SUMMARY_TEMPLATES_PKG.get_unique_id;
1320: select * into gl_temp_rec from GL_SUMMARY_TEMPLATES where template_id = i.template_id;
1321: INSERT INTO GL_SUMMARY_TEMPLATES(
1322: template_id,
1323: ledger_id,
1316:
1317: For i in template_cur
1318: loop
1319: v_template_id := GL_SUMMARY_TEMPLATES_PKG.get_unique_id;
1320: select * into gl_temp_rec from GL_SUMMARY_TEMPLATES where template_id = i.template_id;
1321: INSERT INTO GL_SUMMARY_TEMPLATES(
1322: template_id,
1323: ledger_id,
1324: status,
1317: For i in template_cur
1318: loop
1319: v_template_id := GL_SUMMARY_TEMPLATES_PKG.get_unique_id;
1320: select * into gl_temp_rec from GL_SUMMARY_TEMPLATES where template_id = i.template_id;
1321: INSERT INTO GL_SUMMARY_TEMPLATES(
1322: template_id,
1323: ledger_id,
1324: status,
1325: last_update_date,