eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MTO_INT dependencies on GHR_HISTORY_FETCH

Line 4148: ghr_history_fetch.fetch_people (

4144: hr_utility.raise_error;
4145:
4146: end if;
4147:
4148: ghr_history_fetch.fetch_people (
4149: p_person_id => p_person_id,
4150: p_date_effective => l_effdate,
4151: p_people_data => l_people_row,
4152: p_result_code => l_rc

Line 4198: ghr_history_fetch.fetch_peopleei

4194: -- procedure insert_people_ei tests if informaton_type is null and
4195: -- if it is the row in not inserted into the interface table
4196:
4197: l_people_ei_row.information_type := null;
4198: ghr_history_fetch.fetch_peopleei
4199: (p_person_id => p_person_id
4200: ,p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES'
4201: ,p_date_effective => l_effdate
4202: ,p_per_ei_data => l_people_ei_row

Line 4208: ghr_history_fetch.fetch_peopleei

4204:
4205: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4206:
4207: l_people_ei_row.information_type := null;
4208: ghr_history_fetch.fetch_peopleei
4209: (p_person_id => p_person_id
4210: ,p_information_type => 'GHR_US_PER_SF52'
4211: ,p_date_effective => l_effdate
4212: ,p_per_ei_data => l_people_ei_row

Line 4218: ghr_history_fetch.fetch_peopleei

4214:
4215: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4216:
4217: l_people_ei_row.information_type := null;
4218: ghr_history_fetch.fetch_peopleei
4219: (p_person_id => p_person_id
4220: ,p_information_type => 'GHR_US_PER_GROUP1'
4221: ,p_date_effective => l_effdate
4222: ,p_per_ei_data => l_people_ei_row

Line 4228: ghr_history_fetch.fetch_peopleei

4224:
4225: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4226:
4227: l_people_ei_row.information_type := null;
4228: ghr_history_fetch.fetch_peopleei
4229: (p_person_id => p_person_id
4230: ,p_information_type => 'GHR_US_PER_GROUP2'
4231: ,p_date_effective => l_effdate
4232: ,p_per_ei_data => l_people_ei_row

Line 4239: ghr_history_fetch.fetch_peopleei

4235: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4236:
4237:
4238: l_people_ei_row.information_type := null;
4239: ghr_history_fetch.fetch_peopleei
4240: (p_person_id => p_person_id
4241: ,p_information_type => 'GHR_US_PER_SCD_INFORMATION'
4242: ,p_date_effective => l_effdate
4243: ,p_per_ei_data => l_people_ei_row

Line 4249: ghr_history_fetch.fetch_peopleei

4245:
4246: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4247:
4248: l_people_ei_row.information_type := null;
4249: ghr_history_fetch.fetch_peopleei
4250: (p_person_id => p_person_id
4251: ,p_information_type => 'GHR_US_PER_PROBATIONS'
4252: ,p_date_effective => l_effdate
4253: ,p_per_ei_data => l_people_ei_row

Line 4259: ghr_history_fetch.fetch_peopleei

4255:
4256: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4257:
4258: l_people_ei_row.information_type := null;
4259: ghr_history_fetch.fetch_peopleei
4260: (p_person_id => p_person_id
4261: ,p_information_type => 'GHR_US_PER_RETAINED_GRADE'
4262: ,p_date_effective => l_effdate
4263: ,p_per_ei_data => l_people_ei_row

Line 4269: ghr_history_fetch.fetch_peopleei

4265:
4266: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4267:
4268: l_people_ei_row.information_type := null;
4269: ghr_history_fetch.fetch_peopleei
4270: (p_person_id => p_person_id
4271: ,p_information_type => 'GHR_US_PER_SEPARATE_RETIRE'
4272: ,p_date_effective => l_effdate
4273: ,p_per_ei_data => l_people_ei_row

Line 4279: ghr_history_fetch.fetch_peopleei

4275:
4276: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4277:
4278: l_people_ei_row.information_type := null;
4279: ghr_history_fetch.fetch_peopleei
4280: (p_person_id => p_person_id
4281: ,p_information_type => 'GHR_US_PER_SECURITY'
4282: ,p_date_effective => l_effdate
4283: ,p_per_ei_data => l_people_ei_row

Line 4289: ghr_history_fetch.fetch_peopleei

4285:
4286: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4287:
4288: l_people_ei_row.information_type := null;
4289: ghr_history_fetch.fetch_peopleei
4290: (p_person_id => p_person_id
4291: ,p_information_type => 'GHR_US_PER_CONVERSIONS'
4292: ,p_date_effective => l_effdate
4293: ,p_per_ei_data => l_people_ei_row

Line 4299: ghr_history_fetch.fetch_peopleei

4295:
4296: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4297:
4298: l_people_ei_row.information_type := null;
4299: ghr_history_fetch.fetch_peopleei
4300: (p_person_id => p_person_id
4301: ,p_information_type => 'GHR_US_PER_USER_INFO'
4302: ,p_date_effective => l_effdate
4303: ,p_per_ei_data => l_people_ei_row

Line 4309: ghr_history_fetch.fetch_peopleei

4305:
4306: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4307:
4308: l_people_ei_row.information_type := null;
4309: ghr_history_fetch.fetch_peopleei
4310: (p_person_id => p_person_id
4311: ,p_information_type => 'GHR_US_PER_WF_ROUTING_GROUPS'
4312: ,p_date_effective => l_effdate
4313: ,p_per_ei_data => l_people_ei_row

Line 4444: ghr_history_fetch.fetch_assignment (

4440: hr_utility.raise_error;
4441: end if;
4442: close cur_assignments_f;
4443:
4444: ghr_history_fetch.fetch_assignment (
4445: p_assignment_id => l_assignment_id,
4446: p_date_effective => l_effdate,
4447: p_assignment_data => l_assignments_row,
4448: p_result_code => l_rc);

Line 4469: ghr_history_fetch.fetch_asgei(

4465: p_a => l_assignments_row);
4466:
4467: -- get assignment extra info
4468: l_assignment_ei_row.information_type := null;
4469: ghr_history_fetch.fetch_asgei(
4470: p_assignment_id => l_assignment_id,
4471: p_information_type => 'GHR_US_ASG_SF52',
4472: p_date_effective => l_effdate,
4473: p_asg_ei_data => l_assignment_ei_row

Line 4483: ghr_history_fetch.fetch_asgei(

4479: p_a_ei => l_assignment_ei_row
4480: );
4481:
4482: l_assignment_ei_row.information_type := null;
4483: ghr_history_fetch.fetch_asgei(
4484: p_assignment_id => l_assignment_id,
4485: p_information_type => 'GHR_US_ASG_NON_SF52',
4486: p_date_effective => l_effdate,
4487: p_asg_ei_data => l_assignment_ei_row

Line 4497: ghr_history_fetch.fetch_asgei(

4493: p_a_ei => l_assignment_ei_row
4494: );
4495:
4496: l_assignment_ei_row.information_type := null;
4497: ghr_history_fetch.fetch_asgei(
4498: p_assignment_id => l_assignment_id,
4499: p_information_type => 'GHR_US_ASG_NTE_DATES',
4500: p_date_effective => l_effdate,
4501: p_asg_ei_data => l_assignment_ei_row

Line 4511: ghr_history_fetch.fetch_position(

4507: p_a_ei => l_assignment_ei_row
4508: );
4509:
4510: -- get position info
4511: ghr_history_fetch.fetch_position(
4512: p_position_id => l_position_id,
4513: p_date_effective => l_effdate,
4514: p_position_data => l_position_row,
4515: p_result_code => l_rc

Line 4525: ghr_history_fetch.fetch_positionei

4521: p_pos => l_position_row);
4522:
4523: -- get position extra info
4524: l_position_ei_row.information_type := null;
4525: ghr_history_fetch.fetch_positionei
4526: (p_position_id => l_position_id
4527: ,p_information_type => 'GHR_US_POS_GRP1'
4528: ,p_date_effective => l_effdate
4529: ,p_pos_ei_data => l_position_ei_row

Line 4538: ghr_history_fetch.fetch_positionei

4534: p_effective_date => l_effdate,
4535: p_pos_ei => l_position_ei_row);
4536:
4537: l_position_ei_row.information_type := null;
4538: ghr_history_fetch.fetch_positionei
4539: (p_position_id => l_position_id
4540: ,p_information_type => 'GHR_US_POS_GRP2'
4541: ,p_date_effective => l_effdate
4542: ,p_pos_ei_data => l_position_ei_row

Line 4551: ghr_history_fetch.fetch_positionei

4547: p_effective_date => l_effdate,
4548: p_pos_ei => l_position_ei_row);
4549:
4550: l_position_ei_row.information_type := null;
4551: ghr_history_fetch.fetch_positionei
4552: (p_position_id => l_position_id
4553: ,p_information_type => 'GHR_US_POSITION_DESCRIPTION'
4554: ,p_date_effective => l_effdate
4555: ,p_pos_ei_data => l_position_ei_row

Line 4564: ghr_history_fetch.fetch_positionei

4560: p_effective_date => l_effdate,
4561: p_pos_ei => l_position_ei_row);
4562:
4563: l_position_ei_row.information_type := null;
4564: ghr_history_fetch.fetch_positionei
4565: (p_position_id => l_position_id
4566: ,p_information_type => 'GHR_US_POS_OBLIG'
4567: ,p_date_effective => l_effdate
4568: ,p_pos_ei_data => l_position_ei_row

Line 4577: ghr_history_fetch.fetch_positionei

4573: p_effective_date => l_effdate,
4574: p_pos_ei => l_position_ei_row);
4575:
4576: l_position_ei_row.information_type := null;
4577: ghr_history_fetch.fetch_positionei
4578: (p_position_id => l_position_id
4579: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
4580: ,p_date_effective => l_effdate
4581: ,p_pos_ei_data => l_position_ei_row

Line 4588: GHR_HISTORY_FETCH.fetch_position (

4584: insert_position_ei(p_transfer_name => l_transfer_name,
4585: p_person_id => p_person_id,
4586: p_effective_date => l_effdate,
4587: p_pos_ei => l_position_ei_row);
4588: GHR_HISTORY_FETCH.fetch_position (
4589: p_position_id => l_position_id,
4590: p_date_effective => l_effdate,
4591: p_position_data => l_position_rec,
4592: p_result_code => l_result_code );