DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 278: l_ASGNEI_DATA PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;

274: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
275: )
276: IS
277: l_proc varchar2(30) := 'get_from_history_asgnei';
278: l_ASGNEI_DATA PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
279: l_ASGNEI_DATA_INIT PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
280: l_session ghr_history_api.g_session_var_type;
281: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
282: l_result varchar2(20);

Line 279: l_ASGNEI_DATA_INIT PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;

275: )
276: IS
277: l_proc varchar2(30) := 'get_from_history_asgnei';
278: l_ASGNEI_DATA PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
279: l_ASGNEI_DATA_INIT PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
280: l_session ghr_history_api.g_session_var_type;
281: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
282: l_result varchar2(20);
283: l_non_asg_ei_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;

Line 281: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;

277: l_proc varchar2(30) := 'get_from_history_asgnei';
278: l_ASGNEI_DATA PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
279: l_ASGNEI_DATA_INIT PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
280: l_session ghr_history_api.g_session_var_type;
281: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
282: l_result varchar2(20);
283: l_non_asg_ei_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
284:
285: BEGIN

Line 283: l_non_asg_ei_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;

279: l_ASGNEI_DATA_INIT PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
280: l_session ghr_history_api.g_session_var_type;
281: l_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
282: l_result varchar2(20);
283: l_non_asg_ei_data PER_ASSIGNMENT_EXTRA_INFO%ROWTYPE;
284:
285: BEGIN
286: hr_utility.set_location('Entering:'||l_proc,5);
287: