[Home] [Help]
2898:
2899: cursor c_update_mode_pos is
2900: select pos.effective_start_date ,
2901: pos.effective_end_date
2902: from hr_all_positions_f pos
2903: where pos.position_id = p_id
2904: and p_effective_date
2905: between pos.effective_start_date
2906: and pos.effective_end_date;
2907:
2908: cursor c_update_mode_pos1 is
2909: select pos.effective_start_date ,
2910: pos.effective_end_date
2911: from hr_all_positions_f pos
2912: where pos.position_id = p_id
2913: and p_effective_date < pos.effective_start_date;
2914:
2915:
2988: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
2989: hr_utility.set_message_token('TABLE_NAME','per_assignments_f');
2990: hr_utility.raise_error;
2991: End if;
2992: Elsif p_table_name = 'HR_ALL_POSITIONS_F' then
2993: hr_utility.set_location(l_proc,110);
2994: for update_mode in c_update_mode_pos loop
2995: hr_utility.set_location(l_proc,115);
2996: l_esd := update_mode.effective_start_date;
3022: hr_utility.set_location(l_proc,155);
3023: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
3024: If l_mode is null then
3025: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
3026: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');
3027: hr_utility.raise_error;
3028: End if;
3029: End if;
3030: return l_mode;
3441: -- position object_version_number
3442:
3443: Cursor c_pos_ovn is
3444: select pos.object_version_number
3445: from hr_all_positions_f pos -- Venkat
3446: where pos.position_id = p_pa_request_rec.from_position_id
3447: and p_pa_request_rec.effective_date between
3448: pos.effective_start_date and pos.effective_end_date;
3449:
3462: -- Getting from Organization_id
3463:
3464: Cursor c_from_org_id is
3465: select pos.organization_id
3466: from hr_all_positions_f pos
3467: where pos.position_id = p_pa_request_rec.from_position_id
3468: and p_pa_request_rec.effective_date between
3469: pos.effective_start_date and pos.effective_end_date;
3470:
3471: -- Getting to Organization_id
3472:
3473: Cursor c_to_org_id is
3474: select pos.organization_id
3475: from hr_all_positions_f pos
3476: where pos.position_id = p_pa_request_rec.to_position_id
3477: and p_pa_request_rec.effective_date between
3478: pos.effective_start_date and pos.effective_end_date;
3479:
3584: -- 2839332
3585: --
3586:
3587: -- Bug 3215139
3588: CURSOR get_occ_code(c_position_id hr_all_positions_f.position_id%type, c_effective_date hr_all_positions_f.effective_start_date%type) IS
3589: SELECT pos.job_id
3590: FROM hr_all_positions_f pos
3591: WHERE pos.position_id = c_position_id
3592: AND c_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;
3586:
3587: -- Bug 3215139
3588: CURSOR get_occ_code(c_position_id hr_all_positions_f.position_id%type, c_effective_date hr_all_positions_f.effective_start_date%type) IS
3589: SELECT pos.job_id
3590: FROM hr_all_positions_f pos
3591: WHERE pos.position_id = c_position_id
3592: AND c_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;
3593:
3594: CURSOR get_segment(c_business_group_id per_people_f.business_group_id%type) IS
3600: l_agency_segment hr_organization_information.org_information5%type;
3601: l_pos_agency_code VARCHAR2(30);
3602:
3603: CURSOR c_get_agency_code(c_segment hr_organization_information.org_information5%type,
3604: c_position_id hr_all_positions_f.position_id%type,
3605: c_effective_date hr_all_positions_f.effective_start_date%type) IS
3606: SELECT DECODE(c_segment,'SEGMENT1',SEGMENT1,
3607: 'SEGMENT2',SEGMENT2,
3608: 'SEGMENT3',SEGMENT3,
3601: l_pos_agency_code VARCHAR2(30);
3602:
3603: CURSOR c_get_agency_code(c_segment hr_organization_information.org_information5%type,
3604: c_position_id hr_all_positions_f.position_id%type,
3605: c_effective_date hr_all_positions_f.effective_start_date%type) IS
3606: SELECT DECODE(c_segment,'SEGMENT1',SEGMENT1,
3607: 'SEGMENT2',SEGMENT2,
3608: 'SEGMENT3',SEGMENT3,
3609: 'SEGMENT4',SEGMENT4,
3632: 'SEGMENT27',SEGMENT27,
3633: 'SEGMENT28',SEGMENT28,
3634: 'SEGMENT29',SEGMENT29,
3635: 'SEGMENT30',SEGMENT30) agency_code
3636: FROM per_position_definitions ppd, hr_all_positions_f pos
3637: WHERE pos.position_definition_id = ppd.position_definition_id
3638: AND pos.position_id = c_position_id
3639: AND c_effective_date BETWEEN pos.effective_start_date AND pos.effective_end_date;
3640:
3640:
3641: ------------------------
3642:
3643: l_update_occ_code VARCHAR2(1) := 'N';
3644: l_pos_job_id hr_all_positions_f.job_id%type;
3645:
3646:
3647: --Bug 3381960
3648: -- Get Assignment position for the person
3711: hr_utility.set_location('realign -pos ' || p_pa_request_rec.to_organization_id,1);
3712: ----l_position_data_rec_type.datetrack_mode := return_update_mode
3713: ---- (p_id => p_pa_request_rec.to_position_id,
3714: ---- p_effective_date => p_pa_request_rec.effective_date,
3715: ---- p_table_name => 'HR_ALL_POSITIONS_F'
3716: ---- );
3717: -- Start Bug 1613367
3718: For ovn in asg_ovn(p_pa_request_rec.employee_assignment_id) loop
3719: l_temp_asg_loc_id := ovn.location_id;
3891: hr_utility.set_location('change in data element-pos ' || p_pa_request_rec.to_job_id,1);
3892: l_position_data_rec_type.datetrack_mode := return_update_mode
3893: (p_id => p_pa_request_rec.to_position_id,
3894: p_effective_date => p_pa_request_rec.effective_date,
3895: p_table_name => 'HR_ALL_POSITIONS_F'
3896: );
3897:
3898: --Bug# 6127620
3899: --GHR_HISTORY_API.get_session_date(l_curr_sess_date);
4654: -- End Bug 3431540
4655: l_position_data_rec_type.datetrack_mode := return_update_mode
4656: (p_id => p_pa_request_rec.to_position_id,
4657: p_effective_date => p_pa_request_rec.effective_date,
4658: p_table_name => 'HR_ALL_POSITIONS_F'
4659: );
4660: ghr_sf52_pos_update.update_position_info
4661: (p_pos_data_rec => l_position_data_rec_type);
4662: END IF; -- If NOA is 352