DBA Data[Home] [Help]

APPS.GHR_API dependencies on GHR_HISTORY_FETCH

Line 189: ghr_history_fetch.fetch_people

185: l_assignment_data per_all_assignments_f%rowtype;
186: l_proc varchar2(72) := g_package||'retrieve_business_group_id';
187: Begin
188: if p_person_id is not null then
189: ghr_history_fetch.fetch_people
190: ( p_person_id => p_person_id
191: ,p_date_effective => p_effective_date
192: ,p_altered_pa_request_id => p_altered_pa_request_id
193: ,p_noa_id_corrected => p_noa_id_corrected

Line 199: ghr_history_fetch.fetch_assignment

195: ,p_people_data => l_people_data
196: ,p_result_code => l_result_code);
197: p_business_group_id := l_people_data.business_group_id;
198: elsif p_assignment_id is not null then
199: ghr_history_fetch.fetch_assignment
200: ( p_assignment_id => p_assignment_id
201: ,p_date_effective => p_effective_date
202: ,p_altered_pa_request_id => p_altered_pa_request_id
203: ,p_noa_id_corrected => p_noa_id_corrected

Line 1819: ghr_history_fetch.fetch_element_entry_value

1815: hr_utility.set_location(l_proc,3);
1816:
1817: -- History package call fetch_element_entry_value picks new element name
1818: -- again in its call so sending old element name.
1819: ghr_history_fetch.fetch_element_entry_value
1820: (p_element_name => p_element_name,
1821: p_input_value_name => p_input_value_name,
1822: p_assignment_id => p_assignment_id,
1823: p_date_effective => p_effective_date,

Line 2909: ghr_history_fetch.fetch_assignment

2905: p_position_org_line5 := orig_par_rec.from_position_org_line5;
2906: p_position_org_line6 := orig_par_rec.from_position_org_line6;
2907:
2908: end loop;
2909: ghr_history_fetch.fetch_assignment
2910: ( p_assignment_id => p_assignment_id
2911: ,p_date_effective => l_effective_date
2912: ,p_altered_pa_request_id => p_altered_pa_request_id
2913: ,p_noa_id_corrected => p_noa_id_corrected

Line 2922: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50(

2918: null;
2919: -- raise error.
2920: end if;
2921: p_duty_station_location_id := l_assignment_data.location_id;
2922: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50(
2923: p_assignment_id => p_assignment_id,
2924: p_information_type => 'GHR_US_ASG_SF52',
2925: p_date_effective => l_effective_date,
2926: p_altered_pa_request_id => p_altered_pa_request_id,

Line 2947: ghr_history_fetch.fetch_assignment

2943: if p_assignment_id is NULL then
2944: hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2945: hr_utility.raise_error;
2946: else
2947: ghr_history_fetch.fetch_assignment
2948: ( p_assignment_id => p_assignment_id
2949: ,p_date_effective => p_effective_date
2950: ,p_altered_pa_request_id => p_altered_pa_request_id
2951: ,p_noa_id_corrected => p_noa_id_corrected

Line 3182: -- VSM added following 2 parameters to all the calls to GHR_History_Fetch procedures

3178: end if; --RP
3179: hr_utility.set_location(l_proc, 6);
3180:
3181:
3182: -- VSM added following 2 parameters to all the calls to GHR_History_Fetch procedures
3183: -- ,p_altered_pa_request_id => p_altered_pa_request_id
3184: -- ,p_noa_id_corrected => p_noa_id_corrected
3185:
3186:

Line 3192: ghr_history_fetch.fetch_asgei (p_assignment_id => p_assignment_id

3188: -- Retrieve Assignment Developer Descriptive Flexfield Information
3189: --
3190:
3191: -- This procedures uses session variables for p_altered)pa_request_id and p_noa_id_corrected
3192: ghr_history_fetch.fetch_asgei (p_assignment_id => p_assignment_id
3193: ,p_information_type => 'GHR_US_ASG_SF52'
3194: ,p_date_effective => l_effective_date
3195: ,p_asg_ei_data => l_asg_ei_data
3196: );

Line 3205: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id

3201: --
3202: -- Retrieve Position Developer Descriptive Flexfield Information
3203: --
3204: -- This procedures uses session variables for p_altered)pa_request_id and p_noa_id_corrected
3205: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id
3206: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
3207: ,p_date_effective => l_effective_date
3208: ,p_pos_ei_data => l_pos_ei_data
3209: );

Line 3220: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id

3216: --
3217: -- Retrieve work_Schedule -- (Added for OGSD)
3218:
3219: If p_assignment_id is null then
3220: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id
3221: ,p_information_type => 'GHR_US_POS_GRP1'
3222: ,p_date_effective => l_effective_date
3223: ,p_pos_ei_data => l_pos_ei_data
3224: );

Line 3231: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50(

3227: hr_utility.set_location(l_proc,9);
3228: Else
3229:
3230: -- VSM Prior PRD and Work Schedule
3231: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50(
3232: p_assignment_id => p_assignment_id,
3233: p_information_type => 'GHR_US_ASG_SF52',
3234: p_date_effective => l_effective_date,
3235: p_altered_pa_request_id => p_altered_pa_request_id,

Line 3413: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id

3409: --
3410: -- Retrieve Position's Organization's address lines
3411:
3412:
3413: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id
3414: ,p_information_type => 'GHR_US_POS_GRP1'
3415: ,p_date_effective => p_effective_date
3416: ,p_pos_ei_data => l_pos_ei_data
3417: );