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_BUDGET_ENTITIES

Line 34: (old_bud_entity gl_budget_entities.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
34: (old_bud_entity gl_budget_entities.NAME%Type,
35: new_bud_entity gl_budget_entities.NAME%Type
36: );
37: TYPE t_tbl_bud_entity_map IS TABLE of t_typ_bud_entity_map INDEX BY BINARY_INTEGER;
38:

Line 35: new_bud_entity gl_budget_entities.NAME%Type

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
34: (old_bud_entity gl_budget_entities.NAME%Type,
35: new_bud_entity gl_budget_entities.NAME%Type
36: );
37: TYPE t_tbl_bud_entity_map IS TABLE of t_typ_bud_entity_map INDEX BY BINARY_INTEGER;
38:
39: g_tbl_basic_errors t_tbl_errors;

Line 69: p_old_bud_entity gl_budget_entities.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,
70: p_new_bud_entity gl_budget_entities.NAME%Type
71: );
72:
73: PROCEDURE Put_Debug_Msg (

Line 70: p_new_bud_entity gl_budget_entities.NAME%Type

66: );
67:
68: PROCEDURE add_bud_entity_map (
69: p_old_bud_entity gl_budget_entities.NAME%Type,
70: p_new_bud_entity gl_budget_entities.NAME%Type
71: );
72:
73: PROCEDURE Put_Debug_Msg (
74: p_path IN VARCHAR2,

Line 592: v_bud_entity_id gl_budget_entities.budget_entity_id%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:
595: cursor c_budget_cur is Select budget_name
596: from gl_budgets_v

Line 709: select count(*) into cnt from gl_budget_entities

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
710: Where name = p_new_name
711: and description not like '%R12_MIG_'||p_old_name;
712: ELSE
713: IF (g_debug_mode = 'Y') THEN

Line 829: v_budget_entity_id gl_budget_entities.budget_entity_id%type;

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;
830: X_Name gl_budget_entities.name%type;
831: bud_org_rec gl_budget_entities%rowtype;
832: /* Cursor to loop through all account ranges defined for a budget organization */
833: Cursor range_cur is SELECT *

Line 830: X_Name gl_budget_entities.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;
830: X_Name gl_budget_entities.name%type;
831: bud_org_rec gl_budget_entities%rowtype;
832: /* Cursor to loop through all account ranges defined for a budget organization */
833: Cursor range_cur is SELECT *
834: FROM GL_BUDGET_ASSIGNMENT_RANGES

Line 831: bud_org_rec gl_budget_entities%rowtype;

827: p_budget_entity_id out NOCOPY number) IS
828:
829: v_budget_entity_id gl_budget_entities.budget_entity_id%type;
830: X_Name gl_budget_entities.name%type;
831: bud_org_rec gl_budget_entities%rowtype;
832: /* Cursor to loop through all account ranges defined for a budget organization */
833: Cursor range_cur is SELECT *
834: FROM GL_BUDGET_ASSIGNMENT_RANGES
835: WHERE budget_entity_id = v_budget_entity_id;

Line 842: V_Org_Description gl_budget_entities.description%type;

838: CURSOR BC_CUR(p_range_id IN Number) IS
839: Select * from GL_BUDORG_BC_OPTIONS
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);

Line 849: SELECT budget_entity_id from gl_budget_entities where name = c_new_org_name;

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
849: SELECT budget_entity_id from gl_budget_entities where name = c_new_org_name;
850:
851: BEGIN
852:
853: l_full_path := g_path || 'GL_Budget_Org';

Line 874: select * into bud_org_rec from gl_budget_entities

870: IF (g_debug_mode = 'Y') THEN
871: Put_Debug_Msg(l_full_path, 'Old Budget Entity ID: ' || v_budget_entity_id );
872: END IF;
873:
874: select * into bud_org_rec from gl_budget_entities
875: where budget_entity_id = v_budget_entity_id;
876:
877: get_new_name(bud_org_rec.name,21,'ORG',X_Name);
878: IF (g_debug_mode = 'Y') THEN

Line 895: p_budget_entity_id := gl_budget_entities_pkg.get_unique_id;

891: Else
892: V_Org_Description := bud_org_rec.Description||'R12_MIG_'||bud_org_rec.name;
893: END IF;
894: /************ Insert the corresponding rows in gl_entity_budgets. */
895: p_budget_entity_id := gl_budget_entities_pkg.get_unique_id;
896:
897: INSERT INTO GL_ENTITY_BUDGETS
898: (budget_entity_id, budget_version_id, frozen_flag,
899: created_by, creation_date,

Line 912: INSERT INTO gl_budget_entities(

908: AND bv.budget_type = b.budget_type;
909:
910: /************ Insert Budget Organization */
911:
912: INSERT INTO gl_budget_entities(
913: budget_entity_id,
914: name,
915: ledger_id,
916: last_update_date,

Line 1874: p_old_bud_entity gl_budget_entities.NAME%Type,

1870: END add_bud_map;
1871:
1872:
1873: PROCEDURE add_bud_entity_map (
1874: p_old_bud_entity gl_budget_entities.NAME%Type,
1875: p_new_bud_entity gl_budget_entities.NAME%Type
1876: ) IS
1877: l_tbl_count NUMBER;
1878: BEGIN

Line 1875: p_new_bud_entity gl_budget_entities.NAME%Type

1871:
1872:
1873: PROCEDURE add_bud_entity_map (
1874: p_old_bud_entity gl_budget_entities.NAME%Type,
1875: p_new_bud_entity gl_budget_entities.NAME%Type
1876: ) IS
1877: l_tbl_count NUMBER;
1878: BEGIN
1879: l_tbl_count := g_tbl_bud_entity_map.count;