APPS.IGC_UPGRADE_DATA_R12 dependencies on GL_LEDGERS

Line 18: g_cbc_ledger_id gl_ledgers.ledger_id%TYPE := 0;

14: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCUPGDB.IGC_UPGRADE_DATA_R12.';
15: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
16: g_sob_id NUMBER := 0;
17: g_sob_name VARCHAR2(50) := NULL;
18: g_cbc_ledger_id gl_ledgers.ledger_id%TYPE := 0;
19: g_cbc_ledger_name VARCHAR2(50) := NULL;
20: g_conc_pr_user FND_CONCURRENT_PROGRAMS_VL.user_concurrent_program_name%TYPE;
21:
22: TYPE t_typ_errors IS RECORD

Line 844: v_coa_id gl_ledgers.chart_of_accounts_id%type;

840: Where RANGE_ID = p_range_id;
841: v_range_id varchar2(100) := NULL;
842: V_Org_Description gl_budget_entities.description%type;
843: v_cbc_override gl_budorg_bc_options.funds_check_level_code%type;
844: v_coa_id gl_ledgers.chart_of_accounts_id%type;
845: v_new_range_id GL_BUDGET_ASSIGNMENT_RANGES.range_id%type;
846: l_full_path VARCHAR2(255);
847: /* Cursor to check whether the new organization is already migrated */
848: CURSOR budorg_cur(c_new_org_name IN VARCHAR2) IS

Line 1035: from gl_ledgers where ledger_id = g_cbc_ledger_id;

1031: FOR Ranges in range_cur
1032: LOOP
1033:
1034: select chart_of_accounts_id into v_coa_id
1035: from gl_ledgers where ledger_id = g_cbc_ledger_id;
1036:
1037: select gl_budget_assignment_ranges_s.NEXTVAL into v_new_range_id
1038: from dual;
1039: BEGIN

Line 1302: v_chart_of_accounts_id gl_ledgers.chart_of_accounts_id%type;

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;
1303: user_exception Exception;
1304: v_old_budget_name gl_budgets_v.budget_name%type;
1305: v_new_bud_ver_id gl_budgets_v.budget_version_id%type;
1306: req_id number;

Line 1313: select chart_of_accounts_id into v_chart_of_accounts_id from gl_ledgers where ledger_id = g_cbc_ledger_id;

1309: l_request_status NUMBER;
1310: BEGIN
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

Line 1958: FROM gl_access_set_ledgers acc, gl_ledgers lgr

1954:
1955: BEGIN
1956: SELECT distinct '1'
1957: INTO l_dummy
1958: FROM gl_access_set_ledgers acc, gl_ledgers lgr
1959: WHERE acc.access_set_id = l_gl_data_access_set
1960: AND lgr.ledger_id = acc.ledger_id
1961: AND lgr.object_type_code = 'L'
1962: AND acc.access_privilege_code in ('B','F')