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.PSB_BUDGET_GROUPS_PVT dependencies on PSB_BUDGET_GROUPS

Line 1: package body PSB_BUDGET_GROUPS_PVT as

1: package body PSB_BUDGET_GROUPS_PVT as
2: /* $Header: PSBVBGPB.pls 120.8 2006/01/30 04:20:11 viraghun ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_BUDGET_GROUPS_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_BUDGET_GROUPS_PVT';

1: package body PSB_BUDGET_GROUPS_PVT as
2: /* $Header: PSBVBGPB.pls 120.8 2006/01/30 04:20:11 viraghun ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_BUDGET_GROUPS_PVT';
5:
6: /*For Bug No : 2230514 Start*/
7: --g_debug_flag VARCHAR2(1) := 'N';
8: /*For Bug No : 2230514 End*/

Line 37: from PSB_BUDGET_GROUPS

33: ps_account_position_set_id,
34: nps_account_position_set_id,
35: effective_start_date,
36: effective_end_date
37: from PSB_BUDGET_GROUPS
38: where budget_group_type = 'R'
39: start with budget_group_id = RootBudgetGroup_ID
40: connect by prior budget_group_id = parent_budget_group_id;
41:

Line 80: from psb_budget_groups

76: and c.budget_group_id <> BudgetGroup_ID
77: /*For Bug No : 2255402 Start*/
78: and exists
79: (select 1
80: from psb_budget_groups
81: where budget_group_id = c.budget_group_id
82: and (budget_group_id = RootBudgetGroup_ID
83: or root_budget_group_id = RootBudgetGroup_ID))
84: /*

Line 87: from psb_budget_groups

83: or root_budget_group_id = RootBudgetGroup_ID))
84: /*
85: and c.budget_group_id in
86: (select budget_group_id
87: from psb_budget_groups
88: where (budget_group_id = RootBudgetGroup_ID
89: or root_budget_group_id = RootBudgetGroup_ID))
90: */
91: /*For Bug No : 2255402 End*/

Line 192: from psb_budget_groups

188: and (nvl(a.effective_end_date, Start_Date) >= Start_Date)))
189: and a.account_position_set_id <> AccSet_ID
190: and exists
191: (select 1
192: from psb_budget_groups
193: where budget_group_id = a.budget_group_id
194: and (budget_group_id = RootBudgetGroup_ID
195: or root_budget_group_id = RootBudgetGroup_ID));
196:

Line 201: d from psb_budget_groups

197: /* For Bug No : 2255402 Start --> added the above exist clause
198: and commented the one below
199: and a.budget_group_id in
200: (select budget_group_id
201: d from psb_budget_groups
202: where (budget_group_id = RootBudgetGroup_ID
203: or root_budget_group_id = RootBudgetGroup_ID));
204:
205: For Bug No : 2255402 End*/

Line 398: from PSB_BUDGET_GROUPS_V

394: l_freeze_flag VARCHAR2(1);
395:
396: cursor c_FreezeFlag is
397: select nvl(freeze_hierarchy_flag, root_freeze_hierarchy_flag) freeze_hierarchy_flag
398: from PSB_BUDGET_GROUPS_V
399: where budget_group_id = p_budget_group_id;
400:
401: BEGIN
402:

Line 610: from PSB_BUDGET_GROUPS_V

606: l_return_status VARCHAR2(1);
607:
608: cursor c_Flex is
609: select nvl(chart_of_accounts_id, root_chart_of_accounts_id) flex_code
610: from PSB_BUDGET_GROUPS_V
611: where budget_group_id = p_budget_group_id;
612:
613: BEGIN
614:

Line 895: update PSB_BUDGET_GROUPS

891: -- and update freeze flag
892: --
893: IF (l_budget_group_error <> 'Y') THEN
894:
895: update PSB_BUDGET_GROUPS
896: set freeze_hierarchy_flag = 'Y'
897: where budget_group_id = p_budget_group_id;
898:
899: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1084: cursor C is select ROWID from PSB_BUDGET_GROUPS

1080: p_context in varchar2,
1081: p_mode in varchar2 := 'R'
1082: ) AS
1083:
1084: cursor C is select ROWID from PSB_BUDGET_GROUPS
1085: where BUDGET_GROUP_ID = P_BUDGET_GROUP_ID;
1086: P_LAST_UPDATE_DATE DATE;
1087: P_LAST_UPDATED_BY NUMBER;
1088: P_LAST_UPDATE_LOGIN NUMBER;

Line 1124: insert into PSB_BUDGET_GROUPS (

1120: FND_MSG_PUB.Add ;
1121: raise FND_API.G_EXC_ERROR ;
1122: end if;
1123:
1124: insert into PSB_BUDGET_GROUPS (
1125: budget_group_id,
1126: name,
1127: short_name,
1128: root_budget_group,

Line 1442: from PSB_BUDGET_GROUPS

1438: attribute8,
1439: attribute9,
1440: attribute10,
1441: context
1442: from PSB_BUDGET_GROUPS
1443: where BUDGET_GROUP_ID = P_BUDGET_GROUP_ID
1444: for update of BUDGET_GROUP_ID nowait;
1445: tlinfo c1%rowtype;
1446: --

Line 1772: update PSB_BUDGET_GROUPS set

1768: raise FND_API.G_EXC_ERROR ;
1769: end if;
1770:
1771:
1772: update PSB_BUDGET_GROUPS set
1773: name = p_name,
1774: short_name = p_short_name,
1775: root_budget_group = p_root_budget_group,
1776: parent_budget_group_id = p_parent_budget_group_id,

Line 1960: cursor c1 is select rowid from PSB_BUDGET_GROUPS

1956: p_context in varchar2,
1957: p_mode in varchar2 := 'R'
1958: ) AS
1959:
1960: cursor c1 is select rowid from PSB_BUDGET_GROUPS
1961: where BUDGET_GROUP_ID = P_BUDGET_GROUP_ID
1962: ;
1963: dummy c1%rowtype;
1964: --

Line 2185: from psb_budget_groups

2181: ) AS
2182: cursor C1 is
2183: select budget_group_id,
2184: short_name
2185: from psb_budget_groups
2186: where budget_group_type = 'R'
2187: start with budget_group_id = p_budget_group_id
2188: connect by prior budget_group_id = parent_budget_group_id;
2189:

Line 2597: delete psb_budget_groups where budget_group_id = c1rec.budget_group_id;

2593:
2594:
2595: -- proceed with deletion
2596:
2597: delete psb_budget_groups where budget_group_id = c1rec.budget_group_id;
2598: delete psb_budget_group_resp where budget_group_id = c1rec.budget_group_id;
2599: if (sql%notfound) then
2600: null;
2601: end if;

Line 2612: delete psb_budget_groups where budget_group_id = p_budget_group_id;

2608: null;
2609: end if;
2610: end loop;
2611: -- deleting top level bg
2612: delete psb_budget_groups where budget_group_id = p_budget_group_id;
2613: delete psb_budget_group_resp where budget_group_id = p_budget_group_id;
2614: if (sql%notfound) then
2615: null;
2616: end if;

Line 2708: delete from PSB_BUDGET_GROUPS

2704: end if;
2705: --
2706: p_return_status := FND_API.G_RET_STS_SUCCESS ;
2707: --
2708: delete from PSB_BUDGET_GROUPS
2709: where BUDGET_GROUP_ID = P_BUDGET_GROUP_ID;
2710: if (sql%notfound) then
2711: raise FND_API.G_EXC_ERROR ;
2712: end if;

Line 2774: from psb_budget_groups

2770: ) AS
2771:
2772: Cursor BG_grp_Cur Is
2773: select short_name
2774: from psb_budget_groups
2775: where budget_group_id = p_curr_budget_group_id ;
2776: Bgg_Rec BG_grp_Cur%ROWTYPE;
2777:
2778: Cursor BG_resp_Cur Is

Line 3427: FROM psb_budget_groups_v

3423:
3424: CURSOR c_top_level_bg IS
3425: SELECT budget_group_id,PS_ACCOUNT_POSITION_SET_ID,
3426: NPS_ACCOUNT_POSITION_SET_ID,name,chart_of_accounts_id
3427: FROM psb_budget_groups_v
3428: WHERE root_budget_group = 'Y'
3429: AND (((p_budget_group_id is not null) and
3430: (budget_group_id = p_budget_group_id))
3431: or (p_budget_group_id is null));

Line 3619: PSB_BUDGET_GROUPS d

3615: /*For Bug No : 2359795 End*/
3616: and not exists(select 1
3617: from PSB_BUDGET_ACCOUNTS b,
3618: PSB_SET_RELATIONS_V c,
3619: PSB_BUDGET_GROUPS d
3620: where b.code_combination_id = gcc.code_combination_id
3621: and b.account_position_set_id = c.account_position_set_id
3622: and c.budget_group_id = d.budget_group_id
3623: and (d.budget_group_id = p_top_budget_group_id or

Line 3729: psb_budget_groups_v b

3725: cursor c_Missing_Accounts IS
3726: SELECT a.code_combination_id ccid,b.name bg_name ,s.name set_name
3727: FROM psb_budget_accounts a,
3728: psb_set_relations_v s,
3729: psb_budget_groups_v b
3730: WHERE b.budget_group_id = s.budget_group_id
3731: AND b.budget_group_type = 'R'
3732: AND nvl(b.root_budget_group_id, b.budget_group_id) = p_top_budget_group_id
3733: AND s.account_position_set_id = a.account_position_set_id

Line 3864: FROM psb_budget_groups_v

3860:
3861:
3862: cursor c_Missing_org IS
3863: SELECT budget_group_id ,short_name
3864: FROM psb_budget_groups_v
3865: WHERE budget_group_type = 'R'
3866: AND nvl(root_budget_group_id, budget_group_id) =
3867: p_top_budget_group_id
3868: AND organization_id is null;

Line 3871: FROM psb_budget_groups_v

3867: p_top_budget_group_id
3868: AND organization_id is null;
3869: cursor c_Missing_Top_org IS
3870: SELECT budget_group_id, short_name
3871: FROM psb_budget_groups_v
3872: WHERE budget_group_type = 'R'
3873: AND budget_group_id = p_top_budget_group_id
3874: AND business_group_id is null;
3875:

Line 3879: FROM psb_budget_groups_v bg

3875:
3876:
3877: cursor c_Invalid_ORG IS
3878: SELECT budget_group_id, bg.short_name
3879: FROM psb_budget_groups_v bg
3880: WHERE budget_group_type = 'R'
3881: AND root_budget_group_id = p_top_budget_group_id
3882: AND nvl(root_budget_group,'N') = 'N'
3883: and not exists

Line 4112: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy

4108: --
4109: BEGIN
4110: --
4111:
4112: PSB_BUDGET_GROUPS_PVT.Val_Budget_Group_Hierarchy
4113: (p_api_version => 1.0,
4114: p_init_msg_list => FND_API.G_TRUE,
4115: p_commit => FND_API.G_TRUE,
4116: p_return_status => l_return_status,

Line 4211: PSB_BUDGET_GROUPS_PVT.DELETE_ROW

4207: --
4208: BEGIN
4209: --
4210:
4211: PSB_BUDGET_GROUPS_PVT.DELETE_ROW
4212: (p_api_version => 1.0,
4213: p_init_msg_list => FND_API.G_TRUE,
4214: p_return_status => l_return_status,
4215: p_msg_count => l_msg_count,

Line 4294: PSB_BUDGET_GROUPS_PVT.Account_Overlap_Validation

4290: l_msg_index_out NUMBER;
4291: --
4292: BEGIN
4293: --
4294: PSB_BUDGET_GROUPS_PVT.Account_Overlap_Validation
4295: (p_api_version => 1.0,
4296: p_init_msg_list => FND_API.G_TRUE,
4297: p_return_status => l_return_status,
4298: p_msg_count => l_msg_count,

Line 4377: END PSB_BUDGET_GROUPS_PVT;

4373: /*For Bug No : 2230514 End*/
4374: /* ----------------------------------------------------------------------- */
4375:
4376:
4377: END PSB_BUDGET_GROUPS_PVT;