[Home] [Help]
1462: hr_utility.set_location('Person inside mddds_pay is ' || to_char(l_person_id),1);
1463:
1464: l_refresh_flag := l_per_refresh_flag;
1465:
1466: ghr_api.retrieve_element_entry_value
1467: (p_element_name => 'MDDDS Special Pay',
1468: p_input_value_name => 'Full Time Status',
1469: p_assignment_id => l_assignment_id,
1470: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1472: p_multiple_error_flag => l_multiple_error_flag
1473: );
1474: set_ei(l_org_rec.rei_information9, l_value, l_rei_rec.rei_information9, l_refresh_flag);
1475:
1476: ghr_api.retrieve_element_entry_value
1477: (p_element_name => 'MDDDS Special Pay',
1478: p_input_value_name => 'Length of Service',
1479: p_assignment_id => l_assignment_id,
1480: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1482: p_multiple_error_flag => l_multiple_error_flag
1483: );
1484: set_ei(l_org_rec.rei_information10, l_value, l_rei_rec.rei_information10, l_refresh_flag);
1485:
1486: ghr_api.retrieve_element_entry_value
1487: (p_element_name => 'MDDDS Special Pay',
1488: p_input_value_name => 'Scarce Specialty',
1489: p_assignment_id => l_assignment_id,
1490: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1492: p_multiple_error_flag => l_multiple_error_flag
1493: );
1494: set_ei(l_org_rec.rei_information3, l_value, l_rei_rec.rei_information3, l_refresh_flag);
1495:
1496: ghr_api.retrieve_element_entry_value
1497: (p_element_name => 'MDDDS Special Pay',
1498: p_input_value_name => 'Specialty or Board Certification',
1499: p_assignment_id => l_assignment_id,
1500: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1502: p_multiple_error_flag => l_multiple_error_flag
1503: );
1504: set_ei(l_org_rec.rei_information4, l_value, l_rei_rec.rei_information4, l_refresh_flag);
1505:
1506: ghr_api.retrieve_element_entry_value
1507: (p_element_name => 'MDDDS Special Pay',
1508: p_input_value_name => 'Geographic Location',
1509: p_assignment_id => l_assignment_id,
1510: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1512: p_multiple_error_flag => l_multiple_error_flag
1513: );
1514: set_ei(l_org_rec.rei_information5, l_value, l_rei_rec.rei_information5, l_refresh_flag);
1515:
1516: ghr_api.retrieve_element_entry_value
1517: (p_element_name => 'MDDDS Special Pay',
1518: p_input_value_name => 'Exceptional Qualifications',
1519: p_assignment_id => l_assignment_id,
1520: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1522: p_multiple_error_flag => l_multiple_error_flag
1523: );
1524: set_ei(l_org_rec.rei_information6, l_value, l_rei_rec.rei_information6, l_refresh_flag);
1525:
1526: ghr_api.retrieve_element_entry_value
1527: (p_element_name => 'MDDDS Special Pay',
1528: p_input_value_name => 'Executive Position',
1529: p_assignment_id => l_assignment_id,
1530: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1532: p_multiple_error_flag => l_multiple_error_flag
1533: );
1534: set_ei(l_org_rec.rei_information7, l_value, l_rei_rec.rei_information7, l_refresh_flag);
1535:
1536: ghr_api.retrieve_element_entry_value
1537: (p_element_name => 'MDDDS Special Pay',
1538: p_input_value_name => 'Dentist Post Graduate Training',
1539: p_assignment_id => l_assignment_id,
1540: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1542: p_multiple_error_flag => l_multiple_error_flag
1543: );
1544: set_ei(l_org_rec.rei_information8, l_value, l_rei_rec.rei_information8, l_refresh_flag);
1545:
1546: ghr_api.retrieve_element_entry_value
1547: (p_element_name => 'MDDDS Special Pay',
1548: p_input_value_name => 'Amount',
1549: p_assignment_id => l_assignment_id,
1550: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1556: if l_rei_rec.rei_information11 is null then
1557: l_rei_rec.rei_information11 := 0;
1558: end if;
1559:
1560: ghr_api.retrieve_element_entry_value
1561: (p_element_name => 'MDDDS Special Pay',
1562: p_input_value_name => 'MDDDS Special Pay NTE Date',
1563: p_assignment_id => l_assignment_id,
1564: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1566: p_multiple_error_flag => l_multiple_error_flag
1567: );
1568: set_ei(l_org_rec.rei_information12, l_value, l_rei_rec.rei_information12, l_refresh_flag);
1569:
1570: ghr_api.retrieve_element_entry_value
1571: (p_element_name => 'Premium Pay',
1572: p_input_value_name => 'Premium Pay Ind',
1573: p_assignment_id => l_assignment_id,
1574: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1590: If l_assignment_id is not null then
1591: hr_utility.set_location('Person inside premium_pay_ind is ' || to_char(l_person_id),1);
1592: l_refresh_flag := l_per_refresh_flag;
1593:
1594: ghr_api.retrieve_element_entry_value
1595: (p_element_name => 'Premium Pay',
1596: p_input_value_name => 'Premium Pay Ind',
1597: p_assignment_id => l_assignment_id,
1598: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1756: set_ei(l_org_rec.rei_information17,l_asg_ei_data.aei_information9,l_rei_rec.rei_information17,l_refresh_flag);
1757: l_org_rec.rei_information17 := l_asg_ei_data.aei_information9;
1758:
1759: l_asg_ei_data := null;
1760: /*ghr_api.retrieve_element_entry_value
1761: (p_element_name => 'Within Grade Increase',
1762: p_input_value_name => 'Date Due',
1763: p_assignment_id => l_assignment_id,
1764: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
1895: set_ei(l_org_rec.rei_information11,l_asg_ei_data.aei_information9,l_rei_rec.rei_information11,l_refresh_flag);
1896: -- Start Bug 1318341
1897:
1898: --Bug#5527363 Modified the l_assignment_id parameter passed.
1899: ghr_api.retrieve_element_entry_value
1900: (p_element_name => 'Within Grade Increase',
1901: p_input_value_name => 'Date Due',
1902: p_assignment_id => NVL(l_assignment_id,p_assignment_id),
1903: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2237: l_pos_ei_data := null;
2238: FOR c_bg_id in c_bg LOOP
2239: l_bg_id := c_bg_id.business_group_id;
2240: END LOOP;
2241: l_agency_code := ghr_api.get_position_agency_code_pos
2242: (p_position_id => l_position_id
2243: ,p_business_group_id => l_bg_id
2244: ,p_effective_date => nvl(p_effective_date,trunc(sysdate)));
2245: set_ei(l_org_rec.rei_information4,l_agency_code,l_rei_rec.rei_information4,l_refresh_flag);
2349: End scd_tsp;
2350: --
2351: --
2352: Procedure non_pay_duty is
2353: l_special_info ghr_api.special_information_type;
2354: begin
2355:
2356: If l_person_id is not null then
2357: l_refresh_flag := l_per_refresh_flag;
2371: End non_pay_duty;
2372: --
2373: --
2374: Procedure lwop_info is
2375: l_special_info ghr_api.special_information_type;
2376: begin
2377:
2378: If l_person_id is not null then
2379: l_refresh_flag := l_per_refresh_flag;
2427: IF p_position_id is NOT NULL then
2428: FOR c_bg_id in c_bg1 LOOP
2429: l_bg_id := c_bg_id.business_group_id;
2430: END LOOP;
2431: l_agency_code := ghr_api.get_position_agency_code_pos
2432: (p_position_id => p_position_id
2433: ,p_business_group_id => l_bg_id);
2434: set_ei(l_org_rec.rei_information3, substr(l_agency_code,1,2), l_rei_rec.rei_information3, l_refresh_flag);
2435: END IF;
2570: --
2571: -- Fetch the element entry value
2572: IF l_assignment_id is not null THEN
2573: l_refresh_flag := l_per_refresh_flag;
2574: ghr_api.retrieve_element_entry_value
2575: (p_element_name => 'FEGLI',
2576: p_input_value_name => 'Eligibility Expiration',
2577: p_assignment_id => l_assignment_id,
2578: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2624: --
2625: -- Fetch the element entry value
2626: IF l_assignment_id is not null THEN
2627: l_refresh_flag := l_per_refresh_flag;
2628: ghr_api.retrieve_element_entry_value
2629: (p_element_name => 'Foreign Transfer Allowance',
2630: p_input_value_name => 'Last Action Code',
2631: p_assignment_id => l_assignment_id,
2632: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2634: p_multiple_error_flag => l_multiple_error_flag
2635: );
2636: set_ei(l_org_rec.rei_information3, l_value, l_rei_rec.rei_information3, l_refresh_flag);
2637: l_value := NULL;
2638: ghr_api.retrieve_element_entry_value
2639: (p_element_name => 'Foreign Transfer Allowance',
2640: p_input_value_name => 'Number Family Members',
2641: p_assignment_id => l_assignment_id,
2642: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2644: p_multiple_error_flag => l_multiple_error_flag
2645: );
2646: set_ei(l_org_rec.rei_information4, l_value, l_rei_rec.rei_information4, l_refresh_flag);
2647: l_value := NULL;
2648: ghr_api.retrieve_element_entry_value
2649: (p_element_name => 'Foreign Transfer Allowance',
2650: p_input_value_name => 'Miscellaneous Expense',
2651: p_assignment_id => l_assignment_id,
2652: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2654: p_multiple_error_flag => l_multiple_error_flag
2655: );
2656: set_ei(l_org_rec.rei_information5, l_value, l_rei_rec.rei_information5, l_refresh_flag);
2657: l_value := NULL;
2658: ghr_api.retrieve_element_entry_value
2659: (p_element_name => 'Foreign Transfer Allowance',
2660: p_input_value_name => 'Wardrobe Expense',
2661: p_assignment_id => l_assignment_id,
2662: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2664: p_multiple_error_flag => l_multiple_error_flag
2665: );
2666: set_ei(l_org_rec.rei_information6, l_value, l_rei_rec.rei_information6, l_refresh_flag);
2667: l_value := NULL;
2668: ghr_api.retrieve_element_entry_value
2669: (p_element_name => 'Foreign Transfer Allowance',
2670: p_input_value_name => 'Pre Departure Sub Expense',
2671: p_assignment_id => l_assignment_id,
2672: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2674: p_multiple_error_flag => l_multiple_error_flag
2675: );
2676: set_ei(l_org_rec.rei_information7, l_value, l_rei_rec.rei_information7, l_refresh_flag);
2677: l_value := NULL;
2678: ghr_api.retrieve_element_entry_value
2679: (p_element_name => 'Foreign Transfer Allowance',
2680: p_input_value_name => 'Lease Penalty Expense',
2681: p_assignment_id => l_assignment_id,
2682: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
2684: p_multiple_error_flag => l_multiple_error_flag
2685: );
2686: set_ei(l_org_rec.rei_information8, l_value, l_rei_rec.rei_information8, l_refresh_flag);
2687: l_value := NULL;
2688: ghr_api.retrieve_element_entry_value
2689: (p_element_name => 'Foreign Transfer Allowance',
2690: p_input_value_name => 'Amount',
2691: p_assignment_id => l_assignment_id,
2692: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3451: p_effective_date in date ,
3452: p_refresh_flag in varchar2 default 'Y'
3453: )
3454: is
3455: l_perf_appraisal ghr_api.special_information_type;
3456: l_update_rei varchar2(1) := 'N';
3457: l_exists boolean := FALSE;
3458: l_flag varchar2(1) := null;
3459: l_rei_rec ghr_pa_request_extra_info%rowtype;
3912: end loop;
3913:
3914:
3915: hr_utility.set_location(l_proc,40);
3916: ghr_api.return_special_information
3917: (p_person_id => l_person_id,
3918: p_structure_name => 'US Fed Perf Appraisal',
3919: p_effective_date => nvl(p_effective_date,trunc(sysdate)),
3920: p_special_info => l_perf_appraisal