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 HR_API

Line 1302: p_si ghr_api.special_information_type)

1298: p_transfer_name varchar2,
1299: p_effective_date date,
1300: p_person_id number,
1301: p_flex_name varchar2,
1302: p_si ghr_api.special_information_type)
1303: is
1304:
1305: l_concat varchar2(2000);
1306: l_segment1_meaning varchar2(80);

Line 1455: p_si ghr_api.special_information_type)

1451: p_transfer_name varchar2,
1452: p_effective_date date,
1453: p_person_id number,
1454: p_flex_name varchar2,
1455: p_si ghr_api.special_information_type)
1456: is
1457:
1458: l_segment1_meaning varchar2(80);
1459: l_segment2_meaning varchar2(80);

Line 4036: l_special_info ghr_api.special_information_type;

4032:
4033: l_pos_ei_data per_position_extra_info%rowtype;
4034: l_per_ei_data per_people_extra_info%rowtype;
4035: l_asg_ei_data per_assignment_extra_info%rowtype;
4036: l_special_info ghr_api.special_information_type;
4037:
4038: l_adj_basic_pay number;
4039: l_multi_error_flag boolean;
4040:

Line 4319: ghr_api.return_special_information

4315:
4316: insert_people_ei(l_transfer_name, l_effdate, l_people_ei_row);
4317:
4318: -- get person special information
4319: ghr_api.return_special_information
4320: (p_person_id => p_person_id
4321: ,p_structure_name => 'US Fed Education'
4322: ,p_effective_date => l_effdate
4323: ,p_special_info => l_special_info

Line 4329: ghr_api.return_special_information

4325:
4326: insert_special_info(l_transfer_name, l_effdate, p_person_id,
4327: 'US Fed Education', l_special_info);
4328:
4329: ghr_api.return_special_information
4330: (p_person_id => p_person_id
4331: ,p_structure_name => 'US Fed Cndtn of Emplmt'
4332: ,p_effective_date => l_effdate
4333: ,p_special_info => l_special_info

Line 4339: ghr_api.return_special_information

4335:
4336: insert_special_info(l_transfer_name, l_effdate, p_person_id,
4337: 'US Fed Cndtn of Emplmt', l_special_info);
4338:
4339: ghr_api.return_special_information
4340: (p_person_id => p_person_id
4341: ,p_structure_name => 'US Fed Conduct Perf'
4342: ,p_effective_date => l_effdate
4343: ,p_special_info => l_special_info

Line 4349: ghr_api.return_special_information

4345:
4346: insert_special_info(l_transfer_name, l_effdate, p_person_id,
4347: 'US Fed Conduct Perf', l_special_info);
4348:
4349: ghr_api.return_special_information
4350: (p_person_id => p_person_id
4351: ,p_structure_name => 'US Fed Language'
4352: ,p_effective_date => l_effdate
4353: ,p_special_info => l_special_info

Line 4359: ghr_api.return_special_information

4355:
4356: insert_special_info(l_transfer_name, l_effdate, p_person_id,
4357: 'US Fed Language', l_special_info);
4358:
4359: ghr_api.return_special_information
4360: (p_person_id => p_person_id
4361: ,p_structure_name => 'US Fed Spcl Consdrtn'
4362: ,p_effective_date => l_effdate
4363: ,p_special_info => l_special_info

Line 4369: ghr_api.return_special_information

4365:
4366: insert_special_info(l_transfer_name, l_effdate, p_person_id,
4367: 'US Fed Spcl Consdrtn', l_special_info);
4368:
4369: ghr_api.return_special_information
4370: (p_person_id => p_person_id
4371: ,p_structure_name => 'US Fed Perf Appraisal'
4372: ,p_effective_date => l_effdate
4373: ,p_special_info => l_special_info

Line 4616: ghr_api.retrieve_element_entry_value (

4612: -- Changes from Total Salary -> Amount
4613: -- Adjusted Pay -> Amount
4614:
4615:
4616: ghr_api.retrieve_element_entry_value (
4617: p_element_name => 'Total Pay'
4618: ,p_input_value_name => 'Amount'
4619: ,p_assignment_id => l_assignment_id
4620: ,p_effective_date => l_effdate

Line 4624: ghr_api.retrieve_element_entry_value (

4620: ,p_effective_date => l_effdate
4621: ,p_value => l_element.total_salary
4622: ,p_multiple_error_flag => l_multi_error_flag);
4623:
4624: ghr_api.retrieve_element_entry_value (
4625: p_element_name => 'Basic Salary Rate'
4626: ,p_input_value_name => 'Rate'
4627: ,p_assignment_id => l_assignment_id
4628: ,p_effective_date => l_effdate

Line 4632: ghr_api.retrieve_element_entry_value (

4628: ,p_effective_date => l_effdate
4629: ,p_value => l_element.salary
4630: ,p_multiple_error_flag => l_multi_error_flag);
4631:
4632: ghr_api.retrieve_element_entry_value (
4633: -- FWFA Changes Bug#4444609
4634: p_element_name => 'Locality Pay or SR Supplement'
4635: -- FWFA Changes Modify 'Locality Pay' to 'Locality Pay or SR Supplement'
4636: ,p_input_value_name => 'Rate'

Line 4643: ghr_api.retrieve_element_entry_value (

4639: ,p_effective_date => l_effdate
4640: ,p_value => l_element.locality_adjustment
4641: ,p_multiple_error_flag => l_multi_error_flag);
4642:
4643: ghr_api.retrieve_element_entry_value (
4644: p_element_name => 'Adjusted Basic Pay'
4645: ,p_input_value_name => 'Amount'
4646: ,p_assignment_id => l_assignment_id
4647: ,p_effective_date => l_effdate

Line 4651: ghr_api.retrieve_element_entry_value (

4647: ,p_effective_date => l_effdate
4648: ,p_value => l_element.adjusted_pay
4649: ,p_multiple_error_flag => l_multi_error_flag);
4650:
4651: ghr_api.retrieve_element_entry_value (
4652: p_element_name => 'Other Pay'
4653: ,p_input_value_name => 'Amount'
4654: ,p_assignment_id => l_assignment_id
4655: ,p_effective_date => l_effdate

Line 4659: ghr_api.retrieve_element_entry_value (

4655: ,p_effective_date => l_effdate
4656: ,p_value => l_element.other_pay
4657: ,p_multiple_error_flag => l_multi_error_flag);
4658:
4659: ghr_api.retrieve_element_entry_value (
4660: p_element_name => 'Health Benefits'
4661: ,p_input_value_name => 'Enrollment'
4662: ,p_assignment_id => l_assignment_id
4663: ,p_effective_date => l_effdate

Line 4667: ghr_api.retrieve_element_entry_value (

4663: ,p_effective_date => l_effdate
4664: ,p_value => l_element.enrollment
4665: ,p_multiple_error_flag => l_multi_error_flag);
4666:
4667: ghr_api.retrieve_element_entry_value (
4668: p_element_name => 'Health Benefits'
4669: ,p_input_value_name => 'Health Plan'
4670: ,p_assignment_id => l_assignment_id
4671: ,p_effective_date => l_effdate

Line 4675: ghr_api.retrieve_element_entry_value (

4671: ,p_effective_date => l_effdate
4672: ,p_value => l_element.health_plan
4673: ,p_multiple_error_flag => l_multi_error_flag);
4674:
4675: ghr_api.retrieve_element_entry_value (
4676: p_element_name => 'Health Benefits'
4677: ,p_input_value_name => 'Temps Total Cost'
4678: ,p_assignment_id => l_assignment_id
4679: ,p_effective_date => l_effdate

Line 4683: ghr_api.retrieve_element_entry_value (

4679: ,p_effective_date => l_effdate
4680: ,p_value => l_element.temps_total_cost
4681: ,p_multiple_error_flag => l_multi_error_flag);
4682:
4683: ghr_api.retrieve_element_entry_value (
4684: p_element_name => 'TSP'
4685: ,p_input_value_name => 'Amount'
4686: ,p_assignment_id => l_assignment_id
4687: ,p_effective_date => l_effdate

Line 4691: ghr_api.retrieve_element_entry_value (

4687: ,p_effective_date => l_effdate
4688: ,p_value => l_element.tsp_amount
4689: ,p_multiple_error_flag => l_multi_error_flag);
4690:
4691: ghr_api.retrieve_element_entry_value (
4692: p_element_name => 'TSP'
4693: ,p_input_value_name => 'Rate'
4694: ,p_assignment_id => l_assignment_id
4695: ,p_effective_date => l_effdate

Line 4699: ghr_api.retrieve_element_entry_value (

4695: ,p_effective_date => l_effdate
4696: ,p_value => l_element.tsp_rate
4697: ,p_multiple_error_flag => l_multi_error_flag);
4698:
4699: ghr_api.retrieve_element_entry_value (
4700: p_element_name => 'TSP'
4701: ,p_input_value_name => 'G Fund'
4702: ,p_assignment_id => l_assignment_id
4703: ,p_effective_date => l_effdate

Line 4707: ghr_api.retrieve_element_entry_value (

4703: ,p_effective_date => l_effdate
4704: ,p_value => l_element.tsp_g_fund
4705: ,p_multiple_error_flag => l_multi_error_flag);
4706:
4707: ghr_api.retrieve_element_entry_value (
4708: p_element_name => 'TSP'
4709: ,p_input_value_name => 'F Fund'
4710: ,p_assignment_id => l_assignment_id
4711: ,p_effective_date => l_effdate

Line 4715: ghr_api.retrieve_element_entry_value (

4711: ,p_effective_date => l_effdate
4712: ,p_value => l_element.tsp_f_fund
4713: ,p_multiple_error_flag => l_multi_error_flag);
4714:
4715: ghr_api.retrieve_element_entry_value (
4716: p_element_name => 'TSP'
4717: ,p_input_value_name => 'C Fund'
4718: ,p_assignment_id => l_assignment_id
4719: ,p_effective_date => l_effdate

Line 4723: ghr_api.retrieve_element_entry_value (

4719: ,p_effective_date => l_effdate
4720: ,p_value => l_element.tsp_c_fund
4721: ,p_multiple_error_flag => l_multi_error_flag);
4722:
4723: ghr_api.retrieve_element_entry_value (
4724: p_element_name => 'TSP'
4725: ,p_input_value_name => 'Status'
4726: ,p_assignment_id => l_assignment_id
4727: ,p_effective_date => l_effdate

Line 4731: ghr_api.retrieve_element_entry_value (

4727: ,p_effective_date => l_effdate
4728: ,p_value => l_element.tsp_status
4729: ,p_multiple_error_flag => l_multi_error_flag);
4730:
4731: ghr_api.retrieve_element_entry_value (
4732: p_element_name => 'TSP'
4733: ,p_input_value_name => 'Status Date'
4734: ,p_assignment_id => l_assignment_id
4735: ,p_effective_date => l_effdate

Line 4739: ghr_api.retrieve_element_entry_value (

4735: ,p_effective_date => l_effdate
4736: ,p_value => l_element.tsp_status_date
4737: ,p_multiple_error_flag => l_multi_error_flag);
4738:
4739: ghr_api.retrieve_element_entry_value (
4740: p_element_name => 'TSP'
4741: ,p_input_value_name => 'Eligibility Date'
4742: ,p_assignment_id => l_assignment_id
4743: ,p_effective_date => l_effdate

Line 4747: ghr_api.retrieve_element_entry_value (

4743: ,p_effective_date => l_effdate
4744: ,p_value => l_element.tsp_eligibility_date
4745: ,p_multiple_error_flag => l_multi_error_flag);
4746:
4747: ghr_api.retrieve_element_entry_value (
4748: p_element_name => 'Within Grade Increase'
4749: ,p_input_value_name => 'Status'
4750: ,p_assignment_id => l_assignment_id
4751: ,p_effective_date => l_effdate

Line 4755: ghr_api.retrieve_element_entry_value (

4751: ,p_effective_date => l_effdate
4752: ,p_value => l_element.wgi_status
4753: ,p_multiple_error_flag => l_multi_error_flag);
4754:
4755: ghr_api.retrieve_element_entry_value (
4756: p_element_name => 'Within Grade Increase'
4757: ,p_input_value_name => 'Date Due'
4758: ,p_assignment_id => l_assignment_id
4759: ,p_effective_date => l_effdate

Line 4763: ghr_api.retrieve_element_entry_value (

4759: ,p_effective_date => l_effdate
4760: ,p_value => l_element.wgi_date_due
4761: ,p_multiple_error_flag => l_multi_error_flag);
4762:
4763: ghr_api.retrieve_element_entry_value (
4764: p_element_name => 'Within Grade Increase'
4765: ,p_input_value_name => 'Pay Date'
4766: ,p_assignment_id => l_assignment_id
4767: ,p_effective_date => l_effdate

Line 4771: ghr_api.retrieve_element_entry_value (

4767: ,p_effective_date => l_effdate
4768: ,p_value => l_element.wgi_pay_date
4769: ,p_multiple_error_flag => l_multi_error_flag);
4770:
4771: ghr_api.retrieve_element_entry_value (
4772: p_element_name => 'Within Grade Increase'
4773: ,p_input_value_name => 'Last Increase Date'
4774: ,p_assignment_id => l_assignment_id
4775: ,p_effective_date => l_effdate

Line 4779: ghr_api.retrieve_element_entry_value (

4775: ,p_effective_date => l_effdate
4776: ,p_value => l_element.wgi_last_increase_date
4777: ,p_multiple_error_flag => l_multi_error_flag);
4778:
4779: ghr_api.retrieve_element_entry_value (
4780: p_element_name => 'Within Grade Increase'
4781: ,p_input_value_name => 'Postponmt Effective'
4782: ,p_assignment_id => l_assignment_id
4783: ,p_effective_date => l_effdate

Line 4787: ghr_api.retrieve_element_entry_value (

4783: ,p_effective_date => l_effdate
4784: ,p_value => l_element.wgi_postponmt_effective
4785: ,p_multiple_error_flag => l_multi_error_flag);
4786:
4787: ghr_api.retrieve_element_entry_value (
4788: p_element_name => 'Within Grade Increase'
4789: ,p_input_value_name => 'Postponmt Determ Due'
4790: ,p_assignment_id => l_assignment_id
4791: ,p_effective_date => l_effdate

Line 4795: ghr_api.retrieve_element_entry_value (

4791: ,p_effective_date => l_effdate
4792: ,p_value => l_element.wgi_postponmt_determ_due
4793: ,p_multiple_error_flag => l_multi_error_flag);
4794:
4795: ghr_api.retrieve_element_entry_value (
4796: p_element_name => 'FEGLI'
4797: ,p_input_value_name => 'FEGLI'
4798: ,p_assignment_id => l_assignment_id
4799: ,p_effective_date => l_effdate

Line 4803: ghr_api.retrieve_element_entry_value (

4799: ,p_effective_date => l_effdate
4800: ,p_value => l_element.fegli
4801: ,p_multiple_error_flag => l_multi_error_flag);
4802:
4803: ghr_api.retrieve_element_entry_value (
4804: p_element_name => 'FEGLI'
4805: ,p_input_value_name => 'Eligibility Expiration'
4806: ,p_assignment_id => l_assignment_id
4807: ,p_effective_date => l_effdate

Line 4811: ghr_api.retrieve_element_entry_value (

4807: ,p_effective_date => l_effdate
4808: ,p_value => l_element.eligibility_expiration
4809: ,p_multiple_error_flag => l_multi_error_flag);
4810:
4811: ghr_api.retrieve_element_entry_value (
4812: p_element_name => 'Retirement Plan'
4813: ,p_input_value_name => 'Plan'
4814: ,p_assignment_id => l_assignment_id
4815: ,p_effective_date => l_effdate

Line 4819: ghr_api.retrieve_element_entry_value (

4815: ,p_effective_date => l_effdate
4816: ,p_value => l_element.retirement_plan
4817: ,p_multiple_error_flag => l_multi_error_flag);
4818:
4819: ghr_api.retrieve_element_entry_value (
4820: p_element_name => 'Retention Allowance'
4821: ,p_input_value_name => 'Amount'
4822: ,p_assignment_id => l_assignment_id
4823: ,p_effective_date => l_effdate

Line 4827: ghr_api.retrieve_element_entry_value (

4823: ,p_effective_date => l_effdate
4824: ,p_value => l_element.retention_allowance
4825: ,p_multiple_error_flag => l_multi_error_flag);
4826:
4827: ghr_api.retrieve_element_entry_value (
4828: p_element_name => 'Retention Allowance'
4829: ,p_input_value_name => 'Percentage'
4830: ,p_assignment_id => l_assignment_id
4831: ,p_effective_date => l_effdate

Line 4835: ghr_api.retrieve_element_entry_value (

4831: ,p_effective_date => l_effdate
4832: ,p_value => l_element.to_retention_allow_percentage
4833: ,p_multiple_error_flag => l_multi_error_flag);
4834:
4835: ghr_api.retrieve_element_entry_value (
4836: p_element_name => 'Staffing Differential'
4837: ,p_input_value_name => 'Amount'
4838: ,p_assignment_id => l_assignment_id
4839: ,p_effective_date => l_effdate

Line 4843: ghr_api.retrieve_element_entry_value (

4839: ,p_effective_date => l_effdate
4840: ,p_value => l_element.staffing_differential
4841: ,p_multiple_error_flag => l_multi_error_flag);
4842:
4843: ghr_api.retrieve_element_entry_value (
4844: p_element_name => 'Staffing Differential'
4845: ,p_input_value_name => 'Percent'
4846: ,p_assignment_id => l_assignment_id
4847: ,p_effective_date => l_effdate

Line 4851: ghr_api.retrieve_element_entry_value (

4847: ,p_effective_date => l_effdate
4848: ,p_value => l_element.to_staffing_diff_percentage
4849: ,p_multiple_error_flag => l_multi_error_flag);
4850:
4851: ghr_api.retrieve_element_entry_value (
4852: p_element_name => 'Supervisory Differential'
4853: ,p_input_value_name => 'Amount'
4854: ,p_assignment_id => l_assignment_id
4855: ,p_effective_date => l_effdate

Line 4859: ghr_api.retrieve_element_entry_value (

4855: ,p_effective_date => l_effdate
4856: ,p_value => l_element.supervisory_differential
4857: ,p_multiple_error_flag => l_multi_error_flag);
4858:
4859: ghr_api.retrieve_element_entry_value (
4860: p_element_name => 'Supervisory Differential'
4861: ,p_input_value_name => 'Percentage'
4862: ,p_assignment_id => l_assignment_id
4863: ,p_effective_date => l_effdate

Line 4867: ghr_api.retrieve_element_entry_value (

4863: ,p_effective_date => l_effdate
4864: ,p_value => l_element.to_supervisory_diff_percentage
4865: ,p_multiple_error_flag => l_multi_error_flag);
4866:
4867: ghr_api.retrieve_element_entry_value (
4868: p_element_name => 'AUO'
4869: ,p_input_value_name => 'Amount'
4870: ,p_assignment_id => l_assignment_id
4871: ,p_effective_date => l_effdate

Line 4875: ghr_api.retrieve_element_entry_value (

4871: ,p_effective_date => l_effdate
4872: ,p_value => l_element.auo_amount
4873: ,p_multiple_error_flag => l_multi_error_flag);
4874:
4875: ghr_api.retrieve_element_entry_value (
4876: p_element_name => 'AUO'
4877: ,p_input_value_name => 'Premium Pay Ind'
4878: ,p_assignment_id => l_assignment_id
4879: ,p_effective_date => l_effdate

Line 4883: ghr_api.retrieve_element_entry_value (

4879: ,p_effective_date => l_effdate
4880: ,p_value => l_element.auo_premium_pay_ind
4881: ,p_multiple_error_flag => l_multi_error_flag);
4882:
4883: ghr_api.retrieve_element_entry_value (
4884: p_element_name => 'Availability Pay'
4885: ,p_input_value_name => 'Amount'
4886: ,p_assignment_id => l_assignment_id
4887: ,p_effective_date => l_effdate

Line 4891: ghr_api.retrieve_element_entry_value (

4887: ,p_effective_date => l_effdate
4888: ,p_value => l_element.ap_amount
4889: ,p_multiple_error_flag => l_multi_error_flag);
4890:
4891: ghr_api.retrieve_element_entry_value (
4892: p_element_name => 'Availability Pay'
4893: ,p_input_value_name => 'Premium Pay Ind'
4894: ,p_assignment_id => l_assignment_id
4895: ,p_effective_date => l_effdate

Line 4919: l_misc.occ_series := ghr_api.get_job_occupational_series(

4915: open cur_grd(l_grade_id);
4916: fetch cur_grd into l_misc.from_pay_plan, l_misc.from_grade_or_level;
4917: close cur_grd;
4918:
4919: l_misc.occ_series := ghr_api.get_job_occupational_series(
4920: p_person_id => p_person_id
4921: ,p_assignment_id => l_assignment_id
4922: ,p_effective_date => l_effdate);
4923: