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_WS_OPS_PVT dependencies on PSB_WS_OPS_PVT

Line 1: PACKAGE BODY PSB_WS_Ops_Pvt AS

1: PACKAGE BODY PSB_WS_Ops_Pvt AS
2: /* $Header: PSBVWLOB.pls 120.14 2005/09/02 16:37:06 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WS_Ops_Pvt';
5:

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

1: PACKAGE BODY PSB_WS_Ops_Pvt AS
2: /* $Header: PSBVWLOB.pls 120.14 2005/09/02 16:37:06 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WS_Ops_Pvt';
5:
6: /*--------------------------- Global variables -----------------------------*/
7: g_current_date DATE := sysdate;
8: g_current_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 91: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;

87: l_return_status VARCHAR2(1) ;
88: l_msg_count NUMBER ;
89: l_msg_data VARCHAR2(2000) ;
90: --
91: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;
92: --
93: BEGIN
94: --
95: SAVEPOINT Enforce_WS_Concurrency_Pvt ;

Line 142: PSB_WS_Ops_Pvt.Find_Parent_Worksheets

138: -- parameter.
139: --
140: IF p_parent_or_child_mode = 'PARENT' THEN
141: --
142: PSB_WS_Ops_Pvt.Find_Parent_Worksheets
143: (
144: p_api_version => 1.0 ,
145: p_init_msg_list => FND_API.G_FALSE,
146: p_commit => FND_API.G_FALSE,

Line 158: PSB_WS_Ops_Pvt.Find_Child_Worksheets

154: );
155: --
156: ELSIF p_parent_or_child_mode = 'CHILD' THEN
157: --
158: PSB_WS_Ops_Pvt.Find_Child_Worksheets
159: (
160: p_api_version => 1.0 ,
161: p_init_msg_list => FND_API.G_FALSE,
162: p_commit => FND_API.G_FALSE,

Line 310: PSB_WS_Ops_Pvt.Enforce_WS_Concurrency

306: ELSIF p_operation_type IN ('FREEZE', 'SUBMIT' ) THEN
307: --
308: -- Lock in 'CHILD' mode as the child worksheets also need to be frozen.
309: --
310: PSB_WS_Ops_Pvt.Enforce_WS_Concurrency
311: (
312: p_api_version => 1.0,
313: p_init_msg_list => FND_API.G_FALSE ,
314: p_commit => FND_API.G_FALSE ,

Line 335: PSB_WS_Ops_Pvt.Enforce_WS_Concurrency

331: ELSIF p_operation_type IN ('MOVE') THEN
332: --
333: -- Lock in 'CHILD' mode as the child worksheets are frozen.
334: --
335: PSB_WS_Ops_Pvt.Enforce_WS_Concurrency
336: (
337: p_api_version => 1.0,
338: p_init_msg_list => FND_API.G_FALSE ,
339: p_commit => FND_API.G_FALSE ,

Line 361: PSB_WS_Ops_Pvt.Enforce_WS_Concurrency

357: --
358: -- Also lock in 'PARENT' mode to update their view_flag as per the
359: -- service package selection.
360: --
361: PSB_WS_Ops_Pvt.Enforce_WS_Concurrency
362: (
363: p_api_version => 1.0,
364: p_init_msg_list => FND_API.G_FALSE ,
365: p_commit => FND_API.G_FALSE ,

Line 388: PSB_WS_Ops_Pvt.Enforce_WS_Concurrency

384: -- Lock only the target worksheet in 'PARENT' mode as the changes in
385: -- the source worksheet are to be applied to the target and parent
386: -- worksheets. The targer worksheet is passed as p_worksheet_id.
387: --
388: PSB_WS_Ops_Pvt.Enforce_WS_Concurrency
389: (
390: p_api_version => 1.0,
391: p_init_msg_list => FND_API.G_FALSE,
392: p_commit => FND_API.G_FALSE,

Line 1642: PSB_WS_Ops_Pvt.Create_Local_Dist_Pvt

1638: --
1639: -- Create records in psb_ws_lines and psb_ws_account_lines for the
1640: -- new worksheet.
1641: --
1642: PSB_WS_Ops_Pvt.Create_Local_Dist_Pvt
1643: (
1644: p_account_line_id => l_lines_accts_rec.account_line_id ,
1645: p_new_worksheet_id => l_new_worksheet_id ,
1646: p_new_position_line_id => NULL ,

Line 1723: PSB_WS_Ops_Pvt.Create_Local_Dist_Pvt

1719: WHERE position_line_id = l_lines_pos_rec.position_line_id
1720: )
1721: LOOP
1722: --
1723: PSB_WS_Ops_Pvt.Create_Local_Dist_Pvt
1724: (
1725: p_account_line_id => l_accts_rec.account_line_id ,
1726: p_new_worksheet_id => l_new_worksheet_id ,
1727: p_new_position_line_id => l_new_position_line_id ,

Line 2347: PSB_WS_Ops_Pvt.Add_Worksheet_Line

2343: --
2344: -- Add the account_line to all the worksheets up in the hierarchy.
2345: -- ( The line has already been added in the target worksheet.)
2346: --
2347: PSB_WS_Ops_Pvt.Add_Worksheet_Line
2348: (
2349: p_api_version => 1.0 ,
2350: p_init_msg_list => FND_API.G_FALSE,
2351: p_commit => FND_API.G_FALSE,

Line 2482: PSB_WS_Ops_Pvt.Create_Local_Dist_Pvt

2478: WHERE position_line_id = l_lines_pos_rec.position_line_id
2479: )
2480: LOOP
2481: --
2482: PSB_WS_Ops_Pvt.Create_Local_Dist_Pvt
2483: (
2484: p_account_line_id => l_accts_rec.account_line_id ,
2485: p_new_worksheet_id => p_target_worksheet_id ,
2486: p_new_position_line_id => l_new_position_line_id ,

Line 2518: PSB_WS_Ops_Pvt.Add_Worksheet_Position_Line

2514: --
2515: -- Add the new position line to all the worksheets up in the hierarchy.
2516: -- ( The line has already been added in the target worksheet.)
2517: --
2518: PSB_WS_Ops_Pvt.Add_Worksheet_Position_Line
2519: (
2520: p_api_version => 1.0 ,
2521: p_init_msg_list => FND_API.G_FALSE ,
2522: p_commit => FND_API.G_FALSE ,

Line 2930: PSB_WS_Ops_Pvt.Add_Worksheet_Line

2926: --
2927: -- Add the account_line to all the worksheets up in the hierarchy.
2928: -- ( The line has already been added in the target worksheet.)
2929: --
2930: PSB_WS_Ops_Pvt.Add_Worksheet_Line
2931: (
2932: p_api_version => 1.0 ,
2933: p_init_msg_list => FND_API.G_FALSE,
2934: p_commit => FND_API.G_FALSE,

Line 3324: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;

3320: --
3321: l_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
3322: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
3323: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
3324: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;
3325: --
3326: BEGIN
3327: --
3328: SAVEPOINT Delete_Worksheet ;

Line 3528: PSB_WS_Ops_Pvt.Find_Child_Worksheets

3524: -- p_keep_local_copy_flag parameter is 'N'.
3525: --
3526:
3527: -- Find all the child worksheets.
3528: PSB_WS_Ops_Pvt.Find_Child_Worksheets
3529: (
3530: p_api_version => 1.0 ,
3531: p_init_msg_list => FND_API.G_FALSE,
3532: p_commit => FND_API.G_FALSE,

Line 3842: PSB_WS_Ops_Pvt.Find_Parent_Worksheet

3838: -- Updating the top worksheets in the hierarchy.
3839: --
3840: LOOP
3841: --
3842: PSB_WS_Ops_Pvt.Find_Parent_Worksheet
3843: (
3844: p_api_version => 1.0 ,
3845: p_init_msg_list => FND_API.G_FALSE,
3846: p_commit => FND_API.G_FALSE,

Line 4003: PSB_WS_Ops_Pvt.Add_Worksheet_Line

3999: -- Each account_line_id related to the p_position_line_id needs to be
4000: -- added to all the worksheets up in the hierarchy.
4001: -- ( The line has already been added in the target worksheet.)
4002: --
4003: PSB_WS_Ops_Pvt.Add_Worksheet_Line
4004: (
4005: p_api_version => 1.0 ,
4006: p_init_msg_list => FND_API.G_FALSE,
4007: p_commit => FND_API.G_FALSE,

Line 4327: PSB_WS_Ops_Pvt.Find_Parent_Worksheet

4323: -- Updating the top worksheets in the hierarchy.
4324: --
4325: LOOP
4326: --
4327: PSB_WS_Ops_Pvt.Find_Parent_Worksheet
4328: (
4329: p_api_version => 1.0 ,
4330: p_init_msg_list => FND_API.G_FALSE,
4331: p_commit => FND_API.G_FALSE,

Line 4646: PSB_WS_Ops_Pvt.Find_Parent_Worksheet

4642: IF p_freeze_flag = 'N' AND l_worksheet_type <> 'L' THEN
4643: /* Bug 3664027 End */
4644:
4645: -- Find parent worksheet, if exists.
4646: PSB_WS_Ops_Pvt.Find_Parent_Worksheet
4647: (
4648: p_api_version => 1.0 ,
4649: p_init_msg_list => FND_API.G_FALSE,
4650: p_commit => FND_API.G_FALSE,

Line 5343: PSB_WS_Ops_Pvt.Find_Parent_Worksheet

5339: LOOP
5340: --
5341: -- Find the parent worksheet for the current worksheet.
5342: --
5343: PSB_WS_Ops_Pvt.Find_Parent_Worksheet
5344: (
5345: p_api_version => 1.0 ,
5346: p_init_msg_list => FND_API.G_FALSE,
5347: p_commit => FND_API.G_FALSE,

Line 6543: PSB_WS_Ops_Pvt.Delete_Worksheet

6539: BEGIN
6540: --
6541: SAVEPOINT Delete_Worksheet_CP_Pvt ;
6542: --
6543: PSB_WS_Ops_Pvt.Delete_Worksheet
6544: (
6545: p_api_version => 1.0 ,
6546: p_init_msg_list => FND_API.G_TRUE,
6547: /*For Bug No : 2266309 Start*/

Line 6987: END PSB_WS_Ops_Pvt ;

6983: END Create_New_Position_Worksheet ;
6984: /*---------------------------------------------------------------------------*/
6985:
6986:
6987: END PSB_WS_Ops_Pvt ;