[Home] [Help]
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
1299: where template_id = c_template_id;
1300:
1301: v_template_id number;
1302: v_chart_of_accounts_id gl_ledgers.chart_of_accounts_id%type;
1426: gl_temp_rec.Attribute7,
1427: gl_temp_rec.Attribute8,
1428: gl_temp_rec.Context);
1429:
1430: /* Inserting budgetary control options into GL_SUMMARY_BC_OPTIONS */
1431: FOR BUDCTRL_OPTIONS IN bcoptions_cur(i.template_id)
1432: LOOP
1433:
1434: select budget_name into v_old_budget_name
1436:
1437: select budget_version_id into v_new_bud_ver_id
1438: from gl_budgets_v where description like '%R12_MIG_'||v_old_budget_name;
1439:
1440: GL_SUMMARY_BC_OPTIONS_PKG.Insert_Row(
1441: X_Rowid => v_row_id,
1442: X_Funds_Check_Level_Code => i.CBC_OVERRIDE ,
1443: X_Dr_Cr_Code => BUDCTRL_OPTIONS.dr_cr_code,
1444: X_Amount_Type => BUDCTRL_OPTIONS.amount_type,
1450: X_Creation_Date => BUDCTRL_OPTIONS.creation_date,
1451: X_Last_Update_Login => BUDCTRL_OPTIONS.last_update_login,
1452: X_Funding_Budget_Version_Id => v_new_bud_ver_id
1453: );
1454: END LOOP; --For all records of GL_SUMMARY_BC_OPTIONS for each template.
1455:
1456: update igc_cbc_summary_templates set MIG_RESULT_CODE = 'T',
1457: MIG_REQUEST_ID = fnd_global.conc_request_id
1458: WHERE template_id = i.template_id;