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 1303: p_si ghr_api.special_information_type)

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

Line 1456: p_si ghr_api.special_information_type)

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

Line 4037: l_special_info ghr_api.special_information_type;

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

Line 4320: ghr_api.return_special_information

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

Line 4330: ghr_api.return_special_information

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

Line 4340: ghr_api.return_special_information

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

Line 4350: ghr_api.return_special_information

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

Line 4360: ghr_api.return_special_information

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

Line 4370: ghr_api.return_special_information

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

Line 4619: ghr_api.retrieve_element_entry_value (

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

Line 4627: ghr_api.retrieve_element_entry_value (

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

Line 4635: ghr_api.retrieve_element_entry_value (

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

Line 4646: ghr_api.retrieve_element_entry_value (

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

Line 4654: ghr_api.retrieve_element_entry_value (

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

Line 4662: ghr_api.retrieve_element_entry_value (

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

Line 4670: ghr_api.retrieve_element_entry_value (

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

Line 4678: ghr_api.retrieve_element_entry_value (

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

Line 4686: ghr_api.retrieve_element_entry_value (

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

Line 4694: ghr_api.retrieve_element_entry_value (

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

Line 4702: ghr_api.retrieve_element_entry_value (

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

Line 4710: ghr_api.retrieve_element_entry_value (

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

Line 4718: ghr_api.retrieve_element_entry_value (

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

Line 4726: ghr_api.retrieve_element_entry_value (

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

Line 4734: ghr_api.retrieve_element_entry_value (

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

Line 4742: ghr_api.retrieve_element_entry_value (

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

Line 4750: ghr_api.retrieve_element_entry_value (

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

Line 4758: ghr_api.retrieve_element_entry_value (

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

Line 4766: ghr_api.retrieve_element_entry_value (

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

Line 4774: ghr_api.retrieve_element_entry_value (

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

Line 4782: ghr_api.retrieve_element_entry_value (

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

Line 4790: ghr_api.retrieve_element_entry_value (

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

Line 4798: ghr_api.retrieve_element_entry_value (

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

Line 4806: ghr_api.retrieve_element_entry_value (

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

Line 4814: ghr_api.retrieve_element_entry_value (

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

Line 4822: ghr_api.retrieve_element_entry_value (

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

Line 4830: ghr_api.retrieve_element_entry_value (

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

Line 4838: ghr_api.retrieve_element_entry_value (

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

Line 4846: ghr_api.retrieve_element_entry_value (

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

Line 4854: ghr_api.retrieve_element_entry_value (

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

Line 4862: ghr_api.retrieve_element_entry_value (

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

Line 4870: ghr_api.retrieve_element_entry_value (

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

Line 4878: ghr_api.retrieve_element_entry_value (

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

Line 4886: ghr_api.retrieve_element_entry_value (

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

Line 4894: ghr_api.retrieve_element_entry_value (

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

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

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