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.GHR_SF52_DO_UPDATE dependencies on HR_ALL_POSITIONS_F

Line 2698: from hr_all_positions_f pos

2694:
2695: cursor c_update_mode_pos is
2696: select pos.effective_start_date ,
2697: pos.effective_end_date
2698: from hr_all_positions_f pos
2699: where pos.position_id = p_id
2700: and p_effective_date
2701: between pos.effective_start_date
2702: and pos.effective_end_date;

Line 2707: from hr_all_positions_f pos

2703:
2704: cursor c_update_mode_pos1 is
2705: select pos.effective_start_date ,
2706: pos.effective_end_date
2707: from hr_all_positions_f pos
2708: where pos.position_id = p_id
2709: and p_effective_date < pos.effective_start_date;
2710:
2711:

Line 2788: Elsif p_table_name = 'HR_ALL_POSITIONS_F' then

2784: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
2785: hr_utility.set_message_token('TABLE_NAME','per_assignments_f');
2786: hr_utility.raise_error;
2787: End if;
2788: Elsif p_table_name = 'HR_ALL_POSITIONS_F' then
2789: hr_utility.set_location(l_proc,110);
2790: for update_mode in c_update_mode_pos loop
2791: hr_utility.set_location(l_proc,115);
2792: l_esd := update_mode.effective_start_date;

Line 2822: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');

2818: hr_utility.set_location(l_proc,155);
2819: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
2820: If l_mode is null then
2821: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
2822: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');
2823: hr_utility.raise_error;
2824: End if;
2825: End if;
2826: return l_mode;

Line 3240: from hr_all_positions_f pos -- Venkat

3236: -- position object_version_number
3237:
3238: Cursor c_pos_ovn is
3239: select pos.object_version_number
3240: from hr_all_positions_f pos -- Venkat
3241: where pos.position_id = p_pa_request_rec.from_position_id
3242: and p_pa_request_rec.effective_date between
3243: pos.effective_start_date and pos.effective_end_date;
3244:

Line 3261: from hr_all_positions_f pos

3257: -- Getting from Organization_id
3258:
3259: Cursor c_from_org_id is
3260: select pos.organization_id
3261: from hr_all_positions_f pos
3262: where pos.position_id = p_pa_request_rec.from_position_id
3263: and p_pa_request_rec.effective_date between
3264: pos.effective_start_date and pos.effective_end_date;
3265:

Line 3270: from hr_all_positions_f pos

3266: -- Getting to Organization_id
3267:
3268: Cursor c_to_org_id is
3269: select pos.organization_id
3270: from hr_all_positions_f pos
3271: where pos.position_id = p_pa_request_rec.to_position_id
3272: and p_pa_request_rec.effective_date between
3273: pos.effective_start_date and pos.effective_end_date;
3274:

Line 3368: 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

3364: -- 2839332
3365: --
3366:
3367: -- Bug 3215139
3368: 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
3369: SELECT pos.job_id
3370: FROM hr_all_positions_f pos
3371: WHERE pos.position_id = c_position_id
3372: AND c_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;

Line 3370: FROM hr_all_positions_f pos

3366:
3367: -- Bug 3215139
3368: 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
3369: SELECT pos.job_id
3370: FROM hr_all_positions_f pos
3371: WHERE pos.position_id = c_position_id
3372: AND c_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;
3373:
3374: CURSOR get_segment(c_business_group_id per_people_f.business_group_id%type) IS

Line 3384: c_position_id hr_all_positions_f.position_id%type,

3380: l_agency_segment hr_organization_information.org_information5%type;
3381: l_pos_agency_code VARCHAR2(30);
3382:
3383: CURSOR c_get_agency_code(c_segment hr_organization_information.org_information5%type,
3384: c_position_id hr_all_positions_f.position_id%type,
3385: c_effective_date hr_all_positions_f.effective_start_date%type) IS
3386: SELECT DECODE(c_segment,'SEGMENT1',SEGMENT1,
3387: 'SEGMENT2',SEGMENT2,
3388: 'SEGMENT3',SEGMENT3,

Line 3385: c_effective_date hr_all_positions_f.effective_start_date%type) IS

3381: l_pos_agency_code VARCHAR2(30);
3382:
3383: CURSOR c_get_agency_code(c_segment hr_organization_information.org_information5%type,
3384: c_position_id hr_all_positions_f.position_id%type,
3385: c_effective_date hr_all_positions_f.effective_start_date%type) IS
3386: SELECT DECODE(c_segment,'SEGMENT1',SEGMENT1,
3387: 'SEGMENT2',SEGMENT2,
3388: 'SEGMENT3',SEGMENT3,
3389: 'SEGMENT4',SEGMENT4,

Line 3416: FROM per_position_definitions ppd, hr_all_positions_f pos

3412: 'SEGMENT27',SEGMENT27,
3413: 'SEGMENT28',SEGMENT28,
3414: 'SEGMENT29',SEGMENT29,
3415: 'SEGMENT30',SEGMENT30) agency_code
3416: FROM per_position_definitions ppd, hr_all_positions_f pos
3417: WHERE pos.position_definition_id = ppd.position_definition_id
3418: AND pos.position_id = c_position_id
3419: AND c_effective_date BETWEEN pos.effective_start_date AND pos.effective_end_date;
3420:

Line 3424: l_pos_job_id hr_all_positions_f.job_id%type;

3420:
3421: ------------------------
3422:
3423: l_update_occ_code VARCHAR2(1) := 'N';
3424: l_pos_job_id hr_all_positions_f.job_id%type;
3425:
3426:
3427: --Bug 3381960
3428: -- Get Assignment position for the person

Line 3495: ---- p_table_name => 'HR_ALL_POSITIONS_F'

3491: hr_utility.set_location('realign -pos ' || p_pa_request_rec.to_organization_id,1);
3492: ----l_position_data_rec_type.datetrack_mode := return_update_mode
3493: ---- (p_id => p_pa_request_rec.to_position_id,
3494: ---- p_effective_date => p_pa_request_rec.effective_date,
3495: ---- p_table_name => 'HR_ALL_POSITIONS_F'
3496: ---- );
3497: -- Start Bug 1613367
3498: For ovn in asg_ovn(p_pa_request_rec.employee_assignment_id) loop
3499: l_temp_asg_loc_id := ovn.location_id;

Line 3677: p_table_name => 'HR_ALL_POSITIONS_F'

3673: hr_utility.set_location('change in data element-pos ' || p_pa_request_rec.to_job_id,1);
3674: l_position_data_rec_type.datetrack_mode := return_update_mode
3675: (p_id => p_pa_request_rec.to_position_id,
3676: p_effective_date => p_pa_request_rec.effective_date,
3677: p_table_name => 'HR_ALL_POSITIONS_F'
3678: );
3679:
3680: ghr_sf52_pos_update.update_position_info
3681: (p_pos_data_rec => l_position_data_rec_type

Line 4400: p_table_name => 'HR_ALL_POSITIONS_F'

4396: -- End Bug 3431540
4397: l_position_data_rec_type.datetrack_mode := return_update_mode
4398: (p_id => p_pa_request_rec.to_position_id,
4399: p_effective_date => p_pa_request_rec.effective_date,
4400: p_table_name => 'HR_ALL_POSITIONS_F'
4401: );
4402: ghr_sf52_pos_update.update_position_info
4403: (p_pos_data_rec => l_position_data_rec_type);
4404: END IF; -- If NOA is 352