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_WORKSHEETS

Line 11: g_worksheet_id psb_worksheets.worksheet_id%TYPE ;

7:
8: --
9: -- CALLBACK procedure related global information.
10: --
11: g_worksheet_id psb_worksheets.worksheet_id%TYPE ;
12: g_worksheet_name psb_worksheets.name%TYPE ;
13: g_budget_group_name psb_budget_groups.name%TYPE ;
14: g_itemtype VARCHAR2(2000) ;
15: g_itemkey VARCHAR2(2000) ;

Line 12: g_worksheet_name psb_worksheets.name%TYPE ;

8: --
9: -- CALLBACK procedure related global information.
10: --
11: g_worksheet_id psb_worksheets.worksheet_id%TYPE ;
12: g_worksheet_name psb_worksheets.name%TYPE ;
13: g_budget_group_name psb_budget_groups.name%TYPE ;
14: g_itemtype VARCHAR2(2000) ;
15: g_itemkey VARCHAR2(2000) ;
16:

Line 49: p_merge_to_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

45: p_submitter_name IN VARCHAR2 ,
46: p_operation_type IN VARCHAR2 ,
47: p_review_group_flag IN VARCHAR2 := 'N',
48: p_orig_system IN VARCHAR2 ,
49: p_merge_to_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
50: p_comments IN VARCHAR2 ,
51: p_operation_id IN NUMBER ,
52: p_constraint_set_id IN NUMBER
53: )

Line 66: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

62: --
63: l_ItemType VARCHAR2(100) := 'PSBWS';
64: l_ItemKey VARCHAR2(240) := p_item_key;
65: --
66: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
67: l_comments VARCHAR2(2000) ;
68: --
69: BEGIN
70: --

Line 221: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

217: result OUT NOCOPY VARCHAR2
218: )
219: IS
220: --
221: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
222: l_worksheet_name psb_worksheets.name%TYPE ;
223: l_budget_group_name psb_budget_groups.name%TYPE ;
224: l_submitter_name VARCHAR2(80);
225: --

Line 222: l_worksheet_name psb_worksheets.name%TYPE ;

218: )
219: IS
220: --
221: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
222: l_worksheet_name psb_worksheets.name%TYPE ;
223: l_budget_group_name psb_budget_groups.name%TYPE ;
224: l_submitter_name VARCHAR2(80);
225: --
226: l_orig_system VARCHAR2(8) ;

Line 248: FROM psb_worksheets_v

244: budget_group_name
245: INTO
246: l_worksheet_name ,
247: l_budget_group_name
248: FROM psb_worksheets_v
249: WHERE worksheet_id = l_worksheet_id;
250:
251: --
252: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 308: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

304: l_return_status VARCHAR2(1) ;
305: l_msg_count NUMBER ;
306: l_msg_data VARCHAR2(2000) ;
307: --
308: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
309: l_operation_type VARCHAR2(20) ;
310: --
311: BEGIN
312:

Line 460: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

456: l_return_status VARCHAR2(1) ;
457: l_msg_count NUMBER ;
458: l_msg_data VARCHAR2(2000) ;
459: --
460: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
461: l_validation_status VARCHAR2(1) ;
462: l_operation_type VARCHAR2(20) ;
463: l_constraint_set_id NUMBER ;
464: --

Line 570: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

566: result OUT NOCOPY VARCHAR2
567: )
568: IS
569: --
570: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
571: l_operation_type VARCHAR2(20) ;
572: --
573: BEGIN
574: --

Line 668: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

664: l_return_status VARCHAR2(1) ;
665: l_msg_count NUMBER ;
666: l_msg_data VARCHAR2(2000) ;
667: --
668: l_worksheet_id psb_worksheets.worksheet_id%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 ;

Line 669: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

665: l_msg_count NUMBER ;
666: l_msg_data VARCHAR2(2000) ;
667: --
668: l_worksheet_id psb_worksheets.worksheet_id%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 ;

Line 670: l_worksheet_name psb_worksheets.name%TYPE ;

666: l_msg_data VARCHAR2(2000) ;
667: --
668: l_worksheet_id psb_worksheets.worksheet_id%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:

Line 671: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

667: --
668: l_worksheet_id psb_worksheets.worksheet_id%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: --

Line 672: l_current_freeze_flag psb_worksheets.freeze_flag%TYPE ;

668: l_worksheet_id psb_worksheets.worksheet_id%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 ;

Line 770: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

766: l_return_status VARCHAR2(1) ;
767: l_msg_count NUMBER ;
768: l_msg_data VARCHAR2(2000) ;
769: --
770: l_worksheet_id psb_worksheets.worksheet_id%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 ;

Line 771: l_merge_to_worksheet_id psb_worksheets.worksheet_id%TYPE ;

767: l_msg_count NUMBER ;
768: l_msg_data VARCHAR2(2000) ;
769: --
770: l_worksheet_id psb_worksheets.worksheet_id%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 ;

Line 772: l_worksheet_name psb_worksheets.name%TYPE ;

768: l_msg_data VARCHAR2(2000) ;
769: --
770: l_worksheet_id psb_worksheets.worksheet_id%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:

Line 773: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

769: --
770: l_worksheet_id psb_worksheets.worksheet_id%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: --

Line 774: l_current_freeze_flag psb_worksheets.freeze_flag%TYPE ;

770: l_worksheet_id psb_worksheets.worksheet_id%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 ;

Line 875: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

871: l_return_status VARCHAR2(1) ;
872: l_msg_count NUMBER ;
873: l_msg_data VARCHAR2(2000) ;
874: --
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 ;

Line 876: l_worksheet_name psb_worksheets.name%TYPE ;

872: l_msg_count NUMBER ;
873: l_msg_data VARCHAR2(2000) ;
874: --
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:

Line 877: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

873: l_msg_data VARCHAR2(2000) ;
874: --
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: --

Line 878: l_current_freeze_flag psb_worksheets.freeze_flag%TYPE ;

874: --
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 ;

Line 916: FROM psb_worksheets_v

912: --
913: -- Setting context for the CALLBACK procedure.
914: --
915: SELECT budget_group_name INTO g_worksheet_name
916: FROM psb_worksheets_v
917: WHERE worksheet_id = l_worksheet_id ;
918:
919: g_worksheet_id := l_worksheet_id ;
920: g_itemtype := itemtype ;

Line 992: FROM psb_worksheets

988: -- Check whether the current worksheet is already frozen or not.
989: -- If already frozen, do not have to do anything.
990: --
991: SELECT NVL(freeze_flag, 'N') INTO l_current_freeze_flag
992: FROM psb_worksheets
993: WHERE worksheet_id = l_worksheets_tab(i) ;
994:
995: IF l_current_freeze_flag = 'N' THEN
996: --

Line 1027: FROM psb_worksheets_v

1023: INTO
1024: l_budget_group_id ,
1025: g_budget_group_name ,
1026: g_worksheet_name
1027: FROM psb_worksheets_v
1028: WHERE worksheet_id = l_worksheets_tab(i) ;
1029:
1030: g_worksheet_id := l_worksheets_tab(i) ;
1031:

Line 1111: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

1107: l_return_status VARCHAR2(1) ;
1108: l_msg_count NUMBER ;
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 ;

Line 1112: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;

1108: l_msg_count NUMBER ;
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: --

Line 1133: FROM psb_worksheets

1129: aname => 'OPERATION_ID');
1130:
1131: -- Check if this is a position worksheet.
1132: SELECT NVL( budget_by_position, 'N') INTO l_budget_by_position
1133: FROM psb_worksheets
1134: WHERE worksheet_id = l_worksheet_id ;
1135:
1136: -- Note when a user starts submission process without clickin on service
1137: -- package button, this means all service packages are being selected

Line 1344: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

1340: l_return_status VARCHAR2(1) ;
1341: l_msg_count NUMBER ;
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 ;

Line 1345: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

1341: l_msg_count NUMBER ;
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 ;

Line 1349: l_stage_set_id psb_worksheets.stage_set_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 ;
1351: l_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
1352: l_operation_id NUMBER ;
1353: --

Line 1350: l_target_stage_seq psb_worksheets.current_stage_seq%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 ;
1351: l_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
1352: l_operation_id NUMBER ;
1353: --
1354: BEGIN

Line 1351: l_current_stage_seq psb_worksheets.current_stage_seq%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 ;
1351: l_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
1352: l_operation_id NUMBER ;
1353: --
1354: BEGIN
1355: --

Line 1381: FROM psb_worksheets

1377: current_stage_seq
1378: INTO
1379: l_stage_set_id ,
1380: l_current_stage_seq
1381: FROM psb_worksheets
1382: WHERE worksheet_id = l_worksheet_id ;
1383:
1384: SELECT MIN (sequence_number) INTO l_target_stage_seq
1385: FROM psb_budget_stages

Line 1454: FROM psb_worksheets

1450: --
1451: -- Find current_stage_seq for the current worksheet.
1452: --
1453: SELECT current_stage_seq INTO l_current_stage_seq
1454: FROM psb_worksheets
1455: WHERE worksheet_id = l_worksheets_tab(i) ;
1456:
1457: --
1458: -- Advance the current worksheet to its next stage only when it is

Line 1491: FROM psb_worksheets

1487: name
1488: INTO
1489: l_budget_group_id ,
1490: g_worksheet_name
1491: FROM psb_worksheets
1492: WHERE worksheet_id = l_worksheets_tab(i) ;
1493:
1494: --
1495: -- Send 'Worksheet Stage Moved' related notifications to the budget

Line 1634: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

1630: IS
1631: --
1632: l_return_status VARCHAR2(1) ;
1633: --
1634: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1635: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1636: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1637: l_root_budget_group_id psb_budget_groups.root_budget_group_id%TYPE ;
1638: l_count NUMBER ;

Line 1635: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

1631: --
1632: l_return_status VARCHAR2(1) ;
1633: --
1634: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1635: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1636: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1637: l_root_budget_group_id psb_budget_groups.root_budget_group_id%TYPE ;
1638: l_count NUMBER ;
1639: --

Line 1636: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

1632: l_return_status VARCHAR2(1) ;
1633: --
1634: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1635: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1636: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1637: l_root_budget_group_id psb_budget_groups.root_budget_group_id%TYPE ;
1638: l_count NUMBER ;
1639: --
1640: BEGIN

Line 1662: FROM psb_worksheets ws ,

1658: INTO
1659: l_budget_group_id ,
1660: l_budget_calendar_id ,
1661: l_root_budget_group_id
1662: FROM psb_worksheets ws ,
1663: psb_budget_groups bg
1664: WHERE worksheet_id = l_worksheet_id
1665: AND ws.budget_group_id = bg.budget_group_id ;
1666:

Line 1777: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

1773: l_return_status VARCHAR2(1) ;
1774: l_msg_count NUMBER ;
1775: l_msg_data VARCHAR2(2000) ;
1776: --
1777: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1778: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1779: l_new_worksheet_name psb_worksheets.name%TYPE ;
1780: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1781: l_budget_workflow_rule_id NUMBER ;

Line 1778: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

1774: l_msg_count NUMBER ;
1775: l_msg_data VARCHAR2(2000) ;
1776: --
1777: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1778: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1779: l_new_worksheet_name psb_worksheets.name%TYPE ;
1780: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1781: l_budget_workflow_rule_id NUMBER ;
1782: l_account_or_position_type VARCHAR2(1) ;

Line 1779: l_new_worksheet_name psb_worksheets.name%TYPE ;

1775: l_msg_data VARCHAR2(2000) ;
1776: --
1777: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1778: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1779: l_new_worksheet_name psb_worksheets.name%TYPE ;
1780: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1781: l_budget_workflow_rule_id NUMBER ;
1782: l_account_or_position_type VARCHAR2(1) ;
1783: l_approval_option VARCHAR2(1) ;

Line 1780: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

1776: --
1777: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1778: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1779: l_new_worksheet_name psb_worksheets.name%TYPE ;
1780: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1781: l_budget_workflow_rule_id NUMBER ;
1782: l_account_or_position_type VARCHAR2(1) ;
1783: l_approval_option VARCHAR2(1) ;
1784: l_review_budget_group_id NUMBER ;

Line 1871: FROM psb_worksheets

1867: --
1868: -- Get budget_group_id for the current worksheet.
1869: --
1870: SELECT budget_group_id INTO l_budget_group_id
1871: FROM psb_worksheets
1872: WHERE worksheet_id = l_worksheet_id ;
1873:
1874: l_loop_visited_counter := l_loop_visited_counter + 1 ;
1875:

Line 2013: FROM psb_worksheets

2009: IF l_new_worksheet_id <> 0 THEN
2010:
2011: -- Find new worksheet name.
2012: SELECT name INTO l_new_worksheet_name
2013: FROM psb_worksheets
2014: WHERE worksheet_id = l_new_worksheet_id ;
2015:
2016: -- Find approvers for the current review group.
2017: SELECT wf_role_name INTO l_review_group_approver_name

Line 2099: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

2095: result OUT NOCOPY VARCHAR2
2096: )
2097: IS
2098: --
2099: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2100: --
2101: BEGIN
2102: --
2103: IF ( funcmode = 'RUN' ) THEN

Line 2361: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

2357: l_return_status VARCHAR2(1) ;
2358: l_msg_count NUMBER ;
2359: l_msg_data VARCHAR2(2000) ;
2360: --
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 ;

Line 2362: l_worksheet_name psb_worksheets.name%TYPE ;

2358: l_msg_count NUMBER ;
2359: l_msg_data VARCHAR2(2000) ;
2360: --
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: --

Line 2364: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

2360: --
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: --

Line 2411: -- Update Distribution related information in psb_worksheets.

2407: --
2408: FOR i IN 0..l_worksheets_tab.COUNT-1
2409: LOOP
2410: --
2411: -- Update Distribution related information in psb_worksheets.
2412: --
2413: PSB_Worksheet_Pvt.Update_Worksheet
2414: (
2415: p_api_version => 1.0 ,

Line 2482: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

2478: result OUT NOCOPY VARCHAR2
2479: )
2480: IS
2481: --
2482: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2483: l_approver_name VARCHAR2(80) ;
2484: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2485: l_notification_group_id NUMBER ;
2486: BEGIN

Line 2484: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;

2480: IS
2481: --
2482: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2483: l_approver_name VARCHAR2(80) ;
2484: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2485: l_notification_group_id NUMBER ;
2486: BEGIN
2487: --
2488: IF ( funcmode = 'RUN' ) THEN

Line 2521: FROM psb_worksheets ws,

2517: --
2518: SELECT bg.parent_budget_group_id
2519: INTO
2520: l_parent_budget_group_id
2521: FROM psb_worksheets ws,
2522: psb_budget_groups bg
2523: WHERE ws.worksheet_id = l_worksheet_id
2524: AND ws.budget_group_id = bg.budget_group_id ;
2525:

Line 2595: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

2591: result OUT NOCOPY VARCHAR2
2592: )
2593: IS
2594: --
2595: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2596: l_worksheet_name psb_worksheets.name%TYPE ;
2597: --
2598: l_return_status VARCHAR2(1) ;
2599: l_msg_count NUMBER ;

Line 2596: l_worksheet_name psb_worksheets.name%TYPE ;

2592: )
2593: IS
2594: --
2595: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2596: l_worksheet_name psb_worksheets.name%TYPE ;
2597: --
2598: l_return_status VARCHAR2(1) ;
2599: l_msg_count NUMBER ;
2600: l_msg_data VARCHAR2(2000) ;

Line 2684: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;

2680: date_value IN OUT NOCOPY DATE
2681: )
2682: IS
2683: --
2684: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2685: l_worksheet_name psb_worksheets.name%TYPE ;
2686: --
2687: l_notification_id NUMBER ;
2688:

Line 2685: l_worksheet_name psb_worksheets.name%TYPE ;

2681: )
2682: IS
2683: --
2684: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2685: l_worksheet_name psb_worksheets.name%TYPE ;
2686: --
2687: l_notification_id NUMBER ;
2688:
2689: BEGIN

Line 2760: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

2756: p_return_status OUT NOCOPY VARCHAR2 ,
2757: p_msg_count OUT NOCOPY NUMBER ,
2758: p_msg_data OUT NOCOPY VARCHAR2 ,
2759: --
2760: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
2761: p_review_group_exists OUT NOCOPY VARCHAR2
2762: )
2763: IS
2764: --

Line 2772: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

2768: l_return_status VARCHAR2(1) ;
2769: l_msg_count NUMBER ;
2770: l_msg_data VARCHAR2(2000) ;
2771: --
2772: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2773: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
2774: l_root_budget_group_id psb_budget_groups.root_budget_group_id%TYPE ;
2775: l_count NUMBER ;
2776: --

Line 2773: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

2769: l_msg_count NUMBER ;
2770: l_msg_data VARCHAR2(2000) ;
2771: --
2772: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2773: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
2774: l_root_budget_group_id psb_budget_groups.root_budget_group_id%TYPE ;
2775: l_count NUMBER ;
2776: --
2777: l_exists VARCHAR2(10);

Line 2811: FROM psb_worksheets ws ,

2807: INTO
2808: l_budget_group_id ,
2809: l_budget_calendar_id ,
2810: l_root_budget_group_id
2811: FROM psb_worksheets ws ,
2812: psb_budget_groups bg
2813: WHERE worksheet_id = p_worksheet_id
2814: AND ws.budget_group_id = bg.budget_group_id ;
2815: