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

Line 28: (old_budget_name GL_BUDGETS.BUDGET_NAME%Type,

24: );
25: TYPE t_tbl_errors IS TABLE of t_typ_errors INDEX BY BINARY_INTEGER;
26:
27: TYPE t_typ_bud_map IS RECORD
28: (old_budget_name GL_BUDGETS.BUDGET_NAME%Type,
29: new_budget_name GL_BUDGETS.BUDGET_NAME%Type
30: );
31: TYPE t_tbl_bud_map IS TABLE of t_typ_bud_map INDEX BY BINARY_INTEGER;
32:

Line 29: new_budget_name GL_BUDGETS.BUDGET_NAME%Type

25: TYPE t_tbl_errors IS TABLE of t_typ_errors INDEX BY BINARY_INTEGER;
26:
27: TYPE t_typ_bud_map IS RECORD
28: (old_budget_name GL_BUDGETS.BUDGET_NAME%Type,
29: new_budget_name GL_BUDGETS.BUDGET_NAME%Type
30: );
31: TYPE t_tbl_bud_map IS TABLE of t_typ_bud_map INDEX BY BINARY_INTEGER;
32:
33: TYPE t_typ_bud_entity_map IS RECORD

Line 64: p_old_budget_name GL_BUDGETS.BUDGET_NAME%Type,

60: p_final_out IN VARCHAR2
61: );
62:
63: PROCEDURE add_bud_map (
64: p_old_budget_name GL_BUDGETS.BUDGET_NAME%Type,
65: p_new_budget_name GL_BUDGETS.BUDGET_NAME%Type
66: );
67:
68: PROCEDURE add_bud_entity_map (

Line 65: p_new_budget_name GL_BUDGETS.BUDGET_NAME%Type

61: );
62:
63: PROCEDURE add_bud_map (
64: p_old_budget_name GL_BUDGETS.BUDGET_NAME%Type,
65: p_new_budget_name GL_BUDGETS.BUDGET_NAME%Type
66: );
67:
68: PROCEDURE add_bud_entity_map (
69: p_old_bud_entity gl_budget_entities.NAME%Type,

Line 96: PROCEDURE MIGRATE_GL_BUDGETS ( P_OLD_BUD_NAME IN VARCHAR2,

92: P_LEN IN NUMBER,
93: P_FLAG IN VARCHAR2,
94: P_NEW_NAME IN OUT NOCOPY VARCHAR2);
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:

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 102: PROCEDURE GL_BUDGET_ORG ( P_BUDGET_NAME IN GL_BUDGETS.BUDGET_NAME%TYPE,

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,
104: P_BUDGET_ENTITY_ID OUT NOCOPY NUMBER);
105:
106: PROCEDURE submit_open_year (P_sec_ledger_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 587: v_period_start_name gl_budgets.first_valid_period_name%type;

583: p_accounted_period_type IN gl_sets_of_books.accounted_period_type%type) IS
584:
585: v_period_start_num gl_periods.period_num%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:

Line 588: v_period_end_name gl_budgets.last_valid_period_name%type;

584:
585: v_period_start_num gl_periods.period_num%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;

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 635: Migrate_GL_Budgets(c1.budget_name,NULL,v_budget_version_id,v_latest_opened_year);

631:
632: For c1 in c_budget_cur
633: Loop
634:
635: Migrate_GL_Budgets(c1.budget_name,NULL,v_budget_version_id,v_latest_opened_year);
636:
637: IF (g_debug_mode = 'Y') THEN
638: Put_Debug_Msg(l_full_path, 'New Budget Version Id created for new budget ' || v_budget_version_id );
639: END IF;

Line 657: Migrate_GL_Budgets(c2.budget_name,c2.master_budget_version_id,

653: end loop;
654: Commit; --We need to commit all orphan budgets first .
655: FOR c2 in c_master_cur
656: LOOP
657: Migrate_GL_Budgets(c2.budget_name,c2.master_budget_version_id,
658: v_budget_version_id,v_latest_opened_year);
659:
660: submit_open_year(g_cbc_ledger_id,v_budget_version_id,v_latest_opened_year,p_fiscal_year);
661: IF (g_debug_mode = 'Y') THEN

Line 705: select count(*) into cnt from gl_budgets

701: from dual;
702:
703: end if;
704: IF p_flag = 'BUD' THEN
705: select count(*) into cnt from gl_budgets
706: where budget_name = p_new_name
707: and description not like '%R12_MIG_'||p_old_name;
708: ELSIF p_flag = 'ORG' THEN
709: select count(*) into cnt from gl_budget_entities

Line 731: PROCEDURE Migrate_GL_Budgets(p_old_bud_name in varchar2, p_Master_Bud_Ver_Id in number,

727: end if;
728: end get_new_name;
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;

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 735: v_new_budget gl_budgets.budget_name%type;

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;
738:
739: V_Master_Budget_Version_Id gl_budget_versions.budget_version_id%type;

Line 740: BUDGET gl_budgets%rowtype;

736:
737: --p_budget_version_id gl_budget_versions.budget_version_id%type;
738:
739: V_Master_Budget_Version_Id gl_budget_versions.budget_version_id%type;
740: BUDGET gl_budgets%rowtype;
741:
742: v_row_id varchar2(50) := NULL;
743: l_full_path VARCHAR2(255);
744: CURSOR bud_cur(c_new_budget IN varchar2) IS

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 749: l_full_path := g_path || 'Migrate_GL_Budgets';

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);
751:
752: IF (g_debug_mode = 'Y') THEN
753: Put_Debug_Msg(l_full_path, 'New Budget Name created: ' || v_new_budget);

Line 763: from gl_budgets

759: into p_budget_version_id, p_latest_opened_year;
760: IF bud_cur%rowcount = 0 THEN
761: BEGIN
762: select * into BUDGET
763: from gl_budgets
764: where budget_name = p_old_bud_name;
765: p_budget_version_id := gl_budgets_pkg.get_unique_id;
766:
767: IF (g_debug_mode = 'Y') THEN

Line 765: p_budget_version_id := gl_budgets_pkg.get_unique_id;

761: BEGIN
762: select * into BUDGET
763: from gl_budgets
764: where budget_name = p_old_bud_name;
765: p_budget_version_id := gl_budgets_pkg.get_unique_id;
766:
767: IF (g_debug_mode = 'Y') THEN
768: Put_Debug_Msg(l_full_path, 'New Budget Version ID created: ' || p_budget_version_id );
769: END IF;

Line 777: GL_BUDGETS_PKG.Insert_Row(

773: else
774: BUDGET.Description := BUDGET.Description||'R12_MIG_'||BUDGET.budget_name;
775: End if;
776:
777: GL_BUDGETS_PKG.Insert_Row(
778: X_Rowid => v_row_id,
779: X_Budget_Type => BUDGET.Budget_Type,
780: X_Budget_Name => v_new_budget,
781: X_ledger_Id => g_cbc_ledger_id,

Line 818: Put_Debug_Msg(l_full_path, 'Exception occured in Migrate_GL_Budgets' || SQLERRM);

814: IF bud_cur%ISOPEN THEN
815: CLOSE bud_cur;
816: END IF;
817: IF (g_debug_mode = 'Y') THEN
818: Put_Debug_Msg(l_full_path, 'Exception occured in Migrate_GL_Budgets' || SQLERRM);
819: END IF;
820: /*Added by mbremkum*/
821: APP_EXCEPTION.Raise_Exception;
822: END Migrate_GL_Budgets;

Line 822: END Migrate_GL_Budgets;

818: Put_Debug_Msg(l_full_path, 'Exception occured in Migrate_GL_Budgets' || SQLERRM);
819: END IF;
820: /*Added by mbremkum*/
821: APP_EXCEPTION.Raise_Exception;
822: END Migrate_GL_Budgets;
823:
824:
825: PROCEDURE GL_Budget_Org(P_BUDGET_NAME In gl_budgets.budget_name%type,
826: P_budget_version_id IN Number,

Line 825: PROCEDURE GL_Budget_Org(P_BUDGET_NAME In gl_budgets.budget_name%type,

821: APP_EXCEPTION.Raise_Exception;
822: END Migrate_GL_Budgets;
823:
824:
825: PROCEDURE GL_Budget_Org(P_BUDGET_NAME In gl_budgets.budget_name%type,
826: P_budget_version_id IN Number,
827: p_budget_entity_id out NOCOPY number) IS
828:
829: v_budget_entity_id gl_budget_entities.budget_entity_id%type;

Line 905: FROM gl_budgets b, gl_budget_versions bv

901: SELECT p_budget_entity_id, bv.budget_version_id, 'N',
902: bud_org_rec.last_updated_by, sysdate,
903: bud_org_rec.last_updated_by, sysdate,
904: bud_org_rec.last_update_login
905: FROM gl_budgets b, gl_budget_versions bv
906: WHERE b.ledger_id = bud_org_rec.Ledger_Id
907: AND bv.budget_name = b.budget_name
908: AND bv.budget_type = b.budget_type;
909:

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 ,

Line 1575: gl_budgets bud,

1571: FROM igc_cbc_je_lines igc,
1572: gl_budget_assignments asg,
1573: GL_BUDORG_BC_OPTIONS boc,
1574: GL_BUDGET_VERSIONS BV ,
1575: gl_budgets bud,
1576: gl_period_statuses per_f,
1577: gl_period_statuses per_s
1578: WHERE asg.range_id = boc.range_id
1579: AND BV.BUDGET_VERSION_ID = BOC.FUNDING_BUDGET_VERSION_ID

Line 1629: gl_budgets bud,

1625: ( SELECT 1
1626: FROM gl_budget_assignments asg,
1627: GL_BUDORG_BC_OPTIONS boc,
1628: GL_BUDGET_VERSIONS BV ,
1629: gl_budgets bud,
1630: gl_period_statuses per_f,
1631: gl_period_statuses per_s
1632: WHERE asg.range_id = boc.range_id
1633: AND BV.BUDGET_VERSION_ID = BOC.FUNDING_BUDGET_VERSION_ID

Line 1818: l_cbc_budget_name GL_BUDGETS.BUDGET_NAME%TYPE;

1814: END migrate_cbc_bud_jounals;
1815:
1816:
1817: FUNCTION get_cbc_budget_name(p_pri_budget_name IN VARCHAR2) RETURN VARCHAR2 IS
1818: l_cbc_budget_name GL_BUDGETS.BUDGET_NAME%TYPE;
1819: BEGIN
1820: SELECT budget_name
1821: INTO l_cbc_budget_name
1822: FROM gl_budgets

Line 1822: FROM gl_budgets

1818: l_cbc_budget_name GL_BUDGETS.BUDGET_NAME%TYPE;
1819: BEGIN
1820: SELECT budget_name
1821: INTO l_cbc_budget_name
1822: FROM gl_budgets
1823: WHERE description like '%R12_MIG_'||p_pri_budget_name;
1824: RETURN l_cbc_budget_name;
1825: END;
1826:

Line 1862: p_old_budget_name GL_BUDGETS.BUDGET_NAME%Type,

1858: END IF;
1859: END set_final_out;
1860:
1861: PROCEDURE add_bud_map (
1862: p_old_budget_name GL_BUDGETS.BUDGET_NAME%Type,
1863: p_new_budget_name GL_BUDGETS.BUDGET_NAME%Type
1864: ) IS
1865: l_tbl_count NUMBER;
1866: BEGIN

Line 1863: p_new_budget_name GL_BUDGETS.BUDGET_NAME%Type

1859: END set_final_out;
1860:
1861: PROCEDURE add_bud_map (
1862: p_old_budget_name GL_BUDGETS.BUDGET_NAME%Type,
1863: p_new_budget_name GL_BUDGETS.BUDGET_NAME%Type
1864: ) IS
1865: l_tbl_count NUMBER;
1866: BEGIN
1867: l_tbl_count := g_tbl_bud_map.count;

Line 1994: gl_budgets bud,

1990: ( SELECT 1
1991: FROM gl_budget_assignments asg,
1992: GL_BUDORG_BC_OPTIONS boc,
1993: GL_BUDGET_VERSIONS BV ,
1994: gl_budgets bud,
1995: gl_period_statuses per_f,
1996: gl_period_statuses per_s
1997: WHERE asg.range_id = boc.range_id
1998: AND BV.BUDGET_VERSION_ID = BOC.FUNDING_BUDGET_VERSION_ID