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 2929: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50(

2925: p_organization_id := l_assignment_data.organization_id;
2926: p_grade_id := l_assignment_data.grade_id;
2927: --6850492
2928:
2929: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50(
2930: p_assignment_id => p_assignment_id,
2931: p_information_type => 'GHR_US_ASG_SF52',
2932: p_date_effective => l_effective_date,
2933: p_altered_pa_request_id => p_altered_pa_request_id,

Line 2954: ghr_history_fetch.fetch_assignment

2950: if p_assignment_id is NULL then
2951: hr_utility.set_message(8301, 'GHR_38037_API_ARG_ERR');
2952: hr_utility.raise_error;
2953: else
2954: ghr_history_fetch.fetch_assignment
2955: ( p_assignment_id => p_assignment_id
2956: ,p_date_effective => p_effective_date
2957: ,p_altered_pa_request_id => p_altered_pa_request_id
2958: ,p_noa_id_corrected => p_noa_id_corrected

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

3185: end if; --RP
3186: hr_utility.set_location(l_proc, 6);
3187:
3188:
3189: -- VSM added following 2 parameters to all the calls to GHR_History_Fetch procedures
3190: -- ,p_altered_pa_request_id => p_altered_pa_request_id
3191: -- ,p_noa_id_corrected => p_noa_id_corrected
3192:
3193:

Line 3199: ghr_history_fetch.fetch_asgei (p_assignment_id => p_assignment_id

3195: -- Retrieve Assignment Developer Descriptive Flexfield Information
3196: --
3197:
3198: -- This procedures uses session variables for p_altered)pa_request_id and p_noa_id_corrected
3199: ghr_history_fetch.fetch_asgei (p_assignment_id => p_assignment_id
3200: ,p_information_type => 'GHR_US_ASG_SF52'
3201: ,p_date_effective => l_effective_date
3202: ,p_asg_ei_data => l_asg_ei_data
3203: );

Line 3212: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id

3208: --
3209: -- Retrieve Position Developer Descriptive Flexfield Information
3210: --
3211: -- This procedures uses session variables for p_altered)pa_request_id and p_noa_id_corrected
3212: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id
3213: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
3214: ,p_date_effective => l_effective_date
3215: ,p_pos_ei_data => l_pos_ei_data
3216: );

Line 3227: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id

3223: --
3224: -- Retrieve work_Schedule -- (Added for OGSD)
3225:
3226: If p_assignment_id is null then
3227: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id
3228: ,p_information_type => 'GHR_US_POS_GRP1'
3229: ,p_date_effective => l_effective_date
3230: ,p_pos_ei_data => l_pos_ei_data
3231: );

Line 3238: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50(

3234: hr_utility.set_location(l_proc,9);
3235: Else
3236:
3237: -- VSM Prior PRD and Work Schedule
3238: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50(
3239: p_assignment_id => p_assignment_id,
3240: p_information_type => 'GHR_US_ASG_SF52',
3241: p_date_effective => l_effective_date,
3242: p_altered_pa_request_id => p_altered_pa_request_id,

Line 3420: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id

3416: --
3417: -- Retrieve Position's Organization's address lines
3418:
3419:
3420: ghr_history_fetch.fetch_positionei (p_position_id => l_position_id
3421: ,p_information_type => 'GHR_US_POS_GRP1'
3422: ,p_date_effective => p_effective_date
3423: ,p_pos_ei_data => l_pos_ei_data
3424: );