DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on GHR_ELEMENT_API

Line 5248: ghr_element_api.retrieve_element_info

5244:
5245: if ((p_pa_request_rec.noa_family_code <> 'APP')
5246: OR
5247: (p_pa_request_rec.noa_family_code = 'CONV_APP' and NOT l_ex_emp)) then
5248: ghr_element_api.retrieve_element_info
5249: (p_element_name => 'Basic Salary Rate'
5250: ,p_input_value_name => 'Rate'
5251: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
5252: ,p_effective_date => l_effective_date

Line 5321: ghr_element_api.process_sf52_element

5317: END IF;
5318: -- if Payroll is not installed
5319: ELSIF NOT l_pay_intg
5320: THEN
5321: ghr_element_api.process_sf52_element
5322: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5323: ,p_element_name => 'Basic Salary Rate'
5324: ,p_input_value_name1 => 'Rate'
5325: ,p_value1 => to_char(p_pa_request_rec.to_basic_pay)

Line 5349: ghr_element_api.process_sf52_element

5345: --
5346: If p_pa_request_rec.to_adj_basic_pay is not null then
5347: hr_utility.set_location(l_proc,20);
5348:
5349: ghr_element_api.process_sf52_element
5350: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5351: ,p_element_name => 'Adjusted Basic Pay'
5352: ,p_input_value_name1 => 'Amount'
5353: ,p_value1 => to_char(p_pa_request_rec.to_adj_basic_pay)

Line 5376: ghr_element_api.process_sf52_element

5372: If p_pa_request_rec.to_adj_basic_pay is not null then
5373: if ghr_pay_calc.g_gm_unadjd_basic_pay is not null and ghr_pay_calc.g_gm_unadjd_basic_pay <> 0 then
5374: hr_utility.set_location(l_proc,21);
5375:
5376: ghr_element_api.process_sf52_element
5377: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5378: ,p_element_name => 'Unadjusted Basic Pay'
5379: ,p_input_value_name1 => 'Amount'
5380: ,p_value1 => to_char(ghr_pay_calc.g_gm_unadjd_basic_pay)

Line 5396: ghr_element_api.process_sf52_element

5392: --
5393: If p_pa_request_rec.to_locality_adj is not null then
5394: hr_utility.set_location(l_proc,30);
5395: -- FWFA Changes Bug#4444609: Modify 'Locality Pay' to 'Locality Pay or SR Supplement'
5396: ghr_element_api.process_sf52_element
5397: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5398: ,p_element_name => 'Locality Pay or SR Supplement'
5399: ,p_input_value_name1 => 'Rate'
5400: -- 'Rate' was put by Ashu Gupta in place of 'Amount'

Line 5429: ghr_element_api.process_sf52_element

5425: p_pa_request_rec.second_noa_code IN ('815','816','825','827') THEN
5426: NULL;
5427: ELSE
5428: hr_utility.set_location(l_proc,45);
5429: ghr_element_api.process_sf52_element
5430: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5431: ,p_element_name => 'Total Pay'
5432: ,p_input_value_name1 => 'Amount'
5433: ,p_value1 => to_char(p_pa_request_rec.to_total_salary)

Line 5461: ghr_element_api.process_sf52_element

5457: nvl(p_pa_request_rec.to_supervisory_differential, 0) +
5458: nvl(p_pa_request_rec.to_staffing_differential , 0);
5459: END IF;
5460: hr_utility.set_location(l_proc,55);
5461: ghr_element_api.process_sf52_element
5462: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5463: ,p_element_name => 'Other Pay'
5464: ,p_input_value_name1 => 'Amount'
5465: ,p_value1 => to_char(l_entitled_other_pay)

Line 5492: ghr_element_api.process_sf52_element

5488:
5489: l_element_entry_id := ele_entry.element_entry_id;
5490: End loop;
5491: If l_element_entry_id is not null then
5492: ghr_element_api.process_sf52_element
5493: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5494: ,p_element_name => 'Other Pay'
5495: ,p_input_value_name1 => 'Amount'
5496: ,p_value1 => to_char(p_pa_request_rec.to_other_pay_amount)

Line 5510: ghr_element_api.process_sf52_element

5506:
5507: If p_pa_request_rec.to_auo_premium_pay_indicator is not null or
5508: p_pa_request_rec.to_au_overtime is not null then
5509: hr_utility.set_location(l_proc,60);
5510: ghr_element_api.process_sf52_element
5511: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5512: ,p_element_name => 'AUO'
5513: ,p_input_value_name1 => 'Premium Pay Ind'
5514: ,p_value1 => p_pa_request_rec.to_auo_premium_pay_indicator

Line 5521: ghr_element_api.process_sf52_element

5517: ,p_effective_date => l_effective_date
5518: ,p_process_warning => l_adj_basic_pay_warn
5519: );
5520:
5521: ghr_element_api.process_sf52_element
5522: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5523: ,p_element_name => 'Premium Pay'
5524: ,p_input_value_name1 => 'Premium Pay Ind'
5525: ,p_value1 => p_pa_request_rec.to_auo_premium_pay_indicator

Line 5553: ghr_element_api.process_sf52_element

5549:
5550: l_element_entry_id := ele_entry.element_entry_id;
5551: End loop;
5552: if l_element_entry_id is not null then
5553: ghr_element_api.process_sf52_element
5554: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5555: ,p_element_name => 'AUO'
5556: ,p_input_value_name1 => 'Premium Pay Ind'
5557: ,p_value1 => p_pa_request_rec.to_auo_premium_pay_indicator

Line 5564: ghr_element_api.process_sf52_element

5560: ,p_effective_date => l_effective_date
5561: ,p_process_warning => l_adj_basic_pay_warn
5562: );
5563:
5564: ghr_element_api.process_sf52_element
5565: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5566: ,p_element_name => 'Premium Pay'
5567: ,p_input_value_name1 => 'Premium Pay Ind'
5568: ,p_value1 => p_pa_request_rec.to_auo_premium_pay_indicator

Line 5587: ghr_element_api.process_sf52_element

5583:
5584: If p_pa_request_rec.to_ap_premium_pay_indicator is not null or
5585: p_pa_request_rec.to_availability_pay is not null then
5586: hr_utility.set_location(l_proc,65);
5587: ghr_element_api.process_sf52_element
5588: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5589: ,p_element_name => 'Availability Pay'
5590: ,p_input_value_name1 => 'Premium Pay Ind'
5591: ,p_value1 => p_pa_request_rec.to_ap_premium_pay_indicator

Line 5598: ghr_element_api.process_sf52_element

5594: ,p_effective_date => l_effective_date
5595: ,p_process_warning => l_adj_basic_pay_warn
5596: );
5597:
5598: ghr_element_api.process_sf52_element
5599: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5600: ,p_element_name => 'Premium Pay'
5601: ,p_input_value_name1 => 'Premium Pay Ind'
5602: ,p_value1 => p_pa_request_rec.to_ap_premium_pay_indicator

Line 5631: ghr_element_api.process_sf52_element

5627: l_element_entry_id := ele_entry.element_entry_id;
5628: End loop;
5629: if l_element_entry_id is not null then
5630: hr_utility.set_location(l_proc,33);
5631: ghr_element_api.process_sf52_element
5632: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5633: ,p_element_name => 'Availability Pay'
5634: ,p_input_value_name1 => 'Premium Pay Ind'
5635: ,p_value1 => p_pa_request_rec.to_ap_premium_pay_indicator

Line 5642: ghr_element_api.process_sf52_element

5638: ,p_effective_date => l_effective_date
5639: ,p_process_warning => l_adj_basic_pay_warn
5640: );
5641:
5642: ghr_element_api.process_sf52_element
5643: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5644: ,p_element_name => 'Premium Pay'
5645: ,p_input_value_name1 => 'Premium Pay Ind'
5646: ,p_value1 => p_pa_request_rec.to_ap_premium_pay_indicator

Line 5670: ghr_element_api.process_sf52_element

5666:
5667: If p_pa_request_rec.to_supervisory_differential is not null or
5668: p_pa_request_rec.to_supervisory_diff_percentage is not null then
5669: hr_utility.set_location(l_proc,70);
5670: ghr_element_api.process_sf52_element
5671: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5672: ,p_element_name => 'Supervisory Differential'
5673: ,p_input_value_name1 => 'Amount'
5674: ,p_value1 => to_char(p_pa_request_rec.to_supervisory_differential)

Line 5702: ghr_element_api.process_sf52_element

5698:
5699: l_element_entry_id := ele_entry.element_entry_id;
5700: End loop;
5701: If l_element_entry_id is not null then
5702: ghr_element_api.process_sf52_element
5703: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5704: ,p_element_name => 'Supervisory Differential'
5705: ,p_input_value_name1 => 'Amount'
5706: ,p_value1 => to_char(p_pa_request_rec.to_supervisory_differential)

Line 5728: ghr_element_api.process_sf52_element

5724: If p_pa_request_rec.to_staffing_differential is not null or
5725: p_pa_request_rec.to_staffing_diff_percentage is not null then
5726:
5727: hr_utility.set_location(l_proc,75);
5728: ghr_element_api.process_sf52_element
5729: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5730: ,p_element_name => 'Staffing Differential'
5731: ,p_input_value_name1 => 'Amount'
5732: ,p_value1 => to_char(p_pa_request_rec.to_staffing_differential)

Line 5758: ghr_element_api.process_sf52_element

5754:
5755: l_element_entry_id := ele_entry.element_entry_id;
5756: End loop;
5757: If l_element_entry_id is not null then
5758: ghr_element_api.process_sf52_element
5759: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5760: ,p_element_name => 'Staffing Differential'
5761: ,p_input_value_name1 => 'Amount'
5762: ,p_value1 => to_char(p_pa_request_rec.to_staffing_differential)

Line 5837: ghr_element_api.process_sf52_element

5833: END IF;
5834: -- Bug 2627003
5835:
5836: hr_utility.set_location(l_proc,80);
5837: ghr_element_api.process_sf52_element
5838: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5839: ,p_element_name => 'Retention Allowance'
5840: ,p_input_value_name1 => 'Amount'
5841: ,p_value1 => to_char(p_pa_request_rec.to_retention_allowance)

Line 5880: ghr_element_api.process_sf52_element

5876: p_retention_allow_review.review_date:=NULL;
5877: END IF;
5878: -- Bug 2627003 Adding inp val date for processing
5879:
5880: ghr_element_api.process_sf52_element
5881: (p_assignment_id => p_pa_request_rec.employee_assignment_id
5882: ,p_element_name => 'Retention Allowance'
5883: ,p_input_value_name1 => 'Amount'
5884: ,p_value1 => to_char(p_pa_request_rec.to_retention_allowance)

Line 6012: ghr_element_api.process_sf52_element

6008: l_wgi_exists := TRUE;
6009: END LOOP;
6010:
6011: IF l_wgi_exists = TRUE THEN
6012: ghr_element_api.process_sf52_element
6013: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6014: ,p_element_name => 'Within Grade Increase'
6015: ,p_input_value_name2 => 'Date Due'
6016: ,p_value2 => NULL

Line 6043: ghr_element_api.process_sf52_element

6039: p_retained_grade_rec => l_retained_grade_rec,
6040: p_dlei => NULL
6041: );
6042: hr_utility.set_location('Inside If loop',511);
6043: ghr_element_api.process_sf52_element
6044: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6045: ,p_element_name => 'Within Grade Increase'
6046: ,p_input_value_name2 => 'Date Due'
6047: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR

Line 6065: ghr_element_api.process_sf52_element

6061: -- it comes here. Need to update NULL in that case. .
6062: ELSIF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) IN ('APP','CONV_APP')
6063: AND p_wgi.p_last_equi_incr IS NOT NULL AND l_wgi_cleared = FALSE THEN
6064: hr_utility.set_location('Inside elsif loop',511);
6065: ghr_element_api.process_sf52_element
6066: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6067: ,p_element_name => 'Within Grade Increase'
6068: ,p_input_value_name2 => 'Date Due'
6069: ,p_value2 => NULL -- Bug 3998686

Line 6173: ghr_element_api.process_sf52_element

6169: hr_utility.set_location('l_wgi_due_date calculated is ' || l_wgi_due_date,1);
6170: hr_utility.set_location('lei date calculated is ' || p_wgi.p_last_equi_incr,2);
6171: hr_utility.set_location('l_wgi_pay_date calculated is ' || l_wgi_pay_date,3);
6172:
6173: ghr_element_api.process_sf52_element
6174: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6175: ,p_element_name => 'Within Grade Increase'
6176: ,p_input_value_name2 => 'Date Due'
6177: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR

Line 6199: ghr_element_api.process_sf52_element

6195: hr_utility.set_location(l_proc,85);
6196: hr_utility.set_location('date due ' || p_wgi.p_date_wgi_due,1);
6197: hr_utility.set_location('determ due' || p_wgi.p_date_wgi_postpone_effective,2);
6198:
6199: ghr_element_api.process_sf52_element
6200: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6201: ,p_element_name => 'Within Grade Increase'
6202: ,p_input_value_name2 => 'Date Due'
6203: ,p_value2 =>

Line 6899: ghr_element_api.process_sf52_element

6895: IF c_incdet_rec.pa_incentive_category = 'Biweekly' THEN
6896: l_payment_type := c_incdet_rec.pa_incentive_category;
6897: IF p_first_noa_code = '815' OR
6898: (p_first_noa_code = '002' AND p_second_noa_code = '815') THEN
6899: ghr_element_api.process_sf52_element
6900: (p_assignment_id => p_assignment_id
6901: ,p_element_name => 'Recruitment Incentive Biweekly'
6902: ,p_input_value_name1 => 'Biweekly Amount'
6903: ,p_value1 => c_incdet_rec.pa_incentive_category_amount

Line 6917: ghr_element_api.process_sf52_element

6913: );
6914: END IF;
6915: IF (p_first_noa_code = '816') OR
6916: (p_first_noa_code = '002' AND p_second_noa_code = '816') THEN
6917: ghr_element_api.process_sf52_element
6918: (p_assignment_id => p_assignment_id
6919: ,p_element_name => 'Relocation Incentive Biweekly'
6920: ,p_input_value_name1 => 'Biweekly Amount'
6921: ,p_value1 => c_incdet_rec.pa_incentive_category_amount

Line 6938: ghr_element_api.process_sf52_element

6934: -- Bug#3941541 Separation Incentive Elements.
6935: IF (p_first_noa_code = '825') OR
6936: (p_second_noa_code = '825') OR
6937: (p_first_noa_code = '002' AND p_second_noa_code = '825') THEN
6938: ghr_element_api.process_sf52_element
6939: (p_assignment_id => p_assignment_id
6940: ,p_element_name => 'Separation Incentive Biweekly'
6941: ,p_input_value_name1 => 'Biweekly Amount'
6942: ,p_value1 => c_incdet_rec.pa_incentive_category_amount

Line 6960: ghr_element_api.process_sf52_element

6956: (p_first_noa_code = '002' AND p_second_noa_code = '827') THEN
6957: -- Bug#5039100
6958: --This code is commented for the bug#5307606
6959: /* IF p_payment_option = 'B' AND c_incdet_rec.pa_incentive_category_percent = 0 THEN
6960: ghr_element_api.process_sf52_element
6961: (p_assignment_id => p_assignment_id
6962: ,p_element_name => 'Retention Incentive Biweekly'
6963: ,p_input_value_name1 => 'Percent'
6964: ,p_value1 => c_incdet_rec.pa_incentive_category_percent

Line 6976: ghr_element_api.process_sf52_element

6972:
6973: ELSE*/
6974: --This code is commented for the bug#5307606
6975:
6976: ghr_element_api.process_sf52_element
6977: (p_assignment_id => p_assignment_id
6978: ,p_element_name => 'Retention Incentive Biweekly'
6979: ,p_input_value_name1 => 'Percent'
6980: ,p_value1 => c_incdet_rec.pa_incentive_category_percent

Line 7000: ghr_element_api.process_sf52_element

6996: l_payment_type := c_incdet_rec.pa_incentive_category ;
6997: END IF;
6998: IF p_first_noa_code = '815' OR
6999: (p_first_noa_code = '002' AND p_second_noa_code = '815') THEN
7000: ghr_element_api.process_sf52_element
7001: (p_assignment_id => p_assignment_id
7002: ,p_element_name => 'Recruitment Incentive Lump Sum'
7003: ,p_input_value_name1 => 'Percent'
7004: ,p_value1 => c_incdet_rec.pa_incentive_category_percent

Line 7017: ghr_element_api.process_sf52_element

7013: );
7014: END IF;
7015: IF (p_first_noa_code = '816') OR
7016: (p_first_noa_code = '002' AND p_second_noa_code = '816') THEN
7017: ghr_element_api.process_sf52_element
7018: (p_assignment_id => p_assignment_id
7019: ,p_element_name => 'Relocation Incentive Lump Sum'
7020: ,p_input_value_name1 => 'Percent'
7021: ,p_value1 => c_incdet_rec.pa_incentive_category_percent

Line 7037: ghr_element_api.process_sf52_element

7033: -- Bug#3941541 Separation Incentive Elements.
7034: IF (p_first_noa_code = '825') OR
7035: (p_second_noa_code = '825') OR
7036: (p_first_noa_code = '002' AND p_second_noa_code = '825') THEN
7037: ghr_element_api.process_sf52_element
7038: (p_assignment_id => p_assignment_id
7039: ,p_element_name => 'Separation Incentive Lump Sum'
7040: ,p_input_value_name1 => 'Amount'
7041: ,p_value1 => c_incdet_rec.pa_incentive_category_amount

Line 7054: ghr_element_api.process_sf52_element

7050: -- End of Bug#3941541
7051:
7052: IF (p_first_noa_code = '827') OR
7053: (p_first_noa_code = '002' AND p_second_noa_code = '827') THEN
7054: ghr_element_api.process_sf52_element
7055: (p_assignment_id => p_assignment_id
7056: ,p_element_name => 'Retention Incentive Lump Sum'
7057: ,p_input_value_name1 => 'Percent'
7058: ,p_value1 => c_incdet_rec.pa_incentive_category_percent

Line 7145: ghr_element_api.process_sf52_element

7141: -- as input value2 is moved to Benefits EIT
7142: /* -- Bug 3238026 Added condition for CHG_FEGLI
7143: IF (p_pa_request_rec.noa_family_code = 'CHG_FEGLI') THEN
7144: hr_utility.set_location('Entering IF fegli',123456);
7145: ghr_element_api.process_sf52_element
7146: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7147: ,p_element_name => 'FEGLI'
7148: ,p_input_value_name1 => 'FEGLI'
7149: -- Bug#2759379 Added Input Value2 here.

Line 7160: ghr_element_api.process_sf52_element

7156: );
7157: ELSE
7158: */
7159: hr_utility.set_location('Entering ELSE fegli',123456);
7160: ghr_element_api.process_sf52_element
7161: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7162: ,p_element_name => 'FEGLI'
7163: ,p_input_value_name1 => 'FEGLI'
7164: ,p_value1 => p_pa_request_rec.fegli

Line 7183: ghr_element_api.process_sf52_element

7179: -- Processing retirement plan
7180: --
7181: If p_pa_request_rec.retirement_plan is not null then
7182: hr_utility.set_location(l_proc,20);
7183: ghr_element_api.process_sf52_element
7184: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7185: ,p_element_name => 'Retirement Plan'
7186: ,p_input_value_name1 => 'Plan'
7187: ,p_value1 => p_pa_request_rec.retirement_plan

Line 7208: ghr_element_api.process_sf52_element

7204: p_recruitment_bonus.p_date_recruit_exp is not null then
7205: hr_utility.set_location(l_proc,30);
7206: hr_utility.set_location(l_proc || p_recruitment_bonus.p_date_recruit_exp,31);
7207: hr_utility.set_location(l_proc ||to_char(p_pa_request_rec.employee_assignment_id),35);
7208: ghr_element_api.process_sf52_element
7209: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7210: ,p_element_name => 'Recruitment Bonus'
7211: ,p_input_value_name1 => 'Amount'
7212: ,p_value1 => p_recruitment_bonus.p_recruitment_bonus

Line 7237: ghr_element_api.process_sf52_element

7233: hr_utility.set_location('Rel. Bonus' || p_relocation_bonus.p_relocation_bonus,1);
7234: If p_relocation_bonus.p_relocation_bonus is not null or
7235: p_relocation_bonus.p_date_reloc_exp is not null then
7236: hr_utility.set_location(l_proc,40);
7237: ghr_element_api.process_sf52_element
7238: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7239: ,p_element_name => 'Relocation Bonus'
7240: ,p_input_value_name1 => 'Amount'
7241: ,p_value1 => p_relocation_bonus.p_relocation_bonus

Line 7265: ghr_element_api.process_sf52_element

7261: If p_student_loan_repay.p_amount is not null or
7262: p_student_loan_repay.p_review_date is not null then
7263: IF (p_student_loan_repay.p_repay_schedule = 'L') THEN
7264: hr_utility.set_location(l_proc,40);
7265: ghr_element_api.process_sf52_element
7266: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7267: ,p_element_name => 'Student Loan Repayment LumpSum'
7268: ,p_input_value_name1 => 'Amount'
7269: ,p_value1 => p_student_loan_repay.p_amount

Line 7278: ghr_element_api.process_sf52_element

7274: ,p_process_warning => l_warning
7275: );
7276: ELSIF (p_student_loan_repay.p_repay_schedule = 'R') THEN
7277: hr_utility.set_location(l_proc,40);
7278: ghr_element_api.process_sf52_element
7279: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7280: ,p_element_name => 'Student Loan Repayment'
7281: ,p_input_value_name1 => 'Amount'
7282: ,p_value1 => (p_student_loan_repay.p_amount)

Line 7304: ghr_element_api.process_sf52_element

7300: hr_utility.set_location('Award Percentage ' || p_pa_request_rec.award_percentage,1);
7301: hr_utility.set_location('Date Exemp' || p_gov_award.date_exemp_award,1);
7302: -- Bug # 1061084
7303: hr_utility.set_location('Appropriation Code' || p_gov_award.award_appropriation_code,1);
7304: ghr_element_api.process_sf52_element
7305: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7306: ,p_element_name => 'Federal Awards'
7307: ,p_input_value_name1 => 'Award Agency'
7308: ,p_value1 => p_gov_award.award_agency

Line 7336: ghr_element_api.process_sf52_element

7332: -- process entitlement
7333: --
7334: if p_entitlement.entitlement_flag = 'Y' then
7335: hr_utility.set_location(l_proc,60);
7336: ghr_element_api.process_sf52_element
7337: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7338: ,p_element_name => 'Entitlement'
7339: ,p_input_value_name1 => 'Code'
7340: ,p_value1 => p_entitlement.entitlement_code

Line 7352: ghr_element_api.process_sf52_element

7348: -- process foreign lang profiency pay
7349: --
7350: if p_foreign_lang_prof_pay.for_lang_flag = 'Y' then
7351: hr_utility.set_location(l_proc,70);
7352: ghr_element_api.process_sf52_element
7353: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7354: ,p_element_name => 'Foreign Lang Proficiency Pay'
7355: ,p_input_value_name1 => 'Certification Date'
7356: ,p_value1 =>

Line 7369: ghr_element_api.process_sf52_element

7365: -- Bug#3385386 process foreign Transfer Allowance(FTA) element
7366: --
7367: if p_fta.fta_flag = 'Y' then
7368: hr_utility.set_location(l_proc,75);
7369: ghr_element_api.process_sf52_element
7370: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7371: ,p_element_name => 'Foreign Transfer Allowance'
7372: ,p_input_value_name1 => 'Last Action Code'
7373: ,p_value1 => p_fta.last_action_code

Line 7395: ghr_element_api.process_sf52_element

7391: -- process edp pay
7392: --
7393: if p_edp_pay.edp_flag = 'Y' then
7394: hr_utility.set_location(l_proc,80);
7395: ghr_element_api.process_sf52_element
7396: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7397: ,p_element_name => 'EDP Pay'
7398: ,p_input_value_name1 => 'Premium Pay Ind'
7399: ,p_value1 => p_edp_pay.premium_pay_indicator

Line 7412: ghr_element_api.process_sf52_element

7408: -- process hazard pay
7409: --
7410: if p_hazard_pay.hazard_flag = 'Y' then
7411: hr_utility.set_location(l_proc,85);
7412: ghr_element_api.process_sf52_element
7413: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7414: ,p_element_name => 'Hazard Pay'
7415: ,p_input_value_name1 => 'Premium Pay Ind'
7416: ,p_value1 => p_hazard_pay.premium_pay_indicator

Line 7431: ghr_element_api.process_sf52_element

7427: hr_utility.set_location(l_proc,90);
7428: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' THEN
7429: NULL;
7430: ELSE
7431: ghr_element_api.process_sf52_element
7432: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7433: ,p_element_name => 'Health Benefits'
7434: ,p_input_value_name1 => 'Enrollment'
7435: ,p_value1 => p_health_benefits.enrollment

Line 7456: ghr_element_api.process_sf52_element

7452: hr_utility.set_location(l_proc,90);
7453: IF ghr_utility.is_ghr_ben_fehb = 'TRUE' THEN
7454: NULL;
7455: ELSE
7456: ghr_element_api.process_sf52_element
7457: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7458: ,p_element_name => 'Health Benefits Pre tax'
7459: ,p_input_value_name1 => 'Enrollment'
7460: ,p_value1 => p_health_ben_pre_tax.enrollment

Line 7475: ghr_element_api.process_sf52_element

7471: -- process danger pay
7472: --
7473: if p_danger_pay.danger_flag = 'Y' then
7474: hr_utility.set_location(l_proc,100);
7475: ghr_element_api.process_sf52_element
7476: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7477: ,p_element_name => 'Danger Pay'
7478: ,p_input_value_name1 => 'Last Action Code'
7479: ,p_value1 => p_danger_pay.last_action_code

Line 7491: ghr_element_api.process_sf52_element

7487: -- process imminent danger pay
7488: --
7489: if p_imminent_danger_pay.imminent_danger_flag = 'Y' then
7490: hr_utility.set_location(l_proc,110);
7491: ghr_element_api.process_sf52_element
7492: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7493: ,p_element_name => 'Imminent Danger Pay'
7494: ,p_input_value_name1 => 'Amount'
7495: ,p_value1 => p_imminent_danger_pay.amount

Line 7509: ghr_element_api.process_sf52_element

7505: -- process living_quarters_allow
7506: --
7507: if p_living_quarters_allow.living_quarters_allow_flag = 'Y' then
7508: hr_utility.set_location(l_proc,120);
7509: ghr_element_api.process_sf52_element
7510: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7511: ,p_element_name => 'Living Quarters Allowance'
7512: ,p_input_value_name1 => 'Purchase Amount'
7513: ,p_value1 => p_living_quarters_allow.purchase_amount

Line 7546: ghr_element_api.process_sf52_element

7542: -- process post differential amount
7543: --
7544: if p_post_diff_amt.post_diff_amt_flag = 'Y' then
7545: hr_utility.set_location(l_proc,130);
7546: ghr_element_api.process_sf52_element
7547: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7548: -- ,p_element_name => 'Post Differential Amount' -- Bug 2645878 Elements renamed
7549: ,p_element_name => 'Post Allowance'
7550: ,p_input_value_name1 => 'Amount'

Line 7571: ghr_element_api.process_sf52_element

7567: hr_utility.set_location('subbu'||p_post_diff_percent.percent,141);
7568: hr_utility.set_location('subbu'||p_post_diff_percent.last_action_code,142);
7569: hr_utility.set_location('subbu'||p_post_diff_percent.location,143);
7570:
7571: ghr_element_api.process_sf52_element
7572: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7573: -- ,p_element_name => 'Post Differential Percent' -- Bug 2645878 Element renamed
7574: ,p_element_name => 'Post Differential'
7575: ,p_input_value_name1 => 'Percentage'

Line 7590: ghr_element_api.process_sf52_element

7586: -- process sep_maintenance_allow
7587: --
7588: if p_sep_maintenance_allow.sep_maint_allow_flag = 'Y' then
7589: hr_utility.set_location(l_proc,150);
7590: ghr_element_api.process_sf52_element
7591: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7592: ,p_element_name => 'Separate Maintenance Allowance'
7593: ,p_input_value_name1 => 'Amount'
7594: ,p_value1 => p_sep_maintenance_allow.amount

Line 7608: ghr_element_api.process_sf52_element

7604: -- process supplemental_post_allow
7605: --
7606: if p_supplemental_post_allow.sup_post_allow_flag = 'Y' then
7607: hr_utility.set_location(l_proc,160);
7608: ghr_element_api.process_sf52_element
7609: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7610: ,p_element_name => 'Supplemental Post Allowance'
7611: ,p_input_value_name1 => 'Amount'
7612: ,p_value1 => p_supplemental_post_allow.amount

Line 7622: ghr_element_api.process_sf52_element

7618: -- process temp_lodge_allow
7619: --
7620: if p_temp_lodge_allow.temp_lodge_allow_flag = 'Y' then
7621: hr_utility.set_location(l_proc,170);
7622: ghr_element_api.process_sf52_element
7623: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7624: ,p_element_name => 'Temporary Lodging Allowance'
7625: ,p_input_value_name1 => 'Allowance Type'
7626: ,p_value1 => p_temp_lodge_allow.allowance_type

Line 7638: ghr_element_api.process_sf52_element

7634: -- process premium_pay
7635: --
7636: if p_premium_pay.premium_pay_flag = 'Y' then
7637: hr_utility.set_location(l_proc,180);
7638: ghr_element_api.process_sf52_element
7639: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7640: ,p_element_name => 'Premium Pay'
7641: ,p_input_value_name1 => 'Premium Pay Ind'
7642: ,p_value1 => p_premium_pay.premium_pay_ind

Line 7654: ghr_element_api.process_sf52_element

7650: -- process retirement_annuity
7651: --
7652: if p_retirement_annuity.retirement_annuity_flag = 'Y' then
7653: hr_utility.set_location(l_proc,190);
7654: ghr_element_api.process_sf52_element
7655: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7656: ,p_element_name => 'Retirement Annuity'
7657: ,p_input_value_name1 => 'Sum'
7658: ,p_value1 => p_retirement_annuity.annuity_sum

Line 7671: ghr_element_api.process_sf52_element

7667: -- process severance_pay
7668: --
7669: if p_severance_pay.severance_pay_flag = 'Y' then
7670: hr_utility.set_location(l_proc,200);
7671: ghr_element_api.process_sf52_element
7672: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7673: ,p_element_name => 'Severance Pay'
7674: ,p_input_value_name1 => 'Amount'
7675: ,p_value1 => p_severance_pay.amount

Line 7695: ghr_element_api.process_sf52_element

7691: IF ghr_utility.is_ghr_ben_tsp = 'TRUE' THEN
7692: NULL;
7693: ELSE
7694: -- Bug#4582970 Removed Agncy Elig Date, Emp Elig Date values.
7695: ghr_element_api.process_sf52_element
7696: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7697: ,p_element_name => 'TSP'
7698: ,p_input_value_name1 => 'Amount'
7699: ,p_value1 => p_thrift_saving_plan.amount

Line 7724: ghr_element_api.process_sf52_element

7720: NVL(p_mddds_special_pay.Scarce_Specialty,0) + NVL(p_mddds_special_pay.Specialty_or_Board_Cert,0) +
7721: NVL(p_mddds_special_pay.Geographic_Location,0) + NVL(p_mddds_special_pay.Exceptional_Qualifications,0) +
7722: NVL(p_mddds_special_pay.Executive_Position,0) + NVL(p_mddds_special_pay.Dentist_post_graduate_training,0);
7723: --Bug 3531369
7724: ghr_element_api.process_sf52_element
7725: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7726: ,p_element_name => 'MDDDS Special Pay'
7727: ,p_input_value_name1 => 'Full Time Status'
7728: ,p_value1 => p_mddds_special_pay.Full_Time_Status

Line 7756: ghr_element_api.process_sf52_element

7752: --
7753: --Pradeep
7754: If p_mddds_special_pay.premium_pay_ind is not null then
7755: hr_utility.set_location(l_proc,220);
7756: ghr_element_api.process_sf52_element
7757: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7758: ,p_element_name => 'Premium Pay'
7759: ,p_input_value_name1 => 'Premium Pay Ind'
7760: --,p_value1 => p_premium_pay.premium_pay_ind

Line 7773: ghr_element_api.process_sf52_element

7769: --
7770: --Pradeep
7771: If p_premium_pay_ind.premium_pay_ind is not null then
7772: hr_utility.set_location(l_proc,225);
7773: ghr_element_api.process_sf52_element
7774: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7775: ,p_element_name => 'Premium Pay'
7776: ,p_input_value_name1 => 'Premium Pay Ind'
7777: ,p_value1 => p_premium_pay_ind.premium_pay_ind