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 1681: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;

1677: -- and it is agreed in the design review meeting by MACROSS and JMACGOY.
1678:
1679: DECLARE
1680: l_new_position_id hr_positions_f.position_id%TYPE;
1681: l_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type;
1682: l_pos_ei_data_rec per_position_extra_info%rowtype;
1683: l_new_pos_grp1_rec per_position_extra_info%rowtype;
1684: l_target_personnel_office_id per_position_extra_info.poei_information1%TYPE;
1685: l_target_agency_code per_position_extra_info.poei_information1%TYPE;

Line 1980: -- ghr_sf52_pos_UPDATE.UPDATE_position_info

1976: -- and agency_code Subelement.
1977: -- VSM- Bug # 758441
1978: -- Position history not created for Date END and org id
1979: -- Created wrapper procedure UPDATE_position_info for
1980: -- ghr_sf52_pos_UPDATE.UPDATE_position_info
1981: -- #### ghr_sf52_pos_UPDATE.UPDATE_position_info
1982: BEGIN
1983: UPDATE_position_info (l_position_data_rec);
1984: EXCEPTION

Line 1981: -- #### ghr_sf52_pos_UPDATE.UPDATE_position_info

1977: -- VSM- Bug # 758441
1978: -- Position history not created for Date END and org id
1979: -- Created wrapper procedure UPDATE_position_info for
1980: -- ghr_sf52_pos_UPDATE.UPDATE_position_info
1981: -- #### ghr_sf52_pos_UPDATE.UPDATE_position_info
1982: BEGIN
1983: UPDATE_position_info (l_position_data_rec);
1984: EXCEPTION
1985: WHEN OTHERS THEN

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

1982: BEGIN
1983: UPDATE_position_info (l_position_data_rec);
1984: EXCEPTION
1985: WHEN OTHERS THEN
1986: l_mslerrbuf := 'Error in ghr_sf52_pos_UPDATE.UPDATE_position_info'||' Sql Err is '|| sqlerrm(sqlcode);
1987: raise mass_error;
1988: END;
1989:
1990: ------ghr_sf52_pos_UPDATE.UPDATE_position_info

Line 1990: ------ghr_sf52_pos_UPDATE.UPDATE_position_info

1986: l_mslerrbuf := 'Error in ghr_sf52_pos_UPDATE.UPDATE_position_info'||' Sql Err is '|| sqlerrm(sqlcode);
1987: raise mass_error;
1988: END;
1989:
1990: ------ghr_sf52_pos_UPDATE.UPDATE_position_info
1991: ------ ( p_pos_data_rec => l_position_data_rec);
1992: END IF; -- Bug#4388288 End.
1993: END IF; --- Eligibility
1994: END IF; --- Select flag

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

2052: END;
2053: END LOOP;
2054: EXCEPTION
2055: WHEN OTHERS THEN
2056: l_mslerrbuf := 'Error in ghr_sf52_pos_UPDATE.UPDATE_position_info'||' Sql Err is '|| sqlerrm(sqlcode);
2057: raise mass_error;
2058: END;
2059: END IF; --- End for unass - p_action = CREATE
2060: END;

Line 4083: (p_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type) is

4079: raise mass_error;
4080: END;
4081:
4082: Procedure UPDATE_position_info
4083: (p_position_data_rec ghr_sf52_pos_UPDATE.position_data_rec_type) is
4084: l_proc VARCHAR2(30):='UPDATE_position_info';
4085: Begin
4086: hr_utility.set_location('Entering ' || l_proc, 10);
4087: hr_utility.set_location('Vacant Position ID ' || to_char(p_position_data_rec.position_id), 10);

Line 4089: ghr_sf52_pos_UPDATE.UPDATE_position_info

4085: Begin
4086: hr_utility.set_location('Entering ' || l_proc, 10);
4087: hr_utility.set_location('Vacant Position ID ' || to_char(p_position_data_rec.position_id), 10);
4088: ghr_session.set_session_var_for_core( p_position_data_rec.effective_END_DATE );
4089: ghr_sf52_pos_UPDATE.UPDATE_position_info
4090: ( p_pos_data_rec => p_position_data_rec);
4091: hr_utility.set_location('Calling Pust_UPDATE_process ' || l_proc, 50);
4092: ghr_history_api.post_UPDATE_process;
4093: hr_utility.set_location('Leaving ' || l_proc, 100);