DBA Data[Home] [Help]

APPS.GHR_MRE_PKG dependencies on GHR_SF52_POS_UPDATE

Line 16: (p_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type);

12: l_log_text VARCHAR2(2000) := null;
13: l_mslerrbuf VARCHAR2(2000) := null;
14:
15: Procedure UPDATE_position_info
16: (p_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type);
17:
18: --
19: -- End Global declaration
20: --

Line 1650: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;

1646:
1647: DECLARE
1648:
1649: l_new_position_id hr_positions_f.position_id%TYPE;
1650: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1651:
1652: l_pos_ei_data_rec per_position_extra_info%rowtype;
1653: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1654:

Line 1896: -- ghr_sf52_pos_UPDATE.UPDATE_position_info

1892:
1893: -- VSM- Bug # 758441
1894: -- Position history not created for Date END and org id
1895: -- Created wrapper procedure UPDATE_position_info for
1896: -- ghr_sf52_pos_UPDATE.UPDATE_position_info
1897: -- #### ghr_sf52_pos_UPDATE.UPDATE_position_info
1898:
1899: UPDATE_position_info (l_position_data_rec);
1900:

Line 1897: -- #### ghr_sf52_pos_UPDATE.UPDATE_position_info

1893: -- VSM- Bug # 758441
1894: -- Position history not created for Date END and org id
1895: -- Created wrapper procedure UPDATE_position_info for
1896: -- ghr_sf52_pos_UPDATE.UPDATE_position_info
1897: -- #### ghr_sf52_pos_UPDATE.UPDATE_position_info
1898:
1899: UPDATE_position_info (l_position_data_rec);
1900:
1901: ------ghr_sf52_pos_UPDATE.UPDATE_position_info

Line 1901: ------ghr_sf52_pos_UPDATE.UPDATE_position_info

1897: -- #### ghr_sf52_pos_UPDATE.UPDATE_position_info
1898:
1899: UPDATE_position_info (l_position_data_rec);
1900:
1901: ------ghr_sf52_pos_UPDATE.UPDATE_position_info
1902: ------ ( p_pos_data_rec => l_position_data_rec);
1903: END IF; -- Bug#4388288 End.
1904: END IF; --- Eligibility
1905: END IF; --- Select flag

Line 1910: l_mslerrbuf := 'Error in ghr_sf52_pos_UPDATE.UPDATE_position_info'||' Sql Err is '|| sqlerrm(sqlcode);

1906: END IF; -- Check of availability status id ENDs here
1907: END LOOP;
1908: EXCEPTION
1909: WHEN OTHERS THEN
1910: l_mslerrbuf := 'Error in ghr_sf52_pos_UPDATE.UPDATE_position_info'||' Sql Err is '|| sqlerrm(sqlcode);
1911: raise mass_error;
1912: END;
1913: END IF; --- End for unass - p_action = CREATE
1914: END;

Line 3916: (p_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type) is

3912: raise mass_error;
3913: END;
3914:
3915: Procedure UPDATE_position_info
3916: (p_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type) is
3917: l_proc VARCHAR2(30):='UPDATE_position_info';
3918: Begin
3919: hr_utility.set_location('Entering ' || l_proc, 10);
3920: hr_utility.set_location('Vacant Position ID ' || to_char(p_position_data_rec.position_id), 10);

Line 3922: ghr_sf52_pos_UPDATE.UPDATE_position_info

3918: Begin
3919: hr_utility.set_location('Entering ' || l_proc, 10);
3920: hr_utility.set_location('Vacant Position ID ' || to_char(p_position_data_rec.position_id), 10);
3921: ghr_session.set_session_var_for_core( p_position_data_rec.effective_END_DATE );
3922: ghr_sf52_pos_UPDATE.UPDATE_position_info
3923: ( p_pos_data_rec => p_position_data_rec);
3924: hr_utility.set_location('Calling Pust_UPDATE_process ' || l_proc, 50);
3925: ghr_history_api.post_UPDATE_process;
3926: hr_utility.set_location('Leaving ' || l_proc, 100);