DBA Data[Home] [Help]

APPS.IGC_UPGRADE_DATA_R12 dependencies on GL_SUMMARY_TEMPLATES

Line 1294: gl_temp_rec GL_SUMMARY_TEMPLATES%rowtype;

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

Line 1315: /* Inserting template information in GL_SUMMARY_TEMPLATES for which setup is made in CBC */

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;

Line 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,

Line 1320: select * into gl_temp_rec from GL_SUMMARY_TEMPLATES where template_id = i.template_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,

Line 1321: INSERT INTO GL_SUMMARY_TEMPLATES(

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,