[Home] [Help]
130: Begin
131:
132: l_sf52_data := p_sf52_data ; --NOCOPY Changes
133:
134: hr_utility.set_location(' Entering : ' || l_proc, 10);
135: hr_utility.set_location(' Payment Option ' || p_sf52_data.pa_incentive_payment_option, 15);
136:
137: -- set global to disable checks that disallow changes to core data.
138: -- This is also set back to false when exiting this procedure.
131:
132: l_sf52_data := p_sf52_data ; --NOCOPY Changes
133:
134: hr_utility.set_location(' Entering : ' || l_proc, 10);
135: hr_utility.set_location(' Payment Option ' || p_sf52_data.pa_incentive_payment_option, 15);
136:
137: -- set global to disable checks that disallow changes to core data.
138: -- This is also set back to false when exiting this procedure.
139: ghr_api.g_api_dml := TRUE;
145: savepoint process_SF52;
146:
147: if p_sf52_data.first_noa_code = '001' then
148: -- Cancellation
149: hr_utility.set_location('First LAC CODE is : ' ||p_sf52_data.first_action_la_code1, 11);
150: if p_sf52_data.first_action_la_code1 is null then
151: hr_utility.set_message(8301 , 'GHR_38031_FIRST_LAC_NOT_EXIST');
152: hr_utility.raise_error;
153: end if;
147: if p_sf52_data.first_noa_code = '001' then
148: -- Cancellation
149: hr_utility.set_location('First LAC CODE is : ' ||p_sf52_data.first_action_la_code1, 11);
150: if p_sf52_data.first_action_la_code1 is null then
151: hr_utility.set_message(8301 , 'GHR_38031_FIRST_LAC_NOT_EXIST');
152: hr_utility.raise_error;
153: end if;
154: --6850492
155: l_dual_cancel := 'N';
148: -- Cancellation
149: hr_utility.set_location('First LAC CODE is : ' ||p_sf52_data.first_action_la_code1, 11);
150: if p_sf52_data.first_action_la_code1 is null then
151: hr_utility.set_message(8301 , 'GHR_38031_FIRST_LAC_NOT_EXIST');
152: hr_utility.raise_error;
153: end if;
154: --6850492
155: l_dual_cancel := 'N';
156: for Chk_Dual_Cancel_Rec in Chk_Dual_Cancel
195: ghr_process_sf52.reinit_dual_var;
196: elsif p_sf52_data.first_noa_code is not null and
197: p_sf52_data.second_noa_code is null then
198: -- Single action
199: hr_utility.set_location('Bef call single action Payment Option ' || p_sf52_data.pa_incentive_payment_option, 20);
200: Single_action_SF52 ( p_sf52_data => p_sf52_data,
201: p_process_type => p_process_type,
202: p_capped_other_pay => p_capped_other_pay);
203: else
200: Single_action_SF52 ( p_sf52_data => p_sf52_data,
201: p_process_type => p_process_type,
202: p_capped_other_pay => p_capped_other_pay);
203: else
204: hr_utility.set_message(8301,'GHR_38222_UNKNOWN_NOA');
205: ghr_api.g_api_dml := FALSE;
206: hr_utility.raise_error;
207: -- raise error.
208: end if;
202: p_capped_other_pay => p_capped_other_pay);
203: else
204: hr_utility.set_message(8301,'GHR_38222_UNKNOWN_NOA');
205: ghr_api.g_api_dml := FALSE;
206: hr_utility.raise_error;
207: -- raise error.
208: end if;
209: -- if validate only mode, then rollback.
210: if p_validate then
225: End if;
226:
227: ghr_history_api.reinit_g_session_var;
228: ghr_api.g_api_dml := FALSE;
229: hr_utility.set_location(' Leaving : ' || l_proc, 200);
230:
231: EXCEPTION
232: WHEN others THEN
233: -- Reset IN OUT parameters and set OUT parameters
233: -- Reset IN OUT parameters and set OUT parameters
234:
235: p_sf52_data := l_sf52_data ;
236:
237: hr_utility.set_location('Leaving ' || l_proc,60);
238: RAISE;
239: End;
240:
241: -- |--------------------------< single_action_sf52>---------------------------|
274: l_capped_other_pay number;
275:
276: Begin
277: l_sf52_data := p_sf52_data ; --NOCOPY Changes
278: hr_utility.set_location(' Entering : ' || l_proc, 10);
279: hr_utility.set_location('Inside single action Payment Option ' || p_sf52_data.pa_incentive_payment_option, 20);
280: -- reinitialise session variables
281: ghr_history_api.reinit_g_session_var;
282: -- set values of session variables
275:
276: Begin
277: l_sf52_data := p_sf52_data ; --NOCOPY Changes
278: hr_utility.set_location(' Entering : ' || l_proc, 10);
279: hr_utility.set_location('Inside single action Payment Option ' || p_sf52_data.pa_incentive_payment_option, 20);
280: -- reinitialise session variables
281: ghr_history_api.reinit_g_session_var;
282: -- set values of session variables
283: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
343: -- Check if atleast the min. required items exist in the pa_request
344: ghr_sf52_validn_pkg.prelim_req_chk_for_update_hr
345: (p_pa_request_rec => p_sf52_data
346: );
347: hr_utility.set_location('Bef call main Payment Option ' || l_sf52_data.pa_incentive_payment_option, 20);
348: ghr_sf52_update.main( p_pa_request_rec => l_sf52_data,
349: p_pa_request_ei_rec => l_sf52_ei_data,
350: p_generic_ei_rec => l_agency_ei_data,
351: p_capped_other_pay => l_capped_other_pay);
359: ghr_sf52_update.main( p_pa_request_rec => l_sf52_data,
360: p_pa_request_ei_rec => l_sf52_ei_data,
361: p_generic_ei_rec => l_agency_ei_data,
362: p_capped_other_pay => l_capped_other_pay);
363: hr_utility.set_location( 'Before Call to Post_sf52_process ' || l_proc , 90);
364:
365:
366: ghr_sf52_post_update.Post_sf52_process(
367: p_pa_request_id => l_sf52_data.pa_request_id,
371: p_to_position_id => l_sf52_data.to_position_id,
372: p_agency_code => l_sf52_data.agency_code,
373: p_sf52_data_result => l_sf52_data
374: );
375: hr_utility.set_location( 'After Call to Post_sf52_process ' || l_proc , 90);
376:
377: end if;
378:
379: Update_rfrs_values( p_sf52_data => l_sf52_data,
377: end if;
378:
379: Update_rfrs_values( p_sf52_data => l_sf52_data,
380: p_shadow_data => l_shadow_data);
381: hr_utility.set_location( 'Leaving : ' || l_proc , 100);
382:
383: EXCEPTION
384: WHEN others THEN
385: -- Reset IN OUT parameters and set OUT parameters
385: -- Reset IN OUT parameters and set OUT parameters
386:
387: p_sf52_data := l_sf52_data ;
388:
389: hr_utility.set_location('Leaving ' || l_proc,60);
390: RAISE;
391:
392: End Single_Action_SF52;
393:
426: Begin
427:
428: l_sf52_data := p_sf52_data ; --NOCOPY Changes
429:
430: hr_utility.set_location(' Entering : ' || l_proc, 10);
431: -- reinitialise session variables
432: ghr_history_api.reinit_g_session_var;
433: -- set values of session variables
434: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
512: p_pa_request_ei_rec => l_sf52_ei_data,
513: p_generic_ei_rec => l_agency_ei_data,
514: p_capped_other_pay => l_capped_other_pay);
515:
516: hr_utility.set_location(' l_sf52_data.employee_assignment_id is : ' || l_sf52_data.employee_assignment_id, 11);
517: -- Process 2nd NOA
518: l_new_assignment_id := l_sf52_data.employee_assignment_id;
519: l_sf52_data := p_sf52_data;
520: -- Bug# 1234846-- Venkat --
560: p_noa_id => p_sf52_data.second_noa_id,
561: p_sf52_ei_data => l_sf52_ei_data,
562: p_result => l_result);
563:
564: hr_utility.set_location(l_proc, 30);
565:
566: -- Check if atleast the min. required items exist in the pa_request
567: ghr_sf52_validn_pkg.prelim_req_chk_for_update_hr
568: (p_pa_request_rec => p_sf52_data
572: p_pa_request_ei_rec => l_sf52_ei_data,
573: p_generic_ei_rec => l_agency_ei_data,
574: p_capped_other_pay => l_capped_other_pay);
575:
576: hr_utility.set_location( l_proc , 60);
577: if l_session_var.date_effective > l_today then
578: rollback to dual_action_sf52;
579: else
580: hr_utility.set_location( l_proc , 60);
576: hr_utility.set_location( l_proc , 60);
577: if l_session_var.date_effective > l_today then
578: rollback to dual_action_sf52;
579: else
580: hr_utility.set_location( l_proc , 60);
581: ghr_sf52_post_update.Post_sf52_process(
582: p_pa_request_id => p_sf52_data.pa_request_id,
583: p_effective_date => l_session_var.date_effective,
584: p_object_version_number => p_sf52_data.object_version_number,
586: p_to_position_id => p_sf52_data.to_position_id,
587: p_agency_code => p_sf52_data.agency_code,
588: p_sf52_data_result => l_sf52_data);
589: end if;
590: hr_utility.set_location( l_proc, 125);
591:
592: Update_rfrs_values( p_sf52_data => l_sf52_data_save,
593: p_shadow_data => l_shadow_data);
594:
591:
592: Update_rfrs_values( p_sf52_data => l_sf52_data_save,
593: p_shadow_data => l_shadow_data);
594:
595: hr_utility.set_location( 'Leaving : ' || l_proc , 100);
596:
597: EXCEPTION
598: WHEN others THEN
599: -- Reset IN OUT parameters and set OUT parameters
599: -- Reset IN OUT parameters and set OUT parameters
600:
601: p_sf52_data := l_sf52_data ;
602:
603: hr_utility.set_location('Leaving ' || l_proc,60);
604: RAISE;
605:
606: end;
607:
638: and pit.information_type <> 'GHR_US_PAR_GEN_AGENCY_DATA'
639: and pit.information_type like 'GHR_US%';
640: -- Bug No 570303 added restriction to only look at 'our' info types
641: Begin
642: hr_utility.set_location(l_proc,10);
643: l_information_type := null;
644: for info_type in cur_info_type
645: loop
646: l_information_type := info_type.information_type;
682: information_type = cp_info_type;
683:
684: l_proc varchar2(30):='fetch_Extra_info';
685: Begin
686: hr_utility.set_location('entering : ' || l_proc, 10);
687: if NOT p_agency_ei then
688: l_info_type := get_information_type(p_noa_id => p_noa_id);
689: else
690: l_info_type := 'GHR_US_PAR_GEN_AGENCY_DATA';
698: end if;
699: close c_req_ei;
700: end if;
701:
702: hr_utility.set_location( 'Leaving : ' || l_proc, 50);
703:
704: EXCEPTION
705: WHEN others THEN
706: -- Reset IN OUT parameters and set OUT parameters
707:
708: p_sf52_ei_data := NULL ;
709: p_result := NULL ;
710:
711: hr_utility.set_location('Leaving ' || l_proc,60);
712: RAISE;
713: End;
714:
715: -- |--------------------------< assign_new_rg>--------------------------------|
816: l_fld_names_tab fld_names_typ;
817: BEGIN
818: l_fld_names_tab := p_fld_names_tab;
819: l_column_count := 0;
820: hr_utility.set_location('Entering:'|| l_proc, 5);
821: -- populate the local table with the form_field_names for this noa.
822: FOR curflds_rec in cur_flds(p_noa_id) LOOP
823: l_column_count := l_column_count + 1;
824: p_fld_names_tab(l_column_count) := curflds_rec;
822: FOR curflds_rec in cur_flds(p_noa_id) LOOP
823: l_column_count := l_column_count + 1;
824: p_fld_names_tab(l_column_count) := curflds_rec;
825: END LOOP;
826: hr_utility.set_location('Leaving:'|| l_proc, 10);
827: EXCEPTION
828: WHEN OTHERS THEN
829: -- NOCOPY CHANGES
830: p_fld_names_tab := l_fld_names_tab;
846: p_sf52_data IN ghr_pa_requests%rowtype) RETURN varchar2 IS
847: l_proc varchar2(30):='get_field_info';
848: l_ret_value varchar2(2000);
849: BEGIN
850: hr_utility.set_location('Entering: ' ||l_proc, 10);
851: if (lower(p_field_name) = 'pa_request_id') then
852: l_ret_value := p_sf52_data.pa_request_id;
853:
854: elsif (lower(p_field_name) = 'pa_notification_id') then
1580:
1581: elsif (lower(p_field_name) = 'attribute20') then
1582: l_ret_value := p_sf52_data.attribute20;
1583: end if;
1584: hr_utility.set_location('Leaving: ' ||l_proc, 20);
1585: return l_ret_value;
1586: END;
1587:
1588: Procedure copy_to_new_rg_shared(
1608: Begin
1609:
1610: l_to_field := p_to_field; --NOCOPY Changes
1611:
1612: hr_utility.set_location('Entering:'|| l_proc, 5);
1613: -- initialize l_fld_names_tab1 with proc_methods for first noa.
1614: FOR l_count IN 1..l_column_count1 LOOP
1615: if p_field_name = l_fld_names_tab1(l_count).form_field_name then
1616: l_count1 := l_count;
1697: elsif (LOWER(l_dual_actions.first_noa_proc_method) = 'ue') then
1698: NULL;
1699: else
1700: close get_dual_action;
1701: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');
1702: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1703: hr_utility.raise_error;
1704: end if;
1705: close get_dual_action;
1698: NULL;
1699: else
1700: close get_dual_action;
1701: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');
1702: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1703: hr_utility.raise_error;
1704: end if;
1705: close get_dual_action;
1706: else
1699: else
1700: close get_dual_action;
1701: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');
1702: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1703: hr_utility.raise_error;
1704: end if;
1705: close get_dual_action;
1706: else
1707: open get_dual_action( p_noa_family_code => l_noa_family_code,
1740: null;
1741: else
1742: -- unsupported type. Throw error.
1743: close get_dual_action;
1744: hr_utility.set_message(8301, 'GHR_38498_UNSUPPORTED_ACT_TYP');
1745: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1746: hr_utility.raise_error;
1747: end if;
1748: close get_dual_action;
1741: else
1742: -- unsupported type. Throw error.
1743: close get_dual_action;
1744: hr_utility.set_message(8301, 'GHR_38498_UNSUPPORTED_ACT_TYP');
1745: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1746: hr_utility.raise_error;
1747: end if;
1748: close get_dual_action;
1749: end if;
1742: -- unsupported type. Throw error.
1743: close get_dual_action;
1744: hr_utility.set_message(8301, 'GHR_38498_UNSUPPORTED_ACT_TYP');
1745: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1746: hr_utility.raise_error;
1747: end if;
1748: close get_dual_action;
1749: end if;
1750: end if;
1766: l_pa_req_ref.from_position_id := l_pa_req.from_position_id;
1767: -- if this is a return_to_duty first action, then set to_position = from_position
1768: -- for refresh call. return_to_duty first actions always put to_position info
1769: -- with the 2nd action.
1770: hr_utility.set_location('noa_family_code: ' || l_noa_family_code, 99999);
1771: /*if (p_pa_req.noa_family_code = 'RETURN_TO_DUTY') then
1772: l_pa_req_ref.to_position_id := l_pa_req.from_position_id;
1773: --This has been added to fetch PRD from the Parent Action
1774: --While processing for Return to Duty
1836: -- do nothing, pass it along as is.
1837: null;
1838: else
1839: close get_dual_action;
1840: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1841: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1842: hr_utility.raise_error;
1843: end if;
1844: close get_dual_action;
1837: null;
1838: else
1839: close get_dual_action;
1840: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1841: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1842: hr_utility.raise_error;
1843: end if;
1844: close get_dual_action;
1845: else
1838: else
1839: close get_dual_action;
1840: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1841: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1842: hr_utility.raise_error;
1843: end if;
1844: close get_dual_action;
1845: else
1846: open get_dual_action( p_noa_family_code => l_noa_family_code,
1851: null;
1852: else
1853: -- unsupported type. Throw error.
1854: close get_dual_action;
1855: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1856: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1857: hr_utility.raise_error;
1858: end if;
1859: close get_dual_action;
1852: else
1853: -- unsupported type. Throw error.
1854: close get_dual_action;
1855: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1856: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1857: hr_utility.raise_error;
1858: end if;
1859: close get_dual_action;
1860: end if;
1853: -- unsupported type. Throw error.
1854: close get_dual_action;
1855: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1856: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1857: hr_utility.raise_error;
1858: end if;
1859: close get_dual_action;
1860: end if;
1861: end if;
1969: end if;
1970: end if;
1971:
1972: if (l_correction = true) then
1973: hr_utility.set_location('l_refresh_called_2' || l_proc,9165);
1974: l_to_field := get_field_info( p_field_name => nvl(p_fld_nm_copy_from,p_field_name),
1975: p_sf52_data => l_pa_req_ref2);
1976: -- only assign to p_to_field if it is not null. If it is null, then refresh didn't populate
1977: -- it, so we need to retain the original value.
1997: null;
1998: end if;
1999: end if;
2000:
2001: hr_utility.set_location(' Return Value :' || p_to_field || '+++', 199);
2002: hr_utility.set_location('Leaving:'|| l_proc, 200);
2003:
2004: EXCEPTION
2005: WHEN others THEN
1998: end if;
1999: end if;
2000:
2001: hr_utility.set_location(' Return Value :' || p_to_field || '+++', 199);
2002: hr_utility.set_location('Leaving:'|| l_proc, 200);
2003:
2004: EXCEPTION
2005: WHEN others THEN
2006: -- Reset IN OUT parameters and set OUT parameters
2006: -- Reset IN OUT parameters and set OUT parameters
2007:
2008: p_to_field := l_to_field;
2009:
2010: hr_utility.set_location('Leaving ' || l_proc,55);
2011: RAISE;
2012:
2013: END copy_to_new_rg_shared;
2014:
2025:
2026: BEGIN
2027: l_to_field := p_to_field; --NOCOPY Changes
2028:
2029: hr_utility.set_location('Entering: ' || l_proc, 5);
2030: l_from_char := to_char(p_from_field,'DDMMYYYY');
2031: l_to_char := to_char(p_to_field,'DDMMYYYY');
2032: copy_to_new_rg_shared( p_action_num => p_action_num,
2033: p_field_name => p_field_name,
2035: p_to_field => l_to_char,
2036: p_fld_nm_copy_from => p_fld_nm_copy_from);
2037:
2038: p_to_field := to_date(l_to_char,'DDMMYYYY');
2039: hr_utility.set_location('Leaving: ' || l_proc, 35);
2040:
2041:
2042: EXCEPTION
2043: WHEN others THEN
2044: -- Reset IN OUT parameters and set OUT parameters
2045:
2046: p_to_field := l_to_field;
2047:
2048: hr_utility.set_location('Leaving ' || l_proc,50);
2049: RAISE;
2050:
2051: END;
2052:
2060: l_proc varchar2(30):= 'copy_to_new_rg(char)';
2061: l_to_field VARCHAR2(2000);
2062: BEGIN
2063: l_to_field := p_to_field; --NOCOPY Changes
2064: hr_utility.set_location('Entering: ' || l_proc, 5);
2065: copy_to_new_rg_shared( p_action_num => p_action_num,
2066: p_field_name => p_field_name,
2067: p_from_field => p_from_field,
2068: p_to_field => p_to_field,
2067: p_from_field => p_from_field,
2068: p_to_field => p_to_field,
2069: p_fld_nm_copy_from => p_fld_nm_copy_from);
2070:
2071: hr_utility.set_location('Leaving: ' || l_proc, 10);
2072:
2073: EXCEPTION
2074: WHEN others THEN
2075: -- Reset IN OUT parameters and set OUT parameters
2075: -- Reset IN OUT parameters and set OUT parameters
2076:
2077: p_to_field := l_to_field;
2078:
2079: hr_utility.set_location('Leaving ' || l_proc,55);
2080: RAISE;
2081:
2082: END;
2083:
2092: l_to_char varchar2(100);
2093: l_to_field NUMBER;
2094: BEGIN
2095: l_to_field := p_to_field; --NOCOPY Changes
2096: hr_utility.set_location('Entering: ' || l_proc, 5);
2097: l_from_char := to_char(p_from_field);
2098: l_to_char := to_char(p_to_field);
2099: copy_to_new_rg_shared( p_action_num => p_action_num,
2100: p_field_name => p_field_name,
2102: p_to_field => l_to_char,
2103: p_fld_nm_copy_from => p_fld_nm_copy_from);
2104: p_to_field := to_number(l_to_char);
2105:
2106: hr_utility.set_location('Leaving: ' || l_proc, 35);
2107:
2108: EXCEPTION
2109: WHEN others THEN
2110: -- Reset IN OUT parameters and set OUT parameters
2110: -- Reset IN OUT parameters and set OUT parameters
2111:
2112: p_to_field := l_to_field;
2113:
2114: hr_utility.set_location('Leaving ' || l_proc,56);
2115: RAISE;
2116: END;
2117:
2118:
2118:
2119: BEGIN
2120: l_pa_req :=p_pa_req ; ---NOCOPY Changes
2121:
2122: hr_utility.set_location('Entering:'|| l_proc, 5);
2123: hr_utility.set_location(' no. of rows in table rg ' || to_char(l_column_count), 11);
2124: -- get list of all columns needed for the noa we are correcting.
2125: initialize_fld_names_table( p_noa_id => p_pa_req.first_noa_id,
2126: p_fld_names_tab => l_fld_names_tab1);
2119: BEGIN
2120: l_pa_req :=p_pa_req ; ---NOCOPY Changes
2121:
2122: hr_utility.set_location('Entering:'|| l_proc, 5);
2123: hr_utility.set_location(' no. of rows in table rg ' || to_char(l_column_count), 11);
2124: -- get list of all columns needed for the noa we are correcting.
2125: initialize_fld_names_table( p_noa_id => p_pa_req.first_noa_id,
2126: p_fld_names_tab => l_fld_names_tab1);
2127: l_column_count1 := l_column_count;
2337:
2338:
2339: -- copy_to_new_rg(p_action_num,'CUSTOM_PAY_CALC_FLAG',p_pa_req.custom_pay_calc_flag,l_pa_req.custom_pay_calc_flag);
2340: if (p_action_num = 2) then
2341: hr_utility.set_location('Correcting second action'|| l_proc, 10);
2342: -- if we are correcting the second action of a dual action, then copy all second noa columns into
2343: -- corresponding first noa columns
2344: copy_2ndNoa_to_1stNoa(l_pa_req);
2345: end if;
2346: -- null out second noa columns
2347: null_2ndNoa_cols(l_pa_req);
2348: p_pa_req := l_pa_req;
2349:
2350: hr_utility.set_location('Leaving:'|| l_proc, 15);
2351:
2352: EXCEPTION
2353: WHEN others THEN
2354: -- Reset IN OUT parameters and set OUT parameters
2354: -- Reset IN OUT parameters and set OUT parameters
2355:
2356: p_pa_req := l_pa_req;
2357:
2358: hr_utility.set_location('Leaving ' || l_proc,60);
2359: RAISE;
2360:
2361: END assign_new_rg;
2362:
2400:
2401: BEGIN
2402: l_pa_req :=p_pa_req ; ---NOCOPY Changes
2403:
2404: hr_utility.set_location('Entering:'|| l_proc, 5);
2405: p_pa_req.first_action_la_code1 := p_pa_req.second_action_la_code1;
2406: p_pa_req.first_action_la_code2 := p_pa_req.second_action_la_code2;
2407: p_pa_req.first_action_la_desc1 := p_pa_req.second_action_la_desc1;
2408: p_pa_req.first_action_la_desc2 := p_pa_req.second_action_la_desc2;
2425: p_pa_req.first_lac2_information2 := p_pa_req.second_lac2_information2;
2426: p_pa_req.first_lac2_information3 := p_pa_req.second_lac2_information3;
2427: p_pa_req.first_lac2_information4 := p_pa_req.second_lac2_information4;
2428: p_pa_req.first_lac2_information5 := p_pa_req.second_lac2_information5;
2429: hr_utility.set_location('Leaving:'|| l_proc, 10);
2430:
2431: EXCEPTION
2432: WHEN others THEN
2433: -- Reset IN OUT parameters and set OUT parameters
2433: -- Reset IN OUT parameters and set OUT parameters
2434:
2435: p_pa_req := l_pa_req;
2436:
2437: hr_utility.set_location('Leaving ' || l_proc,65);
2438: RAISE;
2439: END copy_2ndNoa_to_1stNoa;
2440:
2441: -- ---------------------------------------------------------------------------
2474:
2475: BEGIN
2476: l_pa_req :=p_pa_req ; ---NOCOPY Changes
2477:
2478: hr_utility.set_location('Entering:'|| l_proc, 5);
2479: -- set all second noa columns to null.
2480: p_pa_req.second_action_la_code1 := null;
2481: p_pa_req.second_action_la_code2 := null;
2482: p_pa_req.second_action_la_desc1 := null;
2500: p_pa_req.second_lac2_information2 := null;
2501: p_pa_req.second_lac2_information3 := null;
2502: p_pa_req.second_lac2_information4 := null;
2503: p_pa_req.second_lac2_information5 := null;
2504: hr_utility.set_location('Leaving:'|| l_proc, 10);
2505:
2506: EXCEPTION
2507: WHEN others THEN
2508: -- Reset IN OUT parameters and set OUT parameters
2508: -- Reset IN OUT parameters and set OUT parameters
2509:
2510: p_pa_req := l_pa_req;
2511:
2512: hr_utility.set_location('Leaving ' || l_proc,70);
2513: RAISE;
2514:
2515: END null_2ndNoa_cols;
2516:
2561:
2562: l_proc varchar2(30):='get_family_code';
2563: Begin
2564:
2565: hr_utility.set_location( 'entering : ' || l_proc, 10);
2566: open c_fam (p_noa_id);
2567: fetch c_fam into p_noa_family_code;
2568: close c_fam;
2569: hr_utility.set_location( 'leaving : ' || l_proc, 20);
2565: hr_utility.set_location( 'entering : ' || l_proc, 10);
2566: open c_fam (p_noa_id);
2567: fetch c_fam into p_noa_family_code;
2568: close c_fam;
2569: hr_utility.set_location( 'leaving : ' || l_proc, 20);
2570:
2571: EXCEPTION
2572: WHEN others THEN
2573: -- Reset IN OUT parameters and set OUT parameters
2573: -- Reset IN OUT parameters and set OUT parameters
2574:
2575: p_noa_family_code := NULL;
2576:
2577: hr_utility.set_location('Leaving ' || l_proc,75);
2578: RAISE;
2579:
2580: End;
2581:
2771:
2772: BEGIN
2773: for get_par_id in c_get_par_id loop
2774: l_pa_request_id := get_par_id.pa_request_id ;
2775: hr_utility.set_location('par id ' || l_pa_request_id,3);
2776:
2777: for get_request in get_req loop
2778: hr_utility.set_location('par_id ' || l_pa_request_id,2);
2779: l_rec := get_request;
2774: l_pa_request_id := get_par_id.pa_request_id ;
2775: hr_utility.set_location('par id ' || l_pa_request_id,3);
2776:
2777: for get_request in get_req loop
2778: hr_utility.set_location('par_id ' || l_pa_request_id,2);
2779: l_rec := get_request;
2780: hr_utility.set_location('l_rec ' || l_rec.first_noa_code,3);
2781:
2782: l_sf52_rec := l_rec;
2776:
2777: for get_request in get_req loop
2778: hr_utility.set_location('par_id ' || l_pa_request_id,2);
2779: l_rec := get_request;
2780: hr_utility.set_location('l_rec ' || l_rec.first_noa_code,3);
2781:
2782: l_sf52_rec := l_rec;
2783: --Bug # 9329643
2784: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
2803: 'decreased amount of Basic Pay. ' || l_new_line ||
2804: 'Action: Please review the personnel action to verify the Grade and Step, Pay Table amounts,' || l_new_line ||
2805: 'and Pay Rate Determinant code for this employee.' ; -- Bug 3320086 Changed error message.
2806:
2807: hr_utility.set_location(l_log_text,1511);
2808: create_ghr_errorlog(
2809: p_program_name => g_futr_proc_name,
2810: p_log_text => l_log_text,
2811: p_message_name => 'SF52 Routed to Inbox',
2931: if nvl(l_retcode, 0) <> 2 then
2932: l_retcode := 1; /* warning */
2933: end if;
2934:
2935: hr_utility.set_location( l_proc || ' ' || substr(sqlerrm,1,20), 40);
2936: -- Enter a record in process log
2937: --Bug # 9329643 Modified SSN to Emp No
2938: l_log_text := substr(
2939: 'Request Number : ' || l_sf52_rec.request_number || l_new_line ||
2953:
2954: commit;
2955: Exception
2956: When Others then
2957: hr_utility.set_location(' Error While creating Procees Log' || l_proc, 200);
2958: -- Error
2959: l_retcode := 2;
2960: errbuf := 'Process was errored out while creating Error Log. Error: ' || substr(sqlerrm(sqlcode), 1, 50);
2961: return;
2997: (l_sid,sysdate);
2998: end if;
2999: end;
3000:
3001: hr_utility.set_location(' Entering : ' || l_proc, 10);
3002: -- Get concurent Request_id
3003: g_futr_proc_name :='GHR_Proc_Futr_Act';
3004: l_req := Fnd_profile.value('CONC_REQUEST_ID');
3005:
3015: IF p_poi is not null then
3016: for par_pend_for_per_poi in c_par_pend_per_poi loop
3017: l_person_id := par_pend_for_per_poi.person_id;
3018: l_effective_date := par_pend_for_per_poi.effective_date;
3019: hr_utility.set_location( 'Person id ' || l_person_id,1);
3020: hr_utility.set_location(' Eff. Date ' || l_effective_date,2);
3021: sub_proc_futr_sf52;
3022: end loop;
3023: ELSE
3016: for par_pend_for_per_poi in c_par_pend_per_poi loop
3017: l_person_id := par_pend_for_per_poi.person_id;
3018: l_effective_date := par_pend_for_per_poi.effective_date;
3019: hr_utility.set_location( 'Person id ' || l_person_id,1);
3020: hr_utility.set_location(' Eff. Date ' || l_effective_date,2);
3021: sub_proc_futr_sf52;
3022: end loop;
3023: ELSE
3024: for par_pend_for_per in c_par_pend_per loop
3023: ELSE
3024: for par_pend_for_per in c_par_pend_per loop
3025: l_person_id := par_pend_for_per.person_id;
3026: l_effective_date := par_pend_for_per.effective_date;
3027: hr_utility.set_location( 'Person id ' || l_person_id,1);
3028: hr_utility.set_location(' Eff. Date ' || l_effective_date,2);
3029: sub_proc_futr_sf52;
3030: end loop;
3031: END IF;
3024: for par_pend_for_per in c_par_pend_per loop
3025: l_person_id := par_pend_for_per.person_id;
3026: l_effective_date := par_pend_for_per.effective_date;
3027: hr_utility.set_location( 'Person id ' || l_person_id,1);
3028: hr_utility.set_location(' Eff. Date ' || l_effective_date,2);
3029: sub_proc_futr_sf52;
3030: end loop;
3031: END IF;
3032: if l_retcode = 2 then
3030: end loop;
3031: END IF;
3032: if l_retcode = 2 then
3033: retcode := 2;
3034: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
3035: errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
3036: -- Bug 2639698 Sundar
3037: elsif l_retcode = 5 then
3038: retcode := 2;
3035: errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
3036: -- Bug 2639698 Sundar
3037: elsif l_retcode = 5 then
3038: retcode := 2;
3039: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
3040: errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
3041: -- End Bug 2639698 Sundar
3042: elsif l_retcode is not NULL then
3043: -- Warning
3045: errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
3046: elsif l_retcode is null then
3047: retcode := 0;
3048: end if;
3049: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3050: hr_utility.set_location('Ret code ' || to_char(l_retcode), 21);
3051: Exception
3052: when others then
3053: hr_utility.set_location(l_proc, 60);
3046: elsif l_retcode is null then
3047: retcode := 0;
3048: end if;
3049: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3050: hr_utility.set_location('Ret code ' || to_char(l_retcode), 21);
3051: Exception
3052: when others then
3053: hr_utility.set_location(l_proc, 60);
3054: -- Error
3049: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3050: hr_utility.set_location('Ret code ' || to_char(l_retcode), 21);
3051: Exception
3052: when others then
3053: hr_utility.set_location(l_proc, 60);
3054: -- Error
3055: retcode := 2;
3056: errbuf := 'Process Terminated due to Unhandled Errors.' || l_new_line
3057: || 'Error : ' || substr(sqlerrm(sqlcode), 1, 20);
3077: l_employee_number per_people_f.employee_number%type;
3078:
3079: Begin
3080: l_sf52 :=p_sf52; --NOCOPY Changes
3081: hr_utility.set_location( 'Entering : ' || l_proc, 10);
3082: savepoint route_errored_sf52;
3083: /*
3084: l_log_text := 'Request Number : ' || p_sf52.request_number || l_new_line ||
3085: 'PA_REQUEST_ID : ' || to_char(p_sf52.pa_request_id) ||
3086: ' has errors.' || l_new_line ||
3087: 'Error : ' || p_error || l_new_line ||
3088: 'Errored while resetting approval date ';
3089: */
3090: hr_utility.set_location( l_proc, 20);
3091:
3092: --Bug # 9329643
3093: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
3094: (p_person_id => l_sf52.person_id,
3102: ghr_api.call_workflow(
3103: p_pa_request_id => p_sf52.pa_request_id,
3104: p_action_taken => 'CONTINUE',
3105: p_error => p_error);
3106: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3107: Exception
3108: when others then
3109: hr_utility.set_location(l_proc || ' workflow errored out', 30);
3110: rollback to route_errored_sf52;
3105: p_error => p_error);
3106: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3107: Exception
3108: when others then
3109: hr_utility.set_location(l_proc || ' workflow errored out', 30);
3110: rollback to route_errored_sf52;
3111: p_result := '0';
3112: --Bug # 9329643 Modified SSN to Emp No
3113: l_log_text := substr(
3124: p_log_text => l_log_text,
3125: p_message_name => 'Routing Error',
3126: p_log_date => sysdate
3127: );
3128: hr_utility.set_location(l_proc , 40);
3129: p_result := '2';
3130: p_sf52 := l_sf52; --Added for nocopy changes
3131:
3132: End Route_Errorerd_SF52;
3204:
3205:
3206: begin
3207: savepoint get_personnel_off_groupbox;
3208: hr_utility.set_location('Entering ' || l_proc,5);
3209: p_retcode := null;
3210:
3211: -- Find the groupbox of the personnelist, update ghr_pa_routing_history and then call work_flow
3212:
3248:
3249: Exception
3250: when others then
3251: rollback to get_personnel_off_groupbox;
3252: hr_utility.set_location(l_proc,50);
3253:
3254: p_retcode := 2;
3255: create_ghr_errorlog
3256: (p_program_name => g_futr_proc_name,
3262: end get_personnel_off_groupbox;
3263:
3264: begin
3265:
3266: hr_utility.set_location('Entering ' || l_proc ,5);
3267: savepoint fetch_update_routing_details;
3268:
3269: l_user_name := null;
3270: l_groupbox_id := null;
3306: (p_pa_request_id => p_pa_request_id,
3307: p_object_version_number => p_object_version_number,
3308: p_routing_group_id => l_routing_group_id
3309: );
3310: hr_utility.set_location(l_proc ,10);
3311:
3312:
3313: l_log_text := 'Error while updating groupbox to ghr_pa_routing_history table';
3314: for rout_hist in c_rout_history loop
3311:
3312:
3313: l_log_text := 'Error while updating groupbox to ghr_pa_routing_history table';
3314: for rout_hist in c_rout_history loop
3315: hr_utility.set_location(l_proc ,15);
3316: l_pa_routing_history_id := rout_hist.pa_routing_history_id;
3317: l_pa_object_version_number := rout_hist.object_version_number;
3318: end loop;
3319:
3316: l_pa_routing_history_id := rout_hist.pa_routing_history_id;
3317: l_pa_object_version_number := rout_hist.object_version_number;
3318: end loop;
3319:
3320: hr_utility.set_location(l_proc ,20);
3321: ghr_prh_upd.upd
3322: (p_pa_routing_history_id => l_pa_routing_history_id,
3323: p_object_version_number => l_pa_object_version_number,
3324: p_groupbox_id => l_groupbox_id
3322: (p_pa_routing_history_id => l_pa_routing_history_id,
3323: p_object_version_number => l_pa_object_version_number,
3324: p_groupbox_id => l_groupbox_id
3325: );
3326: hr_utility.set_location('Leaving '|| l_proc ,30);
3327: End if;
3328: Else
3329: p_route_flag := TRUE;
3330: End if;
3372: l_rec get_req%rowtype;
3373: l_proc varchar2(30):='Route_Intervn_Future_Actions';
3374:
3375: Begin
3376: hr_utility.set_location(' Entering : ' || l_proc, 10);
3377: open get_req (p_person_id, p_effective_date);
3378: While TRUE
3379: loop
3380: fetch get_req into l_rec;
3390: l_error := Sqlerrm(sqlcode);
3391: rollback to future_Action;
3392: Raise;
3393: End;
3394: hr_utility.set_location(' Entering : ' || l_proc, 100);
3395: End loop;
3396: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3397: End Route_Intervn_Future_Actions;
3398:
3392: Raise;
3393: End;
3394: hr_utility.set_location(' Entering : ' || l_proc, 100);
3395: End loop;
3396: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3397: End Route_Intervn_Future_Actions;
3398:
3399:
3400:
3422: l_rec get_req%rowtype;
3423: l_proc varchar2(30):='Route_Intervn_pend_Actions';
3424:
3425: Begin
3426: hr_utility.set_location(' Entering : ' || l_proc, 10);
3427: open get_req (p_person_id, p_effective_date);
3428: While TRUE
3429: loop
3430: fetch get_req into l_rec;
3440: l_error := Sqlerrm(sqlcode);
3441: rollback to route_pending_Actions;
3442: Raise;
3443: End;
3444: hr_utility.set_location(' Entering : ' || l_proc, 100);
3445: End loop;
3446: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3447: End Route_Intervn_act_pend_today;
3448:
3442: Raise;
3443: End;
3444: hr_utility.set_location(' Entering : ' || l_proc, 100);
3445: End loop;
3446: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3447: End Route_Intervn_act_pend_today;
3448:
3449:
3450:
3456: ) is
3457:
3458: l_proc varchar2(30):='create_ghr_errorlog';
3459: Begin
3460: hr_utility.set_location( 'Entering : ' || l_proc, 10);
3461: insert into ghr_process_log
3462: (process_log_id
3463: ,program_name
3464: ,log_text
3471: ,p_log_text
3472: ,p_message_name
3473: ,p_log_date
3474: );
3475: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3476:
3477: End create_ghr_errorlog;
3478:
3479: -- ---------------------------------------------------------------------------
3785: l_person_id := cur_ass_id_rec.person_id;
3786: EXIT;
3787: END LOOP;
3788: -- From history fetch the Assignment Information Details for the effective date
3789: hr_utility.set_location('Eff. date in get_asg_step_or_rate ' || p_effective_date,25);
3790: IF l_assignment_id IS NOT NULL THEN
3791: ghr_history_fetch.fetch_asgei (
3792: p_assignment_id => l_assignment_id,
3793: p_information_type => 'GHR_US_ASG_SF52',
3815: ELSIF l_asgei_data.aei_information6 = '7' then
3816: p_prd := '0';
3817: ELSE
3818: p_prd := l_asgei_data.aei_information6;
3819: hr_utility.set_location('Sun p_pay_rate_determinant' || p_prd,250);
3820: END IF;
3821: END IF;
3822:
3823: END get_asg_step_or_rate;
3825: begin
3826:
3827: l_sf52_data := p_sf52_data ; --NOCOPY Changes
3828:
3829: hr_utility.set_location('Entering: ' || l_proc, 10);
3830: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3831: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3832: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3833:
3826:
3827: l_sf52_data := p_sf52_data ; --NOCOPY Changes
3828:
3829: hr_utility.set_location('Entering: ' || l_proc, 10);
3830: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3831: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3832: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3833:
3834: ghr_history_api.get_g_session_var( l_session_var);
3827: l_sf52_data := p_sf52_data ; --NOCOPY Changes
3828:
3829: hr_utility.set_location('Entering: ' || l_proc, 10);
3830: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3831: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3832: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3833:
3834: ghr_history_api.get_g_session_var( l_session_var);
3835: for c_rec in get_noa_info LOOP
3828:
3829: hr_utility.set_location('Entering: ' || l_proc, 10);
3830: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3831: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3832: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3833:
3834: ghr_history_api.get_g_session_var( l_session_var);
3835: for c_rec in get_noa_info LOOP
3836: l_first_noa_id := c_rec.first_noa_id;
4045: p_sf52_data.to_au_overtime := l_au_overtime;
4046: p_sf52_data.to_availability_pay := l_availability_pay ;
4047: p_sf52_data.to_other_pay_amount := l_other_pay;
4048: END IF;
4049: hr_utility.set_location('l_from_position_id is ' ||l_from_position_id, 11);
4050: hr_utility.set_location('from_position_id is ' ||p_sf52_data.from_position_id, 12);
4051: hr_utility.set_location('to_position_id is ' ||p_sf52_data.to_position_id, 13);
4052: hr_utility.set_location('to_basic_pay is ' ||p_sf52_data.to_basic_pay, 14);
4053: if (nvl(l_from_position_id, -1) <> nvl(p_sf52_data.from_position_id, -1) and
4046: p_sf52_data.to_availability_pay := l_availability_pay ;
4047: p_sf52_data.to_other_pay_amount := l_other_pay;
4048: END IF;
4049: hr_utility.set_location('l_from_position_id is ' ||l_from_position_id, 11);
4050: hr_utility.set_location('from_position_id is ' ||p_sf52_data.from_position_id, 12);
4051: hr_utility.set_location('to_position_id is ' ||p_sf52_data.to_position_id, 13);
4052: hr_utility.set_location('to_basic_pay is ' ||p_sf52_data.to_basic_pay, 14);
4053: if (nvl(l_from_position_id, -1) <> nvl(p_sf52_data.from_position_id, -1) and
4054: nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2)) then
4047: p_sf52_data.to_other_pay_amount := l_other_pay;
4048: END IF;
4049: hr_utility.set_location('l_from_position_id is ' ||l_from_position_id, 11);
4050: hr_utility.set_location('from_position_id is ' ||p_sf52_data.from_position_id, 12);
4051: hr_utility.set_location('to_position_id is ' ||p_sf52_data.to_position_id, 13);
4052: hr_utility.set_location('to_basic_pay is ' ||p_sf52_data.to_basic_pay, 14);
4053: if (nvl(l_from_position_id, -1) <> nvl(p_sf52_data.from_position_id, -1) and
4054: nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2)) then
4055: -- ie from and to position were same and
4048: END IF;
4049: hr_utility.set_location('l_from_position_id is ' ||l_from_position_id, 11);
4050: hr_utility.set_location('from_position_id is ' ||p_sf52_data.from_position_id, 12);
4051: hr_utility.set_location('to_position_id is ' ||p_sf52_data.to_position_id, 13);
4052: hr_utility.set_location('to_basic_pay is ' ||p_sf52_data.to_basic_pay, 14);
4053: if (nvl(l_from_position_id, -1) <> nvl(p_sf52_data.from_position_id, -1) and
4054: nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2)) then
4055: -- ie from and to position were same and
4056: -- from position has been changed because of refresh.
4058: -- Reverting changes made in Bug # 757932
4059: -- if nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2) then
4060: -- from and to position were same.
4061:
4062: hr_utility.set_location('Case 1 ', 15);
4063:
4064: p_sf52_data.to_adj_basic_pay := l_adj_basic_pay;
4065: p_sf52_data.to_basic_pay := l_basic_pay;
4066: p_sf52_data.to_grade_id := l_grade_id;
4106: END IF;
4107: -- Start Bug 1310894
4108: elsif nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2)
4109: and l_noa_family_code = 'OTHER_PAY' then
4110: hr_utility.set_location('Case 2 ', 15);
4111: -- Other Pay action and From and To Position were same.
4112: p_sf52_data.to_adj_basic_pay := l_adj_basic_pay;
4113: p_sf52_data.to_basic_pay := l_basic_pay;
4114: p_sf52_data.to_grade_id := l_grade_id;
4135: p_sf52_data.to_position_title := p_sf52_data.from_position_title;
4136: -- End Bug 1310894
4137: elsif p_sf52_data.to_position_id is not NULL then
4138: -- User has entered to_position
4139: hr_utility.set_location('Case 3 ', 15);
4140: l_position_id := p_sf52_data.to_position_id;
4141:
4142: -- get to_position columns
4143: -- Bug 2112935 Sundar
4142: -- get to_position columns
4143: -- Bug 2112935 Sundar
4144: -- For Retro 866 and 740, need to pass initial PRD as null.
4145: -- Call determine_ia to Find out Retro NOAs.
4146: hr_utility.set_location('l_session_var.altered_pa_request_id ' || l_session_var.altered_pa_request_id ,15);
4147:
4148: FOR l_orig_rec IN c_orig_rec(l_session_var.altered_pa_request_id) LOOP
4149: l_orig_pa_request_id := l_orig_rec.pa_request_id;
4150: l_orig_pa_notification_id := l_orig_rec.pa_notification_id;
4164: p_retro_eff_date => l_effective_date,
4165: p_retro_pa_request_id => l_retro_pa_request_id,
4166: p_retro_first_noa => l_retro_first_noa,
4167: p_retro_second_noa => l_retro_second_noa);
4168: hr_utility.set_location('Retro 1st NOA ' || l_retro_first_noa ,15);
4169: hr_utility.set_location('Retro 2nd NOA ' || l_retro_second_noa ,15);
4170:
4171: -- 8303159 For dual actions with 740 combination if first noa code is 740 need to
4172: -- consider it is as retro NOA
4165: p_retro_pa_request_id => l_retro_pa_request_id,
4166: p_retro_first_noa => l_retro_first_noa,
4167: p_retro_second_noa => l_retro_second_noa);
4168: hr_utility.set_location('Retro 1st NOA ' || l_retro_first_noa ,15);
4169: hr_utility.set_location('Retro 2nd NOA ' || l_retro_second_noa ,15);
4170:
4171: -- 8303159 For dual actions with 740 combination if first noa code is 740 need to
4172: -- consider it is as retro NOA
4173: IF l_session_var.altered_pa_request_id is not null and l_orig_second_noa is not null
4186: IF ((l_retro_first_noa = '866' OR l_retro_second_noa = '866') OR
4187: (l_retro_first_noa = '740' OR l_retro_second_noa = '740')) THEN
4188: NULL;
4189: ELSE
4190: hr_utility.set_location('FWFA prd :'||l_prd,80);
4191: hr_utility.set_location('FWFA refresh prd :'||p_sf52_data.pay_rate_determinant,90);
4192: --Begin Bug# 14047036, 13587903
4193: IF l_noa_family_code = 'CORRECT' THEN
4194: FOR l_get_prd_pm IN get_prd_pm(l_second_noa_id) LOOP
4187: (l_retro_first_noa = '740' OR l_retro_second_noa = '740')) THEN
4188: NULL;
4189: ELSE
4190: hr_utility.set_location('FWFA prd :'||l_prd,80);
4191: hr_utility.set_location('FWFA refresh prd :'||p_sf52_data.pay_rate_determinant,90);
4192: --Begin Bug# 14047036, 13587903
4193: IF l_noa_family_code = 'CORRECT' THEN
4194: FOR l_get_prd_pm IN get_prd_pm(l_second_noa_id) LOOP
4195: l_prd_pm := l_get_prd_pm.process_method_code;
4198: FOR l_get_prd_pm IN get_prd_pm(l_first_noa_id) LOOP
4199: l_prd_pm := l_get_prd_pm.process_method_code;
4200: END LOOP;
4201: END IF;
4202: hr_utility.set_location('PRD Process Method :'|| l_prd_pm,92);
4203: --End Bug# 14047036, 13587903
4204: --Bug# 13587903 added RPA prd not null condition to get the PRD from assginment
4205: IF l_prd IS NOT NULL AND l_prd_pm NOT IN ('AP') AND --Bug# 13587903
4206: l_prd <> nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) then
4205: IF l_prd IS NOT NULL AND l_prd_pm NOT IN ('AP') AND --Bug# 13587903
4206: l_prd <> nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) then
4207: p_sf52_data.pay_rate_determinant := l_prd;
4208: END IF;
4209: hr_utility.set_location('p_sf52_data.to_position_id'||p_sf52_data.to_position_id,10);
4210: hr_utility.set_location('p_sf52_data.from_position_id'||p_sf52_data.from_position_id,11);
4211: --6850492
4212: get_asg_step_or_rate(p_sf52_data.to_position_id,p_sf52_data.effective_date,l_step_or_rate1,l_prd1);
4213: --6850492
4206: l_prd <> nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) then
4207: p_sf52_data.pay_rate_determinant := l_prd;
4208: END IF;
4209: hr_utility.set_location('p_sf52_data.to_position_id'||p_sf52_data.to_position_id,10);
4210: hr_utility.set_location('p_sf52_data.from_position_id'||p_sf52_data.from_position_id,11);
4211: --6850492
4212: get_asg_step_or_rate(p_sf52_data.to_position_id,p_sf52_data.effective_date,l_step_or_rate1,l_prd1);
4213: --6850492
4214: hr_utility.set_location('l_prd1'||l_prd1,10);
4210: hr_utility.set_location('p_sf52_data.from_position_id'||p_sf52_data.from_position_id,11);
4211: --6850492
4212: get_asg_step_or_rate(p_sf52_data.to_position_id,p_sf52_data.effective_date,l_step_or_rate1,l_prd1);
4213: --6850492
4214: hr_utility.set_location('l_prd1'||l_prd1,10);
4215: hr_utility.set_location('l_step_or_rate1'||l_step_or_rate1,12);
4216:
4217: -- Added to compare step or rate with '00' for dual actions
4218: IF l_step_or_rate1 IS NOT NULL AND
4211: --6850492
4212: get_asg_step_or_rate(p_sf52_data.to_position_id,p_sf52_data.effective_date,l_step_or_rate1,l_prd1);
4213: --6850492
4214: hr_utility.set_location('l_prd1'||l_prd1,10);
4215: hr_utility.set_location('l_step_or_rate1'||l_step_or_rate1,12);
4216:
4217: -- Added to compare step or rate with '00' for dual actions
4218: IF l_step_or_rate1 IS NOT NULL AND
4219: l_step_or_rate1 <> nvl(p_sf52_data.to_step_or_rate,hr_api.g_varchar2) AND
4228: -- end if
4229:
4230: --6850492
4231: END IF;
4232: hr_utility.set_location('bef call to to_data PRD ' || p_sf52_data.pay_rate_determinant ,15);
4233: hr_utility.set_location('bef call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,15);
4234: ghr_pa_requests_pkg.get_sf52_to_data_elements
4235: (p_position_id => p_sf52_data.to_position_id
4236: ,p_effective_date => p_sf52_data.effective_date
4229:
4230: --6850492
4231: END IF;
4232: hr_utility.set_location('bef call to to_data PRD ' || p_sf52_data.pay_rate_determinant ,15);
4233: hr_utility.set_location('bef call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,15);
4234: ghr_pa_requests_pkg.get_sf52_to_data_elements
4235: (p_position_id => p_sf52_data.to_position_id
4236: ,p_effective_date => p_sf52_data.effective_date
4237: ,p_prd => p_sf52_data.pay_rate_determinant
4250: ,p_position_org_line5 => l_position_org_line5
4251: ,p_position_org_line6 => l_position_org_line6
4252: ,p_duty_station_id => l_duty_station_id
4253: );
4254: hr_utility.set_location('After call to to_data PRD ' || p_sf52_data.pay_rate_determinant ,15);
4255:
4256:
4257: --Added 855 for bug 3617311
4258: --6850492 added 713 to compare for dual actions as 713 can be performed as a second action
4294: p_sf52_data.to_step_or_rate := l_step_or_rate;
4295: END IF;
4296: END IF;
4297:
4298: hr_utility.set_location('aft call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,16);
4299: if nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) in ('A','B','E','F','U','V') then
4300:
4301: ----Temp Promo Changes by AVR 03-JUN-2000--Start---
4302:
4318: p_prd => p_sf52_data.pay_rate_determinant,
4319: p_pa_request_id => p_sf52_data.pa_request_id,
4320: p_effective_date => p_sf52_data.effective_date);
4321: end if;
4322: hr_utility.set_location('aft call to upda 34 pay BAsis ' || p_sf52_data.to_pay_basis ,1);
4323: end if;
4324: hr_utility.set_location('aft call to upda 34 pay BAsis outside if '
4325: || p_sf52_data.to_pay_basis ,1);
4326:
4320: p_effective_date => p_sf52_data.effective_date);
4321: end if;
4322: hr_utility.set_location('aft call to upda 34 pay BAsis ' || p_sf52_data.to_pay_basis ,1);
4323: end if;
4324: hr_utility.set_location('aft call to upda 34 pay BAsis outside if '
4325: || p_sf52_data.to_pay_basis ,1);
4326:
4327: if (l_first_noa_code = '352') then
4328: p_sf52_data.to_position_org_line1 :=
4358: open get_pos_bg ( P_sf52_data.to_position_id);
4359: fetch get_pos_bg into l_business_group_id;
4360: if get_pos_bg%notfound then
4361: close get_pos_bg;
4362: hr_utility.set_location ( l_proc || 'get_pos_bg not found ', 100);
4363: hr_utility.set_message(8301 , 'GHR_38415_BUSN_GRP_NOT_FOUND');
4364: hr_utility.raise_error;
4365: else
4366: close get_pos_bg;
4359: fetch get_pos_bg into l_business_group_id;
4360: if get_pos_bg%notfound then
4361: close get_pos_bg;
4362: hr_utility.set_location ( l_proc || 'get_pos_bg not found ', 100);
4363: hr_utility.set_message(8301 , 'GHR_38415_BUSN_GRP_NOT_FOUND');
4364: hr_utility.raise_error;
4365: else
4366: close get_pos_bg;
4367: end if;
4360: if get_pos_bg%notfound then
4361: close get_pos_bg;
4362: hr_utility.set_location ( l_proc || 'get_pos_bg not found ', 100);
4363: hr_utility.set_message(8301 , 'GHR_38415_BUSN_GRP_NOT_FOUND');
4364: hr_utility.raise_error;
4365: else
4366: close get_pos_bg;
4367: end if;
4368:
4383:
4384: -- JH DS starts populated from ASG. Populate using To Position if To Posn PM is UE, or APUE and
4385: -- to_posn <> from posn.
4386: --
4387: hr_utility.set_location('To Posn ID ' || p_sf52_data.to_position_id ,20);
4388: IF p_sf52_data.to_position_id IS NOT NULL THEN
4389: /* l_pm value determined above
4390: FOR pm_rec in get_to_posn_title_pm LOOP
4391: l_pm := pm_rec.process_method_code;
4390: FOR pm_rec in get_to_posn_title_pm LOOP
4391: l_pm := pm_rec.process_method_code;
4392: END Loop;
4393: */
4394: hr_utility.set_location('To Posn PM ' || l_pm ,20);
4395: IF l_pm = 'UE' THEN
4396: p_sf52_data.duty_station_location_id := l_location_id;
4397: p_sf52_data.duty_station_id := l_duty_station_id;
4398: ELSIF l_pm = 'APUE' and nvl(p_sf52_data.to_position_id,hr_api.g_number)
4407: -- If the refresh is for realignment then refresh position org. lines using the procedure
4408: -- ghr_pa_requests_pkg.get_rei_org_lines
4409: if p_sf52_data.first_noa_code = '790' or
4410: p_sf52_data.second_noa_code = '790' then
4411: hr_utility.set_location('Realignment NOA: ' || l_proc, 410);
4412: ghr_pa_requests_pkg.get_rei_org_lines(
4413: P_PA_REQUEST_ID => p_sf52_data.pa_request_id,
4414: P_ORGANIZATION_ID => l_organization_id,
4415: P_POSITION_ORG_LINE1 => l_position_org_line1,
4419: P_POSITION_ORG_LINE5 => l_position_org_line5,
4420: P_POSITION_ORG_LINE6 => l_position_org_line6
4421: );
4422: if l_organization_id is not NULL then
4423: hr_utility.set_location('Realignment NOA Refreshed: ' || l_proc, 420);
4424: p_sf52_data.to_position_org_line1 := l_position_org_line1;
4425: p_sf52_data.to_position_org_line2 := l_position_org_line2;
4426: p_sf52_data.to_position_org_line3 := l_position_org_line3;
4427: p_sf52_data.to_position_org_line4 := l_position_org_line4;
4427: p_sf52_data.to_position_org_line4 := l_position_org_line4;
4428: p_sf52_data.to_position_org_line5 := l_position_org_line5;
4429: p_sf52_data.to_position_org_line6 := l_position_org_line6;
4430: else
4431: hr_utility.set_location('Realignment NOA NOT Refreshed: ' || l_proc, 430);
4432: end if;
4433: end if;
4434:
4435: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
4462: ,p_personnel_office_id => l_personnel_office_id
4463: ,p_office_symbol => l_office_symbol
4464: ,p_part_time_hours => l_part_time_hours);
4465:
4466: hr_utility.set_location('l_work_schedule is ' || l_work_schedule, 11);
4467: if (not p_from_only) then
4468: hr_utility.set_location('l_work_schedule is ' || l_work_schedule, 12);
4469: p_sf52_data.flsa_category := l_flsa_category ;
4470: p_sf52_data.bargaining_unit_status := l_bargaining_unit_status;
4464: ,p_part_time_hours => l_part_time_hours);
4465:
4466: hr_utility.set_location('l_work_schedule is ' || l_work_schedule, 11);
4467: if (not p_from_only) then
4468: hr_utility.set_location('l_work_schedule is ' || l_work_schedule, 12);
4469: p_sf52_data.flsa_category := l_flsa_category ;
4470: p_sf52_data.bargaining_unit_status := l_bargaining_unit_status;
4471: p_sf52_data.work_schedule := l_work_schedule;
4472: p_sf52_data.functional_class := l_functional_class ;
4480: p_sf52_data.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
4481: ,'GHR_US_WORK_SCHEDULE'
4482: ,l_work_schedule);
4483: end if;
4484: hr_utility.set_location('l_work_schedule_desc is ' || p_sf52_data.work_schedule_desc, 13);
4485: if (p_from_only = FALSE) then
4486: ghr_history_fetch.fetch_people(
4487: p_person_id => p_person_id,
4488: p_date_effective => p_effective_date,
4492: p_people_data => l_people_data,
4493: p_result_code => l_result_code
4494: );
4495: if (l_result_code is not null) then
4496: hr_utility.set_location(l_proc || 'non-null result_code', 910);
4497: end if;
4498:
4499: p_sf52_data.employee_national_identifier := l_people_data.national_identifier;
4500: p_sf52_data.employee_date_of_birth := l_people_data.date_of_birth;
4613: ,p_multiple_error_flag => l_multiple_error_flag);
4614:
4615: /*
4616: if (l_multiple_error_flag) then
4617: hr_utility.set_message(8301 , 'GHR_99999_MULT_ERR_FLAG');
4618: hr_utility.raise_error;
4619: end if;
4620: */
4621:
4614:
4615: /*
4616: if (l_multiple_error_flag) then
4617: hr_utility.set_message(8301 , 'GHR_99999_MULT_ERR_FLAG');
4618: hr_utility.raise_error;
4619: end if;
4620: */
4621:
4622: p_sf52_data.fegli := l_fegli ;
4632: ,p_value => l_retirement_plan
4633: ,p_multiple_error_flag => l_multiple_error_flag);
4634: /*
4635: if (l_multiple_error_flag) then
4636: hr_utility.set_message(8301 , 'GHR_99999_MULT_ERR_FLAG2');
4637: hr_utility.raise_error;
4638: end if;
4639: */
4640:
4633: ,p_multiple_error_flag => l_multiple_error_flag);
4634: /*
4635: if (l_multiple_error_flag) then
4636: hr_utility.set_message(8301 , 'GHR_99999_MULT_ERR_FLAG2');
4637: hr_utility.raise_error;
4638: end if;
4639: */
4640:
4641: p_sf52_data.retirement_plan := l_retirement_plan ;
4646: end if;
4647:
4648: --- Code for converting the pay values per Retain Grade Pay Basis
4649: -- if employee is on retain grade
4650: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4651: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4652: hr_utility.set_location('PER ID '|| p_person_id,1 );
4653: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4654: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4647:
4648: --- Code for converting the pay values per Retain Grade Pay Basis
4649: -- if employee is on retain grade
4650: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4651: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4652: hr_utility.set_location('PER ID '|| p_person_id,1 );
4653: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4654: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4655: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4648: --- Code for converting the pay values per Retain Grade Pay Basis
4649: -- if employee is on retain grade
4650: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4651: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4652: hr_utility.set_location('PER ID '|| p_person_id,1 );
4653: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4654: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4655: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4656: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4649: -- if employee is on retain grade
4650: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4651: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4652: hr_utility.set_location('PER ID '|| p_person_id,1 );
4653: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4654: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4655: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4656: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4657: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4650: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4651: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4652: hr_utility.set_location('PER ID '|| p_person_id,1 );
4653: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4654: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4655: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4656: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4657: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4658: IF p_sf52_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
4651: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4652: hr_utility.set_location('PER ID '|| p_person_id,1 );
4653: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4654: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4655: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4656: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4657: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4658: IF p_sf52_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
4659: IF l_from_position_id = p_sf52_data.to_position_id and
4652: hr_utility.set_location('PER ID '|| p_person_id,1 );
4653: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4654: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4655: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4656: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4657: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4658: IF p_sf52_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
4659: IF l_from_position_id = p_sf52_data.to_position_id and
4660: l_session_var.noa_id_correct is not NULL and
4653: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4654: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4655: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4656: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4657: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4658: IF p_sf52_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
4659: IF l_from_position_id = p_sf52_data.to_position_id and
4660: l_session_var.noa_id_correct is not NULL and
4661: l_pm = 'AP' THEN
4701: END IF;
4702: -- display all values retrieved
4703: print_sf52('Retrieved by refresh: ', p_sf52_data);
4704:
4705: hr_utility.set_location('Leaving: ' || l_proc, 100);
4706:
4707: EXCEPTION
4708: WHEN others THEN
4709: -- Reset IN OUT parameters and set OUT parameters
4709: -- Reset IN OUT parameters and set OUT parameters
4710:
4711: p_sf52_data := l_sf52_data ;
4712:
4713: hr_utility.set_location('Leaving ' || l_proc,80);
4714: RAISE;
4715:
4716: end refresh_pa_request;
4717:
4854: l_fld_names_tab fld_names_typ;
4855:
4856: BEGIN
4857: l_fld_names_tab := p_fld_names_tab; --NOCOPY Changes
4858: hr_utility.set_location('Entering:'|| l_proc, 5);
4859:
4860: -- populate the local table with the form_field_names for this noa.
4861: if (p_2nd_noa_id is not null) then
4862: hr_utility.set_location( l_proc || 'dual action', 7);
4858: hr_utility.set_location('Entering:'|| l_proc, 5);
4859:
4860: -- populate the local table with the form_field_names for this noa.
4861: if (p_2nd_noa_id is not null) then
4862: hr_utility.set_location( l_proc || 'dual action', 7);
4863: FOR curflds_rec in cur_flds2(p_1st_noa_id, p_2nd_noa_id) LOOP
4864: l_column_count := l_column_count + 1;
4865: p_fld_names_tab(l_column_count) := curflds_rec;
4866: END LOOP;
4868: l_column_count := l_column_count +1;
4869: p_fld_names_tab(l_column_count) := cur_postitle_rec;
4870: end LOOP;
4871: else
4872: hr_utility.set_location( l_proc || 'single action', 9);
4873: FOR curflds_rec in cur_flds1(p_1st_noa_id) LOOP
4874: l_column_count := l_column_count + 1;
4875: p_fld_names_tab(l_column_count) := curflds_rec;
4876: END LOOP;
4878: l_column_count := l_column_count +1;
4879: p_fld_names_tab(l_column_count) := cur_postitle_rec;
4880: end LOOP;
4881: end if;
4882: hr_utility.set_location('Leaving:'|| l_proc, 10);
4883:
4884: EXCEPTION
4885: WHEN others THEN
4886: -- Reset IN OUT parameters and set OUT parameters
4886: -- Reset IN OUT parameters and set OUT parameters
4887:
4888: p_fld_names_tab :=l_fld_names_tab;
4889:
4890: hr_utility.set_location('Leaving ' || l_proc,60);
4891: RAISE;
4892: END initialize_fld_names_table;
4893:
4894: --
4904: l_to_field VARCHAR2(2000);
4905:
4906: BEGIN
4907: l_to_field := p_to_field; --NOCOPY Changes
4908: hr_utility.set_location('Entering:'|| l_proc, 5);
4909: FOR l_count IN 1..l_column_count LOOP
4910: if p_field_name = l_fld_names_tab(l_count).form_field_name then
4911: l_found := TRUE;
4912: p_to_field := p_from_field; -- Sundar 2112935 Copying source to the target.
4916: if not l_found then
4917: p_to_field := null;
4918: end if;
4919:
4920: hr_utility.set_location('Leaving:'|| l_proc, 10);
4921:
4922: EXCEPTION
4923: WHEN others THEN
4924: -- Reset IN OUT parameters and set OUT parameters
4924: -- Reset IN OUT parameters and set OUT parameters
4925:
4926: p_to_field :=l_to_field;
4927:
4928: hr_utility.set_location('Leaving ' || l_proc,60);
4929: RAISE;
4930: END copy_to_new_rg;
4931:
4932: BEGIN
4929: RAISE;
4930: END copy_to_new_rg;
4931:
4932: BEGIN
4933: hr_utility.set_location('Entering:'|| l_proc, 5);
4934: hr_utility.set_location(' no. of rows in table rg ' || to_char(l_column_count), 11);
4935: -- get list of all columns needed for the noa we are correcting.
4936: initialize_fld_names_table( p_1st_noa_id => p_first_noa_id,
4937: p_2nd_noa_id => p_second_noa_id,
4930: END copy_to_new_rg;
4931:
4932: BEGIN
4933: hr_utility.set_location('Entering:'|| l_proc, 5);
4934: hr_utility.set_location(' no. of rows in table rg ' || to_char(l_column_count), 11);
4935: -- get list of all columns needed for the noa we are correcting.
4936: initialize_fld_names_table( p_1st_noa_id => p_first_noa_id,
4937: p_2nd_noa_id => p_second_noa_id,
4938: p_fld_names_tab => l_fld_names_tab);
5128:
5129: -- copy_to_new_rg('CUSTOM_PAY_CALC_FLAG',p_pa_req_in.custom_pay_calc_flag,l_pa_req.custom_pay_calc_flag);
5130: p_pa_req_out := l_pa_req;
5131:
5132: hr_utility.set_location('Leaving:'|| l_proc, 15);
5133:
5134: EXCEPTION
5135: WHEN others THEN
5136: -- Reset IN OUT parameters and set OUT parameters
5136: -- Reset IN OUT parameters and set OUT parameters
5137:
5138: p_pa_req_out :=NULL;
5139:
5140: hr_utility.set_location('Leaving ' || l_proc,60);
5141: RAISE;
5142:
5143: END get_par_ap_apue_fields;
5144:
5215: l_ret_allow_perc_out NUMBER;
5216: BEGIN
5217: l_sf52_data :=p_sf52_data ; --NOCOPY Changes
5218:
5219: hr_utility.set_location('Entering:'|| l_proc, 5);
5220: p_sf52_data.to_adj_basic_pay := p_sf52_data.from_adj_basic_pay;
5221: p_sf52_data.agency_code := p_sf52_data.from_agency_code;
5222:
5223: l_open_range_out_basic_pay := p_sf52_data.to_basic_pay;
5265: p_sf52_data.to_ap_premium_pay_indicator := l_sf52_data.to_ap_premium_pay_indicator;
5266: p_sf52_data.to_auo_premium_pay_indicator := l_sf52_data.to_auo_premium_pay_indicator;
5267: p_sf52_data.to_retention_allowance := l_sf52_data.to_retention_allowance;
5268: p_sf52_data.to_retention_allow_percentage := l_sf52_data.to_retention_allow_percentage;
5269: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5270: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5271: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5272: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5273: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5266: p_sf52_data.to_auo_premium_pay_indicator := l_sf52_data.to_auo_premium_pay_indicator;
5267: p_sf52_data.to_retention_allowance := l_sf52_data.to_retention_allowance;
5268: p_sf52_data.to_retention_allow_percentage := l_sf52_data.to_retention_allow_percentage;
5269: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5270: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5271: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5272: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5273: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5274: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5267: p_sf52_data.to_retention_allowance := l_sf52_data.to_retention_allowance;
5268: p_sf52_data.to_retention_allow_percentage := l_sf52_data.to_retention_allow_percentage;
5269: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5270: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5271: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5272: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5273: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5274: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5275: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5268: p_sf52_data.to_retention_allow_percentage := l_sf52_data.to_retention_allow_percentage;
5269: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5270: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5271: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5272: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5273: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5274: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5275: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5276: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5269: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5270: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5271: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5272: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5273: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5274: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5275: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5276: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5277: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5270: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5271: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5272: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5273: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5274: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5275: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5276: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5277: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5278: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5271: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5272: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5273: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5274: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5275: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5276: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5277: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5278: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5279:
5272: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5273: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5274: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5275: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5276: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5277: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5278: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5279:
5280: ghr_pay_calc.main_pay_calc (
5273: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5274: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5275: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5276: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5277: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5278: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5279:
5280: ghr_pay_calc.main_pay_calc (
5281: p_person_id => p_sf52_data.person_id
5274: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5275: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5276: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5277: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5278: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5279:
5280: ghr_pay_calc.main_pay_calc (
5281: p_person_id => p_sf52_data.person_id
5282: ,p_position_id => p_sf52_data.to_position_id
5334:
5335: -- Check if we had any warning messages
5336: -- Calculation not done.
5337: IF l_message_set THEN
5338: hr_utility.set_location( l_proc, 80);
5339: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5340: hr_utility.raise_error;
5341: END IF;
5342:
5335: -- Check if we had any warning messages
5336: -- Calculation not done.
5337: IF l_message_set THEN
5338: hr_utility.set_location( l_proc, 80);
5339: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5340: hr_utility.raise_error;
5341: END IF;
5342:
5343: IF l_calculated THEN
5336: -- Calculation not done.
5337: IF l_message_set THEN
5338: hr_utility.set_location( l_proc, 80);
5339: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5340: hr_utility.raise_error;
5341: END IF;
5342:
5343: IF l_calculated THEN
5344: hr_utility.set_location( l_proc, 50);
5340: hr_utility.raise_error;
5341: END IF;
5342:
5343: IF l_calculated THEN
5344: hr_utility.set_location( l_proc, 50);
5345: -- FWFA Changes Bug#4444609
5346: p_sf52_data.pay_rate_determinant := NVL(l_out_pay_rate_determinant,p_sf52_data.input_pay_rate_determinant);
5347: p_sf52_data.to_pay_table_identifier := l_calc_pay_table_id;
5348: -- FWFA Changes
5356: /*
5357: -- Be careful with setting 'other' pay if it is 'NE'
5358: IF get_other_pay_amount_pm <> 'NE' THEN
5359: -- Populate these values if required
5360: hr_utility.set_location( l_proc, 60);
5361: p_sf52_data.to_other_pay_amount := l_other_pay_amount;
5362: p_sf52_data.to_au_overtime := l_au_overtime;
5363: p_sf52_data.to_au_overtime := l_au_overtime;
5364: END IF;
5363: p_sf52_data.to_au_overtime := l_au_overtime;
5364: END IF;
5365: */
5366: IF l_out_step_or_rate IS NOT NULL THEN
5367: hr_utility.set_location( l_proc, 70);
5368: p_sf52_data.to_step_or_rate := l_out_step_or_rate;
5369: END IF;
5370: -- should this check be here?? This is not the same as the future action case
5371: -- where the pay calc is being run for the second time.
5375: -- GHR_99999_MANDT_COLM_NULL
5376: -- this must never be the case as this SF52 must have been
5377: -- validated at the time future action was saved.
5378: -- raise error
5379: hr_utility.set_location( l_proc, 80);
5380: hr_utility.set_message( 8301, 'GHR_99999_MANDT_COLM_NULL');
5381: hr_utility.raise_error;
5382: null;
5383: END IF;
5376: -- this must never be the case as this SF52 must have been
5377: -- validated at the time future action was saved.
5378: -- raise error
5379: hr_utility.set_location( l_proc, 80);
5380: hr_utility.set_message( 8301, 'GHR_99999_MANDT_COLM_NULL');
5381: hr_utility.raise_error;
5382: null;
5383: END IF;
5384: */
5377: -- validated at the time future action was saved.
5378: -- raise error
5379: hr_utility.set_location( l_proc, 80);
5380: hr_utility.set_message( 8301, 'GHR_99999_MANDT_COLM_NULL');
5381: hr_utility.raise_error;
5382: null;
5383: END IF;
5384: */
5385: ELSE
5385: ELSE
5386: -- GHR_99999_PC_FAILED
5387: -- ie Pay calc failed
5388: -- raise error. As values can not be entered interactively
5389: hr_utility.set_location( l_proc, 100);
5390: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5391: hr_utility.raise_error;
5392: null;
5393: END IF;
5386: -- GHR_99999_PC_FAILED
5387: -- ie Pay calc failed
5388: -- raise error. As values can not be entered interactively
5389: hr_utility.set_location( l_proc, 100);
5390: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5391: hr_utility.raise_error;
5392: null;
5393: END IF;
5394:
5387: -- ie Pay calc failed
5388: -- raise error. As values can not be entered interactively
5389: hr_utility.set_location( l_proc, 100);
5390: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5391: hr_utility.raise_error;
5392: null;
5393: END IF;
5394:
5395: EXCEPTION
5397: -- Reset IN OUT parameters and set OUT parameters
5398:
5399: p_sf52_data := l_sf52_data ;
5400:
5401: hr_utility.set_location('Leaving ' || l_proc,60);
5402: RAISE;
5403:
5404: end derive_to_columns;
5405:
5438:
5439: print_sf52('Initial Data: ', p_sf52_data);
5440:
5441: -- fetch Shadow sf52 of original/root SF52;
5442: hr_utility.set_location('Entering ' || l_proc, 100);
5443: open c_sf52_shadow (p_sf52_data.pa_request_id);
5444: fetch c_sf52_shadow into l_shadow_data;
5445: if c_sf52_shadow%notfound then
5446: hr_utility.set_location(' Error, Shadow not found ' || l_proc, 101);
5442: hr_utility.set_location('Entering ' || l_proc, 100);
5443: open c_sf52_shadow (p_sf52_data.pa_request_id);
5444: fetch c_sf52_shadow into l_shadow_data;
5445: if c_sf52_shadow%notfound then
5446: hr_utility.set_location(' Error, Shadow not found ' || l_proc, 101);
5447: close c_sf52_shadow;
5448: hr_utility.set_message(8301,'GHR_38417_SHADOW_SF52_NOTFOUND');
5449: hr_utility.raise_error;
5450: else
5444: fetch c_sf52_shadow into l_shadow_data;
5445: if c_sf52_shadow%notfound then
5446: hr_utility.set_location(' Error, Shadow not found ' || l_proc, 101);
5447: close c_sf52_shadow;
5448: hr_utility.set_message(8301,'GHR_38417_SHADOW_SF52_NOTFOUND');
5449: hr_utility.raise_error;
5450: else
5451: close c_sf52_shadow ;
5452: end if;
5445: if c_sf52_shadow%notfound then
5446: hr_utility.set_location(' Error, Shadow not found ' || l_proc, 101);
5447: close c_sf52_shadow;
5448: hr_utility.set_message(8301,'GHR_38417_SHADOW_SF52_NOTFOUND');
5449: hr_utility.raise_error;
5450: else
5451: close c_sf52_shadow ;
5452: end if;
5453: -- convert shadow rg to SF52 format
5450: else
5451: close c_sf52_shadow ;
5452: end if;
5453: -- convert shadow rg to SF52 format
5454: hr_utility.set_location('Call Convert_shadoe_to_sf52 ' || l_proc, 110);
5455: ghr_history_conv_rg.convert_shadow_to_sf52 (
5456: p_shadow => l_shadow_data,
5457: p_sf52 => l_sf52_shadow);
5458:
5480: l_sf52_refresh_data.to_pay_plan := p_sf52_data.to_pay_plan;
5481: END IF;
5482:
5483: -- vsm
5484: hr_utility.set_location(l_proc, 120);
5485: -- Start Bug 1310894
5486: l_bef_basic_pay := p_sf52_data.from_basic_pay;
5487: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 135);
5488: -- End Bug 1310894
5483: -- vsm
5484: hr_utility.set_location(l_proc, 120);
5485: -- Start Bug 1310894
5486: l_bef_basic_pay := p_sf52_data.from_basic_pay;
5487: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 135);
5488: -- End Bug 1310894
5489:
5490: refresh_pa_request
5491: (p_person_id => p_sf52_data.person_id,
5490: refresh_pa_request
5491: (p_person_id => p_sf52_data.person_id,
5492: p_effective_date => p_sf52_data.effective_date,
5493: p_sf52_data => l_sf52_refresh_data);
5494: hr_utility.set_location(l_proc, 130);
5495: print_sf52('refresh record before get_par: ', l_sf52_refresh_data);
5496:
5497: -- Call procedure to nullify NE/UE columns.
5498: get_par_ap_apue_fields( p_pa_req_in => l_sf52_refresh_data,
5516: p_shadow_rec => l_sf52_shadow,
5517: p_sf52_rec => p_sf52_data,
5518: p_changed => l_changed);
5519: if (l_changed) then
5520: hr_utility.set_location('REFRESH CHANGED SF52.' , 11999);
5521: end if;
5522: if (l_changed and p_process_type = 'FUTURE') then
5523: raise e_refresh;
5524: end if;
5524: end if;
5525: -- Bug#4709111 Reverted the fix done for 4680047. Commented the following code.
5526: -- Bug#4680047
5527: /* IF p_sf52_data.input_pay_rate_determinant <> l_sf52_refresh_data.pay_rate_determinant THEN
5528: hr_utility.set_location('FWFA RPA Input PRD: '||p_sf52_data.input_pay_rate_determinant,12000);
5529: hr_utility.set_location('FWFA Refresh PRD: '||l_sf52_refresh_data.pay_rate_determinant,13000);
5530: p_sf52_data.input_pay_rate_determinant := l_sf52_refresh_data.pay_rate_determinant;
5531: p_sf52_data.pay_rate_determinant := l_sf52_refresh_data.pay_rate_determinant;
5532: END IF; */
5525: -- Bug#4709111 Reverted the fix done for 4680047. Commented the following code.
5526: -- Bug#4680047
5527: /* IF p_sf52_data.input_pay_rate_determinant <> l_sf52_refresh_data.pay_rate_determinant THEN
5528: hr_utility.set_location('FWFA RPA Input PRD: '||p_sf52_data.input_pay_rate_determinant,12000);
5529: hr_utility.set_location('FWFA Refresh PRD: '||l_sf52_refresh_data.pay_rate_determinant,13000);
5530: p_sf52_data.input_pay_rate_determinant := l_sf52_refresh_data.pay_rate_determinant;
5531: p_sf52_data.pay_rate_determinant := l_sf52_refresh_data.pay_rate_determinant;
5532: END IF; */
5533: print_sf52('sf52 record after cascade: ', p_sf52_data);
5532: END IF; */
5533: print_sf52('sf52 record after cascade: ', p_sf52_data);
5534: print_sf52('shadow record after cascade: ', l_sf52_shadow);
5535: print_sf52('refresh record after cascade: ', l_sf52_refresh_data);
5536: hr_utility.set_location(l_proc, 150);
5537: -- Bug 3704438 - PTH Issue - Start
5538: IF p_sf52_data.work_schedule in ('F', 'G', 'B', 'I', 'J')
5539: and p_sf52_data.part_time_hours is not null then
5540: p_sf52_data.part_time_hours := null;
5547: ,p_assignment_id => p_sf52_data.employee_assignment_id
5548: ,p_effective_date => p_sf52_data.effective_date
5549: ,p_value => l_retention_allowance
5550: ,p_multiple_error_flag => l_multi_error_flag);
5551: hr_utility.set_location('Retention Allowance on Eff Date'||l_retention_allowance, 164);
5552: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
5553: ,p_input_value_name => 'Amount'
5554: ,p_assignment_id => p_sf52_data.employee_assignment_id
5555: ,p_effective_date => p_sf52_data.effective_date
5554: ,p_assignment_id => p_sf52_data.employee_assignment_id
5555: ,p_effective_date => p_sf52_data.effective_date
5556: ,p_value => l_supervisory_differential
5557: ,p_multiple_error_flag => l_multi_error_flag);
5558: hr_utility.set_location('Supervisory Differential on Eff Date'||l_supervisory_differential, 165);
5559: ghr_api.retrieve_element_entry_value (p_element_name => 'Staffing Differential'
5560: ,p_input_value_name => 'Amount'
5561: ,p_assignment_id => p_sf52_data.employee_assignment_id
5562: ,p_effective_date => p_sf52_data.effective_date
5561: ,p_assignment_id => p_sf52_data.employee_assignment_id
5562: ,p_effective_date => p_sf52_data.effective_date
5563: ,p_value => l_staffing_differential
5564: ,p_multiple_error_flag => l_multi_error_flag);
5565: hr_utility.set_location('Staffing Differential on Eff Date'||l_staffing_differential, 166);
5566:
5567: -- Start Bug 2633367
5568: IF p_sf52_data.first_noa_code in ('810') THEN
5569: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 160);
5565: hr_utility.set_location('Staffing Differential on Eff Date'||l_staffing_differential, 166);
5566:
5567: -- Start Bug 2633367
5568: IF p_sf52_data.first_noa_code in ('810') THEN
5569: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 160);
5570: hr_utility.set_location('to_basic_pay is '||p_sf52_data.to_basic_pay, 161);
5571: hr_utility.set_location('from_basic_pay is '||p_sf52_data.from_basic_pay, 162);
5572: IF nvl(p_sf52_data.from_basic_pay,0) <> nvl(l_bef_basic_pay,0) then
5573: IF p_sf52_data.to_retention_allow_percentage is not null then
5566:
5567: -- Start Bug 2633367
5568: IF p_sf52_data.first_noa_code in ('810') THEN
5569: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 160);
5570: hr_utility.set_location('to_basic_pay is '||p_sf52_data.to_basic_pay, 161);
5571: hr_utility.set_location('from_basic_pay is '||p_sf52_data.from_basic_pay, 162);
5572: IF nvl(p_sf52_data.from_basic_pay,0) <> nvl(l_bef_basic_pay,0) then
5573: IF p_sf52_data.to_retention_allow_percentage is not null then
5574:
5567: -- Start Bug 2633367
5568: IF p_sf52_data.first_noa_code in ('810') THEN
5569: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 160);
5570: hr_utility.set_location('to_basic_pay is '||p_sf52_data.to_basic_pay, 161);
5571: hr_utility.set_location('from_basic_pay is '||p_sf52_data.from_basic_pay, 162);
5572: IF nvl(p_sf52_data.from_basic_pay,0) <> nvl(l_bef_basic_pay,0) then
5573: IF p_sf52_data.to_retention_allow_percentage is not null then
5574:
5575: -- Changed For FWS
5614: nvl(p_sf52_data.to_availability_pay,0) +
5615: nvl(p_sf52_data.to_retention_allowance,0) +
5616: nvl(p_sf52_data.to_supervisory_differential,0) +
5617: nvl(p_sf52_data.to_staffing_differential,0);
5618: hr_utility.set_location('Recalculated Other Pay is '||p_sf52_data.to_other_pay_amount, 166);
5619: if p_sf52_data.to_other_pay_amount = 0 then
5620: p_sf52_data.to_other_pay_amount := null;
5621: end if;
5622: -- End Bug 2633367
5625: /* Commenting this portion of code because recalculation of
5626: retention allowance included in ghr_pay_calc.main_pay_calc
5627: if nvl(p_sf52_data.from_basic_pay,0) <> nvl(p_sf52_data.to_basic_pay,0) and
5628: p_sf52_data.first_noa_code not in ('810','818','819') then
5629: hr_utility.set_location('Change in Basic Pay and Non Other Pay Action', 163);
5630: --Get the retention allowance and supervisory differential on that date
5631: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
5632: ,p_input_value_name => 'Amount'
5633: ,p_assignment_id => p_sf52_data.employee_assignment_id
5633: ,p_assignment_id => p_sf52_data.employee_assignment_id
5634: ,p_effective_date => p_sf52_data.effective_date
5635: ,p_value => l_retention_allowance
5636: ,p_multiple_error_flag => l_multi_error_flag);
5637: hr_utility.set_location('Retention Allowance on Eff Date'||l_retention_allowance, 164);
5638: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
5639: ,p_input_value_name => 'Amount'
5640: ,p_assignment_id => p_sf52_data.employee_assignment_id
5641: ,p_effective_date => p_sf52_data.effective_date
5640: ,p_assignment_id => p_sf52_data.employee_assignment_id
5641: ,p_effective_date => p_sf52_data.effective_date
5642: ,p_value => l_supervisory_differential
5643: ,p_multiple_error_flag => l_multi_error_flag);
5644: hr_utility.set_location('Supervisory Differential on Eff Date'||l_supervisory_differential, 165);
5645: if l_retention_allowance is null then
5646: p_sf52_data.to_retention_allowance := null;
5647: p_sf52_data.to_other_pay_amount := nvl(p_sf52_data.to_au_overtime,0) +
5648: nvl(p_sf52_data.to_availability_pay,0) +
5648: nvl(p_sf52_data.to_availability_pay,0) +
5649: nvl(p_sf52_data.to_retention_allowance,0) +
5650: nvl(p_sf52_data.to_supervisory_differential,0) +
5651: nvl(p_sf52_data.to_staffing_differential,0);
5652: hr_utility.set_location('Recalculated Other Pay is '||p_sf52_data.to_other_pay_amount, 166);
5653: end if;
5654: if l_supervisory_differential is null then
5655: p_sf52_data.to_supervisory_differential := null;
5656: p_sf52_data.to_other_pay_amount := nvl(p_sf52_data.to_au_overtime,0) +
5657: nvl(p_sf52_data.to_availability_pay,0) +
5658: nvl(p_sf52_data.to_retention_allowance,0) +
5659: nvl(p_sf52_data.to_supervisory_differential,0) +
5660: nvl(p_sf52_data.to_staffing_differential,0);
5661: hr_utility.set_location('Recalculated Other Pay is '||p_sf52_data.to_other_pay_amount, 167);
5662: end if;
5663: if p_sf52_data.to_other_pay_amount = 0 then
5664: p_sf52_data.to_other_pay_amount := null;
5665: end if;
5673: redo_Pay_calc ( p_sf52_rec => p_sf52_data,
5674: p_capped_other_pay => l_capped_other_pay);
5675: END IF;
5676:
5677: hr_utility.set_location(l_proc, 170);
5678: ghr_history_conv_rg.convert_sf52_to_shadow (
5679: p_shadow => p_shadow_data,
5680: p_sf52 => l_sf52_shadow);
5681:
5678: ghr_history_conv_rg.convert_sf52_to_shadow (
5679: p_shadow => p_shadow_data,
5680: p_sf52 => l_sf52_shadow);
5681:
5682: hr_utility.set_location('Leaving : ' || l_proc, 180);
5683:
5684: EXCEPTION
5685: WHEN others THEN
5686: -- Reset IN OUT parameters and set OUT parameters
5687:
5688: p_sf52_data := l_sf52_data ;
5689: p_shadow_data :=NULL ;
5690:
5691: hr_utility.set_location('Leaving ' || l_proc,160);
5692: RAISE;
5693:
5694: End refresh_req_shadow ;
5695:
5725: Begin
5726: l_capped_other_pay := p_capped_other_pay; --NOCOPY Changes
5727: l_sf52_rec := p_sf52_rec ;
5728:
5729: hr_utility.set_location( 'Entering : ' || l_proc,10);
5730:
5731: print_sf52('Before redo_pay : ' , p_sf52_rec);
5732:
5733: If nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2)
5737: then
5738: -- and (p_sf52_rec.first_noa_code <> '899') and
5739: -- not (p_sf52_rec.first_noa_code = '002' and
5740: -- p_sf52_rec.second_noa_code = '899')
5741: hr_utility.set_location('Valid Family ' || l_proc, 11);
5742: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5743: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5744: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5745: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5739: -- not (p_sf52_rec.first_noa_code = '002' and
5740: -- p_sf52_rec.second_noa_code = '899')
5741: hr_utility.set_location('Valid Family ' || l_proc, 11);
5742: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5743: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5744: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5745: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5746: l_pay_calc_in_rec.pa_request_id := p_sf52_rec.pa_request_id;
5747: l_pay_calc_in_rec.person_id := p_sf52_rec.person_id;
5740: -- p_sf52_rec.second_noa_code = '899')
5741: hr_utility.set_location('Valid Family ' || l_proc, 11);
5742: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5743: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5744: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5745: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5746: l_pay_calc_in_rec.pa_request_id := p_sf52_rec.pa_request_id;
5747: l_pay_calc_in_rec.person_id := p_sf52_rec.person_id;
5748: l_pay_calc_in_rec.position_id := p_sf52_rec.to_position_id;
5741: hr_utility.set_location('Valid Family ' || l_proc, 11);
5742: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5743: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5744: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5745: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5746: l_pay_calc_in_rec.pa_request_id := p_sf52_rec.pa_request_id;
5747: l_pay_calc_in_rec.person_id := p_sf52_rec.person_id;
5748: l_pay_calc_in_rec.position_id := p_sf52_rec.to_position_id;
5749: l_pay_calc_in_rec.noa_family_code := p_sf52_rec.noa_family_code;
5802: IF p_sf52_rec.noa_family_code like 'GHR_SAL%' AND
5803: p_sf52_rec.pay_rate_determinant IN ('3','4','J','K','U','V') AND
5804: p_sf52_rec.effective_date >= to_date('01/05/2005','dd/mm/yyyy') THEN
5805: l_pay_calc_in_rec.retention_allowance := p_sf52_rec.to_retention_allowance;
5806: hr_utility.set_location('setting retention - fwfa ' || p_sf52_rec.to_retention_allowance,120);
5807: ELSE
5808: ghr_api.retrieve_element_entry_value
5809: (p_element_name => 'Retention Allowance'
5810: ,p_input_value_name => 'Amount'
5825: l_pay_calc_in_rec.current_basic_pay := p_sf52_rec.from_basic_pay;
5826: l_pay_calc_in_rec.current_adj_basic_pay := p_sf52_rec.from_adj_basic_pay;
5827: l_pay_calc_in_rec.current_step_or_rate := p_sf52_rec.from_step_or_rate;
5828:
5829: hr_utility.set_location('Before Main Pay Calc ' || l_proc, 13);
5830: hr_utility.set_location('Pay Calc In PRD : '||l_pay_calc_in_rec.pay_rate_determinant, 14);
5831:
5832:
5833: ghr_pay_calc.sql_main_pay_calc
5826: l_pay_calc_in_rec.current_adj_basic_pay := p_sf52_rec.from_adj_basic_pay;
5827: l_pay_calc_in_rec.current_step_or_rate := p_sf52_rec.from_step_or_rate;
5828:
5829: hr_utility.set_location('Before Main Pay Calc ' || l_proc, 13);
5830: hr_utility.set_location('Pay Calc In PRD : '||l_pay_calc_in_rec.pay_rate_determinant, 14);
5831:
5832:
5833: ghr_pay_calc.sql_main_pay_calc
5834: ( p_pay_calc_data => l_pay_calc_in_rec,
5836: p_message_set => l_message_set,
5837: p_calculated => l_calculated
5838: );
5839:
5840: hr_utility.set_location('After Main Pay Calc ' || l_proc, 13);
5841: if l_calculated then
5842: hr_utility.set_location('l_Calculated is TRUE ' || l_proc, 13);
5843: else
5844: hr_utility.set_location('l_Calculated is FASLE ' || l_proc, 13);
5838: );
5839:
5840: hr_utility.set_location('After Main Pay Calc ' || l_proc, 13);
5841: if l_calculated then
5842: hr_utility.set_location('l_Calculated is TRUE ' || l_proc, 13);
5843: else
5844: hr_utility.set_location('l_Calculated is FASLE ' || l_proc, 13);
5845: end if;
5846: If not nvl(l_pay_calc_out_rec.open_pay_fields, FALSE) then
5840: hr_utility.set_location('After Main Pay Calc ' || l_proc, 13);
5841: if l_calculated then
5842: hr_utility.set_location('l_Calculated is TRUE ' || l_proc, 13);
5843: else
5844: hr_utility.set_location('l_Calculated is FASLE ' || l_proc, 13);
5845: end if;
5846: If not nvl(l_pay_calc_out_rec.open_pay_fields, FALSE) then
5847: hr_utility.set_location('pay fields not open',1);
5848:
5843: else
5844: hr_utility.set_location('l_Calculated is FASLE ' || l_proc, 13);
5845: end if;
5846: If not nvl(l_pay_calc_out_rec.open_pay_fields, FALSE) then
5847: hr_utility.set_location('pay fields not open',1);
5848:
5849: If l_calculated then
5850: -- assign
5851: hr_utility.set_location( ' Not Custom Pay Calc : ' || l_proc,12);
5847: hr_utility.set_location('pay fields not open',1);
5848:
5849: If l_calculated then
5850: -- assign
5851: hr_utility.set_location( ' Not Custom Pay Calc : ' || l_proc,12);
5852:
5853: p_sf52_rec.custom_pay_calc_flag := 'N';
5854: -- FWFA Changes Bug#4444609
5855: p_sf52_rec.from_pay_table_identifier := l_pay_calc_out_rec.pay_table_id;
5869: g_step_or_rate := l_pay_calc_out_rec.out_step_or_rate;
5870: IF g_prd is NOT NULL THEN
5871: IF l_pay_calc_out_rec.out_step_or_rate IS NOT NULL THEN
5872: IF nvl(g_prd,'0') not in ('A','B','E','F','U','V') THEN
5873: hr_utility.set_location('Inside G_prd condition',10);
5874: p_sf52_rec.to_step_or_rate :=
5875: NVL(l_pay_calc_out_rec.out_step_or_rate, p_sf52_rec.to_step_or_rate);
5876: ----Bug 2914406 fix start
5877: p_sf52_rec.pay_rate_determinant :=
5878: NVL(l_pay_calc_out_rec.out_pay_rate_determinant, p_sf52_rec.pay_rate_determinant);
5879: ----Bug 2914406 fix End
5880: END IF;
5881: ELSE
5882: hr_utility.set_location('Inside G_prd condition and g_step null',10);
5883: p_sf52_rec.pay_rate_determinant :=
5884: NVL(l_pay_calc_out_rec.out_pay_rate_determinant, p_sf52_rec.pay_rate_determinant);
5885: END IF;
5886: ELSE
5883: p_sf52_rec.pay_rate_determinant :=
5884: NVL(l_pay_calc_out_rec.out_pay_rate_determinant, p_sf52_rec.pay_rate_determinant);
5885: END IF;
5886: ELSE
5887: hr_utility.set_location('Inside G_prd NULL condition',10);
5888: -- FWFA Changes Bug#4444609 Modified the value of PRD.
5889: p_sf52_rec.pay_rate_determinant :=
5890: NVL(p_sf52_rec.input_pay_rate_determinant, p_sf52_rec.pay_rate_determinant);
5891: -- FWFA Changes
5893: NVL(l_pay_calc_out_rec.out_step_or_rate, p_sf52_rec.to_step_or_rate);
5894: END IF;
5895: ELSE
5896: -- FWFA Changes Bug#4444609 Modified the value of PRD
5897: hr_utility.set_location('inside NON 894 Actions ',20);
5898: p_sf52_rec.pay_rate_determinant :=
5899: NVL(l_pay_calc_out_rec.out_pay_rate_determinant,
5900: NVL(p_sf52_rec.input_pay_rate_determinant,p_sf52_rec.pay_rate_determinant)
5901: );
5905: END IF;
5906: -- End Processing for bug 2684176
5907: End if;
5908: Elsif l_pay_calc_out_rec.open_pay_fields then
5909: hr_utility.set_location('open pay fields',1);
5910: hr_utility.set_location( 'Error - Pay Calc failed ' || l_proc, 90);
5911: hr_utility.set_message(8301,'GHR_38401_OPEN_PAY');
5912: hr_utility.raise_error;
5913: -- error; -- send back to user
5906: -- End Processing for bug 2684176
5907: End if;
5908: Elsif l_pay_calc_out_rec.open_pay_fields then
5909: hr_utility.set_location('open pay fields',1);
5910: hr_utility.set_location( 'Error - Pay Calc failed ' || l_proc, 90);
5911: hr_utility.set_message(8301,'GHR_38401_OPEN_PAY');
5912: hr_utility.raise_error;
5913: -- error; -- send back to user
5914:
5907: End if;
5908: Elsif l_pay_calc_out_rec.open_pay_fields then
5909: hr_utility.set_location('open pay fields',1);
5910: hr_utility.set_location( 'Error - Pay Calc failed ' || l_proc, 90);
5911: hr_utility.set_message(8301,'GHR_38401_OPEN_PAY');
5912: hr_utility.raise_error;
5913: -- error; -- send back to user
5914:
5915: End if;
5908: Elsif l_pay_calc_out_rec.open_pay_fields then
5909: hr_utility.set_location('open pay fields',1);
5910: hr_utility.set_location( 'Error - Pay Calc failed ' || l_proc, 90);
5911: hr_utility.set_message(8301,'GHR_38401_OPEN_PAY');
5912: hr_utility.raise_error;
5913: -- error; -- send back to user
5914:
5915: End if;
5916: End if;
5917: Elsif nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) = 'OTHER_PAY'
5918: then
5919: -- and (p_sf52_rec.first_noa_code <> '899') and not (p_sf52_rec.first_noa_code = '002' and
5920: -- p_sf52_rec.second_noa_code = '899')
5921: hr_utility.set_location( 'Other Pay Calculation ' || l_proc, 95);
5922: -- fOR OTHER PAY family calculate other_pay_amount and total_pay_amount
5923: p_sf52_rec.to_other_pay_amount := nvl(p_sf52_rec.to_au_overtime , 0) +
5924: nvl(p_sf52_rec.to_availability_pay , 0) +
5925: nvl(p_sf52_rec.to_retention_allowance , 0) +
5931:
5932: End if;
5933: -- VSM temp call
5934: -- Begin Update 34 - Validation Logic
5935: hr_utility.set_location( 'Before calling do_pay_caps_main noa_family_code is ' ||p_sf52_rec.noa_family_code, 95);
5936: ghr_history_api.get_g_session_var( l_session_var);
5937: -- Bug#4486823 RRR Changes. Added GHR_INCENTIVE Family also.
5938: IF not (p_sf52_rec.noa_family_code in
5939: ('POS_REVIEW',
5947: /*BUG 7186053 Commented the below line as it is not required. Code in the if clause should not run for
5948: all the NOA Families mentioned in the condition. */
5949: -- AND l_session_var.noa_id_correct is not NULL) THEN
5950: ) THEN
5951: hr_utility.set_location( 'Before calling do_pay_caps_main ' ||p_capped_other_pay , 95);
5952: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5953:
5954: --BUG # 14032192 passing total salary as addition of adjusted basic pay and other pay
5955: lo_total_salary := p_sf52_rec.to_total_salary;
5948: all the NOA Families mentioned in the condition. */
5949: -- AND l_session_var.noa_id_correct is not NULL) THEN
5950: ) THEN
5951: hr_utility.set_location( 'Before calling do_pay_caps_main ' ||p_capped_other_pay , 95);
5952: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5953:
5954: --BUG # 14032192 passing total salary as addition of adjusted basic pay and other pay
5955: lo_total_salary := p_sf52_rec.to_total_salary;
5956: if nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) <> 'OTHER_PAY' THEN
5967: end if;
5968:
5969: IF p_capped_other_pay <> hr_api.g_number OR
5970: p_capped_other_pay is NULL THEN
5971: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5972:
5973: ghr_pay_caps.do_pay_caps_main (
5974: p_pa_request_id => p_sf52_rec.pa_request_id,
5975: p_effective_date => NVL(p_sf52_rec.effective_date,TRUNC(sysdate)) ,
6006:
6007: l_temp_ret_allo_percentage := trunc((l_temp_retention_allowance/p_sf52_rec.to_basic_pay)*100,2);
6008:
6009: if l_pay_cap_message then
6010: hr_utility.raise_error;
6011: -- This would show the error message with tokens passed with
6012: -- the values from the sub-program called above - do_pay_caps_main.
6013: -- So no need to explicitly again initiate the error message
6014: -- and set of the tokens seperately. Earlier 38893 message was called here.
6021:
6022: -- End Update 34 - Validation Logic
6023: print_sf52('After redo_pay : ' , p_sf52_rec);
6024:
6025: hr_utility.set_location( 'Leaving : ' || l_proc,100);
6026:
6027: EXCEPTION
6028: WHEN others THEN
6029: -- Reset IN OUT parameters and set OUT parameters
6030:
6031: p_capped_other_pay := l_capped_other_pay;
6032: p_sf52_rec := l_sf52_rec ;
6033:
6034: hr_utility.set_location('Leaving ' || l_proc,101);
6035: RAISE;
6036:
6037: End redo_pay_calc;
6038:
6314: -- Reset IN OUT parameters and set OUT parameters
6315:
6316: p_sf52_data := l_sf52_data ;
6317:
6318: hr_utility.set_location('Leaving Update_rfrs_values ' ,160);
6319: RAISE;
6320:
6321: End Update_rfrs_values;
6322:
6567: -- Reset IN OUT parameters and set OUT parameters
6568:
6569: p_result := NULL;
6570:
6571: hr_utility.set_location('Leaving Update_Shadow_row ' ,100);
6572: RAISE;
6573:
6574: end update_shadow_row;
6575:
6575:
6576: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE)
6577: IS
6578: BEGIN
6579: hr_utility.set_location ('-----------------------------------------------', 10);
6580: hr_utility.set_location (p_proc, 20);
6581: hr_utility.set_location ('-----------------------------------------------', 30);
6582: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6583: , 40);
6576: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE)
6577: IS
6578: BEGIN
6579: hr_utility.set_location ('-----------------------------------------------', 10);
6580: hr_utility.set_location (p_proc, 20);
6581: hr_utility.set_location ('-----------------------------------------------', 30);
6582: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6583: , 40);
6584: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6577: IS
6578: BEGIN
6579: hr_utility.set_location ('-----------------------------------------------', 10);
6580: hr_utility.set_location (p_proc, 20);
6581: hr_utility.set_location ('-----------------------------------------------', 30);
6582: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6583: , 40);
6584: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6585: , 50);
6578: BEGIN
6579: hr_utility.set_location ('-----------------------------------------------', 10);
6580: hr_utility.set_location (p_proc, 20);
6581: hr_utility.set_location ('-----------------------------------------------', 30);
6582: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6583: , 40);
6584: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6585: , 50);
6586: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6580: hr_utility.set_location (p_proc, 20);
6581: hr_utility.set_location ('-----------------------------------------------', 30);
6582: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6583: , 40);
6584: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6585: , 50);
6586: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6587: , 60);
6588: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6582: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6583: , 40);
6584: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6585: , 50);
6586: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6587: , 60);
6588: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6589: , 70);
6590: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6584: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6585: , 50);
6586: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6587: , 60);
6588: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6589: , 70);
6590: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6591: , 90);
6592: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6586: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6587: , 60);
6588: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6589: , 70);
6590: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6591: , 90);
6592: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6593: , 100);
6594: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6588: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6589: , 70);
6590: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6591: , 90);
6592: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6593: , 100);
6594: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6595: , 110);
6596: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6590: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6591: , 90);
6592: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6593: , 100);
6594: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6595: , 110);
6596: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6597: , 120);
6598: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6592: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6593: , 100);
6594: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6595: , 110);
6596: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6597: , 120);
6598: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6599: , 130);
6600: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6594: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6595: , 110);
6596: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6597: , 120);
6598: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6599: , 130);
6600: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6601: , 140);
6602: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6596: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6597: , 120);
6598: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6599: , 130);
6600: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6601: , 140);
6602: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6603: , 150);
6604: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6598: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6599: , 130);
6600: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6601: , 140);
6602: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6603: , 150);
6604: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6605: , 160);
6606: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6600: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6601: , 140);
6602: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6603: , 150);
6604: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6605: , 160);
6606: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6607: , 170);
6608: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6602: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6603: , 150);
6604: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6605: , 160);
6606: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6607: , 170);
6608: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6609: , 180);
6610: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6604: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6605: , 160);
6606: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6607: , 170);
6608: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6609: , 180);
6610: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6611: , 190);
6612: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6606: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6607: , 170);
6608: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6609: , 180);
6610: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6611: , 190);
6612: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6613: , 200);
6614: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6608: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6609: , 180);
6610: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6611: , 190);
6612: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6613: , 200);
6614: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6615: , 210);
6616: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6610: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6611: , 190);
6612: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6613: , 200);
6614: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6615: , 210);
6616: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6617: , 220);
6618: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6612: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6613: , 200);
6614: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6615: , 210);
6616: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6617: , 220);
6618: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6619: , 230);
6620: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6614: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6615: , 210);
6616: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6617: , 220);
6618: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6619: , 230);
6620: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6621: , 240);
6622: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6616: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6617: , 220);
6618: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6619: , 230);
6620: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6621: , 240);
6622: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6623: , 250);
6624: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6618: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6619: , 230);
6620: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6621: , 240);
6622: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6623: , 250);
6624: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6625: , 260);
6626: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6620: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6621: , 240);
6622: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6623: , 250);
6624: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6625: , 260);
6626: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6627: , 270);
6628: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6622: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6623: , 250);
6624: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6625: , 260);
6626: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6627: , 270);
6628: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6629: , 280);
6630: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6624: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6625: , 260);
6626: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6627: , 270);
6628: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6629: , 280);
6630: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6631: , 290);
6632: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6626: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6627: , 270);
6628: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6629: , 280);
6630: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6631: , 290);
6632: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6633: , 300);
6634: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6628: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6629: , 280);
6630: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6631: , 290);
6632: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6633: , 300);
6634: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6635: , 310);
6636: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6630: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6631: , 290);
6632: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6633: , 300);
6634: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6635: , 310);
6636: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6637: , 320);
6638: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6632: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6633: , 300);
6634: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6635: , 310);
6636: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6637: , 320);
6638: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6639: , 330);
6640: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6634: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6635: , 310);
6636: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6637: , 320);
6638: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6639: , 330);
6640: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6641: , 340);
6642: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6636: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6637: , 320);
6638: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6639: , 330);
6640: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6641: , 340);
6642: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6643: , 350);
6644: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6638: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6639: , 330);
6640: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6641: , 340);
6642: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6643: , 350);
6644: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6645: , 360);
6646: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6640: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6641: , 340);
6642: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6643: , 350);
6644: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6645: , 360);
6646: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6647: , 370);
6648: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6642: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6643: , 350);
6644: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6645: , 360);
6646: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6647: , 370);
6648: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6649: , 380);
6650: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6644: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6645: , 360);
6646: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6647: , 370);
6648: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6649: , 380);
6650: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6651: , 390);
6652: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6646: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6647: , 370);
6648: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6649: , 380);
6650: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6651: , 390);
6652: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6653: , 400);
6654: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6648: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6649: , 380);
6650: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6651: , 390);
6652: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6653: , 400);
6654: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6655: , 410);
6656: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6650: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6651: , 390);
6652: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6653: , 400);
6654: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6655: , 410);
6656: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6657: , 420);
6658: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6652: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6653: , 400);
6654: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6655: , 410);
6656: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6657: , 420);
6658: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6659: , 430);
6660: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6654: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6655: , 410);
6656: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6657: , 420);
6658: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6659: , 430);
6660: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6661: , 440);
6662: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6656: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6657: , 420);
6658: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6659: , 430);
6660: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6661: , 440);
6662: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6663: , 450);
6664: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6658: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6659: , 430);
6660: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6661: , 440);
6662: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6663: , 450);
6664: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6665: , 460);
6666: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6660: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6661: , 440);
6662: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6663: , 450);
6664: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6665: , 460);
6666: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6667: , 470);
6668: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6662: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6663: , 450);
6664: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6665: , 460);
6666: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6667: , 470);
6668: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6669: , 480);
6670: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6664: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6665: , 460);
6666: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6667: , 470);
6668: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6669: , 480);
6670: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6671: , 490);
6672: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6666: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6667: , 470);
6668: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6669: , 480);
6670: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6671: , 490);
6672: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6673: , 500);
6674: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6668: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6669: , 480);
6670: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6671: , 490);
6672: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6673: , 500);
6674: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6675: , 510);
6676: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6670: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6671: , 490);
6672: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6673: , 500);
6674: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6675: , 510);
6676: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6677: , 520);
6678: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6672: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6673: , 500);
6674: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6675: , 510);
6676: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6677: , 520);
6678: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6679: , 530);
6680: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6674: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6675: , 510);
6676: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6677: , 520);
6678: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6679: , 530);
6680: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6681: , 540);
6682: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6676: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6677: , 520);
6678: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6679: , 530);
6680: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6681: , 540);
6682: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6683: , 550);
6684: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6678: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6679: , 530);
6680: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6681: , 540);
6682: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6683: , 550);
6684: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6685: , 560);
6686: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6680: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6681: , 540);
6682: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6683: , 550);
6684: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6685: , 560);
6686: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6687: , 570);
6688: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6682: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6683: , 550);
6684: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6685: , 560);
6686: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6687: , 570);
6688: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6689: , 580);
6690: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6684: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6685: , 560);
6686: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6687: , 570);
6688: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6689: , 580);
6690: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6691: , 590);
6692: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6686: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6687: , 570);
6688: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6689: , 580);
6690: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6691: , 590);
6692: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6693: , 600);
6694: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6688: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6689: , 580);
6690: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6691: , 590);
6692: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6693: , 600);
6694: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6695: , 610);
6696: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6690: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6691: , 590);
6692: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6693: , 600);
6694: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6695: , 610);
6696: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6697: , 610);
6698: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6692: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6693: , 600);
6694: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6695: , 610);
6696: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6697: , 610);
6698: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6699: , 610);
6700: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6694: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6695: , 610);
6696: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6697: , 610);
6698: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6699: , 610);
6700: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6701: , 610);
6702: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6696: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6697: , 610);
6698: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6699: , 610);
6700: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6701: , 610);
6702: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6703: , 610);
6704: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6698: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6699: , 610);
6700: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6701: , 610);
6702: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6703: , 610);
6704: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6705: , 610);
6706: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6700: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6701: , 610);
6702: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6703: , 610);
6704: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6705: , 610);
6706: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6707: , 610);
6708: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6702: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6703: , 610);
6704: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6705: , 610);
6706: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6707: , 610);
6708: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6709: , 610);
6710: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6704: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6705: , 610);
6706: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6707: , 610);
6708: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6709: , 610);
6710: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6711: , 610);
6712: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6706: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6707: , 610);
6708: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6709: , 610);
6710: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6711: , 610);
6712: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6713: , 710);
6714: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6708: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6709: , 610);
6710: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6711: , 610);
6712: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6713: , 710);
6714: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6715: , 710);
6716: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6710: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6711: , 610);
6712: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6713: , 710);
6714: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6715: , 710);
6716: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6717: --, 710);
6718: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6712: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6713: , 710);
6714: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6715: , 710);
6716: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6717: --, 710);
6718: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6719: , 710);
6720: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6714: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6715: , 710);
6716: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6717: --, 710);
6718: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6719: , 710);
6720: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6721: , 710);
6722: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6716: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6717: --, 710);
6718: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6719: , 710);
6720: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6721: , 710);
6722: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6723: , 710);
6724: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6718: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6719: , 710);
6720: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6721: , 710);
6722: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6723: , 710);
6724: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6725: , 710);
6726: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6720: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6721: , 710);
6722: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6723: , 710);
6724: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6725: , 710);
6726: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6727: , 710);
6728: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6722: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6723: , 710);
6724: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6725: , 710);
6726: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6727: , 710);
6728: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6729: , 710);
6730: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6724: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6725: , 710);
6726: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6727: , 710);
6728: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6729: , 710);
6730: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6731: , 710);
6732: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6726: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6727: , 710);
6728: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6729: , 710);
6730: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6731: , 710);
6732: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6733: , 710);
6734: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6728: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6729: , 710);
6730: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6731: , 710);
6732: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6733: , 710);
6734: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6735: , 710);
6736: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6730: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6731: , 710);
6732: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6733: , 710);
6734: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6735: , 710);
6736: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6737: , 810);
6738: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6732: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6733: , 710);
6734: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6735: , 710);
6736: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6737: , 810);
6738: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6739: , 810);
6740: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6734: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6735: , 710);
6736: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6737: , 810);
6738: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6739: , 810);
6740: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6741: , 810);
6742: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6736: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6737: , 810);
6738: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6739: , 810);
6740: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6741: , 810);
6742: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6743: , 810);
6744: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6738: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6739: , 810);
6740: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6741: , 810);
6742: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6743: , 810);
6744: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6745: , 810); -- Bug 3659193 Added Substr for Notepad.
6746: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6740: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6741: , 810);
6742: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6743: , 810);
6744: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6745: , 810); -- Bug 3659193 Added Substr for Notepad.
6746: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6747: , 810);
6748: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6742: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6743: , 810);
6744: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6745: , 810); -- Bug 3659193 Added Substr for Notepad.
6746: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6747: , 810);
6748: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6749: , 810);
6750: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6744: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6745: , 810); -- Bug 3659193 Added Substr for Notepad.
6746: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6747: , 810);
6748: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6749: , 810);
6750: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6751: , 810);
6752: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6746: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6747: , 810);
6748: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6749: , 810);
6750: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6751: , 810);
6752: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6753: , 810);
6754: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6748: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6749: , 810);
6750: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6751: , 810);
6752: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6753: , 810);
6754: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6755: , 810);
6756: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6750: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6751: , 810);
6752: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6753: , 810);
6754: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6755: , 810);
6756: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6757: , 810);
6758: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6752: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6753: , 810);
6754: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6755: , 810);
6756: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6757: , 810);
6758: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6759: , 810);
6760: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6754: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6755: , 810);
6756: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6757: , 810);
6758: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6759: , 810);
6760: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6761: , 810);
6762: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6756: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6757: , 810);
6758: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6759: , 810);
6760: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6761: , 810);
6762: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6763: , 910);
6764: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6758: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6759: , 810);
6760: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6761: , 810);
6762: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6763: , 910);
6764: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6765: , 910);
6766: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6760: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6761: , 810);
6762: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6763: , 910);
6764: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6765: , 910);
6766: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6767: , 910);
6768: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6762: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6763: , 910);
6764: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6765: , 910);
6766: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6767: , 910);
6768: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6769: , 910); -- Bug 3381432 added 'substr'
6770: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6764: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6765: , 910);
6766: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6767: , 910);
6768: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6769: , 910); -- Bug 3381432 added 'substr'
6770: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6771: , 910);
6772: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6766: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6767: , 910);
6768: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6769: , 910); -- Bug 3381432 added 'substr'
6770: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6771: , 910);
6772: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6773: , 910);
6774: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6768: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6769: , 910); -- Bug 3381432 added 'substr'
6770: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6771: , 910);
6772: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6773: , 910);
6774: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6775: , 910); -- Bug 3381432 added 'substr'
6776: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6770: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6771: , 910);
6772: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6773: , 910);
6774: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6775: , 910); -- Bug 3381432 added 'substr'
6776: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6777: , 910);
6778: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6772: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6773: , 910);
6774: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6775: , 910); -- Bug 3381432 added 'substr'
6776: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6777: , 910);
6778: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6779: , 910); -- Bug 3381432 added 'substr'
6780: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6774: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6775: , 910); -- Bug 3381432 added 'substr'
6776: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6777: , 910);
6778: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6779: , 910); -- Bug 3381432 added 'substr'
6780: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6781: , 910);
6782: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6776: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6777: , 910);
6778: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6779: , 910); -- Bug 3381432 added 'substr'
6780: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6781: , 910);
6782: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6783: , 910);
6784: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6778: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6779: , 910); -- Bug 3381432 added 'substr'
6780: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6781: , 910);
6782: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6783: , 910);
6784: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6785: , 1010);
6786: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6780: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6781: , 910);
6782: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6783: , 910);
6784: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6785: , 1010);
6786: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6787: , 1010);
6788: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6782: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6783: , 910);
6784: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6785: , 1010);
6786: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6787: , 1010);
6788: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6789: , 1010);
6790: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6784: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6785: , 1010);
6786: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6787: , 1010);
6788: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6789: , 1010);
6790: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6791: , 1010);
6792: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6786: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6787: , 1010);
6788: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6789: , 1010);
6790: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6791: , 1010);
6792: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6793: , 1010);
6794: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6788: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6789: , 1010);
6790: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6791: , 1010);
6792: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6793: , 1010);
6794: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6795: , 1010);
6796: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6790: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6791: , 1010);
6792: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6793: , 1010);
6794: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6795: , 1010);
6796: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6797: , 1010);
6798: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6792: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6793: , 1010);
6794: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6795: , 1010);
6796: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6797: , 1010);
6798: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6799: , 1010);
6800: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6794: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6795: , 1010);
6796: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6797: , 1010);
6798: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6799: , 1010);
6800: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6801: , 1010);
6802: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6796: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6797: , 1010);
6798: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6799: , 1010);
6800: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6801: , 1010);
6802: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6803: , 1010);
6804: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6798: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6799: , 1010);
6800: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6801: , 1010);
6802: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6803: , 1010);
6804: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6805: , 1010);
6806: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6800: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6801: , 1010);
6802: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6803: , 1010);
6804: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6805: , 1010);
6806: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6807: , 1010);
6808: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6802: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6803: , 1010);
6804: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6805: , 1010);
6806: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6807: , 1010);
6808: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6809: , 1010);
6810: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6804: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6805: , 1010);
6806: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6807: , 1010);
6808: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6809: , 1010);
6810: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6811: , 1010);
6812: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6806: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6807: , 1010);
6808: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6809: , 1010);
6810: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6811: , 1010);
6812: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6813: , 1010);
6814: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6808: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6809: , 1010);
6810: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6811: , 1010);
6812: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6813: , 1010);
6814: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6815: , 1010);
6816: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6810: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6811: , 1010);
6812: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6813: , 1010);
6814: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6815: , 1010);
6816: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6817: , 1010);
6818: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6812: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6813: , 1010);
6814: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6815: , 1010);
6816: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6817: , 1010);
6818: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6819: , 1010);
6820: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6814: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6815: , 1010);
6816: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6817: , 1010);
6818: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6819: , 1010);
6820: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6821: , 1010);
6822: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6816: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6817: , 1010);
6818: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6819: , 1010);
6820: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6821: , 1010);
6822: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6823: , 1010);
6824: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6818: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6819: , 1010);
6820: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6821: , 1010);
6822: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6823: , 1010);
6824: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6825: , 1010);
6826: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6820: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6821: , 1010);
6822: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6823: , 1010);
6824: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6825: , 1010);
6826: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6827: , 1010);
6828: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6822: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6823: , 1010);
6824: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6825: , 1010);
6826: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6827: , 1010);
6828: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6829: , 1010);
6830: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6824: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6825: , 1010);
6826: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6827: , 1010);
6828: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6829: , 1010);
6830: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6831: , 1010);
6832: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6826: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6827: , 1010);
6828: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6829: , 1010);
6830: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6831: , 1010);
6832: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6833: , 1010);
6834: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6828: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6829: , 1010);
6830: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6831: , 1010);
6832: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6833: , 1010);
6834: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6835: , 1010);
6836: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6830: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6831: , 1010);
6832: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6833: , 1010);
6834: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6835: , 1010);
6836: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6837: --, 1010);
6838: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6832: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6833: , 1010);
6834: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6835: , 1010);
6836: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6837: --, 1010);
6838: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6839: --, 1010);
6840: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6834: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6835: , 1010);
6836: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6837: --, 1010);
6838: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6839: --, 1010);
6840: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6841: , 1010);
6842: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6836: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6837: --, 1010);
6838: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6839: --, 1010);
6840: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6841: , 1010);
6842: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6843: , 1010);
6844: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6838: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6839: --, 1010);
6840: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6841: , 1010);
6842: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6843: , 1010);
6844: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6845: , 1010);
6846: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6840: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6841: , 1010);
6842: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6843: , 1010);
6844: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6845: , 1010);
6846: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6847: , 1010);
6848: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6842: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6843: , 1010);
6844: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6845: , 1010);
6846: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6847: , 1010);
6848: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6849: , 1010);
6850: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6844: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6845: , 1010);
6846: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6847: , 1010);
6848: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6849: , 1010);
6850: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6851: , 1010);
6852: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6846: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6847: , 1010);
6848: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6849: , 1010);
6850: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6851: , 1010);
6852: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6853: , 1010);
6854: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6848: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6849: , 1010);
6850: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6851: , 1010);
6852: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6853: , 1010);
6854: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6855: , 1010);
6856: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6850: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6851: , 1010);
6852: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6853: , 1010);
6854: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6855: , 1010);
6856: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6857: , 1010);
6858: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6852: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6853: , 1010);
6854: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6855: , 1010);
6856: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6857: , 1010);
6858: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6859: , 1010);
6860: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6854: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6855: , 1010);
6856: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6857: , 1010);
6858: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6859: , 1010);
6860: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6861: , 1010);
6862: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6856: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6857: , 1010);
6858: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6859: , 1010);
6860: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6861: , 1010);
6862: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6863: , 1010);
6864: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6858: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6859: , 1010);
6860: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6861: , 1010);
6862: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6863: , 1010);
6864: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6865: , 1010);
6866: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6860: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6861: , 1010);
6862: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6863: , 1010);
6864: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6865: , 1010);
6866: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6867: , 1010);
6868: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6862: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6863: , 1010);
6864: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6865: , 1010);
6866: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6867: , 1010);
6868: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6869: , 1010);
6870: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6864: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6865: , 1010);
6866: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6867: , 1010);
6868: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6869: , 1010);
6870: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6871: , 1010);
6872: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6866: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6867: , 1010);
6868: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6869: , 1010);
6870: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6871: , 1010);
6872: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6873: , 1010);
6874: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6868: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6869: , 1010);
6870: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6871: , 1010);
6872: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6873: , 1010);
6874: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6875: , 1010);
6876: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6870: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6871: , 1010);
6872: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6873: , 1010);
6874: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6875: , 1010);
6876: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6877: , 1010);
6878: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6872: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6873: , 1010);
6874: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6875: , 1010);
6876: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6877: , 1010);
6878: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6879: , 1010);
6880: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6874: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6875: , 1010);
6876: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6877: , 1010);
6878: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6879: , 1010);
6880: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6881: , 1010);
6882: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6876: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6877: , 1010);
6878: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6879: , 1010);
6880: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6881: , 1010);
6882: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6883: , 1010);
6884: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6878: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6879: , 1010);
6880: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6881: , 1010);
6882: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6883: , 1010);
6884: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6885: , 1010);
6886: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6880: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6881: , 1010);
6882: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6883: , 1010);
6884: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6885: , 1010);
6886: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6887: , 1010);
6888: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6882: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6883: , 1010);
6884: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6885: , 1010);
6886: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6887: , 1010);
6888: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6889: , 1010);
6890: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6884: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6885: , 1010);
6886: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6887: , 1010);
6888: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6889: , 1010);
6890: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6891: , 1010);
6892: hr_utility.set_location(p_proc||'.payment option: '||p_pa_request_rec.pa_incentive_payment_option
6886: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6887: , 1010);
6888: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6889: , 1010);
6890: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6891: , 1010);
6892: hr_utility.set_location(p_proc||'.payment option: '||p_pa_request_rec.pa_incentive_payment_option
6893: , 1010);
6894: hr_utility.set_location(p_proc||'.award salary '||p_pa_request_rec.award_salary
6888: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6889: , 1010);
6890: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6891: , 1010);
6892: hr_utility.set_location(p_proc||'.payment option: '||p_pa_request_rec.pa_incentive_payment_option
6893: , 1010);
6894: hr_utility.set_location(p_proc||'.award salary '||p_pa_request_rec.award_salary
6895: , 1010);
6896:
6890: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6891: , 1010);
6892: hr_utility.set_location(p_proc||'.payment option: '||p_pa_request_rec.pa_incentive_payment_option
6893: , 1010);
6894: hr_utility.set_location(p_proc||'.award salary '||p_pa_request_rec.award_salary
6895: , 1010);
6896:
6897: END print_sf52;
6898:
6979: l_which_noa := 1;
6980: l_dual_noa_id := p_first_noa_id;
6981: end if;
6982: l_ovn := p_ovn;
6983: hr_utility.set_location('l_ovn'||l_ovn,1);
6984: l_pa_request_id := ghr_approved_pa_requests.ghr_cancel_sf52(
6985: p_pa_request_id => p_pa_request_id
6986: , p_par_object_version_number => l_ovn
6987: , p_noa_id => l_dual_noa_id
7064: -- 8737212 Updating Routing History
7065:
7066:
7067: if p_sf52_data.second_noa_code = p_second_noa_code then
7068: hr_utility.set_location('before first process',1000);
7069: ghr_corr_canc_sf52.cancel_routine(p_sf52_data);
7070: hr_utility.set_location('before sec process'||l_sf52_dual_sec_rec.first_noa_id,1001);
7071: hr_utility.set_location('before sec process'||l_sf52_dual_sec_rec.second_noa_id,1002);
7072: ghr_corr_canc_sf52.cancel_routine(l_sf52_dual_sec_rec);
7066:
7067: if p_sf52_data.second_noa_code = p_second_noa_code then
7068: hr_utility.set_location('before first process',1000);
7069: ghr_corr_canc_sf52.cancel_routine(p_sf52_data);
7070: hr_utility.set_location('before sec process'||l_sf52_dual_sec_rec.first_noa_id,1001);
7071: hr_utility.set_location('before sec process'||l_sf52_dual_sec_rec.second_noa_id,1002);
7072: ghr_corr_canc_sf52.cancel_routine(l_sf52_dual_sec_rec);
7073: elsif p_sf52_data.second_noa_code = p_first_noa_code then
7074: ghr_corr_canc_sf52.cancel_routine(l_sf52_dual_sec_rec);
7067: if p_sf52_data.second_noa_code = p_second_noa_code then
7068: hr_utility.set_location('before first process',1000);
7069: ghr_corr_canc_sf52.cancel_routine(p_sf52_data);
7070: hr_utility.set_location('before sec process'||l_sf52_dual_sec_rec.first_noa_id,1001);
7071: hr_utility.set_location('before sec process'||l_sf52_dual_sec_rec.second_noa_id,1002);
7072: ghr_corr_canc_sf52.cancel_routine(l_sf52_dual_sec_rec);
7073: elsif p_sf52_data.second_noa_code = p_first_noa_code then
7074: ghr_corr_canc_sf52.cancel_routine(l_sf52_dual_sec_rec);
7075: ghr_corr_canc_sf52.cancel_routine(p_sf52_data);
7084: close c_dual_first;
7085:
7086: ghr_history_api.reinit_g_session_var;
7087:
7088: hr_utility.set_location('l_sf52_dual_sec_rec.from_position_id'||l_sf52_dual_sec_rec.from_position_id,10);
7089: hr_utility.set_location('l_sf52_dual_sec_rec.to_position_id'||l_sf52_dual_sec_rec.to_position_id,11);
7090: ghr_sf52_post_update.get_notification_details
7091: (p_pa_request_id => l_sf52_dual_sec_rec.pa_request_id,
7092: p_effective_date => l_sf52_dual_sec_rec.effective_date,
7085:
7086: ghr_history_api.reinit_g_session_var;
7087:
7088: hr_utility.set_location('l_sf52_dual_sec_rec.from_position_id'||l_sf52_dual_sec_rec.from_position_id,10);
7089: hr_utility.set_location('l_sf52_dual_sec_rec.to_position_id'||l_sf52_dual_sec_rec.to_position_id,11);
7090: ghr_sf52_post_update.get_notification_details
7091: (p_pa_request_id => l_sf52_dual_sec_rec.pa_request_id,
7092: p_effective_date => l_sf52_dual_sec_rec.effective_date,
7093: -- p_object_version_number => p_imm_pa_request_rec.object_version_number,