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_WORKSHEETS

Line 18: p_new_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

14:
15: PROCEDURE Create_Local_Dist_Pvt
16: (
17: p_account_line_id IN psb_ws_lines.account_line_id%TYPE ,
18: p_new_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
19: p_new_position_line_id IN psb_ws_lines_positions.position_line_id%TYPE ,
20: p_return_status OUT NOCOPY VARCHAR2
21: ) ;
22:

Line 39: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

35: ) ;
36:
37: PROCEDURE Delete_Worksheet_Pvt
38: (
39: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
40: p_budget_by_position IN psb_worksheets.budget_by_position%TYPE ,
41: p_delete_lines_flag IN VARCHAR2 ,
42: p_return_status OUT NOCOPY VARCHAR2
43: ) ;

Line 40: p_budget_by_position IN psb_worksheets.budget_by_position%TYPE ,

36:
37: PROCEDURE Delete_Worksheet_Pvt
38: (
39: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
40: p_budget_by_position IN psb_worksheets.budget_by_position%TYPE ,
41: p_delete_lines_flag IN VARCHAR2 ,
42: p_return_status OUT NOCOPY VARCHAR2
43: ) ;
44:

Line 78: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

74: p_return_status OUT NOCOPY VARCHAR2 ,
75: p_msg_count OUT NOCOPY NUMBER ,
76: p_msg_data OUT NOCOPY VARCHAR2 ,
77: --
78: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
79: p_parent_or_child_mode IN VARCHAR2 ,
80: p_maintenance_mode IN VARCHAR2 := 'MAINTENANCE'
81: )
82: IS

Line 267: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

263: p_return_status OUT NOCOPY VARCHAR2 ,
264: p_msg_count OUT NOCOPY NUMBER ,
265: p_msg_data OUT NOCOPY VARCHAR2 ,
266: --
267: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
268: p_operation_type IN VARCHAR2
269: )
270: IS
271: --

Line 505: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

501: p_return_status OUT NOCOPY VARCHAR2 ,
502: p_msg_count OUT NOCOPY NUMBER ,
503: p_msg_data OUT NOCOPY VARCHAR2 ,
504: --
505: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
506: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
507: p_account_position_set_tbl IN account_position_set_tbl_type ,
508: p_service_package_operation_id
509: IN NUMBER := FND_API.G_MISS_NUM ,

Line 506: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,

502: p_msg_count OUT NOCOPY NUMBER ,
503: p_msg_data OUT NOCOPY VARCHAR2 ,
504: --
505: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
506: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
507: p_account_position_set_tbl IN account_position_set_tbl_type ,
508: p_service_package_operation_id
509: IN NUMBER := FND_API.G_MISS_NUM ,
510: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

Line 510: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

506: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
507: p_account_position_set_tbl IN account_position_set_tbl_type ,
508: p_service_package_operation_id
509: IN NUMBER := FND_API.G_MISS_NUM ,
510: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
511: )
512: IS
513: --
514: l_api_name CONSTANT VARCHAR2(30) := 'Create_Worksheet(Set)' ;

Line 521: l_worksheet_name psb_worksheets.name%TYPE ;

517: l_return_status VARCHAR2(1) ;
518: l_msg_count NUMBER ;
519: l_msg_data VARCHAR2(2000) ;
520: --
521: l_worksheet_name psb_worksheets.name%TYPE ;
522: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
523: l_worksheet_description psb_worksheets.description%TYPE ;
524: l_main_worksheet_name psb_worksheets.name%TYPE ;
525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;

Line 522: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;

518: l_msg_count NUMBER ;
519: l_msg_data VARCHAR2(2000) ;
520: --
521: l_worksheet_name psb_worksheets.name%TYPE ;
522: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
523: l_worksheet_description psb_worksheets.description%TYPE ;
524: l_main_worksheet_name psb_worksheets.name%TYPE ;
525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
526: l_main_budget_group_name psb_budget_groups.name%TYPE ;

Line 523: l_worksheet_description psb_worksheets.description%TYPE ;

519: l_msg_data VARCHAR2(2000) ;
520: --
521: l_worksheet_name psb_worksheets.name%TYPE ;
522: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
523: l_worksheet_description psb_worksheets.description%TYPE ;
524: l_main_worksheet_name psb_worksheets.name%TYPE ;
525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
526: l_main_budget_group_name psb_budget_groups.name%TYPE ;
527: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

Line 524: l_main_worksheet_name psb_worksheets.name%TYPE ;

520: --
521: l_worksheet_name psb_worksheets.name%TYPE ;
522: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
523: l_worksheet_description psb_worksheets.description%TYPE ;
524: l_main_worksheet_name psb_worksheets.name%TYPE ;
525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
526: l_main_budget_group_name psb_budget_groups.name%TYPE ;
527: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
528: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;

521: l_worksheet_name psb_worksheets.name%TYPE ;
522: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
523: l_worksheet_description psb_worksheets.description%TYPE ;
524: l_main_worksheet_name psb_worksheets.name%TYPE ;
525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
526: l_main_budget_group_name psb_budget_groups.name%TYPE ;
527: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
528: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
529: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 527: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

523: l_worksheet_description psb_worksheets.description%TYPE ;
524: l_main_worksheet_name psb_worksheets.name%TYPE ;
525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
526: l_main_budget_group_name psb_budget_groups.name%TYPE ;
527: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
528: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
529: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
530: l_service_package_count NUMBER ;
531: --

Line 528: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

524: l_main_worksheet_name psb_worksheets.name%TYPE ;
525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
526: l_main_budget_group_name psb_budget_groups.name%TYPE ;
527: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
528: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
529: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
530: l_service_package_count NUMBER ;
531: --
532: l_tmp_char VARCHAR2(1) ;

Line 529: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

525: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
526: l_main_budget_group_name psb_budget_groups.name%TYPE ;
527: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
528: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
529: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
530: l_service_package_count NUMBER ;
531: --
532: l_tmp_char VARCHAR2(1) ;
533: l_lines_added NUMBER := 0 ;

Line 537: FROM psb_worksheets

533: l_lines_added NUMBER := 0 ;
534: --
535: CURSOR l_worksheets_csr IS
536: SELECT *
537: FROM psb_worksheets
538: WHERE worksheet_id = p_worksheet_id ;
539: --
540: l_worksheets_rec l_worksheets_csr%ROWTYPE ;
541: --

Line 654: -- Create the new worksheet in psb_worksheets table.

650: l_global_worksheet_id := l_worksheets_rec.global_worksheet_id ;
651: END IF ;
652:
653: --
654: -- Create the new worksheet in psb_worksheets table.
655: --
656: PSB_Worksheet_Pvt.Create_Worksheet
657: (
658: p_api_version => 1.0 ,

Line 1042: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

1038: p_return_status OUT NOCOPY VARCHAR2 ,
1039: p_msg_count OUT NOCOPY NUMBER ,
1040: p_msg_data OUT NOCOPY VARCHAR2 ,
1041: --
1042: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
1043: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
1044: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
1045: )
1046:

Line 1043: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,

1039: p_msg_count OUT NOCOPY NUMBER ,
1040: p_msg_data OUT NOCOPY VARCHAR2 ,
1041: --
1042: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
1043: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
1044: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
1045: )
1046:
1047: IS

Line 1044: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

1040: p_msg_data OUT NOCOPY VARCHAR2 ,
1041: --
1042: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
1043: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
1044: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
1045: )
1046:
1047: IS
1048: --

Line 1056: l_worksheet_name psb_worksheets.name%TYPE ;

1052: l_return_status VARCHAR2(1) ;
1053: l_msg_count NUMBER ;
1054: l_msg_data VARCHAR2(2000) ;
1055: --
1056: l_worksheet_name psb_worksheets.name%TYPE ;
1057: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1058: l_worksheet_description psb_worksheets.description%TYPE ;
1059: l_main_worksheet_name psb_worksheets.name%TYPE ;
1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;

Line 1057: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;

1053: l_msg_count NUMBER ;
1054: l_msg_data VARCHAR2(2000) ;
1055: --
1056: l_worksheet_name psb_worksheets.name%TYPE ;
1057: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1058: l_worksheet_description psb_worksheets.description%TYPE ;
1059: l_main_worksheet_name psb_worksheets.name%TYPE ;
1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1061: l_main_budget_group_name psb_budget_groups.name%TYPE ;

Line 1058: l_worksheet_description psb_worksheets.description%TYPE ;

1054: l_msg_data VARCHAR2(2000) ;
1055: --
1056: l_worksheet_name psb_worksheets.name%TYPE ;
1057: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1058: l_worksheet_description psb_worksheets.description%TYPE ;
1059: l_main_worksheet_name psb_worksheets.name%TYPE ;
1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1061: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1062: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

Line 1059: l_main_worksheet_name psb_worksheets.name%TYPE ;

1055: --
1056: l_worksheet_name psb_worksheets.name%TYPE ;
1057: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1058: l_worksheet_description psb_worksheets.description%TYPE ;
1059: l_main_worksheet_name psb_worksheets.name%TYPE ;
1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1061: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1062: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1063: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;

1056: l_worksheet_name psb_worksheets.name%TYPE ;
1057: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1058: l_worksheet_description psb_worksheets.description%TYPE ;
1059: l_main_worksheet_name psb_worksheets.name%TYPE ;
1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1061: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1062: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1063: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1064: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 1062: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

1058: l_worksheet_description psb_worksheets.description%TYPE ;
1059: l_main_worksheet_name psb_worksheets.name%TYPE ;
1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1061: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1062: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1063: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1064: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1065: --
1066: l_tmp_char VARCHAR2(1) ;

Line 1063: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

1059: l_main_worksheet_name psb_worksheets.name%TYPE ;
1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1061: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1062: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1063: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1064: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1065: --
1066: l_tmp_char VARCHAR2(1) ;
1067: --

Line 1064: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

1060: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1061: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1062: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1063: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1064: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1065: --
1066: l_tmp_char VARCHAR2(1) ;
1067: --
1068: CURSOR l_worksheets_csr IS

Line 1070: FROM psb_worksheets

1066: l_tmp_char VARCHAR2(1) ;
1067: --
1068: CURSOR l_worksheets_csr IS
1069: SELECT *
1070: FROM psb_worksheets
1071: WHERE worksheet_id = p_worksheet_id ;
1072: --
1073: l_ws_row_type l_worksheets_csr%ROWTYPE ;
1074: --

Line 1149: -- Create the new worksheet in psb_worksheets table.

1145: l_global_worksheet_id := l_ws_row_type.global_worksheet_id ;
1146: END IF ;
1147:
1148: --
1149: -- Create the new worksheet in psb_worksheets table.
1150: --
1151: PSB_Worksheet_Pvt.Create_Worksheet
1152: (
1153: p_api_version => 1.0 ,

Line 1457: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

1453: p_return_status OUT NOCOPY VARCHAR2 ,
1454: p_msg_count OUT NOCOPY NUMBER ,
1455: p_msg_data OUT NOCOPY VARCHAR2 ,
1456: --
1457: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
1458: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
1459: )
1460:
1461: IS

Line 1458: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

1454: p_msg_count OUT NOCOPY NUMBER ,
1455: p_msg_data OUT NOCOPY VARCHAR2 ,
1456: --
1457: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
1458: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
1459: )
1460:
1461: IS
1462: --

Line 1470: l_worksheet_name psb_worksheets.name%TYPE ;

1466: l_return_status VARCHAR2(1) ;
1467: l_msg_count NUMBER ;
1468: l_msg_data VARCHAR2(2000) ;
1469: --
1470: l_worksheet_name psb_worksheets.name%TYPE ;
1471: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1472: l_worksheet_description psb_worksheets.description%TYPE ;
1473: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1474: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 1471: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;

1467: l_msg_count NUMBER ;
1468: l_msg_data VARCHAR2(2000) ;
1469: --
1470: l_worksheet_name psb_worksheets.name%TYPE ;
1471: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1472: l_worksheet_description psb_worksheets.description%TYPE ;
1473: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1474: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1475: l_new_position_line_id psb_ws_lines_positions.position_line_id%TYPE ;

Line 1472: l_worksheet_description psb_worksheets.description%TYPE ;

1468: l_msg_data VARCHAR2(2000) ;
1469: --
1470: l_worksheet_name psb_worksheets.name%TYPE ;
1471: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1472: l_worksheet_description psb_worksheets.description%TYPE ;
1473: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1474: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1475: l_new_position_line_id psb_ws_lines_positions.position_line_id%TYPE ;
1476: l_new_fte_line_id psb_ws_fte_lines.fte_line_id%TYPE ;

Line 1474: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

1470: l_worksheet_name psb_worksheets.name%TYPE ;
1471: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
1472: l_worksheet_description psb_worksheets.description%TYPE ;
1473: l_main_budget_group_name psb_budget_groups.name%TYPE ;
1474: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1475: l_new_position_line_id psb_ws_lines_positions.position_line_id%TYPE ;
1476: l_new_fte_line_id psb_ws_fte_lines.fte_line_id%TYPE ;
1477: l_new_element_line_id psb_ws_element_lines.element_line_id%TYPE ;
1478: l_new_position_assignment_id

Line 1489: FROM psb_worksheets

1485: l_dummy_account_line_id psb_ws_account_lines.account_line_id%TYPE ;
1486: --
1487: CURSOR l_worksheets_csr IS
1488: SELECT *
1489: FROM psb_worksheets
1490: WHERE worksheet_id = p_worksheet_id ;
1491: --
1492: l_ws_row_type l_worksheets_csr%ROWTYPE ;
1493: --

Line 1557: -- Create the new worksheet in psb_worksheets table.

1553: Fnd_Message.Set_Token( 'BUDGET_GROUP_NAME', l_main_budget_group_name ) ;
1554: l_worksheet_description := Fnd_Message.Get ;
1555:
1556: --
1557: -- Create the new worksheet in psb_worksheets table.
1558: --
1559: PSB_Worksheet_Pvt.Create_Worksheet
1560: (
1561: p_api_version => 1.0 ,

Line 2046: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

2042: p_return_status OUT NOCOPY VARCHAR2 ,
2043: p_msg_count OUT NOCOPY NUMBER ,
2044: p_msg_data OUT NOCOPY VARCHAR2 ,
2045: --
2046: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
2047: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
2048: )
2049: IS
2050: --

Line 2047: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE

2043: p_msg_count OUT NOCOPY NUMBER ,
2044: p_msg_data OUT NOCOPY VARCHAR2 ,
2045: --
2046: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
2047: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
2048: )
2049: IS
2050: --
2051: l_api_name CONSTANT VARCHAR2(30) := 'Merge_Worksheets';

Line 2058: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;

2054: l_return_status VARCHAR2(1) ;
2055: l_msg_count NUMBER ;
2056: l_msg_data VARCHAR2(2000) ;
2057: --
2058: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2059: l_source_copy_of_worksheet_id psb_worksheets.budget_group_id%TYPE ;
2060: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2061: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
2062: l_source_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;

Line 2059: l_source_copy_of_worksheet_id psb_worksheets.budget_group_id%TYPE ;

2055: l_msg_count NUMBER ;
2056: l_msg_data VARCHAR2(2000) ;
2057: --
2058: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2059: l_source_copy_of_worksheet_id psb_worksheets.budget_group_id%TYPE ;
2060: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2061: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
2062: l_source_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2063: --

Line 2060: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;

2056: l_msg_data VARCHAR2(2000) ;
2057: --
2058: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2059: l_source_copy_of_worksheet_id psb_worksheets.budget_group_id%TYPE ;
2060: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2061: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
2062: l_source_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2063: --
2064: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;

Line 2061: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;

2057: --
2058: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2059: l_source_copy_of_worksheet_id psb_worksheets.budget_group_id%TYPE ;
2060: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2061: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
2062: l_source_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2063: --
2064: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2065: l_target_freeze_flag psb_worksheets.freeze_flag%TYPE ;

Line 2062: l_source_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;

2058: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2059: l_source_copy_of_worksheet_id psb_worksheets.budget_group_id%TYPE ;
2060: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2061: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
2062: l_source_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2063: --
2064: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2065: l_target_freeze_flag psb_worksheets.freeze_flag%TYPE ;
2066: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;

Line 2064: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;

2060: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2061: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
2062: l_source_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2063: --
2064: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2065: l_target_freeze_flag psb_worksheets.freeze_flag%TYPE ;
2066: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2067: l_target_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2068: l_target_account_line_id psb_ws_account_lines.account_line_id%TYPE ;

Line 2065: l_target_freeze_flag psb_worksheets.freeze_flag%TYPE ;

2061: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
2062: l_source_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2063: --
2064: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2065: l_target_freeze_flag psb_worksheets.freeze_flag%TYPE ;
2066: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2067: l_target_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2068: l_target_account_line_id psb_ws_account_lines.account_line_id%TYPE ;
2069: l_target_position_line_id psb_ws_lines_positions.position_line_id%TYPE;

Line 2066: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;

2062: l_source_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2063: --
2064: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2065: l_target_freeze_flag psb_worksheets.freeze_flag%TYPE ;
2066: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2067: l_target_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2068: l_target_account_line_id psb_ws_account_lines.account_line_id%TYPE ;
2069: l_target_position_line_id psb_ws_lines_positions.position_line_id%TYPE;
2070: l_target_position_id psb_ws_position_lines.position_id%TYPE;

Line 2067: l_target_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;

2063: --
2064: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2065: l_target_freeze_flag psb_worksheets.freeze_flag%TYPE ;
2066: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
2067: l_target_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
2068: l_target_account_line_id psb_ws_account_lines.account_line_id%TYPE ;
2069: l_target_position_line_id psb_ws_lines_positions.position_line_id%TYPE;
2070: l_target_position_id psb_ws_position_lines.position_id%TYPE;
2071: --

Line 2079: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;

2075: l_new_position_assignment_id
2076: psb_position_assignments.position_assignment_id%TYPE ;
2077: l_rowid VARCHAR2(2000);
2078: --
2079: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2080: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2081: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
2082: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
2083: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;

Line 2080: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

2076: psb_position_assignments.position_assignment_id%TYPE ;
2077: l_rowid VARCHAR2(2000);
2078: --
2079: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2080: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2081: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
2082: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
2083: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
2084: l_segment_values_tbl FND_FLEX_EXT.SegmentArray ;

Line 2081: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;

2077: l_rowid VARCHAR2(2000);
2078: --
2079: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2080: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
2081: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
2082: l_period_amount_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
2083: l_period_fte_tbl PSB_WS_Acct1.g_prdamt_tbl_type ;
2084: l_segment_values_tbl FND_FLEX_EXT.SegmentArray ;
2085: --

Line 2143: FROM psb_worksheets

2139: l_source_budget_group_id ,
2140: l_source_budget_by_position ,
2141: l_source_copy_of_worksheet_id ,
2142: l_source_current_stage_seq
2143: FROM psb_worksheets
2144: WHERE worksheet_id = p_source_worksheet_id ;
2145:
2146:
2147: SELECT budget_group_id ,

Line 2158: FROM psb_worksheets

2154: l_target_current_stage_seq ,
2155: l_target_freeze_flag ,
2156: l_global_worksheet_id ,
2157: l_global_worksheet_flag
2158: FROM psb_worksheets
2159: WHERE worksheet_id = p_target_worksheet_id ;
2160:
2161: --
2162: -- Find global worksheet information for the target worksheet, used

Line 3309: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

3305: p_return_status OUT NOCOPY VARCHAR2 ,
3306: p_msg_count OUT NOCOPY NUMBER ,
3307: p_msg_data OUT NOCOPY VARCHAR2 ,
3308: --
3309: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
3310: p_keep_local_copy_flag IN VARCHAR2 := 'N'
3311: )
3312: IS
3313: --

Line 3321: l_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;

3317: l_return_status VARCHAR2(1) ;
3318: l_msg_count NUMBER ;
3319: l_msg_data VARCHAR2(2000) ;
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: --

Line 3322: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;

3318: l_msg_count NUMBER ;
3319: l_msg_data VARCHAR2(2000) ;
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

Line 3323: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;

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

Line 3353: FROM psb_worksheets

3349: INTO
3350: l_global_worksheet_flag ,
3351: l_local_copy_flag ,
3352: l_budget_by_position
3353: FROM psb_worksheets
3354: WHERE worksheet_id = p_worksheet_id ;
3355:
3356: --
3357: -- Take action bases on the type of the worksheet.

Line 3371: FROM psb_worksheets

3367: -- Find all related worksheets.
3368: FOR l_worksheet_rec IN
3369: (
3370: SELECT worksheet_id
3371: FROM psb_worksheets
3372: WHERE global_worksheet_id = p_worksheet_id
3373: AND NVL( global_worksheet_flag, 'N' ) = 'N'
3374: )
3375: LOOP

Line 3403: FROM psb_worksheets

3399: -- Delete all the child official worksheets.
3400: FOR l_worksheet_rec IN
3401: (
3402: SELECT worksheet_id, budget_by_position
3403: FROM psb_worksheets
3404: WHERE global_worksheet_id = p_worksheet_id
3405: AND NVL( global_worksheet_flag, 'N' ) = 'N'
3406: AND NVL( local_copy_flag, 'N' ) = 'N'
3407: )

Line 3430: FROM psb_worksheets

3426: -- Delete or update all the child local worksheets.
3427: FOR l_worksheet_rec IN
3428: (
3429: SELECT worksheet_id, budget_by_position
3430: FROM psb_worksheets
3431: WHERE global_worksheet_id = p_worksheet_id
3432: AND NVL( global_worksheet_flag, 'N' ) = 'N'
3433: AND NVL( local_copy_flag, 'N' ) = 'Y'
3434: )

Line 3588: FROM psb_worksheets

3584:
3585: FOR l_local_ws_rec IN
3586: (
3587: SELECT worksheet_id
3588: FROM psb_worksheets
3589: WHERE copy_of_worksheet_id = l_worksheets_tab(i)
3590: )
3591: LOOP
3592:

Line 3649: FROM psb_worksheets

3645:
3646: FOR l_local_ws_rec IN
3647: (
3648: SELECT worksheet_id
3649: FROM psb_worksheets
3650: WHERE copy_of_worksheet_id = l_worksheets_tab(i)
3651: )
3652: LOOP
3653:

Line 3743: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

3739: p_return_status OUT NOCOPY VARCHAR2 ,
3740: p_msg_count OUT NOCOPY NUMBER ,
3741: p_msg_data OUT NOCOPY VARCHAR2 ,
3742: --
3743: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
3744: p_account_line_id IN psb_ws_account_lines.account_line_id%TYPE,
3745: p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE
3746: )
3747: IS

Line 3764: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;

3760: WHERE account_line_id = p_account_line_id ;
3761: --
3762: l_ws_lines_row_type l_ws_lines_csr%ROWTYPE ;
3763: --
3764: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3765: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3766: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3767: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3768: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 3765: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;

3761: --
3762: l_ws_lines_row_type l_ws_lines_csr%ROWTYPE ;
3763: --
3764: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3765: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3766: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3767: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3768: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3769: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE ;

Line 3766: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

3762: l_ws_lines_row_type l_ws_lines_csr%ROWTYPE ;
3763: --
3764: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3765: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3766: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3767: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3768: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3769: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE ;
3770:

Line 3767: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;

3763: --
3764: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3765: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3766: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3767: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3768: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3769: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE ;
3770:
3771: BEGIN

Line 3768: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;

3764: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3765: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3766: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3767: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
3768: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
3769: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE ;
3770:
3771: BEGIN
3772: --

Line 4098: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;

4094: l_return_status VARCHAR2(1) ;
4095: l_msg_count NUMBER ;
4096: l_msg_data VARCHAR2(2000) ;
4097: --
4098: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4099: --
4100: CURSOR l_ws_lines_csr
4101: IS
4102: SELECT *

Line 4226: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

4222: p_return_status OUT NOCOPY VARCHAR2 ,
4223: p_msg_count OUT NOCOPY NUMBER ,
4224: p_msg_data OUT NOCOPY VARCHAR2 ,
4225: --
4226: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
4227: p_position_line_id IN psb_ws_position_lines.position_line_id%TYPE,
4228: p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE
4229: )
4230: IS

Line 4248: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;

4244: --
4245: l_ws_lines_positions_row_type
4246: l_ws_lines_positions_csr%ROWTYPE ;
4247: --
4248: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4249: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4250: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4251: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4252: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 4249: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;

4245: l_ws_lines_positions_row_type
4246: l_ws_lines_positions_csr%ROWTYPE ;
4247: --
4248: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4249: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4250: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4251: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4252: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4253: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE;

Line 4250: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

4246: l_ws_lines_positions_csr%ROWTYPE ;
4247: --
4248: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4249: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4250: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4251: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4252: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4253: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE;
4254:

Line 4251: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;

4247: --
4248: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4249: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4250: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4251: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4252: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4253: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE;
4254:
4255: BEGIN

Line 4252: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;

4248: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4249: l_current_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4250: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4251: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
4252: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4253: l_distribution_id psb_ws_distribution_details.distribution_id%TYPE;
4254:
4255: BEGIN
4256: --

Line 4453: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;

4449: l_return_status VARCHAR2(1) ;
4450: l_msg_count NUMBER ;
4451: l_msg_data VARCHAR2(2000) ;
4452: --
4453: l_current_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4454: --
4455: CURSOR l_ws_lines_positions_csr
4456: IS
4457: SELECT *

Line 4580: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

4576: p_return_status OUT NOCOPY VARCHAR2 ,
4577: p_msg_count OUT NOCOPY NUMBER ,
4578: p_msg_data OUT NOCOPY VARCHAR2 ,
4579: --
4580: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
4581: p_freeze_flag IN psb_ws_lines.freeze_flag%TYPE
4582: )
4583: IS
4584: --

Line 4588: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;

4584: --
4585: l_api_name CONSTANT VARCHAR2(30) := 'Freeze_Worksheet' ;
4586: l_api_version CONSTANT NUMBER := 1.0 ;
4587: --
4588: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
4589: l_return_status VARCHAR2(1) ;
4590: l_msg_count NUMBER ;
4591: l_msg_data VARCHAR2(2000) ;
4592: --

Line 4593: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;

4589: l_return_status VARCHAR2(1) ;
4590: l_msg_count NUMBER ;
4591: l_msg_data VARCHAR2(2000) ;
4592: --
4593: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4594: l_parent_freeze_flag psb_worksheets.freeze_flag%TYPE ;
4595: l_worksheet_type VARCHAR2(1);
4596: --
4597:

Line 4594: l_parent_freeze_flag psb_worksheets.freeze_flag%TYPE ;

4590: l_msg_count NUMBER ;
4591: l_msg_data VARCHAR2(2000) ;
4592: --
4593: l_parent_worksheet_id psb_worksheets.worksheet_id%TYPE ;
4594: l_parent_freeze_flag psb_worksheets.freeze_flag%TYPE ;
4595: l_worksheet_type VARCHAR2(1);
4596: --
4597:
4598: -- bug start 3970347

Line 4599: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE;

4595: l_worksheet_type VARCHAR2(1);
4596: --
4597:
4598: -- bug start 3970347
4599: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE;
4600: l_gl_cutoff_period psb_worksheets.gl_cutoff_period%TYPE := NULL;
4601: -- bug end 3970347
4602:
4603: BEGIN

Line 4600: l_gl_cutoff_period psb_worksheets.gl_cutoff_period%TYPE := NULL;

4596: --
4597:
4598: -- bug start 3970347
4599: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE;
4600: l_gl_cutoff_period psb_worksheets.gl_cutoff_period%TYPE := NULL;
4601: -- bug end 3970347
4602:
4603: BEGIN
4604: --

Line 4639: FROM psb_worksheets

4635: INTO l_worksheet_type,
4636: -- bug start 3970347
4637: l_global_worksheet_flag
4638: -- bug end 3970347
4639: FROM psb_worksheets
4640: WHERE worksheet_id = p_worksheet_id;
4641:
4642: IF p_freeze_flag = 'N' AND l_worksheet_type <> 'L' THEN
4643: /* Bug 3664027 End */

Line 4670: FROM psb_worksheets

4666: -- Check the freeze_flag for the parent worksheet.
4667: IF l_parent_worksheet_id <> 0 THEN
4668:
4669: SELECT NVL(freeze_flag, 'N') INTO l_parent_freeze_flag
4670: FROM psb_worksheets
4671: WHERE worksheet_id = l_parent_worksheet_id ;
4672:
4673: IF l_parent_freeze_flag = 'Y' THEN
4674:

Line 4687: -- Update freeze_flag in psb_worksheets.

4683: END IF ;
4684: -- End validating the parent worksheet for unfreeze operation.
4685:
4686: --
4687: -- Update freeze_flag in psb_worksheets.
4688: --
4689:
4690: /* bug start 3970347 */
4691: -- check if the worksheet is global worksheet. If global, then

Line 4695: FROM psb_worksheets

4691: -- check if the worksheet is global worksheet. If global, then
4692: -- pass the gl cutoff date otherwise pass null
4693: IF l_global_worksheet_flag = 'Y' THEN
4694: FOR l_gl_cutoff_period_rec IN (SELECT gl_cutoff_period
4695: FROM psb_worksheets
4696: WHERE worksheet_id = p_worksheet_id)
4697: LOOP
4698: l_gl_cutoff_period := l_gl_cutoff_period_rec.gl_cutoff_period;
4699: END LOOP;

Line 4737: FROM psb_worksheets

4733:
4734:
4735: -- Get position budgeting flag.
4736: SELECT NVL(budget_by_position, 'N') INTO l_budget_by_position
4737: FROM psb_worksheets
4738: WHERE worksheet_id = p_worksheet_id ;
4739:
4740:
4741: IF l_budget_by_position = 'Y' THEN

Line 4807: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

4803: p_return_status OUT NOCOPY VARCHAR2 ,
4804: p_msg_count OUT NOCOPY NUMBER ,
4805: p_msg_data OUT NOCOPY VARCHAR2 ,
4806: --
4807: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
4808: p_stage_seq IN psb_worksheets.current_stage_seq%TYPE
4809: := FND_API.G_MISS_NUM ,
4810: p_operation_id IN NUMBER := FND_API.G_MISS_NUM
4811: )

Line 4808: p_stage_seq IN psb_worksheets.current_stage_seq%TYPE

4804: p_msg_count OUT NOCOPY NUMBER ,
4805: p_msg_data OUT NOCOPY VARCHAR2 ,
4806: --
4807: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
4808: p_stage_seq IN psb_worksheets.current_stage_seq%TYPE
4809: := FND_API.G_MISS_NUM ,
4810: p_operation_id IN NUMBER := FND_API.G_MISS_NUM
4811: )
4812: IS

Line 4821: l_stage_set_id psb_worksheets.stage_set_id%TYPE ;

4817: l_return_status VARCHAR2(1) ;
4818: l_msg_count NUMBER ;
4819: l_msg_data VARCHAR2(2000) ;
4820: --
4821: l_stage_set_id psb_worksheets.stage_set_id%TYPE ;
4822: l_target_stage_seq psb_worksheets.current_stage_seq%TYPE ;
4823: l_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
4824: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
4825: l_service_package_count NUMBER ;

Line 4822: l_target_stage_seq psb_worksheets.current_stage_seq%TYPE ;

4818: l_msg_count NUMBER ;
4819: l_msg_data VARCHAR2(2000) ;
4820: --
4821: l_stage_set_id psb_worksheets.stage_set_id%TYPE ;
4822: l_target_stage_seq psb_worksheets.current_stage_seq%TYPE ;
4823: l_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
4824: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
4825: l_service_package_count NUMBER ;
4826: --

Line 4823: l_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;

4819: l_msg_data VARCHAR2(2000) ;
4820: --
4821: l_stage_set_id psb_worksheets.stage_set_id%TYPE ;
4822: l_target_stage_seq psb_worksheets.current_stage_seq%TYPE ;
4823: l_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
4824: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
4825: l_service_package_count NUMBER ;
4826: --
4827:

Line 4824: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;

4820: --
4821: l_stage_set_id psb_worksheets.stage_set_id%TYPE ;
4822: l_target_stage_seq psb_worksheets.current_stage_seq%TYPE ;
4823: l_current_stage_seq psb_worksheets.current_stage_seq%TYPE ;
4824: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
4825: l_service_package_count NUMBER ;
4826: --
4827:
4828: -- bug start 3970347

Line 4829: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE;

4825: l_service_package_count NUMBER ;
4826: --
4827:
4828: -- bug start 3970347
4829: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE;
4830: l_gl_cutoff_period psb_worksheets.gl_cutoff_period%TYPE;
4831: -- bug end 3970347
4832:
4833: BEGIN

Line 4830: l_gl_cutoff_period psb_worksheets.gl_cutoff_period%TYPE;

4826: --
4827:
4828: -- bug start 3970347
4829: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE;
4830: l_gl_cutoff_period psb_worksheets.gl_cutoff_period%TYPE;
4831: -- bug end 3970347
4832:
4833: BEGIN
4834: --

Line 4856: -- get the global worksheet flag from psb_worksheets table

4852: -- Get position budgeting flag.
4853:
4854: SELECT NVL( budget_by_position, 'N') ,
4855: /* bug start 3970347 */
4856: -- get the global worksheet flag from psb_worksheets table
4857: global_worksheet_flag
4858: /* bug end 3970347 */
4859: INTO l_budget_by_position ,
4860: /* bug start 3970347 */

Line 4863: FROM psb_worksheets

4859: INTO l_budget_by_position ,
4860: /* bug start 3970347 */
4861: l_global_worksheet_flag
4862: /* bug end 3970347 */
4863: FROM psb_worksheets
4864: WHERE worksheet_id = p_worksheet_id ;
4865:
4866: IF ( p_stage_seq = FND_API.G_MISS_NUM ) OR ( p_stage_seq IS NULL) THEN
4867:

Line 4876: FROM psb_worksheets

4872: current_stage_seq
4873: INTO
4874: l_stage_set_id ,
4875: l_current_stage_seq
4876: FROM psb_worksheets
4877: WHERE worksheet_id = p_worksheet_id ;
4878:
4879: SELECT MIN (sequence_number) INTO l_target_stage_seq
4880: FROM psb_budget_stages

Line 4898: -- Updating the psb_worksheets.

4894: RETURN ;
4895: END IF ;
4896:
4897: --
4898: -- Updating the psb_worksheets.
4899: --
4900:
4901: /* bug start 3970347 */
4902: -- check if the worksheet is global worksheet. If global, then

Line 4906: FROM psb_worksheets

4902: -- check if the worksheet is global worksheet. If global, then
4903: -- pass the gl cutoff date.
4904: IF l_global_worksheet_flag = 'Y' THEN
4905: FOR l_gl_cutoff_period_rec IN (SELECT gl_cutoff_period
4906: FROM psb_worksheets
4907: WHERE worksheet_id = p_worksheet_id)
4908: LOOP
4909: l_gl_cutoff_period := l_gl_cutoff_period_rec.gl_cutoff_period;
4910: END LOOP;

Line 5116: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

5112: p_return_status OUT NOCOPY VARCHAR2 ,
5113: p_msg_count OUT NOCOPY NUMBER ,
5114: p_msg_data OUT NOCOPY VARCHAR2 ,
5115: --
5116: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
5117: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
5118: )
5119: IS
5120: --

Line 5117: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

5113: p_msg_count OUT NOCOPY NUMBER ,
5114: p_msg_data OUT NOCOPY VARCHAR2 ,
5115: --
5116: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
5117: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
5118: )
5119: IS
5120: --
5121: l_api_name CONSTANT VARCHAR2(30) := 'Find_Parent_Worksheet' ;

Line 5127: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;

5123: l_return_status VARCHAR2(1) ;
5124: l_msg_count NUMBER ;
5125: l_msg_data VARCHAR2(2000) ;
5126: --
5127: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5128: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5129: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5130: l_global_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5131: --

Line 5128: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;

5124: l_msg_count NUMBER ;
5125: l_msg_data VARCHAR2(2000) ;
5126: --
5127: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5128: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5129: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5130: l_global_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5131: --
5132: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;

Line 5129: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

5125: l_msg_data VARCHAR2(2000) ;
5126: --
5127: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5128: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5129: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5130: l_global_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5131: --
5132: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5133: --

Line 5130: l_global_budget_group_id psb_worksheets.budget_group_id%TYPE ;

5126: --
5127: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5128: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5129: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5130: l_global_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5131: --
5132: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5133: --
5134: BEGIN

Line 5132: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;

5128: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5129: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5130: l_global_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5131: --
5132: l_parent_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5133: --
5134: BEGIN
5135: --
5136: SAVEPOINT Find_Parent_Worksheet_Pvt ;

Line 5167: FROM psb_worksheets ws,

5163: l_budget_group_id ,
5164: l_global_worksheet_id ,
5165: l_global_worksheet_flag ,
5166: l_parent_budget_group_id
5167: FROM psb_worksheets ws,
5168: psb_budget_groups bg
5169: WHERE ws.worksheet_id = p_worksheet_id
5170: AND ws.budget_group_id = bg.budget_group_id ;
5171:

Line 5188: FROM psb_worksheets

5184: --
5185: -- Find global budget_group_id for the global worksheet.
5186: --
5187: SELECT budget_group_id INTO l_global_budget_group_id
5188: FROM psb_worksheets
5189: WHERE worksheet_id = l_global_worksheet_id ;
5190:
5191: --
5192: -- If parent budget group for the current worksheet is same as the budget

Line 5212: FROM psb_worksheets

5208: -- New way to find if a worksheet has been created for a budget group.
5209: -- ( Bug#2832148 )
5210: --
5211: SELECT worksheet_id INTO p_worksheet_id_OUT
5212: FROM psb_worksheets
5213: WHERE global_worksheet_id = l_global_worksheet_id
5214: AND budget_group_id = l_parent_budget_group_id
5215: AND worksheet_type = 'O' ;
5216:

Line 5296: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

5292: p_return_status OUT NOCOPY VARCHAR2 ,
5293: p_msg_count OUT NOCOPY NUMBER ,
5294: p_msg_data OUT NOCOPY VARCHAR2 ,
5295: --
5296: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
5297: p_worksheet_tbl IN OUT NOCOPY Worksheet_Tbl_Type
5298: )
5299: IS
5300: --

Line 5307: l_current_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;

5303: l_return_status VARCHAR2(1) ;
5304: l_msg_count NUMBER ;
5305: l_msg_data VARCHAR2(2000) ;
5306: --
5307: l_current_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5308: l_parent_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5309: --
5310: l_count NUMBER ;
5311: --

Line 5308: l_parent_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;

5304: l_msg_count NUMBER ;
5305: l_msg_data VARCHAR2(2000) ;
5306: --
5307: l_current_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5308: l_parent_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5309: --
5310: l_count NUMBER ;
5311: --
5312: BEGIN

Line 5436: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

5432: p_return_status OUT NOCOPY VARCHAR2 ,
5433: p_msg_count OUT NOCOPY NUMBER ,
5434: p_msg_data OUT NOCOPY VARCHAR2 ,
5435: --
5436: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
5437: p_worksheet_tbl IN OUT NOCOPY Worksheet_Tbl_Type
5438: )
5439: IS
5440: --

Line 5447: l_child_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;

5443: l_return_status VARCHAR2(1) ;
5444: l_msg_count NUMBER ;
5445: l_msg_data VARCHAR2(2000) ;
5446: --
5447: l_child_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5448: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5449: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5450: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5451: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

Line 5448: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;

5444: l_msg_count NUMBER ;
5445: l_msg_data VARCHAR2(2000) ;
5446: --
5447: l_child_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5448: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5449: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5450: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5451: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
5452: --

Line 5449: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;

5445: l_msg_data VARCHAR2(2000) ;
5446: --
5447: l_child_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5448: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5449: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5450: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5451: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
5452: --
5453: l_count NUMBER ;

Line 5450: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;

5446: --
5447: l_child_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5448: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5449: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5450: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5451: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
5452: --
5453: l_count NUMBER ;
5454: --

Line 5451: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

5447: l_child_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5448: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE ;
5449: l_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5450: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5451: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
5452: --
5453: l_count NUMBER ;
5454: --
5455: BEGIN

Line 5494: FROM psb_worksheets

5490: l_budget_group_id ,
5491: l_budget_calendar_id ,
5492: l_global_worksheet_id ,
5493: l_global_worksheet_flag
5494: FROM psb_worksheets
5495: WHERE worksheet_id = p_worksheet_id ;
5496:
5497: IF l_global_worksheet_flag = 'Y' THEN
5498: l_global_worksheet_id := p_worksheet_id ;

Line 5559: FROM psb_worksheets

5555: -- New way to find if a worksheet has been created for a budget group.
5556: -- ( Bug#2832148 )
5557: --
5558: SELECT worksheet_id INTO l_child_worksheet_id
5559: FROM psb_worksheets
5560: WHERE global_worksheet_id = l_global_worksheet_id
5561: AND budget_group_id = l_budget_group_rec.budget_group_id
5562: AND worksheet_type = 'O' ;
5563:

Line 5659: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

5655: p_return_status OUT NOCOPY VARCHAR2 ,
5656: p_msg_count OUT NOCOPY NUMBER ,
5657: p_msg_data OUT NOCOPY VARCHAR2 ,
5658: --
5659: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
5660: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
5661: )
5662: IS
5663: --

Line 5660: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE

5656: p_msg_count OUT NOCOPY NUMBER ,
5657: p_msg_data OUT NOCOPY VARCHAR2 ,
5658: --
5659: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
5660: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
5661: )
5662: IS
5663: --
5664: l_api_name CONSTANT VARCHAR2(30) := 'Update_Worksheet' ;

Line 5671: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;

5667: l_return_status VARCHAR2(1) ;
5668: l_msg_count NUMBER ;
5669: l_msg_data VARCHAR2(2000) ;
5670: --
5671: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5672: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5673: l_source_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5674: l_source_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5675: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;

Line 5672: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;

5668: l_msg_count NUMBER ;
5669: l_msg_data VARCHAR2(2000) ;
5670: --
5671: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5672: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5673: l_source_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5674: l_source_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5675: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
5676: --

Line 5673: l_source_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

5669: l_msg_data VARCHAR2(2000) ;
5670: --
5671: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5672: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5673: l_source_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5674: l_source_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5675: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
5676: --
5677: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;

Line 5674: l_source_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;

5670: --
5671: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5672: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5673: l_source_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5674: l_source_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5675: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
5676: --
5677: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5678: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;

Line 5675: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;

5671: l_source_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5672: l_source_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5673: l_source_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5674: l_source_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5675: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
5676: --
5677: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5678: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5679: l_target_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 5677: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;

5673: l_source_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5674: l_source_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5675: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
5676: --
5677: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5678: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5679: l_target_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5680: --
5681: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

Line 5678: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;

5674: l_source_global_worksheet_flag psb_worksheets.global_worksheet_flag%TYPE ;
5675: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
5676: --
5677: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5678: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5679: l_target_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5680: --
5681: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
5682: l_ws_lines_rec psb_ws_lines%ROWTYPE ;

Line 5679: l_target_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

5675: l_source_budget_by_position psb_worksheets.budget_by_position%TYPE ;
5676: --
5677: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5678: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5679: l_target_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5680: --
5681: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
5682: l_ws_lines_rec psb_ws_lines%ROWTYPE ;
5683: l_ws_lines_positions_rec psb_ws_lines_positions%ROWTYPE ;

Line 5681: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

5677: l_target_budget_group_id psb_worksheets.budget_group_id%TYPE ;
5678: l_target_local_copy_flag psb_worksheets.local_copy_flag%TYPE ;
5679: l_target_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
5680: --
5681: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
5682: l_ws_lines_rec psb_ws_lines%ROWTYPE ;
5683: l_ws_lines_positions_rec psb_ws_lines_positions%ROWTYPE ;
5684: /* Bug No 2378285 Start */
5685: l_gl_cutoff_period DATE;

Line 5728: FROM psb_worksheets

5724: l_source_budget_by_position,
5725: /* Bug No 2378285 Start */
5726: l_gl_cutoff_period
5727: /* Bug No 2378285 End */
5728: FROM psb_worksheets
5729: WHERE worksheet_id = p_source_worksheet_id ;
5730:
5731: IF l_source_global_worksheet_flag = 'Y' THEN
5732: l_source_global_worksheet_id := p_source_worksheet_id ;

Line 5777: FROM psb_worksheets

5773: INTO
5774: l_target_budget_group_id ,
5775: l_target_global_worksheet_id ,
5776: l_target_local_copy_flag
5777: FROM psb_worksheets
5778: WHERE worksheet_id = p_target_worksheet_id ;
5779:
5780: --
5781: -- The source and target worksheet must be part of same global worksheet.

Line 5798: FROM psb_worksheets

5794: --
5795: -- Get budget calendar for the global worksheet.
5796: --
5797: SELECT budget_calendar_id INTO l_budget_calendar_id
5798: FROM psb_worksheets
5799: WHERE worksheet_id = l_source_global_worksheet_id ;
5800:
5801: --
5802: -- Get budget calendar related info to find all the budget groups down in

Line 6046: p_new_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

6042: --
6043: PROCEDURE Create_Local_Dist_Pvt
6044: (
6045: p_account_line_id IN psb_ws_lines.account_line_id%TYPE ,
6046: p_new_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
6047: p_new_position_line_id IN psb_ws_lines_positions.position_line_id%TYPE ,
6048: p_return_status OUT NOCOPY VARCHAR2
6049: )
6050: IS

Line 6290: -- psb_worksheets and matrix tables (psb_ws_lines and psb_ws_lines_positions).

6286: | PROCEDURE Delete_Worksheet_Pvt ( Private ) |
6287: +===========================================================================*/
6288: --
6289: -- This API deletes an official worksheet by performing deletes on
6290: -- psb_worksheets and matrix tables (psb_ws_lines and psb_ws_lines_positions).
6291: -- It also deletes worksheet related data from other tables.
6292: --
6293: PROCEDURE Delete_Worksheet_Pvt
6294: (

Line 6295: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

6291: -- It also deletes worksheet related data from other tables.
6292: --
6293: PROCEDURE Delete_Worksheet_Pvt
6294: (
6295: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
6296: p_budget_by_position IN psb_worksheets.budget_by_position%TYPE ,
6297: p_delete_lines_flag IN VARCHAR2 ,
6298: p_return_status OUT NOCOPY VARCHAR2
6299: )

Line 6296: p_budget_by_position IN psb_worksheets.budget_by_position%TYPE ,

6292: --
6293: PROCEDURE Delete_Worksheet_Pvt
6294: (
6295: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
6296: p_budget_by_position IN psb_worksheets.budget_by_position%TYPE ,
6297: p_delete_lines_flag IN VARCHAR2 ,
6298: p_return_status OUT NOCOPY VARCHAR2
6299: )
6300: IS

Line 6306: l_local_copy_flag psb_worksheets.local_copy_flag%TYPE;

6302: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Worksheet_Pvt' ;
6303: --
6304: l_account_line_id psb_ws_lines.account_line_id%TYPE;
6305: l_position_line_id psb_ws_lines_positions.position_line_id%TYPE ;
6306: l_local_copy_flag psb_worksheets.local_copy_flag%TYPE;
6307: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
6308: l_return_status VARCHAR2(1) ;
6309: /*For Bug No : 2266309 Start*/
6310: l_record_ctr NUMBER := 0;

Line 6307: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;

6303: --
6304: l_account_line_id psb_ws_lines.account_line_id%TYPE;
6305: l_position_line_id psb_ws_lines_positions.position_line_id%TYPE ;
6306: l_local_copy_flag psb_worksheets.local_copy_flag%TYPE;
6307: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
6308: l_return_status VARCHAR2(1) ;
6309: /*For Bug No : 2266309 Start*/
6310: l_record_ctr NUMBER := 0;
6311: /*For Bug No : 2266309 End*/

Line 6480: -- Delete from psb_worksheets.

6476: -- Delete from psb_ws_submit_comments.
6477: DELETE psb_ws_submit_comments
6478: WHERE worksheet_id = p_worksheet_id ;
6479:
6480: -- Delete from psb_worksheets.
6481: DELETE psb_worksheets
6482: WHERE worksheet_id = p_worksheet_id ;
6483:
6484: /*For Bug No : 2613269 Start*/

Line 6481: DELETE psb_worksheets

6477: DELETE psb_ws_submit_comments
6478: WHERE worksheet_id = p_worksheet_id ;
6479:
6480: -- Delete from psb_worksheets.
6481: DELETE psb_worksheets
6482: WHERE worksheet_id = p_worksheet_id ;
6483:
6484: /*For Bug No : 2613269 Start*/
6485: fnd_attached_documents2_pkg.delete_attachments

Line 6486: (X_entity_name => 'PSB_WORKSHEETS',

6482: WHERE worksheet_id = p_worksheet_id ;
6483:
6484: /*For Bug No : 2613269 Start*/
6485: fnd_attached_documents2_pkg.delete_attachments
6486: (X_entity_name => 'PSB_WORKSHEETS',
6487: X_pk1_value => p_worksheet_id,
6488: X_delete_document_flag => 'Y'
6489: );
6490: /*For Bug No : 2613269 End*/

Line 6628: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

6624: p_return_status OUT NOCOPY VARCHAR2 ,
6625: p_msg_count OUT NOCOPY NUMBER ,
6626: p_msg_data OUT NOCOPY VARCHAR2 ,
6627: --
6628: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
6629: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
6630: p_service_package_operation_id
6631: IN NUMBER := FND_API.G_MISS_NUM ,
6632: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

Line 6629: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,

6625: p_msg_count OUT NOCOPY NUMBER ,
6626: p_msg_data OUT NOCOPY VARCHAR2 ,
6627: --
6628: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
6629: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
6630: p_service_package_operation_id
6631: IN NUMBER := FND_API.G_MISS_NUM ,
6632: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
6633: )

Line 6632: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

6628: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
6629: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
6630: p_service_package_operation_id
6631: IN NUMBER := FND_API.G_MISS_NUM ,
6632: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
6633: )
6634: IS
6635: --
6636: l_api_name CONSTANT VARCHAR2(30) := 'Create_New_Position_Worksheet' ;

Line 6643: l_worksheet_name psb_worksheets.name%TYPE ;

6639: l_return_status VARCHAR2(1) ;
6640: l_msg_count NUMBER ;
6641: l_msg_data VARCHAR2(2000) ;
6642: --
6643: l_worksheet_name psb_worksheets.name%TYPE ;
6644: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
6645: l_worksheet_description psb_worksheets.description%TYPE ;
6646: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
6647: l_main_budget_group_name psb_budget_groups.name%TYPE ;

Line 6644: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;

6640: l_msg_count NUMBER ;
6641: l_msg_data VARCHAR2(2000) ;
6642: --
6643: l_worksheet_name psb_worksheets.name%TYPE ;
6644: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
6645: l_worksheet_description psb_worksheets.description%TYPE ;
6646: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
6647: l_main_budget_group_name psb_budget_groups.name%TYPE ;
6648: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

Line 6645: l_worksheet_description psb_worksheets.description%TYPE ;

6641: l_msg_data VARCHAR2(2000) ;
6642: --
6643: l_worksheet_name psb_worksheets.name%TYPE ;
6644: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
6645: l_worksheet_description psb_worksheets.description%TYPE ;
6646: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
6647: l_main_budget_group_name psb_budget_groups.name%TYPE ;
6648: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
6649: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 6646: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;

6642: --
6643: l_worksheet_name psb_worksheets.name%TYPE ;
6644: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
6645: l_worksheet_description psb_worksheets.description%TYPE ;
6646: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
6647: l_main_budget_group_name psb_budget_groups.name%TYPE ;
6648: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
6649: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
6650: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

Line 6648: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;

6644: l_budget_by_position psb_worksheets.budget_by_position%TYPE ;
6645: l_worksheet_description psb_worksheets.description%TYPE ;
6646: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
6647: l_main_budget_group_name psb_budget_groups.name%TYPE ;
6648: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
6649: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
6650: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
6651: l_service_package_count NUMBER ;
6652: --

Line 6649: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;

6645: l_worksheet_description psb_worksheets.description%TYPE ;
6646: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
6647: l_main_budget_group_name psb_budget_groups.name%TYPE ;
6648: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
6649: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
6650: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
6651: l_service_package_count NUMBER ;
6652: --
6653: l_tmp_char VARCHAR2(1) ;

Line 6650: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;

6646: l_main_budget_group_id psb_worksheets.budget_group_id%TYPE ;
6647: l_main_budget_group_name psb_budget_groups.name%TYPE ;
6648: l_main_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
6649: l_new_worksheet_id psb_worksheets.worksheet_id%TYPE ;
6650: l_global_worksheet_id psb_worksheets.worksheet_id%TYPE ;
6651: l_service_package_count NUMBER ;
6652: --
6653: l_tmp_char VARCHAR2(1) ;
6654: l_lines_added NUMBER := 0 ;

Line 6658: FROM psb_worksheets

6654: l_lines_added NUMBER := 0 ;
6655: --
6656: CURSOR l_worksheets_csr IS
6657: SELECT *
6658: FROM psb_worksheets
6659: WHERE worksheet_id = p_worksheet_id ;
6660: --
6661: l_worksheets_rec l_worksheets_csr%ROWTYPE ;
6662: --

Line 6729: -- Create the new worksheet in psb_worksheets table.

6725: l_global_worksheet_id := l_worksheets_rec.global_worksheet_id ;
6726: END IF ;
6727:
6728: --
6729: -- Create the new worksheet in psb_worksheets table.
6730: --
6731: PSB_Worksheet_Pvt.Create_Worksheet
6732: (
6733: p_api_version => 1.0 ,