[Home] [Help]
1750: hr_utility.set_location('Person inside mddds_pay is ' || to_char(l_person_id),1);
1751:
1752: l_refresh_flag := l_per_refresh_flag;
1753:
1754: ghr_api.retrieve_element_entry_value
1755: (p_element_name => 'MDDDS Special Pay',
1756: p_input_value_name => 'Full Time Status',
1757: p_assignment_id => l_assignment_id,
1758: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1760: p_multiple_error_flag => l_multiple_error_flag
1761: );
1762: set_ei(l_org_rec.rei_information9, l_value, l_rei_rec.rei_information9, l_refresh_flag);
1763:
1764: ghr_api.retrieve_element_entry_value
1765: (p_element_name => 'MDDDS Special Pay',
1766: p_input_value_name => 'Length of Service',
1767: p_assignment_id => l_assignment_id,
1768: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1770: p_multiple_error_flag => l_multiple_error_flag
1771: );
1772: set_ei(l_org_rec.rei_information10, l_value, l_rei_rec.rei_information10, l_refresh_flag);
1773:
1774: ghr_api.retrieve_element_entry_value
1775: (p_element_name => 'MDDDS Special Pay',
1776: p_input_value_name => 'Scarce Specialty',
1777: p_assignment_id => l_assignment_id,
1778: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1780: p_multiple_error_flag => l_multiple_error_flag
1781: );
1782: set_ei(l_org_rec.rei_information3, l_value, l_rei_rec.rei_information3, l_refresh_flag);
1783:
1784: ghr_api.retrieve_element_entry_value
1785: (p_element_name => 'MDDDS Special Pay',
1786: p_input_value_name => 'Specialty or Board Certification',
1787: p_assignment_id => l_assignment_id,
1788: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1790: p_multiple_error_flag => l_multiple_error_flag
1791: );
1792: set_ei(l_org_rec.rei_information4, l_value, l_rei_rec.rei_information4, l_refresh_flag);
1793:
1794: ghr_api.retrieve_element_entry_value
1795: (p_element_name => 'MDDDS Special Pay',
1796: p_input_value_name => 'Geographic Location',
1797: p_assignment_id => l_assignment_id,
1798: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1800: p_multiple_error_flag => l_multiple_error_flag
1801: );
1802: set_ei(l_org_rec.rei_information5, l_value, l_rei_rec.rei_information5, l_refresh_flag);
1803:
1804: ghr_api.retrieve_element_entry_value
1805: (p_element_name => 'MDDDS Special Pay',
1806: p_input_value_name => 'Exceptional Qualifications',
1807: p_assignment_id => l_assignment_id,
1808: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1810: p_multiple_error_flag => l_multiple_error_flag
1811: );
1812: set_ei(l_org_rec.rei_information6, l_value, l_rei_rec.rei_information6, l_refresh_flag);
1813:
1814: ghr_api.retrieve_element_entry_value
1815: (p_element_name => 'MDDDS Special Pay',
1816: p_input_value_name => 'Executive Position',
1817: p_assignment_id => l_assignment_id,
1818: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1820: p_multiple_error_flag => l_multiple_error_flag
1821: );
1822: set_ei(l_org_rec.rei_information7, l_value, l_rei_rec.rei_information7, l_refresh_flag);
1823:
1824: ghr_api.retrieve_element_entry_value
1825: (p_element_name => 'MDDDS Special Pay',
1826: p_input_value_name => 'Dentist Post Graduate Training',
1827: p_assignment_id => l_assignment_id,
1828: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1830: p_multiple_error_flag => l_multiple_error_flag
1831: );
1832: set_ei(l_org_rec.rei_information8, l_value, l_rei_rec.rei_information8, l_refresh_flag);
1833:
1834: ghr_api.retrieve_element_entry_value
1835: (p_element_name => 'MDDDS Special Pay',
1836: p_input_value_name => 'Amount',
1837: p_assignment_id => l_assignment_id,
1838: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1844: if l_rei_rec.rei_information11 is null then
1845: l_rei_rec.rei_information11 := 0;
1846: end if;
1847:
1848: ghr_api.retrieve_element_entry_value
1849: (p_element_name => 'MDDDS Special Pay',
1850: p_input_value_name => 'MDDDS Special Pay NTE Date',
1851: p_assignment_id => l_assignment_id,
1852: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1854: p_multiple_error_flag => l_multiple_error_flag
1855: );
1856: set_ei(l_org_rec.rei_information12, l_value, l_rei_rec.rei_information12, l_refresh_flag);
1857:
1858: ghr_api.retrieve_element_entry_value
1859: (p_element_name => 'Premium Pay',
1860: p_input_value_name => 'Premium Pay Ind',
1861: p_assignment_id => l_assignment_id,
1862: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1878: If l_assignment_id is not null then
1879: hr_utility.set_location('Person inside premium_pay_ind is ' || to_char(l_person_id),1);
1880: l_refresh_flag := l_per_refresh_flag;
1881:
1882: ghr_api.retrieve_element_entry_value
1883: (p_element_name => 'Premium Pay',
1884: p_input_value_name => 'Premium Pay Ind',
1885: p_assignment_id => l_assignment_id,
1886: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2047: set_ei(l_org_rec.rei_information17,l_asg_ei_data.aei_information9,l_rei_rec.rei_information17,l_refresh_flag);
2048: l_org_rec.rei_information17 := l_asg_ei_data.aei_information9;
2049:
2050: l_asg_ei_data := null;
2051: /*ghr_api.retrieve_element_entry_value
2052: (p_element_name => 'Within Grade Increase',
2053: p_input_value_name => 'Date Due',
2054: p_assignment_id => l_assignment_id,
2055: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2248: set_ei(l_org_rec.rei_information11,l_asg_ei_data.aei_information9,l_rei_rec.rei_information11,l_refresh_flag);
2249: -- Start Bug 1318341
2250:
2251: --Bug#5527363 Modified the l_assignment_id parameter passed.
2252: ghr_api.retrieve_element_entry_value
2253: (p_element_name => 'Within Grade Increase',
2254: p_input_value_name => 'Date Due',
2255: p_assignment_id => NVL(l_assignment_id,p_assignment_id),
2256: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2666: l_pos_ei_data := null;
2667: FOR c_bg_id in c_bg LOOP
2668: l_bg_id := c_bg_id.business_group_id;
2669: END LOOP;
2670: l_agency_code := ghr_api.get_position_agency_code_pos
2671: (p_position_id => l_position_id
2672: ,p_business_group_id => l_bg_id
2673: ,p_effective_date => nvl(p_effective_date,trunc(sysdate)));
2674: set_ei(l_org_rec.rei_information4,l_agency_code,l_rei_rec.rei_information4,l_refresh_flag);
2813: End scd_tsp;
2814: --
2815: --
2816: Procedure non_pay_duty is
2817: l_special_info ghr_api.special_information_type;
2818: begin
2819:
2820: If l_person_id is not null then
2821: l_refresh_flag := l_per_refresh_flag;
2876: End non_pay_duty;
2877: --
2878: --
2879: Procedure lwop_info is
2880: l_special_info ghr_api.special_information_type;
2881: begin
2882:
2883: If l_person_id is not null then
2884: l_refresh_flag := l_per_refresh_flag;
2962: IF p_position_id is NOT NULL then
2963: FOR c_bg_id in c_bg1 LOOP
2964: l_bg_id := c_bg_id.business_group_id;
2965: END LOOP;
2966: l_agency_code := ghr_api.get_position_agency_code_pos
2967: (p_position_id => p_position_id
2968: ,p_business_group_id => l_bg_id);
2969: set_ei(l_org_rec.rei_information3, substr(l_agency_code,1,2), l_rei_rec.rei_information3, l_refresh_flag);
2970: END IF;
3105: --
3106: -- Fetch the element entry value
3107: IF l_assignment_id is not null THEN
3108: l_refresh_flag := l_per_refresh_flag;
3109: ghr_api.retrieve_element_entry_value
3110: (p_element_name => 'FEGLI',
3111: p_input_value_name => 'Eligibility Expiration',
3112: p_assignment_id => l_assignment_id,
3113: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3159: --
3160: -- Fetch the element entry value
3161: IF l_assignment_id is not null THEN
3162: l_refresh_flag := l_per_refresh_flag;
3163: ghr_api.retrieve_element_entry_value
3164: (p_element_name => 'Foreign Transfer Allowance',
3165: p_input_value_name => 'Last Action Code',
3166: p_assignment_id => l_assignment_id,
3167: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3169: p_multiple_error_flag => l_multiple_error_flag
3170: );
3171: set_ei(l_org_rec.rei_information3, l_value, l_rei_rec.rei_information3, l_refresh_flag);
3172: l_value := NULL;
3173: ghr_api.retrieve_element_entry_value
3174: (p_element_name => 'Foreign Transfer Allowance',
3175: p_input_value_name => 'Number Family Members',
3176: p_assignment_id => l_assignment_id,
3177: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3179: p_multiple_error_flag => l_multiple_error_flag
3180: );
3181: set_ei(l_org_rec.rei_information4, l_value, l_rei_rec.rei_information4, l_refresh_flag);
3182: l_value := NULL;
3183: ghr_api.retrieve_element_entry_value
3184: (p_element_name => 'Foreign Transfer Allowance',
3185: p_input_value_name => 'Miscellaneous Expense',
3186: p_assignment_id => l_assignment_id,
3187: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3189: p_multiple_error_flag => l_multiple_error_flag
3190: );
3191: set_ei(l_org_rec.rei_information5, l_value, l_rei_rec.rei_information5, l_refresh_flag);
3192: l_value := NULL;
3193: ghr_api.retrieve_element_entry_value
3194: (p_element_name => 'Foreign Transfer Allowance',
3195: p_input_value_name => 'Wardrobe Expense',
3196: p_assignment_id => l_assignment_id,
3197: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3199: p_multiple_error_flag => l_multiple_error_flag
3200: );
3201: set_ei(l_org_rec.rei_information6, l_value, l_rei_rec.rei_information6, l_refresh_flag);
3202: l_value := NULL;
3203: ghr_api.retrieve_element_entry_value
3204: (p_element_name => 'Foreign Transfer Allowance',
3205: p_input_value_name => 'Pre Departure Sub Expense',
3206: p_assignment_id => l_assignment_id,
3207: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3209: p_multiple_error_flag => l_multiple_error_flag
3210: );
3211: set_ei(l_org_rec.rei_information7, l_value, l_rei_rec.rei_information7, l_refresh_flag);
3212: l_value := NULL;
3213: ghr_api.retrieve_element_entry_value
3214: (p_element_name => 'Foreign Transfer Allowance',
3215: p_input_value_name => 'Lease Penalty Expense',
3216: p_assignment_id => l_assignment_id,
3217: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3219: p_multiple_error_flag => l_multiple_error_flag
3220: );
3221: set_ei(l_org_rec.rei_information8, l_value, l_rei_rec.rei_information8, l_refresh_flag);
3222: l_value := NULL;
3223: ghr_api.retrieve_element_entry_value
3224: (p_element_name => 'Foreign Transfer Allowance',
3225: p_input_value_name => 'Amount',
3226: p_assignment_id => l_assignment_id,
3227: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
4208: p_effective_date in date ,
4209: p_refresh_flag in varchar2 default 'Y'
4210: )
4211: is
4212: l_perf_appraisal ghr_api.special_information_type;
4213: l_update_rei varchar2(1) := 'N';
4214: l_exists boolean := FALSE;
4215: l_flag varchar2(1) := null;
4216: l_rei_rec ghr_pa_request_extra_info%rowtype;
4669: end loop;
4670:
4671:
4672: hr_utility.set_location(l_proc,40);
4673: ghr_api.return_special_information
4674: (p_person_id => l_person_id,
4675: p_structure_name => 'US Fed Perf Appraisal',
4676: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
4677: p_special_info => l_perf_appraisal