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

Line 331: PSB_WS_Ops_Pvt.Check_WS_Ops_Concurrency

327: aname => 'OPERATION_TYPE' );
328: --
329: -- API to perform worksheet related concurrency control.
330: --
331: PSB_WS_Ops_Pvt.Check_WS_Ops_Concurrency
332: (
333: p_api_version => 1.0,
334: p_init_msg_list => FND_API.G_FALSE ,
335: p_commit => FND_API.G_FALSE ,

Line 673: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;

669: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
670: l_worksheet_name psb_worksheets.name%TYPE ;
671: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
672: l_current_freeze_flag psb_worksheets.freeze_flag%TYPE ;
673: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;
674:
675: --
676: l_notification_id NUMBER ;
677: l_submitter_name VARCHAR2(80);

Line 693: PSB_WS_Ops_Pvt.Copy_Worksheet

689:
690: --
691: -- Call the API.
692: --
693: PSB_WS_Ops_Pvt.Copy_Worksheet
694: (
695: p_api_version => 1.0 ,
696: p_init_msg_list => FND_API.G_TRUE,
697: p_commit => FND_API.G_FALSE,

Line 775: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;

771: l_merge_to_worksheet_id psb_worksheets.worksheet_id%TYPE ;
772: l_worksheet_name psb_worksheets.name%TYPE ;
773: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
774: l_current_freeze_flag psb_worksheets.freeze_flag%TYPE ;
775: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;
776:
777: --
778: l_notification_id NUMBER ;
779: l_submitter_name VARCHAR2(80);

Line 806: PSB_WS_Ops_Pvt.Merge_Worksheets

802:
803: --
804: -- Call the API.
805: --
806: PSB_WS_Ops_Pvt.Merge_Worksheets
807: (
808: p_api_version => 1.0 ,
809: p_init_msg_list => FND_API.G_TRUE,
810: p_commit => FND_API.G_FALSE,

Line 879: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;

875: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
876: l_worksheet_name psb_worksheets.name%TYPE ;
877: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
878: l_current_freeze_flag psb_worksheets.freeze_flag%TYPE ;
879: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;
880:
881: --
882: l_notification_id NUMBER ;
883: l_submitter_name VARCHAR2(80);

Line 926: PSB_WS_Ops_Pvt.Freeze_Worksheet

922:
923: --
924: -- Freeze the top level worksheet.
925: --
926: PSB_WS_Ops_Pvt.Freeze_Worksheet
927: (
928: p_api_version => 1.0 ,
929: p_init_msg_list => FND_API.G_FALSE,
930: p_commit => FND_API.G_FALSE,

Line 963: PSB_WS_Ops_Pvt.Find_Child_Worksheets

959:
960: --
961: -- Call API to find all lower level worksheets.
962: --
963: PSB_WS_Ops_Pvt.Find_Child_Worksheets
964: (
965: p_api_version => 1.0 ,
966: p_init_msg_list => FND_API.G_FALSE,
967: p_commit => FND_API.G_FALSE,

Line 997: PSB_WS_Ops_Pvt.Freeze_Worksheet

993: WHERE worksheet_id = l_worksheets_tab(i) ;
994:
995: IF l_current_freeze_flag = 'N' THEN
996: --
997: PSB_WS_Ops_Pvt.Freeze_Worksheet
998: (
999: p_api_version => 1.0 ,
1000: p_init_msg_list => FND_API.G_FALSE,
1001: p_commit => FND_API.G_FALSE,

Line 1113: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;

1109: l_msg_data VARCHAR2(2000) ;
1110: --
1111: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1112: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1113: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;
1114: l_operation_id NUMBER ;
1115: l_service_package_count NUMBER ;
1116: --
1117: BEGIN

Line 1148: PSB_WS_Ops_Pvt.Find_Parent_Worksheets

1144: WHERE worksheet_id = l_worksheet_id
1145: AND operation_id = l_operation_id ) ;
1146:
1147: -- Get all parent worksheets for the selected worksheet.
1148: PSB_WS_Ops_Pvt.Find_Parent_Worksheets
1149: (
1150: p_api_version => 1.0 ,
1151: p_init_msg_list => FND_API.G_FALSE,
1152: p_commit => FND_API.G_FALSE,

Line 1346: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;

1342: l_msg_data VARCHAR2(2000) ;
1343: --
1344: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1345: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1346: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;
1347: --
1348: l_notification_id NUMBER ;
1349: l_stage_set_id psb_worksheets.stage_set_id%TYPE ;
1350: l_target_stage_seq psb_worksheets.current_stage_seq%TYPE ;

Line 1402: PSB_WS_Ops_Pvt.Change_Worksheet_Stage

1398:
1399: --
1400: -- Change the stage of the current worksheet.
1401: --
1402: PSB_WS_Ops_Pvt.Change_Worksheet_Stage
1403: (
1404: p_api_version => 1.0 ,
1405: p_init_msg_list => FND_API.G_FALSE,
1406: p_commit => FND_API.G_FALSE,

Line 1426: PSB_WS_Ops_Pvt.Find_Child_Worksheets

1422: --
1423: -- Find all the child worksheets as they may also be advanced to
1424: -- next stages depening on their current stage.
1425: --
1426: PSB_WS_Ops_Pvt.Find_Child_Worksheets
1427: (
1428: p_api_version => 1.0 ,
1429: p_init_msg_list => FND_API.G_FALSE,
1430: p_commit => FND_API.G_FALSE,

Line 1786: l_set_tbl PSB_WS_Ops_Pvt.account_position_set_tbl_type ;

1782: l_account_or_position_type VARCHAR2(1) ;
1783: l_approval_option VARCHAR2(1) ;
1784: l_review_budget_group_id NUMBER ;
1785: l_review_budget_group_name psb_budget_workflow_rules.name%TYPE ;
1786: l_set_tbl PSB_WS_Ops_Pvt.account_position_set_tbl_type ;
1787: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
1788: --For Bug#4475288: Modifying width of l_review_group_approver_name from VARCHAR2(80)
1789: l_review_group_approver_name psb_budget_group_resp.wf_role_name%TYPE ;
1790: l_operation_id NUMBER ;

Line 1958: PSB_WS_Ops_Pvt.Create_Worksheet

1954: --
1955: -- Create a new worksheet for the current review group.
1956: -- ( Rule type 'Account' or 'Positions' )
1957: --
1958: PSB_WS_Ops_Pvt.Create_Worksheet
1959: (
1960: p_api_version => 1.0 ,
1961: p_init_msg_list => FND_API.G_TRUE ,
1962: p_commit => FND_API.G_FALSE ,

Line 1981: PSB_WS_Ops_Pvt.Create_New_Position_Worksheet

1977: --
1978: -- Create a new worksheet for the current review group.
1979: -- ( Rule type 'New Positions' )
1980: --
1981: PSB_WS_Ops_Pvt.Create_New_Position_Worksheet
1982: (
1983: p_api_version => 1.0 ,
1984: p_init_msg_list => FND_API.G_TRUE ,
1985: p_commit => FND_API.G_FALSE ,

Line 2365: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;

2361: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2362: l_worksheet_name psb_worksheets.name%TYPE ;
2363: l_submitter_id NUMBER ;
2364: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2365: l_worksheets_tab PSB_WS_Ops_Pvt.Worksheet_Tbl_Type ;
2366: --
2367: BEGIN
2368: --
2369: IF ( funcmode = 'RUN' ) THEN

Line 2384: PSB_WS_Ops_Pvt.Find_Child_Worksheets

2380:
2381: --
2382: -- Call API to find all lower level worksheets.
2383: --
2384: PSB_WS_Ops_Pvt.Find_Child_Worksheets
2385: (
2386: p_api_version => 1.0 ,
2387: p_init_msg_list => FND_API.G_FALSE,
2388: p_commit => FND_API.G_FALSE,

Line 2616: PSB_WS_Ops_Pvt.Freeze_Worksheet

2612: aname => 'WORKSHEET_ID');
2613: --
2614: -- Unfreeze only the current worksheet.
2615: --
2616: PSB_WS_Ops_Pvt.Freeze_Worksheet
2617: (
2618: p_api_version => 1.0 ,
2619: p_init_msg_list => FND_API.G_FALSE,
2620: p_commit => FND_API.G_FALSE,