eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_UPGRADE_DATA_R12 dependencies on GL_BUDGETS_V

Line 99: P_LATEST_OPENED_YEAR OUT NOCOPY Gl_BUDGETS_V.LATEST_OPENED_YEAR%TYPE);

95:
96: PROCEDURE MIGRATE_GL_BUDGETS ( P_OLD_BUD_NAME IN VARCHAR2,
97: P_MASTER_BUD_VER_ID IN NUMBER,
98: P_BUDGET_VERSION_ID OUT NOCOPY GL_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
99: P_LATEST_OPENED_YEAR OUT NOCOPY Gl_BUDGETS_V.LATEST_OPENED_YEAR%TYPE);
100:
101:
102: PROCEDURE GL_BUDGET_ORG ( P_BUDGET_NAME IN GL_BUDGETS.BUDGET_NAME%TYPE,
103: P_BUDGET_VERSION_ID IN NUMBER,

Line 108: p_latest_open_year IN GL_BUDGETS_V.Latest_opened_year%type,

104: P_BUDGET_ENTITY_ID OUT NOCOPY NUMBER);
105:
106: PROCEDURE submit_open_year (P_sec_ledger_id IN Number,
107: Bud_Version_Id IN NUMBER,
108: p_latest_open_year IN GL_BUDGETS_V.Latest_opened_year%type,
109: p_fiscal_year IN NUMBER);
110:
111: PROCEDURE migrate_cbc_bud_jounals(p_fiscal_year IN NUMBER);
112:

Line 590: v_latest_opened_year gl_budgets_v.LATEST_OPENED_YEAR%type;

586: v_period_end_num gl_periods.period_num%type;
587: v_period_start_name gl_budgets.first_valid_period_name%type;
588: v_period_end_name gl_budgets.last_valid_period_name%type;
589: v_budget_version_id gl_budget_versions.budget_version_id%type;
590: v_latest_opened_year gl_budgets_v.LATEST_OPENED_YEAR%type;
591:
592: v_bud_entity_id gl_budget_entities.budget_entity_id%type;
593: l_full_path VARCHAR2(255);
594:

Line 596: from gl_budgets_v

592: v_bud_entity_id gl_budget_entities.budget_entity_id%type;
593: l_full_path VARCHAR2(255);
594:
595: cursor c_budget_cur is Select budget_name
596: from gl_budgets_v
597: where ledger_id = g_sob_id
598: and first_valid_period_name = v_period_start_name
599: and last_valid_period_name = v_period_end_name
600: and master_budget_version_id is null;

Line 603: from gl_budgets_v

599: and last_valid_period_name = v_period_end_name
600: and master_budget_version_id is null;
601:
602: cursor c_master_cur is Select budget_name,master_budget_version_id
603: from gl_budgets_v
604: where ledger_id = g_sob_id
605: and first_valid_period_name = v_period_start_name
606: and last_valid_period_name = v_period_end_name
607: and master_budget_version_id is not null;

Line 733: p_latest_opened_year OUT NOCOPY gl_budgets_v.LATEST_OPENED_YEAR%type) is

729:
730:
731: PROCEDURE Migrate_GL_Budgets(p_old_bud_name in varchar2, p_Master_Bud_Ver_Id in number,
732: p_budget_version_id Out NOCOPY gl_budget_versions.budget_version_id%type,
733: p_latest_opened_year OUT NOCOPY gl_budgets_v.LATEST_OPENED_YEAR%type) is
734:
735: v_new_budget gl_budgets.budget_name%type;
736:
737: --p_budget_version_id gl_budget_versions.budget_version_id%type;

Line 746: FROM gl_budgets_v

742: v_row_id varchar2(50) := NULL;
743: l_full_path VARCHAR2(255);
744: CURSOR bud_cur(c_new_budget IN varchar2) IS
745: select budget_version_id, latest_opened_year
746: FROM gl_budgets_v
747: WHERE budget_name = c_new_budget;
748: BEGIN
749: l_full_path := g_path || 'Migrate_GL_Budgets';
750: get_new_name(p_old_bud_name,11,'BUD',v_new_budget);

Line 1187: p_latest_open_year IN gl_budgets_v.latest_opened_year%type,

1183:
1184:
1185: PROCEDURE submit_open_year(P_sec_ledger_id IN Number,
1186: Bud_Version_Id IN NUMBER,
1187: p_latest_open_year IN gl_budgets_v.latest_opened_year%type,
1188: p_fiscal_year IN NUMBER)
1189: IS
1190: req_id number;
1191: v_access_set_id number;

Line 1304: v_old_budget_name gl_budgets_v.budget_name%type;

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;
1307: v_row_id varchar2(50) := NULL;
1308: l_full_path VARCHAR2(255);

Line 1305: v_new_bud_ver_id gl_budgets_v.budget_version_id%type;

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;
1307: v_row_id varchar2(50) := NULL;
1308: l_full_path VARCHAR2(255);
1309: l_request_status NUMBER;

Line 1435: from gl_budgets_v where budget_version_id = BUDCTRL_OPTIONS.funding_budget_version_id;

1431: FOR BUDCTRL_OPTIONS IN bcoptions_cur(i.template_id)
1432: LOOP
1433:
1434: select budget_name into v_old_budget_name
1435: from gl_budgets_v where budget_version_id = BUDCTRL_OPTIONS.funding_budget_version_id;
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:

Line 1438: from gl_budgets_v where description like '%R12_MIG_'||v_old_budget_name;

1434: select budget_name into v_old_budget_name
1435: from gl_budgets_v where budget_version_id = BUDCTRL_OPTIONS.funding_budget_version_id;
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 ,