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 4149: ghr_history_fetch.fetch_people (

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

Line 4199: ghr_history_fetch.fetch_peopleei

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

Line 4209: ghr_history_fetch.fetch_peopleei

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

Line 4219: ghr_history_fetch.fetch_peopleei

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

Line 4229: ghr_history_fetch.fetch_peopleei

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

Line 4240: ghr_history_fetch.fetch_peopleei

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

Line 4250: ghr_history_fetch.fetch_peopleei

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

Line 4260: ghr_history_fetch.fetch_peopleei

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

Line 4270: ghr_history_fetch.fetch_peopleei

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

Line 4280: ghr_history_fetch.fetch_peopleei

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

Line 4290: ghr_history_fetch.fetch_peopleei

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

Line 4300: ghr_history_fetch.fetch_peopleei

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

Line 4310: ghr_history_fetch.fetch_peopleei

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

Line 4446: ghr_history_fetch.fetch_assignment (

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

Line 4472: ghr_history_fetch.fetch_asgei(

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

Line 4486: ghr_history_fetch.fetch_asgei(

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

Line 4500: ghr_history_fetch.fetch_asgei(

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

Line 4514: ghr_history_fetch.fetch_position(

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

Line 4528: ghr_history_fetch.fetch_positionei

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

Line 4541: ghr_history_fetch.fetch_positionei

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

Line 4554: ghr_history_fetch.fetch_positionei

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

Line 4567: ghr_history_fetch.fetch_positionei

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

Line 4580: ghr_history_fetch.fetch_positionei

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

Line 4591: GHR_HISTORY_FETCH.fetch_position (

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