[Home] [Help]
86: Begin
87:
88: l_sf52_data := p_sf52_data ; --NOCOPY Changes
89:
90: hr_utility.set_location(' Entering : ' || l_proc, 10);
91: hr_utility.set_location(' Payment Option ' || p_sf52_data.pa_incentive_payment_option, 15);
92:
93: -- set global to disable checks that disallow changes to core data.
94: -- This is also set back to false when exiting this procedure.
87:
88: l_sf52_data := p_sf52_data ; --NOCOPY Changes
89:
90: hr_utility.set_location(' Entering : ' || l_proc, 10);
91: hr_utility.set_location(' Payment Option ' || p_sf52_data.pa_incentive_payment_option, 15);
92:
93: -- set global to disable checks that disallow changes to core data.
94: -- This is also set back to false when exiting this procedure.
95: ghr_api.g_api_dml := TRUE;
101: savepoint process_SF52;
102:
103: if p_sf52_data.first_noa_code = '001' then
104: -- Cancellation
105: hr_utility.set_location('First LAC CODE is : ' ||p_sf52_data.first_action_la_code1, 11);
106: if p_sf52_data.first_action_la_code1 is null then
107: hr_utility.set_message(8301 , 'GHR_38031_FIRST_LAC_NOT_EXIST');
108: hr_utility.raise_error;
109: end if;
103: if p_sf52_data.first_noa_code = '001' then
104: -- Cancellation
105: hr_utility.set_location('First LAC CODE is : ' ||p_sf52_data.first_action_la_code1, 11);
106: if p_sf52_data.first_action_la_code1 is null then
107: hr_utility.set_message(8301 , 'GHR_38031_FIRST_LAC_NOT_EXIST');
108: hr_utility.raise_error;
109: end if;
110: ghr_corr_canc_sf52.cancel_routine(p_sf52_data);
111:
104: -- Cancellation
105: hr_utility.set_location('First LAC CODE is : ' ||p_sf52_data.first_action_la_code1, 11);
106: if p_sf52_data.first_action_la_code1 is null then
107: hr_utility.set_message(8301 , 'GHR_38031_FIRST_LAC_NOT_EXIST');
108: hr_utility.raise_error;
109: end if;
110: ghr_corr_canc_sf52.cancel_routine(p_sf52_data);
111:
112: elsif p_sf52_data.first_noa_code = '002' then
121: p_process_type => p_process_type);
122: elsif p_sf52_data.first_noa_code is not null and
123: p_sf52_data.second_noa_code is null then
124: -- Single action
125: hr_utility.set_location('Bef call single action Payment Option ' || p_sf52_data.pa_incentive_payment_option, 20);
126: Single_action_SF52 ( p_sf52_data => p_sf52_data,
127: p_process_type => p_process_type,
128: p_capped_other_pay => p_capped_other_pay);
129: else
126: Single_action_SF52 ( p_sf52_data => p_sf52_data,
127: p_process_type => p_process_type,
128: p_capped_other_pay => p_capped_other_pay);
129: else
130: hr_utility.set_message(8301,'GHR_38222_UNKNOWN_NOA');
131: ghr_api.g_api_dml := FALSE;
132: hr_utility.raise_error;
133: -- raise error.
134: end if;
128: p_capped_other_pay => p_capped_other_pay);
129: else
130: hr_utility.set_message(8301,'GHR_38222_UNKNOWN_NOA');
131: ghr_api.g_api_dml := FALSE;
132: hr_utility.raise_error;
133: -- raise error.
134: end if;
135: -- if validate only mode, then rollback.
136: if p_validate then
151: End if;
152:
153: ghr_history_api.reinit_g_session_var;
154: ghr_api.g_api_dml := FALSE;
155: hr_utility.set_location(' Leaving : ' || l_proc, 200);
156:
157: EXCEPTION
158: WHEN others THEN
159: -- Reset IN OUT parameters and set OUT parameters
159: -- Reset IN OUT parameters and set OUT parameters
160:
161: p_sf52_data := l_sf52_data ;
162:
163: hr_utility.set_location('Leaving ' || l_proc,60);
164: RAISE;
165: End;
166:
167: -- |--------------------------< single_action_sf52>---------------------------|
200: l_capped_other_pay number;
201:
202: Begin
203: l_sf52_data := p_sf52_data ; --NOCOPY Changes
204: hr_utility.set_location(' Entering : ' || l_proc, 10);
205: hr_utility.set_location('Inside single action Payment Option ' || p_sf52_data.pa_incentive_payment_option, 20);
206: -- reinitialise session variables
207: ghr_history_api.reinit_g_session_var;
208: -- set values of session variables
201:
202: Begin
203: l_sf52_data := p_sf52_data ; --NOCOPY Changes
204: hr_utility.set_location(' Entering : ' || l_proc, 10);
205: hr_utility.set_location('Inside single action Payment Option ' || p_sf52_data.pa_incentive_payment_option, 20);
206: -- reinitialise session variables
207: ghr_history_api.reinit_g_session_var;
208: -- set values of session variables
209: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
269: -- Check if atleast the min. required items exist in the pa_request
270: ghr_sf52_validn_pkg.prelim_req_chk_for_update_hr
271: (p_pa_request_rec => p_sf52_data
272: );
273: hr_utility.set_location('Bef call main Payment Option ' || l_sf52_data.pa_incentive_payment_option, 20);
274: ghr_sf52_update.main( p_pa_request_rec => l_sf52_data,
275: p_pa_request_ei_rec => l_sf52_ei_data,
276: p_generic_ei_rec => l_agency_ei_data,
277: p_capped_other_pay => l_capped_other_pay);
285: ghr_sf52_update.main( p_pa_request_rec => l_sf52_data,
286: p_pa_request_ei_rec => l_sf52_ei_data,
287: p_generic_ei_rec => l_agency_ei_data,
288: p_capped_other_pay => l_capped_other_pay);
289: hr_utility.set_location( 'Before Call to Post_sf52_process ' || l_proc , 90);
290:
291:
292: ghr_sf52_post_update.Post_sf52_process(
293: p_pa_request_id => l_sf52_data.pa_request_id,
297: p_to_position_id => l_sf52_data.to_position_id,
298: p_agency_code => l_sf52_data.agency_code,
299: p_sf52_data_result => l_sf52_data
300: );
301: hr_utility.set_location( 'After Call to Post_sf52_process ' || l_proc , 90);
302:
303: end if;
304:
305: Update_rfrs_values( p_sf52_data => l_sf52_data,
303: end if;
304:
305: Update_rfrs_values( p_sf52_data => l_sf52_data,
306: p_shadow_data => l_shadow_data);
307: hr_utility.set_location( 'Leaving : ' || l_proc , 100);
308:
309: EXCEPTION
310: WHEN others THEN
311: -- Reset IN OUT parameters and set OUT parameters
311: -- Reset IN OUT parameters and set OUT parameters
312:
313: p_sf52_data := l_sf52_data ;
314:
315: hr_utility.set_location('Leaving ' || l_proc,60);
316: RAISE;
317:
318: End Single_Action_SF52;
319:
352: Begin
353:
354: l_sf52_data := p_sf52_data ; --NOCOPY Changes
355:
356: hr_utility.set_location(' Entering : ' || l_proc, 10);
357: -- reinitialise session variables
358: ghr_history_api.reinit_g_session_var;
359: -- set values of session variables
360: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
429: p_pa_request_ei_rec => l_sf52_ei_data,
430: p_generic_ei_rec => l_agency_ei_data,
431: p_capped_other_pay => l_capped_other_pay);
432:
433: hr_utility.set_location(' l_sf52_data.employee_assignment_id is : ' || l_sf52_data.employee_assignment_id, 11);
434: -- Process 2nd NOA
435: l_new_assignment_id := l_sf52_data.employee_assignment_id;
436: l_sf52_data := p_sf52_data;
437: -- Bug# 1234846-- Venkat --
468: p_noa_id => p_sf52_data.second_noa_id,
469: p_sf52_ei_data => l_sf52_ei_data,
470: p_result => l_result);
471:
472: hr_utility.set_location(l_proc, 30);
473:
474: -- Check if atleast the min. required items exist in the pa_request
475: ghr_sf52_validn_pkg.prelim_req_chk_for_update_hr
476: (p_pa_request_rec => p_sf52_data
480: p_pa_request_ei_rec => l_sf52_ei_data,
481: p_generic_ei_rec => l_agency_ei_data,
482: p_capped_other_pay => l_capped_other_pay);
483:
484: hr_utility.set_location( l_proc , 60);
485: if l_session_var.date_effective > l_today then
486: rollback to dual_action_sf52;
487: else
488: hr_utility.set_location( l_proc , 60);
484: hr_utility.set_location( l_proc , 60);
485: if l_session_var.date_effective > l_today then
486: rollback to dual_action_sf52;
487: else
488: hr_utility.set_location( l_proc , 60);
489: ghr_sf52_post_update.Post_sf52_process(
490: p_pa_request_id => p_sf52_data.pa_request_id,
491: p_effective_date => l_session_var.date_effective,
492: p_object_version_number => p_sf52_data.object_version_number,
494: p_to_position_id => p_sf52_data.to_position_id,
495: p_agency_code => p_sf52_data.agency_code,
496: p_sf52_data_result => l_sf52_data);
497: end if;
498: hr_utility.set_location( l_proc, 125);
499:
500: Update_rfrs_values( p_sf52_data => l_sf52_data_save,
501: p_shadow_data => l_shadow_data);
502:
499:
500: Update_rfrs_values( p_sf52_data => l_sf52_data_save,
501: p_shadow_data => l_shadow_data);
502:
503: hr_utility.set_location( 'Leaving : ' || l_proc , 100);
504:
505: EXCEPTION
506: WHEN others THEN
507: -- Reset IN OUT parameters and set OUT parameters
507: -- Reset IN OUT parameters and set OUT parameters
508:
509: p_sf52_data := l_sf52_data ;
510:
511: hr_utility.set_location('Leaving ' || l_proc,60);
512: RAISE;
513:
514: end;
515:
546: and pit.information_type <> 'GHR_US_PAR_GEN_AGENCY_DATA'
547: and pit.information_type like 'GHR_US%';
548: -- Bug No 570303 added restriction to only look at 'our' info types
549: Begin
550: hr_utility.set_location(l_proc,10);
551: l_information_type := null;
552: for info_type in cur_info_type
553: loop
554: l_information_type := info_type.information_type;
590: information_type = cp_info_type;
591:
592: l_proc varchar2(30):='fetch_Extra_info';
593: Begin
594: hr_utility.set_location('entering : ' || l_proc, 10);
595: if NOT p_agency_ei then
596: l_info_type := get_information_type(p_noa_id => p_noa_id);
597: else
598: l_info_type := 'GHR_US_PAR_GEN_AGENCY_DATA';
606: end if;
607: close c_req_ei;
608: end if;
609:
610: hr_utility.set_location( 'Leaving : ' || l_proc, 50);
611:
612: EXCEPTION
613: WHEN others THEN
614: -- Reset IN OUT parameters and set OUT parameters
615:
616: p_sf52_ei_data := NULL ;
617: p_result := NULL ;
618:
619: hr_utility.set_location('Leaving ' || l_proc,60);
620: RAISE;
621: End;
622:
623: -- |--------------------------< assign_new_rg>--------------------------------|
724: l_fld_names_tab fld_names_typ;
725: BEGIN
726: l_fld_names_tab := p_fld_names_tab;
727: l_column_count := 0;
728: hr_utility.set_location('Entering:'|| l_proc, 5);
729: -- populate the local table with the form_field_names for this noa.
730: FOR curflds_rec in cur_flds(p_noa_id) LOOP
731: l_column_count := l_column_count + 1;
732: p_fld_names_tab(l_column_count) := curflds_rec;
730: FOR curflds_rec in cur_flds(p_noa_id) LOOP
731: l_column_count := l_column_count + 1;
732: p_fld_names_tab(l_column_count) := curflds_rec;
733: END LOOP;
734: hr_utility.set_location('Leaving:'|| l_proc, 10);
735: EXCEPTION
736: WHEN OTHERS THEN
737: -- NOCOPY CHANGES
738: p_fld_names_tab := l_fld_names_tab;
754: p_sf52_data IN ghr_pa_requests%rowtype) RETURN varchar2 IS
755: l_proc varchar2(30):='get_field_info';
756: l_ret_value varchar2(2000);
757: BEGIN
758: hr_utility.set_location('Entering: ' ||l_proc, 10);
759: if (lower(p_field_name) = 'pa_request_id') then
760: l_ret_value := p_sf52_data.pa_request_id;
761:
762: elsif (lower(p_field_name) = 'pa_notification_id') then
1488:
1489: elsif (lower(p_field_name) = 'attribute20') then
1490: l_ret_value := p_sf52_data.attribute20;
1491: end if;
1492: hr_utility.set_location('Leaving: ' ||l_proc, 20);
1493: return l_ret_value;
1494: END;
1495:
1496: Procedure copy_to_new_rg_shared(
1516: Begin
1517:
1518: l_to_field := p_to_field; --NOCOPY Changes
1519:
1520: hr_utility.set_location('Entering:'|| l_proc, 5);
1521: -- initialize l_fld_names_tab1 with proc_methods for first noa.
1522: FOR l_count IN 1..l_column_count1 LOOP
1523: if p_field_name = l_fld_names_tab1(l_count).form_field_name then
1524: l_count1 := l_count;
1602: elsif (LOWER(l_dual_actions.first_noa_proc_method) = 'ue') then
1603: NULL;
1604: else
1605: close get_dual_action;
1606: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');
1607: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1608: hr_utility.raise_error;
1609: end if;
1610: close get_dual_action;
1603: NULL;
1604: else
1605: close get_dual_action;
1606: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');
1607: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1608: hr_utility.raise_error;
1609: end if;
1610: close get_dual_action;
1611: else
1604: else
1605: close get_dual_action;
1606: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');
1607: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1608: hr_utility.raise_error;
1609: end if;
1610: close get_dual_action;
1611: else
1612: open get_dual_action( p_noa_family_code => l_noa_family_code,
1640: null;
1641: else
1642: -- unsupported type. Throw error.
1643: close get_dual_action;
1644: hr_utility.set_message(8301, 'GHR_38498_UNSUPPORTED_ACT_TYP');
1645: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1646: hr_utility.raise_error;
1647: end if;
1648: close get_dual_action;
1641: else
1642: -- unsupported type. Throw error.
1643: close get_dual_action;
1644: hr_utility.set_message(8301, 'GHR_38498_UNSUPPORTED_ACT_TYP');
1645: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1646: hr_utility.raise_error;
1647: end if;
1648: close get_dual_action;
1649: end if;
1642: -- unsupported type. Throw error.
1643: close get_dual_action;
1644: hr_utility.set_message(8301, 'GHR_38498_UNSUPPORTED_ACT_TYP');
1645: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1646: hr_utility.raise_error;
1647: end if;
1648: close get_dual_action;
1649: end if;
1650: end if;
1666: l_pa_req_ref.from_position_id := l_pa_req.from_position_id;
1667: -- if this is a return_to_duty first action, then set to_position = from_position
1668: -- for refresh call. return_to_duty first actions always put to_position info
1669: -- with the 2nd action.
1670: hr_utility.set_location('noa_family_code: ' || l_noa_family_code, 99999);
1671: if (p_pa_req.noa_family_code = 'RETURN_TO_DUTY') then
1672: l_pa_req_ref.to_position_id := l_pa_req.from_position_id;
1673: else
1674: l_pa_req_ref.to_position_id := l_pa_req.to_position_id;
1728: -- do nothing, pass it along as is.
1729: null;
1730: else
1731: close get_dual_action;
1732: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1733: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1734: hr_utility.raise_error;
1735: end if;
1736: close get_dual_action;
1729: null;
1730: else
1731: close get_dual_action;
1732: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1733: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1734: hr_utility.raise_error;
1735: end if;
1736: close get_dual_action;
1737: else
1730: else
1731: close get_dual_action;
1732: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1733: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1734: hr_utility.raise_error;
1735: end if;
1736: close get_dual_action;
1737: else
1738: open get_dual_action( p_noa_family_code => l_noa_family_code,
1743: null;
1744: else
1745: -- unsupported type. Throw error.
1746: close get_dual_action;
1747: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1748: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1749: hr_utility.raise_error;
1750: end if;
1751: close get_dual_action;
1744: else
1745: -- unsupported type. Throw error.
1746: close get_dual_action;
1747: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1748: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1749: hr_utility.raise_error;
1750: end if;
1751: close get_dual_action;
1752: end if;
1745: -- unsupported type. Throw error.
1746: close get_dual_action;
1747: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1748: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1749: hr_utility.raise_error;
1750: end if;
1751: close get_dual_action;
1752: end if;
1753: end if;
1798: end if;
1799: end if;
1800:
1801: if (l_correction = true) then
1802: hr_utility.set_location('l_refresh_called_2' || l_proc,9165);
1803: l_to_field := get_field_info( p_field_name => nvl(p_fld_nm_copy_from,p_field_name),
1804: p_sf52_data => l_pa_req_ref2);
1805: -- only assign to p_to_field if it is not null. If it is null, then refresh didn't populate
1806: -- it, so we need to retain the original value.
1857: end if;
1858: end if;
1859:
1860: if (l_correction = true) then
1861: hr_utility.set_location('l_refresh_called_2' || l_proc,9165);
1862: l_to_field := get_field_info( p_field_name => nvl(p_fld_nm_copy_from,p_field_name),
1863: p_sf52_data => l_pa_req_ref2);
1864: -- only assign to p_to_field if it is not null. If it is null, then refresh didn't populate
1865: -- it, so we need to retain the original value.
1885: null;
1886: end if;
1887: end if;
1888:
1889: hr_utility.set_location(' Return Value :' || p_to_field || '+++', 199);
1890: hr_utility.set_location('Leaving:'|| l_proc, 200);
1891:
1892: EXCEPTION
1893: WHEN others THEN
1886: end if;
1887: end if;
1888:
1889: hr_utility.set_location(' Return Value :' || p_to_field || '+++', 199);
1890: hr_utility.set_location('Leaving:'|| l_proc, 200);
1891:
1892: EXCEPTION
1893: WHEN others THEN
1894: -- Reset IN OUT parameters and set OUT parameters
1894: -- Reset IN OUT parameters and set OUT parameters
1895:
1896: p_to_field := l_to_field;
1897:
1898: hr_utility.set_location('Leaving ' || l_proc,55);
1899: RAISE;
1900:
1901: END copy_to_new_rg_shared;
1902:
1913:
1914: BEGIN
1915: l_to_field := p_to_field; --NOCOPY Changes
1916:
1917: hr_utility.set_location('Entering: ' || l_proc, 5);
1918: l_from_char := to_char(p_from_field,'DDMMYYYY');
1919: l_to_char := to_char(p_to_field,'DDMMYYYY');
1920: copy_to_new_rg_shared( p_action_num => p_action_num,
1921: p_field_name => p_field_name,
1923: p_to_field => l_to_char,
1924: p_fld_nm_copy_from => p_fld_nm_copy_from);
1925:
1926: p_to_field := to_date(l_to_char,'DDMMYYYY');
1927: hr_utility.set_location('Leaving: ' || l_proc, 35);
1928:
1929:
1930: EXCEPTION
1931: WHEN others THEN
1932: -- Reset IN OUT parameters and set OUT parameters
1933:
1934: p_to_field := l_to_field;
1935:
1936: hr_utility.set_location('Leaving ' || l_proc,50);
1937: RAISE;
1938:
1939: END;
1940:
1948: l_proc varchar2(30):= 'copy_to_new_rg(char)';
1949: l_to_field VARCHAR2(2000);
1950: BEGIN
1951: l_to_field := p_to_field; --NOCOPY Changes
1952: hr_utility.set_location('Entering: ' || l_proc, 5);
1953: copy_to_new_rg_shared( p_action_num => p_action_num,
1954: p_field_name => p_field_name,
1955: p_from_field => p_from_field,
1956: p_to_field => p_to_field,
1955: p_from_field => p_from_field,
1956: p_to_field => p_to_field,
1957: p_fld_nm_copy_from => p_fld_nm_copy_from);
1958:
1959: hr_utility.set_location('Leaving: ' || l_proc, 10);
1960:
1961: EXCEPTION
1962: WHEN others THEN
1963: -- Reset IN OUT parameters and set OUT parameters
1963: -- Reset IN OUT parameters and set OUT parameters
1964:
1965: p_to_field := l_to_field;
1966:
1967: hr_utility.set_location('Leaving ' || l_proc,55);
1968: RAISE;
1969:
1970: END;
1971:
1980: l_to_char varchar2(100);
1981: l_to_field NUMBER;
1982: BEGIN
1983: l_to_field := p_to_field; --NOCOPY Changes
1984: hr_utility.set_location('Entering: ' || l_proc, 5);
1985: l_from_char := to_char(p_from_field);
1986: l_to_char := to_char(p_to_field);
1987: copy_to_new_rg_shared( p_action_num => p_action_num,
1988: p_field_name => p_field_name,
1990: p_to_field => l_to_char,
1991: p_fld_nm_copy_from => p_fld_nm_copy_from);
1992: p_to_field := to_number(l_to_char);
1993:
1994: hr_utility.set_location('Leaving: ' || l_proc, 35);
1995:
1996: EXCEPTION
1997: WHEN others THEN
1998: -- Reset IN OUT parameters and set OUT parameters
1998: -- Reset IN OUT parameters and set OUT parameters
1999:
2000: p_to_field := l_to_field;
2001:
2002: hr_utility.set_location('Leaving ' || l_proc,56);
2003: RAISE;
2004: END;
2005:
2006:
2006:
2007: BEGIN
2008: l_pa_req :=p_pa_req ; ---NOCOPY Changes
2009:
2010: hr_utility.set_location('Entering:'|| l_proc, 5);
2011: hr_utility.set_location(' no. of rows in table rg ' || to_char(l_column_count), 11);
2012: -- get list of all columns needed for the noa we are correcting.
2013: initialize_fld_names_table( p_noa_id => p_pa_req.first_noa_id,
2014: p_fld_names_tab => l_fld_names_tab1);
2007: BEGIN
2008: l_pa_req :=p_pa_req ; ---NOCOPY Changes
2009:
2010: hr_utility.set_location('Entering:'|| l_proc, 5);
2011: hr_utility.set_location(' no. of rows in table rg ' || to_char(l_column_count), 11);
2012: -- get list of all columns needed for the noa we are correcting.
2013: initialize_fld_names_table( p_noa_id => p_pa_req.first_noa_id,
2014: p_fld_names_tab => l_fld_names_tab1);
2015: l_column_count1 := l_column_count;
2226:
2227: -- 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);
2228:
2229: if (p_action_num = 2) then
2230: hr_utility.set_location('Correcting second action'|| l_proc, 10);
2231: -- if we are correcting the second action of a dual action, then copy all second noa columns into
2232: -- corresponding first noa columns
2233: copy_2ndNoa_to_1stNoa(l_pa_req);
2234: end if;
2236: null_2ndNoa_cols(l_pa_req);
2237:
2238: p_pa_req := l_pa_req;
2239:
2240: hr_utility.set_location('Leaving:'|| l_proc, 15);
2241:
2242: EXCEPTION
2243: WHEN others THEN
2244: -- Reset IN OUT parameters and set OUT parameters
2244: -- Reset IN OUT parameters and set OUT parameters
2245:
2246: p_pa_req := l_pa_req;
2247:
2248: hr_utility.set_location('Leaving ' || l_proc,60);
2249: RAISE;
2250:
2251: END assign_new_rg;
2252:
2290:
2291: BEGIN
2292: l_pa_req :=p_pa_req ; ---NOCOPY Changes
2293:
2294: hr_utility.set_location('Entering:'|| l_proc, 5);
2295: p_pa_req.first_action_la_code1 := p_pa_req.second_action_la_code1;
2296: p_pa_req.first_action_la_code2 := p_pa_req.second_action_la_code2;
2297: p_pa_req.first_action_la_desc1 := p_pa_req.second_action_la_desc1;
2298: p_pa_req.first_action_la_desc2 := p_pa_req.second_action_la_desc2;
2315: p_pa_req.first_lac2_information2 := p_pa_req.second_lac2_information2;
2316: p_pa_req.first_lac2_information3 := p_pa_req.second_lac2_information3;
2317: p_pa_req.first_lac2_information4 := p_pa_req.second_lac2_information4;
2318: p_pa_req.first_lac2_information5 := p_pa_req.second_lac2_information5;
2319: hr_utility.set_location('Leaving:'|| l_proc, 10);
2320:
2321: EXCEPTION
2322: WHEN others THEN
2323: -- Reset IN OUT parameters and set OUT parameters
2323: -- Reset IN OUT parameters and set OUT parameters
2324:
2325: p_pa_req := l_pa_req;
2326:
2327: hr_utility.set_location('Leaving ' || l_proc,65);
2328: RAISE;
2329: END copy_2ndNoa_to_1stNoa;
2330:
2331: -- ---------------------------------------------------------------------------
2364:
2365: BEGIN
2366: l_pa_req :=p_pa_req ; ---NOCOPY Changes
2367:
2368: hr_utility.set_location('Entering:'|| l_proc, 5);
2369: -- set all second noa columns to null.
2370: p_pa_req.second_action_la_code1 := null;
2371: p_pa_req.second_action_la_code2 := null;
2372: p_pa_req.second_action_la_desc1 := null;
2390: p_pa_req.second_lac2_information2 := null;
2391: p_pa_req.second_lac2_information3 := null;
2392: p_pa_req.second_lac2_information4 := null;
2393: p_pa_req.second_lac2_information5 := null;
2394: hr_utility.set_location('Leaving:'|| l_proc, 10);
2395:
2396: EXCEPTION
2397: WHEN others THEN
2398: -- Reset IN OUT parameters and set OUT parameters
2398: -- Reset IN OUT parameters and set OUT parameters
2399:
2400: p_pa_req := l_pa_req;
2401:
2402: hr_utility.set_location('Leaving ' || l_proc,70);
2403: RAISE;
2404:
2405: END null_2ndNoa_cols;
2406:
2451:
2452: l_proc varchar2(30):='get_family_code';
2453: Begin
2454:
2455: hr_utility.set_location( 'entering : ' || l_proc, 10);
2456: open c_fam (p_noa_id);
2457: fetch c_fam into p_noa_family_code;
2458: close c_fam;
2459: hr_utility.set_location( 'leaving : ' || l_proc, 20);
2455: hr_utility.set_location( 'entering : ' || l_proc, 10);
2456: open c_fam (p_noa_id);
2457: fetch c_fam into p_noa_family_code;
2458: close c_fam;
2459: hr_utility.set_location( 'leaving : ' || l_proc, 20);
2460:
2461: EXCEPTION
2462: WHEN others THEN
2463: -- Reset IN OUT parameters and set OUT parameters
2463: -- Reset IN OUT parameters and set OUT parameters
2464:
2465: p_noa_family_code := NULL;
2466:
2467: hr_utility.set_location('Leaving ' || l_proc,75);
2468: RAISE;
2469:
2470: End;
2471:
2659:
2660: BEGIN
2661: for get_par_id in c_get_par_id loop
2662: l_pa_request_id := get_par_id.pa_request_id ;
2663: hr_utility.set_location('par id ' || l_pa_request_id,3);
2664:
2665: for get_request in get_req loop
2666: hr_utility.set_location('par_id ' || l_pa_request_id,2);
2667: l_rec := get_request;
2662: l_pa_request_id := get_par_id.pa_request_id ;
2663: hr_utility.set_location('par id ' || l_pa_request_id,3);
2664:
2665: for get_request in get_req loop
2666: hr_utility.set_location('par_id ' || l_pa_request_id,2);
2667: l_rec := get_request;
2668: hr_utility.set_location('l_rec ' || l_rec.first_noa_code,3);
2669:
2670: l_sf52_rec := l_rec;
2664:
2665: for get_request in get_req loop
2666: hr_utility.set_location('par_id ' || l_pa_request_id,2);
2667: l_rec := get_request;
2668: hr_utility.set_location('l_rec ' || l_rec.first_noa_code,3);
2669:
2670: l_sf52_rec := l_rec;
2671:
2672: Begin
2686: 'decreased amount of Basic Pay. ' || l_new_line ||
2687: 'Action: Please review the personnel action to verify the Grade and Step, Pay Table amounts,' || l_new_line ||
2688: 'and Pay Rate Determinant code for this employee.' ; -- Bug 3320086 Changed error message.
2689:
2690: hr_utility.set_location(l_log_text,1511);
2691: create_ghr_errorlog(
2692: p_program_name => g_futr_proc_name,
2693: p_log_text => l_log_text,
2694: p_message_name => 'SF52 Routed to Inbox',
2814: if nvl(l_retcode, 0) <> 2 then
2815: l_retcode := 1; /* warning */
2816: end if;
2817:
2818: hr_utility.set_location( l_proc || ' ' || substr(sqlerrm,1,20), 40);
2819: -- Enter a record in process log
2820: l_log_text := substr(
2821: 'Request Number : ' || l_sf52_rec.request_number || l_new_line ||
2822: 'PA_REQUEST_ID : ' || to_char(l_sf52_rec.pa_request_id) || l_new_line ||
2835:
2836: commit;
2837: Exception
2838: When Others then
2839: hr_utility.set_location(' Error While creating Procees Log' || l_proc, 200);
2840: -- Error
2841: l_retcode := 2;
2842: errbuf := 'Process was errored out while creating Error Log. Error: ' || substr(sqlerrm(sqlcode), 1, 50);
2843: return;
2879: (l_sid,sysdate);
2880: end if;
2881: end;
2882:
2883: hr_utility.set_location(' Entering : ' || l_proc, 10);
2884: -- Get concurent Request_id
2885: g_futr_proc_name :='GHR_Proc_Futr_Act';
2886: l_req := Fnd_profile.value('CONC_REQUEST_ID');
2887:
2897: IF p_poi is not null then
2898: for par_pend_for_per_poi in c_par_pend_per_poi loop
2899: l_person_id := par_pend_for_per_poi.person_id;
2900: l_effective_date := par_pend_for_per_poi.effective_date;
2901: hr_utility.set_location( 'Person id ' || l_person_id,1);
2902: hr_utility.set_location(' Eff. Date ' || l_effective_date,2);
2903: sub_proc_futr_sf52;
2904: end loop;
2905: ELSE
2898: for par_pend_for_per_poi in c_par_pend_per_poi loop
2899: l_person_id := par_pend_for_per_poi.person_id;
2900: l_effective_date := par_pend_for_per_poi.effective_date;
2901: hr_utility.set_location( 'Person id ' || l_person_id,1);
2902: hr_utility.set_location(' Eff. Date ' || l_effective_date,2);
2903: sub_proc_futr_sf52;
2904: end loop;
2905: ELSE
2906: for par_pend_for_per in c_par_pend_per loop
2905: ELSE
2906: for par_pend_for_per in c_par_pend_per loop
2907: l_person_id := par_pend_for_per.person_id;
2908: l_effective_date := par_pend_for_per.effective_date;
2909: hr_utility.set_location( 'Person id ' || l_person_id,1);
2910: hr_utility.set_location(' Eff. Date ' || l_effective_date,2);
2911: sub_proc_futr_sf52;
2912: end loop;
2913: END IF;
2906: for par_pend_for_per in c_par_pend_per loop
2907: l_person_id := par_pend_for_per.person_id;
2908: l_effective_date := par_pend_for_per.effective_date;
2909: hr_utility.set_location( 'Person id ' || l_person_id,1);
2910: hr_utility.set_location(' Eff. Date ' || l_effective_date,2);
2911: sub_proc_futr_sf52;
2912: end loop;
2913: END IF;
2914: if l_retcode = 2 then
2912: end loop;
2913: END IF;
2914: if l_retcode = 2 then
2915: retcode := 2;
2916: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
2917: errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
2918: -- Bug 2639698 Sundar
2919: elsif l_retcode = 5 then
2920: retcode := 2;
2917: errbuf := 'There were errors in SF52''s which could NOT be routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
2918: -- Bug 2639698 Sundar
2919: elsif l_retcode = 5 then
2920: retcode := 2;
2921: hr_utility.set_location('Ret code ' || to_char(l_retcode),1);
2922: errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG';
2923: -- End Bug 2639698 Sundar
2924: elsif l_retcode is not NULL then
2925: -- Warning
2927: errbuf := 'There were errors in SF52''s which were routed to approver''s Inbox. Detail in GHR_PROCESS_LOG' ;
2928: elsif l_retcode is null then
2929: retcode := 0;
2930: end if;
2931: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2932: hr_utility.set_location('Ret code ' || to_char(l_retcode), 21);
2933: Exception
2934: when others then
2935: hr_utility.set_location(l_proc, 60);
2928: elsif l_retcode is null then
2929: retcode := 0;
2930: end if;
2931: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2932: hr_utility.set_location('Ret code ' || to_char(l_retcode), 21);
2933: Exception
2934: when others then
2935: hr_utility.set_location(l_proc, 60);
2936: -- Error
2931: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2932: hr_utility.set_location('Ret code ' || to_char(l_retcode), 21);
2933: Exception
2934: when others then
2935: hr_utility.set_location(l_proc, 60);
2936: -- Error
2937: retcode := 2;
2938: errbuf := 'Process Terminated due to Unhandled Errors.' || l_new_line
2939: || 'Error : ' || substr(sqlerrm(sqlcode), 1, 20);
2957: l_sf52 ghr_pa_requests%rowtype ;
2958:
2959: Begin
2960: l_sf52 :=p_sf52; --NOCOPY Changes
2961: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2962: savepoint route_errored_sf52;
2963: /*
2964: l_log_text := 'Request Number : ' || p_sf52.request_number || l_new_line ||
2965: 'PA_REQUEST_ID : ' || to_char(p_sf52.pa_request_id) ||
2966: ' has errors.' || l_new_line ||
2967: 'Error : ' || p_error || l_new_line ||
2968: 'Errored while resetting approval date ';
2969: */
2970: hr_utility.set_location( l_proc, 20);
2971: l_log_text := 'Request Number : ' || p_sf52.request_number || l_new_line ||
2972: 'PA_REQUEST_ID : ' || to_char(p_sf52.pa_request_id) ||
2973: ' has errors.' || l_new_line ||
2974: 'Error : ' || p_error || l_new_line ||
2977: ghr_api.call_workflow(
2978: p_pa_request_id => p_sf52.pa_request_id,
2979: p_action_taken => 'CONTINUE',
2980: p_error => p_error);
2981: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2982: Exception
2983: when others then
2984: hr_utility.set_location(l_proc || ' workflow errored out', 30);
2985: rollback to route_errored_sf52;
2980: p_error => p_error);
2981: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2982: Exception
2983: when others then
2984: hr_utility.set_location(l_proc || ' workflow errored out', 30);
2985: rollback to route_errored_sf52;
2986: p_result := '0';
2987: l_log_text := substr(
2988: 'Request Number : ' || p_sf52.request_number || l_new_line ||
2998: p_log_text => l_log_text,
2999: p_message_name => 'Routing Error',
3000: p_log_date => sysdate
3001: );
3002: hr_utility.set_location(l_proc , 40);
3003: p_result := '2';
3004: p_sf52 := l_sf52; --Added for nocopy changes
3005:
3006: End Route_Errorerd_SF52;
3078:
3079:
3080: begin
3081: savepoint get_personnel_off_groupbox;
3082: hr_utility.set_location('Entering ' || l_proc,5);
3083: p_retcode := null;
3084:
3085: -- Find the groupbox of the personnelist, update ghr_pa_routing_history and then call work_flow
3086:
3122:
3123: Exception
3124: when others then
3125: rollback to get_personnel_off_groupbox;
3126: hr_utility.set_location(l_proc,50);
3127:
3128: p_retcode := 2;
3129: create_ghr_errorlog
3130: (p_program_name => g_futr_proc_name,
3136: end get_personnel_off_groupbox;
3137:
3138: begin
3139:
3140: hr_utility.set_location('Entering ' || l_proc ,5);
3141: savepoint fetch_update_routing_details;
3142:
3143: l_user_name := null;
3144: l_groupbox_id := null;
3180: (p_pa_request_id => p_pa_request_id,
3181: p_object_version_number => p_object_version_number,
3182: p_routing_group_id => l_routing_group_id
3183: );
3184: hr_utility.set_location(l_proc ,10);
3185:
3186:
3187: l_log_text := 'Error while updating groupbox to ghr_pa_routing_history table';
3188: for rout_hist in c_rout_history loop
3185:
3186:
3187: l_log_text := 'Error while updating groupbox to ghr_pa_routing_history table';
3188: for rout_hist in c_rout_history loop
3189: hr_utility.set_location(l_proc ,15);
3190: l_pa_routing_history_id := rout_hist.pa_routing_history_id;
3191: l_pa_object_version_number := rout_hist.object_version_number;
3192: end loop;
3193:
3190: l_pa_routing_history_id := rout_hist.pa_routing_history_id;
3191: l_pa_object_version_number := rout_hist.object_version_number;
3192: end loop;
3193:
3194: hr_utility.set_location(l_proc ,20);
3195: ghr_prh_upd.upd
3196: (p_pa_routing_history_id => l_pa_routing_history_id,
3197: p_object_version_number => l_pa_object_version_number,
3198: p_groupbox_id => l_groupbox_id
3196: (p_pa_routing_history_id => l_pa_routing_history_id,
3197: p_object_version_number => l_pa_object_version_number,
3198: p_groupbox_id => l_groupbox_id
3199: );
3200: hr_utility.set_location('Leaving '|| l_proc ,30);
3201: End if;
3202: Else
3203: p_route_flag := TRUE;
3204: End if;
3246: l_rec get_req%rowtype;
3247: l_proc varchar2(30):='Route_Intervn_Future_Actions';
3248:
3249: Begin
3250: hr_utility.set_location(' Entering : ' || l_proc, 10);
3251: open get_req (p_person_id, p_effective_date);
3252: While TRUE
3253: loop
3254: fetch get_req into l_rec;
3264: l_error := Sqlerrm(sqlcode);
3265: rollback to future_Action;
3266: Raise;
3267: End;
3268: hr_utility.set_location(' Entering : ' || l_proc, 100);
3269: End loop;
3270: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3271: End Route_Intervn_Future_Actions;
3272:
3266: Raise;
3267: End;
3268: hr_utility.set_location(' Entering : ' || l_proc, 100);
3269: End loop;
3270: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3271: End Route_Intervn_Future_Actions;
3272:
3273:
3274:
3296: l_rec get_req%rowtype;
3297: l_proc varchar2(30):='Route_Intervn_pend_Actions';
3298:
3299: Begin
3300: hr_utility.set_location(' Entering : ' || l_proc, 10);
3301: open get_req (p_person_id, p_effective_date);
3302: While TRUE
3303: loop
3304: fetch get_req into l_rec;
3314: l_error := Sqlerrm(sqlcode);
3315: rollback to route_pending_Actions;
3316: Raise;
3317: End;
3318: hr_utility.set_location(' Entering : ' || l_proc, 100);
3319: End loop;
3320: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3321: End Route_Intervn_act_pend_today;
3322:
3316: Raise;
3317: End;
3318: hr_utility.set_location(' Entering : ' || l_proc, 100);
3319: End loop;
3320: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3321: End Route_Intervn_act_pend_today;
3322:
3323:
3324:
3330: ) is
3331:
3332: l_proc varchar2(30):='create_ghr_errorlog';
3333: Begin
3334: hr_utility.set_location( 'Entering : ' || l_proc, 10);
3335: insert into ghr_process_log
3336: (process_log_id
3337: ,program_name
3338: ,log_text
3345: ,p_log_text
3346: ,p_message_name
3347: ,p_log_date
3348: );
3349: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
3350:
3351: End create_ghr_errorlog;
3352:
3353: -- ---------------------------------------------------------------------------
3603: l_person_id := cur_ass_id_rec.person_id;
3604: EXIT;
3605: END LOOP;
3606: -- From history fetch the Assignment Information Details for the effective date
3607: hr_utility.set_location('Eff. date in get_asg_step_or_rate ' || p_effective_date,25);
3608: IF l_assignment_id IS NOT NULL THEN
3609: ghr_history_fetch.fetch_asgei (
3610: p_assignment_id => l_assignment_id,
3611: p_information_type => 'GHR_US_ASG_SF52',
3633: ELSIF l_asgei_data.aei_information6 = '7' then
3634: p_prd := '0';
3635: ELSE
3636: p_prd := l_asgei_data.aei_information6;
3637: hr_utility.set_location('Sun p_pay_rate_determinant' || p_prd,250);
3638: END IF;
3639: END IF;
3640:
3641: END get_asg_step_or_rate;
3643: begin
3644:
3645: l_sf52_data := p_sf52_data ; --NOCOPY Changes
3646:
3647: hr_utility.set_location('Entering: ' || l_proc, 10);
3648: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3649: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3650: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3651:
3644:
3645: l_sf52_data := p_sf52_data ; --NOCOPY Changes
3646:
3647: hr_utility.set_location('Entering: ' || l_proc, 10);
3648: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3649: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3650: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3651:
3652: ghr_history_api.get_g_session_var( l_session_var);
3645: l_sf52_data := p_sf52_data ; --NOCOPY Changes
3646:
3647: hr_utility.set_location('Entering: ' || l_proc, 10);
3648: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3649: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3650: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3651:
3652: ghr_history_api.get_g_session_var( l_session_var);
3653: for c_rec in get_noa_info LOOP
3646:
3647: hr_utility.set_location('Entering: ' || l_proc, 10);
3648: hr_utility.set_location('pay Rate in the beginning of Ref '|| p_sf52_data.pay_rate_determinant,11);
3649: hr_utility.set_location('To Pay Basis '|| p_sf52_data.to_pay_basis,11);
3650: hr_utility.set_location('Noa Family Code '|| p_sf52_data.noa_family_code,11);
3651:
3652: ghr_history_api.get_g_session_var( l_session_var);
3653: for c_rec in get_noa_info LOOP
3654: l_first_noa_id := c_rec.first_noa_id;
3863: p_sf52_data.to_au_overtime := l_au_overtime;
3864: p_sf52_data.to_availability_pay := l_availability_pay ;
3865: p_sf52_data.to_other_pay_amount := l_other_pay;
3866: END IF;
3867: hr_utility.set_location('l_from_position_id is ' ||l_from_position_id, 11);
3868: hr_utility.set_location('from_position_id is ' ||p_sf52_data.from_position_id, 12);
3869: hr_utility.set_location('to_position_id is ' ||p_sf52_data.to_position_id, 13);
3870: hr_utility.set_location('to_basic_pay is ' ||p_sf52_data.to_basic_pay, 14);
3871: if (nvl(l_from_position_id, -1) <> nvl(p_sf52_data.from_position_id, -1) and
3864: p_sf52_data.to_availability_pay := l_availability_pay ;
3865: p_sf52_data.to_other_pay_amount := l_other_pay;
3866: END IF;
3867: hr_utility.set_location('l_from_position_id is ' ||l_from_position_id, 11);
3868: hr_utility.set_location('from_position_id is ' ||p_sf52_data.from_position_id, 12);
3869: hr_utility.set_location('to_position_id is ' ||p_sf52_data.to_position_id, 13);
3870: hr_utility.set_location('to_basic_pay is ' ||p_sf52_data.to_basic_pay, 14);
3871: if (nvl(l_from_position_id, -1) <> nvl(p_sf52_data.from_position_id, -1) and
3872: nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2)) then
3865: p_sf52_data.to_other_pay_amount := l_other_pay;
3866: END IF;
3867: hr_utility.set_location('l_from_position_id is ' ||l_from_position_id, 11);
3868: hr_utility.set_location('from_position_id is ' ||p_sf52_data.from_position_id, 12);
3869: hr_utility.set_location('to_position_id is ' ||p_sf52_data.to_position_id, 13);
3870: hr_utility.set_location('to_basic_pay is ' ||p_sf52_data.to_basic_pay, 14);
3871: if (nvl(l_from_position_id, -1) <> nvl(p_sf52_data.from_position_id, -1) and
3872: nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2)) then
3873: -- ie from and to position were same and
3866: END IF;
3867: hr_utility.set_location('l_from_position_id is ' ||l_from_position_id, 11);
3868: hr_utility.set_location('from_position_id is ' ||p_sf52_data.from_position_id, 12);
3869: hr_utility.set_location('to_position_id is ' ||p_sf52_data.to_position_id, 13);
3870: hr_utility.set_location('to_basic_pay is ' ||p_sf52_data.to_basic_pay, 14);
3871: if (nvl(l_from_position_id, -1) <> nvl(p_sf52_data.from_position_id, -1) and
3872: nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2)) then
3873: -- ie from and to position were same and
3874: -- from position has been changed because of refresh.
3876: -- Reverting changes made in Bug # 757932
3877: -- if nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2) then
3878: -- from and to position were same.
3879:
3880: hr_utility.set_location('Case 1 ', 15);
3881:
3882: p_sf52_data.to_adj_basic_pay := l_adj_basic_pay;
3883: p_sf52_data.to_basic_pay := l_basic_pay;
3884: p_sf52_data.to_grade_id := l_grade_id;
3924: END IF;
3925: -- Start Bug 1310894
3926: elsif nvl(l_from_position_id, -1) = nvl(p_sf52_data.to_position_id, -2)
3927: and l_noa_family_code = 'OTHER_PAY' then
3928: hr_utility.set_location('Case 2 ', 15);
3929: -- Other Pay action and From and To Position were same.
3930: p_sf52_data.to_adj_basic_pay := l_adj_basic_pay;
3931: p_sf52_data.to_basic_pay := l_basic_pay;
3932: p_sf52_data.to_grade_id := l_grade_id;
3953: p_sf52_data.to_position_title := p_sf52_data.from_position_title;
3954: -- End Bug 1310894
3955: elsif p_sf52_data.to_position_id is not NULL then
3956: -- User has entered to_position
3957: hr_utility.set_location('Case 3 ', 15);
3958: l_position_id := p_sf52_data.to_position_id;
3959:
3960: -- get to_position columns
3961: -- Bug 2112935 Sundar
3960: -- get to_position columns
3961: -- Bug 2112935 Sundar
3962: -- For Retro 866 and 740, need to pass initial PRD as null.
3963: -- Call determine_ia to Find out Retro NOAs.
3964: hr_utility.set_location('l_session_var.altered_pa_request_id ' || l_session_var.altered_pa_request_id ,15);
3965:
3966: FOR l_orig_rec IN c_orig_rec(l_session_var.altered_pa_request_id) LOOP
3967: l_orig_pa_request_id := l_orig_rec.pa_request_id;
3968: l_orig_pa_notification_id := l_orig_rec.pa_notification_id;
3979: p_retro_eff_date => l_effective_date,
3980: p_retro_pa_request_id => l_retro_pa_request_id,
3981: p_retro_first_noa => l_retro_first_noa,
3982: p_retro_second_noa => l_retro_second_noa);
3983: hr_utility.set_location('Retro 1st NOA ' || l_retro_first_noa ,15);
3984: hr_utility.set_location('Retro 2nd NOA ' || l_retro_second_noa ,15);
3985:
3986: IF ((l_retro_first_noa = '866' OR l_retro_second_noa = '866') OR
3987: (l_retro_first_noa = '740' OR l_retro_second_noa = '740')) THEN
3980: p_retro_pa_request_id => l_retro_pa_request_id,
3981: p_retro_first_noa => l_retro_first_noa,
3982: p_retro_second_noa => l_retro_second_noa);
3983: hr_utility.set_location('Retro 1st NOA ' || l_retro_first_noa ,15);
3984: hr_utility.set_location('Retro 2nd NOA ' || l_retro_second_noa ,15);
3985:
3986: IF ((l_retro_first_noa = '866' OR l_retro_second_noa = '866') OR
3987: (l_retro_first_noa = '740' OR l_retro_second_noa = '740')) THEN
3988: NULL;
3986: IF ((l_retro_first_noa = '866' OR l_retro_second_noa = '866') OR
3987: (l_retro_first_noa = '740' OR l_retro_second_noa = '740')) THEN
3988: NULL;
3989: ELSE
3990: hr_utility.set_location('FWFA prd :'||l_prd,80);
3991: hr_utility.set_location('FWFA refresh prd :'||p_sf52_data.pay_rate_determinant,90);
3992: IF l_prd IS NOT NULL AND
3993: l_prd <> nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) then
3994: p_sf52_data.pay_rate_determinant := l_prd;
3987: (l_retro_first_noa = '740' OR l_retro_second_noa = '740')) THEN
3988: NULL;
3989: ELSE
3990: hr_utility.set_location('FWFA prd :'||l_prd,80);
3991: hr_utility.set_location('FWFA refresh prd :'||p_sf52_data.pay_rate_determinant,90);
3992: IF l_prd IS NOT NULL AND
3993: l_prd <> nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) then
3994: p_sf52_data.pay_rate_determinant := l_prd;
3995: END IF;
3993: l_prd <> nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) then
3994: p_sf52_data.pay_rate_determinant := l_prd;
3995: END IF;
3996: END IF;
3997: hr_utility.set_location('bef call to to_data PRD ' || p_sf52_data.pay_rate_determinant ,15);
3998: hr_utility.set_location('bef call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,15);
3999: ghr_pa_requests_pkg.get_sf52_to_data_elements
4000: (p_position_id => p_sf52_data.to_position_id
4001: ,p_effective_date => p_sf52_data.effective_date
3994: p_sf52_data.pay_rate_determinant := l_prd;
3995: END IF;
3996: END IF;
3997: hr_utility.set_location('bef call to to_data PRD ' || p_sf52_data.pay_rate_determinant ,15);
3998: hr_utility.set_location('bef call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,15);
3999: ghr_pa_requests_pkg.get_sf52_to_data_elements
4000: (p_position_id => p_sf52_data.to_position_id
4001: ,p_effective_date => p_sf52_data.effective_date
4002: ,p_prd => p_sf52_data.pay_rate_determinant
4015: ,p_position_org_line5 => l_position_org_line5
4016: ,p_position_org_line6 => l_position_org_line6
4017: ,p_duty_station_id => l_duty_station_id
4018: );
4019: hr_utility.set_location('After call to to_data PRD ' || p_sf52_data.pay_rate_determinant ,15);
4020: --Added 855 for bug 3617311
4021: IF ( l_first_noa_code <> '713' AND l_first_noa_code <> '855' AND l_second_noa_code <> '855' ) THEN
4022: p_sf52_data.to_grade_id := l_grade_id;
4023: p_sf52_data.to_grade_or_level := l_grade_or_level;
4044: -- Bug 2112935
4045: p_sf52_data.to_step_or_rate := l_step_or_rate;
4046: END IF;
4047:
4048: hr_utility.set_location('aft call to to_data pay BAsis ' || p_sf52_data.to_pay_basis ,16);
4049: if nvl(p_sf52_data.pay_rate_determinant,hr_api.g_varchar2) in ('A','B','E','F','U','V') then
4050:
4051: ----Temp Promo Changes by AVR 03-JUN-2000--Start---
4052:
4068: p_prd => p_sf52_data.pay_rate_determinant,
4069: p_pa_request_id => p_sf52_data.pa_request_id,
4070: p_effective_date => p_sf52_data.effective_date);
4071: end if;
4072: hr_utility.set_location('aft call to upda 34 pay BAsis ' || p_sf52_data.to_pay_basis ,1);
4073: end if;
4074: hr_utility.set_location('aft call to upda 34 pay BAsis outside if '
4075: || p_sf52_data.to_pay_basis ,1);
4076:
4070: p_effective_date => p_sf52_data.effective_date);
4071: end if;
4072: hr_utility.set_location('aft call to upda 34 pay BAsis ' || p_sf52_data.to_pay_basis ,1);
4073: end if;
4074: hr_utility.set_location('aft call to upda 34 pay BAsis outside if '
4075: || p_sf52_data.to_pay_basis ,1);
4076:
4077: if (l_first_noa_code = '352') then
4078: p_sf52_data.to_position_org_line1 :=
4108: open get_pos_bg ( P_sf52_data.to_position_id);
4109: fetch get_pos_bg into l_business_group_id;
4110: if get_pos_bg%notfound then
4111: close get_pos_bg;
4112: hr_utility.set_location ( l_proc || 'get_pos_bg not found ', 100);
4113: hr_utility.set_message(8301 , 'GHR_38415_BUSN_GRP_NOT_FOUND');
4114: hr_utility.raise_error;
4115: else
4116: close get_pos_bg;
4109: fetch get_pos_bg into l_business_group_id;
4110: if get_pos_bg%notfound then
4111: close get_pos_bg;
4112: hr_utility.set_location ( l_proc || 'get_pos_bg not found ', 100);
4113: hr_utility.set_message(8301 , 'GHR_38415_BUSN_GRP_NOT_FOUND');
4114: hr_utility.raise_error;
4115: else
4116: close get_pos_bg;
4117: end if;
4110: if get_pos_bg%notfound then
4111: close get_pos_bg;
4112: hr_utility.set_location ( l_proc || 'get_pos_bg not found ', 100);
4113: hr_utility.set_message(8301 , 'GHR_38415_BUSN_GRP_NOT_FOUND');
4114: hr_utility.raise_error;
4115: else
4116: close get_pos_bg;
4117: end if;
4118:
4133:
4134: -- JH DS starts populated from ASG. Populate using To Position if To Posn PM is UE, or APUE and
4135: -- to_posn <> from posn.
4136: --
4137: hr_utility.set_location('To Posn ID ' || p_sf52_data.to_position_id ,20);
4138: IF p_sf52_data.to_position_id IS NOT NULL THEN
4139: /* l_pm value determined above
4140: FOR pm_rec in get_to_posn_title_pm LOOP
4141: l_pm := pm_rec.process_method_code;
4140: FOR pm_rec in get_to_posn_title_pm LOOP
4141: l_pm := pm_rec.process_method_code;
4142: END Loop;
4143: */
4144: hr_utility.set_location('To Posn PM ' || l_pm ,20);
4145: IF l_pm = 'UE' THEN
4146: p_sf52_data.duty_station_location_id := l_location_id;
4147: p_sf52_data.duty_station_id := l_duty_station_id;
4148: ELSIF l_pm = 'APUE' and nvl(p_sf52_data.to_position_id,hr_api.g_number)
4158: -- If the refresh is for realignment then refresh position org. lines using the procedure
4159: -- ghr_pa_requests_pkg.get_rei_org_lines
4160: if p_sf52_data.first_noa_code = '790' or
4161: p_sf52_data.second_noa_code = '790' then
4162: hr_utility.set_location('Realignment NOA: ' || l_proc, 410);
4163: ghr_pa_requests_pkg.get_rei_org_lines(
4164: P_PA_REQUEST_ID => p_sf52_data.pa_request_id,
4165: P_ORGANIZATION_ID => l_organization_id,
4166: P_POSITION_ORG_LINE1 => l_position_org_line1,
4170: P_POSITION_ORG_LINE5 => l_position_org_line5,
4171: P_POSITION_ORG_LINE6 => l_position_org_line6
4172: );
4173: if l_organization_id is not NULL then
4174: hr_utility.set_location('Realignment NOA Refreshed: ' || l_proc, 420);
4175: p_sf52_data.to_position_org_line1 := l_position_org_line1;
4176: p_sf52_data.to_position_org_line2 := l_position_org_line2;
4177: p_sf52_data.to_position_org_line3 := l_position_org_line3;
4178: p_sf52_data.to_position_org_line4 := l_position_org_line4;
4178: p_sf52_data.to_position_org_line4 := l_position_org_line4;
4179: p_sf52_data.to_position_org_line5 := l_position_org_line5;
4180: p_sf52_data.to_position_org_line6 := l_position_org_line6;
4181: else
4182: hr_utility.set_location('Realignment NOA NOT Refreshed: ' || l_proc, 430);
4183: end if;
4184: end if;
4185:
4186: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
4213: ,p_personnel_office_id => l_personnel_office_id
4214: ,p_office_symbol => l_office_symbol
4215: ,p_part_time_hours => l_part_time_hours);
4216:
4217: hr_utility.set_location('l_work_schedule is ' || l_work_schedule, 11);
4218: if (not p_from_only) then
4219: hr_utility.set_location('l_work_schedule is ' || l_work_schedule, 12);
4220: p_sf52_data.flsa_category := l_flsa_category ;
4221: p_sf52_data.bargaining_unit_status := l_bargaining_unit_status;
4215: ,p_part_time_hours => l_part_time_hours);
4216:
4217: hr_utility.set_location('l_work_schedule is ' || l_work_schedule, 11);
4218: if (not p_from_only) then
4219: hr_utility.set_location('l_work_schedule is ' || l_work_schedule, 12);
4220: p_sf52_data.flsa_category := l_flsa_category ;
4221: p_sf52_data.bargaining_unit_status := l_bargaining_unit_status;
4222: p_sf52_data.work_schedule := l_work_schedule;
4223: p_sf52_data.functional_class := l_functional_class ;
4231: p_sf52_data.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning(800
4232: ,'GHR_US_WORK_SCHEDULE'
4233: ,l_work_schedule);
4234: end if;
4235: hr_utility.set_location('l_work_schedule_desc is ' || p_sf52_data.work_schedule_desc, 13);
4236:
4237: if (p_from_only = FALSE) then
4238: ghr_history_fetch.fetch_people(
4239: p_person_id => p_person_id,
4244: p_people_data => l_people_data,
4245: p_result_code => l_result_code
4246: );
4247: if (l_result_code is not null) then
4248: hr_utility.set_location(l_proc || 'non-null result_code', 910);
4249: end if;
4250:
4251: p_sf52_data.employee_national_identifier := l_people_data.national_identifier;
4252: p_sf52_data.employee_date_of_birth := l_people_data.date_of_birth;
4365: ,p_multiple_error_flag => l_multiple_error_flag);
4366:
4367: /*
4368: if (l_multiple_error_flag) then
4369: hr_utility.set_message(8301 , 'GHR_99999_MULT_ERR_FLAG');
4370: hr_utility.raise_error;
4371: end if;
4372: */
4373:
4366:
4367: /*
4368: if (l_multiple_error_flag) then
4369: hr_utility.set_message(8301 , 'GHR_99999_MULT_ERR_FLAG');
4370: hr_utility.raise_error;
4371: end if;
4372: */
4373:
4374: p_sf52_data.fegli := l_fegli ;
4384: ,p_value => l_retirement_plan
4385: ,p_multiple_error_flag => l_multiple_error_flag);
4386: /*
4387: if (l_multiple_error_flag) then
4388: hr_utility.set_message(8301 , 'GHR_99999_MULT_ERR_FLAG2');
4389: hr_utility.raise_error;
4390: end if;
4391: */
4392:
4385: ,p_multiple_error_flag => l_multiple_error_flag);
4386: /*
4387: if (l_multiple_error_flag) then
4388: hr_utility.set_message(8301 , 'GHR_99999_MULT_ERR_FLAG2');
4389: hr_utility.raise_error;
4390: end if;
4391: */
4392:
4393: p_sf52_data.retirement_plan := l_retirement_plan ;
4398: end if;
4399:
4400: --- Code for converting the pay values per Retain Grade Pay Basis
4401: -- if employee is on retain grade
4402: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4403: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4404: hr_utility.set_location('PER ID '|| p_person_id,1 );
4405: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4406: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4399:
4400: --- Code for converting the pay values per Retain Grade Pay Basis
4401: -- if employee is on retain grade
4402: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4403: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4404: hr_utility.set_location('PER ID '|| p_person_id,1 );
4405: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4406: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4407: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4400: --- Code for converting the pay values per Retain Grade Pay Basis
4401: -- if employee is on retain grade
4402: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4403: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4404: hr_utility.set_location('PER ID '|| p_person_id,1 );
4405: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4406: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4407: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4408: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4401: -- if employee is on retain grade
4402: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4403: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4404: hr_utility.set_location('PER ID '|| p_person_id,1 );
4405: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4406: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4407: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4408: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4409: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4402: hr_utility.set_location('PRD is '|| p_sf52_data.pay_rate_determinant,1 );
4403: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4404: hr_utility.set_location('PER ID '|| p_person_id,1 );
4405: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4406: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4407: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4408: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4409: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4410: IF p_sf52_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
4403: hr_utility.set_location('Eff Date is '|| p_sf52_data.effective_date,1 );
4404: hr_utility.set_location('PER ID '|| p_person_id,1 );
4405: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4406: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4407: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4408: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4409: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4410: IF p_sf52_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
4411: IF l_from_position_id = p_sf52_data.to_position_id and
4404: hr_utility.set_location('PER ID '|| p_person_id,1 );
4405: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4406: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4407: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4408: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4409: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4410: IF p_sf52_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
4411: IF l_from_position_id = p_sf52_data.to_position_id and
4412: l_session_var.noa_id_correct is not NULL and
4405: hr_utility.set_location('POS ID '|| p_sf52_data.to_position_id,1 );
4406: hr_utility.set_location('from_basic_pay is '|| p_sf52_data.from_basic_pay,1 );
4407: hr_utility.set_location('from_locality_adj is '|| p_sf52_data.from_locality_adj,1 );
4408: hr_utility.set_location('from_adj_basic_pay is '|| p_sf52_data.from_adj_basic_pay,1 );
4409: hr_utility.set_location('from_total_salary is '|| p_sf52_data.from_total_salary,1 );
4410: IF p_sf52_data.pay_rate_determinant IN ('A','B','E','F','U','V') THEN
4411: IF l_from_position_id = p_sf52_data.to_position_id and
4412: l_session_var.noa_id_correct is not NULL and
4413: l_pm = 'AP' THEN
4453: END IF;
4454: -- display all values retrieved
4455: print_sf52('Retrieved by refresh: ', p_sf52_data);
4456:
4457: hr_utility.set_location('Leaving: ' || l_proc, 100);
4458:
4459: EXCEPTION
4460: WHEN others THEN
4461: -- Reset IN OUT parameters and set OUT parameters
4461: -- Reset IN OUT parameters and set OUT parameters
4462:
4463: p_sf52_data := l_sf52_data ;
4464:
4465: hr_utility.set_location('Leaving ' || l_proc,80);
4466: RAISE;
4467:
4468: end refresh_pa_request;
4469:
4606: l_fld_names_tab fld_names_typ;
4607:
4608: BEGIN
4609: l_fld_names_tab := p_fld_names_tab; --NOCOPY Changes
4610: hr_utility.set_location('Entering:'|| l_proc, 5);
4611:
4612: -- populate the local table with the form_field_names for this noa.
4613: if (p_2nd_noa_id is not null) then
4614: hr_utility.set_location( l_proc || 'dual action', 7);
4610: hr_utility.set_location('Entering:'|| l_proc, 5);
4611:
4612: -- populate the local table with the form_field_names for this noa.
4613: if (p_2nd_noa_id is not null) then
4614: hr_utility.set_location( l_proc || 'dual action', 7);
4615: FOR curflds_rec in cur_flds2(p_1st_noa_id, p_2nd_noa_id) LOOP
4616: l_column_count := l_column_count + 1;
4617: p_fld_names_tab(l_column_count) := curflds_rec;
4618: END LOOP;
4620: l_column_count := l_column_count +1;
4621: p_fld_names_tab(l_column_count) := cur_postitle_rec;
4622: end LOOP;
4623: else
4624: hr_utility.set_location( l_proc || 'single action', 9);
4625: FOR curflds_rec in cur_flds1(p_1st_noa_id) LOOP
4626: l_column_count := l_column_count + 1;
4627: p_fld_names_tab(l_column_count) := curflds_rec;
4628: END LOOP;
4630: l_column_count := l_column_count +1;
4631: p_fld_names_tab(l_column_count) := cur_postitle_rec;
4632: end LOOP;
4633: end if;
4634: hr_utility.set_location('Leaving:'|| l_proc, 10);
4635:
4636: EXCEPTION
4637: WHEN others THEN
4638: -- Reset IN OUT parameters and set OUT parameters
4638: -- Reset IN OUT parameters and set OUT parameters
4639:
4640: p_fld_names_tab :=l_fld_names_tab;
4641:
4642: hr_utility.set_location('Leaving ' || l_proc,60);
4643: RAISE;
4644: END initialize_fld_names_table;
4645:
4646: --
4656: l_to_field VARCHAR2(2000);
4657:
4658: BEGIN
4659: l_to_field := p_to_field; --NOCOPY Changes
4660: hr_utility.set_location('Entering:'|| l_proc, 5);
4661: FOR l_count IN 1..l_column_count LOOP
4662: if p_field_name = l_fld_names_tab(l_count).form_field_name then
4663: l_found := TRUE;
4664: p_to_field := p_from_field; -- Sundar 2112935 Copying source to the target.
4668: if not l_found then
4669: p_to_field := null;
4670: end if;
4671:
4672: hr_utility.set_location('Leaving:'|| l_proc, 10);
4673:
4674: EXCEPTION
4675: WHEN others THEN
4676: -- Reset IN OUT parameters and set OUT parameters
4676: -- Reset IN OUT parameters and set OUT parameters
4677:
4678: p_to_field :=l_to_field;
4679:
4680: hr_utility.set_location('Leaving ' || l_proc,60);
4681: RAISE;
4682: END copy_to_new_rg;
4683:
4684: BEGIN
4681: RAISE;
4682: END copy_to_new_rg;
4683:
4684: BEGIN
4685: hr_utility.set_location('Entering:'|| l_proc, 5);
4686: hr_utility.set_location(' no. of rows in table rg ' || to_char(l_column_count), 11);
4687: -- get list of all columns needed for the noa we are correcting.
4688: initialize_fld_names_table( p_1st_noa_id => p_first_noa_id,
4689: p_2nd_noa_id => p_second_noa_id,
4682: END copy_to_new_rg;
4683:
4684: BEGIN
4685: hr_utility.set_location('Entering:'|| l_proc, 5);
4686: hr_utility.set_location(' no. of rows in table rg ' || to_char(l_column_count), 11);
4687: -- get list of all columns needed for the noa we are correcting.
4688: initialize_fld_names_table( p_1st_noa_id => p_first_noa_id,
4689: p_2nd_noa_id => p_second_noa_id,
4690: p_fld_names_tab => l_fld_names_tab);
4880:
4881: -- copy_to_new_rg('CUSTOM_PAY_CALC_FLAG',p_pa_req_in.custom_pay_calc_flag,l_pa_req.custom_pay_calc_flag);
4882: p_pa_req_out := l_pa_req;
4883:
4884: hr_utility.set_location('Leaving:'|| l_proc, 15);
4885:
4886: EXCEPTION
4887: WHEN others THEN
4888: -- Reset IN OUT parameters and set OUT parameters
4888: -- Reset IN OUT parameters and set OUT parameters
4889:
4890: p_pa_req_out :=NULL;
4891:
4892: hr_utility.set_location('Leaving ' || l_proc,60);
4893: RAISE;
4894:
4895: END get_par_ap_apue_fields;
4896:
4967: l_ret_allow_perc_out NUMBER;
4968: BEGIN
4969: l_sf52_data :=p_sf52_data ; --NOCOPY Changes
4970:
4971: hr_utility.set_location('Entering:'|| l_proc, 5);
4972: p_sf52_data.to_adj_basic_pay := p_sf52_data.from_adj_basic_pay;
4973: p_sf52_data.agency_code := p_sf52_data.from_agency_code;
4974:
4975: l_open_range_out_basic_pay := p_sf52_data.to_basic_pay;
5017: p_sf52_data.to_ap_premium_pay_indicator := l_sf52_data.to_ap_premium_pay_indicator;
5018: p_sf52_data.to_auo_premium_pay_indicator := l_sf52_data.to_auo_premium_pay_indicator;
5019: p_sf52_data.to_retention_allowance := l_sf52_data.to_retention_allowance;
5020: p_sf52_data.to_retention_allow_percentage := l_sf52_data.to_retention_allow_percentage;
5021: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5022: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5023: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5024: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5025: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5018: p_sf52_data.to_auo_premium_pay_indicator := l_sf52_data.to_auo_premium_pay_indicator;
5019: p_sf52_data.to_retention_allowance := l_sf52_data.to_retention_allowance;
5020: p_sf52_data.to_retention_allow_percentage := l_sf52_data.to_retention_allow_percentage;
5021: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5022: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5023: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5024: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5025: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5026: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5019: p_sf52_data.to_retention_allowance := l_sf52_data.to_retention_allowance;
5020: p_sf52_data.to_retention_allow_percentage := l_sf52_data.to_retention_allow_percentage;
5021: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5022: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5023: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5024: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5025: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5026: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5027: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5020: p_sf52_data.to_retention_allow_percentage := l_sf52_data.to_retention_allow_percentage;
5021: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5022: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5023: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5024: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5025: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5026: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5027: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5028: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5021: hr_utility.set_location(l_proc ||' to_organization_id: ' || p_sf52_data.to_organization_id, 12);
5022: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5023: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5024: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5025: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5026: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5027: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5028: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5029: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5022: hr_utility.set_location(l_proc ||' to_job_id: ' || p_sf52_data.to_job_id, 13);
5023: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5024: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5025: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5026: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5027: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5028: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5029: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5030: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5023: hr_utility.set_location(l_proc ||' to_grade_id: ' || p_sf52_data.to_grade_id, 14);
5024: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5025: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5026: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5027: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5028: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5029: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5030: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5031:
5024: hr_utility.set_location(l_proc ||' to_supervisory_differential: ' || p_sf52_data.to_supervisory_differential, 15);
5025: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5026: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5027: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5028: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5029: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5030: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5031:
5032: ghr_pay_calc.main_pay_calc (
5025: hr_utility.set_location(l_proc ||' to_staffing_differential: ' || p_sf52_data.to_staffing_differential, 16);
5026: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5027: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5028: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5029: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5030: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5031:
5032: ghr_pay_calc.main_pay_calc (
5033: p_person_id => p_sf52_data.person_id
5026: hr_utility.set_location(l_proc ||' to_au_overtime: ' || p_sf52_data.to_au_overtime, 17);
5027: hr_utility.set_location(l_proc ||' to_availability_pay: ' || p_sf52_data.to_availability_pay, 18);
5028: hr_utility.set_location(l_proc ||' to_ap_premium_pay_indicator: ' || p_sf52_data.to_ap_premium_pay_indicator, 19);
5029: hr_utility.set_location(l_proc ||' to_auo_premium_pay_indicator: ' || p_sf52_data.to_auo_premium_pay_indicator, 21);
5030: hr_utility.set_location(l_proc ||' to_retention_allowance: ' || p_sf52_data.to_retention_allowance, 22);
5031:
5032: ghr_pay_calc.main_pay_calc (
5033: p_person_id => p_sf52_data.person_id
5034: ,p_position_id => p_sf52_data.to_position_id
5086:
5087: -- Check if we had any warning messages
5088: -- Calculation not done.
5089: IF l_message_set THEN
5090: hr_utility.set_location( l_proc, 80);
5091: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5092: hr_utility.raise_error;
5093: END IF;
5094:
5087: -- Check if we had any warning messages
5088: -- Calculation not done.
5089: IF l_message_set THEN
5090: hr_utility.set_location( l_proc, 80);
5091: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5092: hr_utility.raise_error;
5093: END IF;
5094:
5095: IF l_calculated THEN
5088: -- Calculation not done.
5089: IF l_message_set THEN
5090: hr_utility.set_location( l_proc, 80);
5091: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5092: hr_utility.raise_error;
5093: END IF;
5094:
5095: IF l_calculated THEN
5096: hr_utility.set_location( l_proc, 50);
5092: hr_utility.raise_error;
5093: END IF;
5094:
5095: IF l_calculated THEN
5096: hr_utility.set_location( l_proc, 50);
5097: -- FWFA Changes Bug#4444609
5098: p_sf52_data.pay_rate_determinant := NVL(l_out_pay_rate_determinant,p_sf52_data.input_pay_rate_determinant);
5099: p_sf52_data.to_pay_table_identifier := l_calc_pay_table_id;
5100: -- FWFA Changes
5108: /*
5109: -- Be careful with setting 'other' pay if it is 'NE'
5110: IF get_other_pay_amount_pm <> 'NE' THEN
5111: -- Populate these values if required
5112: hr_utility.set_location( l_proc, 60);
5113: p_sf52_data.to_other_pay_amount := l_other_pay_amount;
5114: p_sf52_data.to_au_overtime := l_au_overtime;
5115: p_sf52_data.to_au_overtime := l_au_overtime;
5116: END IF;
5115: p_sf52_data.to_au_overtime := l_au_overtime;
5116: END IF;
5117: */
5118: IF l_out_step_or_rate IS NOT NULL THEN
5119: hr_utility.set_location( l_proc, 70);
5120: p_sf52_data.to_step_or_rate := l_out_step_or_rate;
5121: END IF;
5122: -- should this check be here?? This is not the same as the future action case
5123: -- where the pay calc is being run for the second time.
5127: -- GHR_99999_MANDT_COLM_NULL
5128: -- this must never be the case as this SF52 must have been
5129: -- validated at the time future action was saved.
5130: -- raise error
5131: hr_utility.set_location( l_proc, 80);
5132: hr_utility.set_message( 8301, 'GHR_99999_MANDT_COLM_NULL');
5133: hr_utility.raise_error;
5134: null;
5135: END IF;
5128: -- this must never be the case as this SF52 must have been
5129: -- validated at the time future action was saved.
5130: -- raise error
5131: hr_utility.set_location( l_proc, 80);
5132: hr_utility.set_message( 8301, 'GHR_99999_MANDT_COLM_NULL');
5133: hr_utility.raise_error;
5134: null;
5135: END IF;
5136: */
5129: -- validated at the time future action was saved.
5130: -- raise error
5131: hr_utility.set_location( l_proc, 80);
5132: hr_utility.set_message( 8301, 'GHR_99999_MANDT_COLM_NULL');
5133: hr_utility.raise_error;
5134: null;
5135: END IF;
5136: */
5137: ELSE
5137: ELSE
5138: -- GHR_99999_PC_FAILED
5139: -- ie Pay calc failed
5140: -- raise error. As values can not be entered interactively
5141: hr_utility.set_location( l_proc, 100);
5142: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5143: hr_utility.raise_error;
5144: null;
5145: END IF;
5138: -- GHR_99999_PC_FAILED
5139: -- ie Pay calc failed
5140: -- raise error. As values can not be entered interactively
5141: hr_utility.set_location( l_proc, 100);
5142: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5143: hr_utility.raise_error;
5144: null;
5145: END IF;
5146:
5139: -- ie Pay calc failed
5140: -- raise error. As values can not be entered interactively
5141: hr_utility.set_location( l_proc, 100);
5142: hr_utility.set_message( 8301, 'GHR_38416_PC_FAILED');
5143: hr_utility.raise_error;
5144: null;
5145: END IF;
5146:
5147: EXCEPTION
5149: -- Reset IN OUT parameters and set OUT parameters
5150:
5151: p_sf52_data := l_sf52_data ;
5152:
5153: hr_utility.set_location('Leaving ' || l_proc,60);
5154: RAISE;
5155:
5156: end derive_to_columns;
5157:
5190:
5191: print_sf52('Initial Data: ', p_sf52_data);
5192:
5193: -- fetch Shadow sf52 of original/root SF52;
5194: hr_utility.set_location('Entering ' || l_proc, 100);
5195: open c_sf52_shadow (p_sf52_data.pa_request_id);
5196: fetch c_sf52_shadow into l_shadow_data;
5197: if c_sf52_shadow%notfound then
5198: hr_utility.set_location(' Error, Shadow not found ' || l_proc, 101);
5194: hr_utility.set_location('Entering ' || l_proc, 100);
5195: open c_sf52_shadow (p_sf52_data.pa_request_id);
5196: fetch c_sf52_shadow into l_shadow_data;
5197: if c_sf52_shadow%notfound then
5198: hr_utility.set_location(' Error, Shadow not found ' || l_proc, 101);
5199: close c_sf52_shadow;
5200: hr_utility.set_message(8301,'GHR_38417_SHADOW_SF52_NOTFOUND');
5201: hr_utility.raise_error;
5202: else
5196: fetch c_sf52_shadow into l_shadow_data;
5197: if c_sf52_shadow%notfound then
5198: hr_utility.set_location(' Error, Shadow not found ' || l_proc, 101);
5199: close c_sf52_shadow;
5200: hr_utility.set_message(8301,'GHR_38417_SHADOW_SF52_NOTFOUND');
5201: hr_utility.raise_error;
5202: else
5203: close c_sf52_shadow ;
5204: end if;
5197: if c_sf52_shadow%notfound then
5198: hr_utility.set_location(' Error, Shadow not found ' || l_proc, 101);
5199: close c_sf52_shadow;
5200: hr_utility.set_message(8301,'GHR_38417_SHADOW_SF52_NOTFOUND');
5201: hr_utility.raise_error;
5202: else
5203: close c_sf52_shadow ;
5204: end if;
5205: -- convert shadow rg to SF52 format
5202: else
5203: close c_sf52_shadow ;
5204: end if;
5205: -- convert shadow rg to SF52 format
5206: hr_utility.set_location('Call Convert_shadoe_to_sf52 ' || l_proc, 110);
5207: ghr_history_conv_rg.convert_shadow_to_sf52 (
5208: p_shadow => l_shadow_data,
5209: p_sf52 => l_sf52_shadow);
5210:
5232: l_sf52_refresh_data.to_pay_plan := p_sf52_data.to_pay_plan;
5233: END IF;
5234:
5235: -- vsm
5236: hr_utility.set_location(l_proc, 120);
5237:
5238: -- Start Bug 1310894
5239: l_bef_basic_pay := p_sf52_data.from_basic_pay;
5240: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 135);
5236: hr_utility.set_location(l_proc, 120);
5237:
5238: -- Start Bug 1310894
5239: l_bef_basic_pay := p_sf52_data.from_basic_pay;
5240: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 135);
5241: -- End Bug 1310894
5242:
5243: refresh_pa_request
5244: (p_person_id => p_sf52_data.person_id,
5244: (p_person_id => p_sf52_data.person_id,
5245: p_effective_date => p_sf52_data.effective_date,
5246: p_sf52_data => l_sf52_refresh_data);
5247:
5248: hr_utility.set_location(l_proc, 130);
5249: print_sf52('refresh record before get_par: ', l_sf52_refresh_data);
5250:
5251: -- Call procedure to nullify NE/UE columns.
5252: get_par_ap_apue_fields( p_pa_req_in => l_sf52_refresh_data,
5270: p_shadow_rec => l_sf52_shadow,
5271: p_sf52_rec => p_sf52_data,
5272: p_changed => l_changed);
5273: if (l_changed) then
5274: hr_utility.set_location('REFRESH CHANGED SF52.' , 11999);
5275: end if;
5276: if (l_changed and p_process_type = 'FUTURE') then
5277: raise e_refresh;
5278: end if;
5278: end if;
5279: -- Bug#4709111 Reverted the fix done for 4680047. Commented the following code.
5280: -- Bug#4680047
5281: /* IF p_sf52_data.input_pay_rate_determinant <> l_sf52_refresh_data.pay_rate_determinant THEN
5282: hr_utility.set_location('FWFA RPA Input PRD: '||p_sf52_data.input_pay_rate_determinant,12000);
5283: hr_utility.set_location('FWFA Refresh PRD: '||l_sf52_refresh_data.pay_rate_determinant,13000);
5284: p_sf52_data.input_pay_rate_determinant := l_sf52_refresh_data.pay_rate_determinant;
5285: p_sf52_data.pay_rate_determinant := l_sf52_refresh_data.pay_rate_determinant;
5286: END IF; */
5279: -- Bug#4709111 Reverted the fix done for 4680047. Commented the following code.
5280: -- Bug#4680047
5281: /* IF p_sf52_data.input_pay_rate_determinant <> l_sf52_refresh_data.pay_rate_determinant THEN
5282: hr_utility.set_location('FWFA RPA Input PRD: '||p_sf52_data.input_pay_rate_determinant,12000);
5283: hr_utility.set_location('FWFA Refresh PRD: '||l_sf52_refresh_data.pay_rate_determinant,13000);
5284: p_sf52_data.input_pay_rate_determinant := l_sf52_refresh_data.pay_rate_determinant;
5285: p_sf52_data.pay_rate_determinant := l_sf52_refresh_data.pay_rate_determinant;
5286: END IF; */
5287: print_sf52('sf52 record after cascade: ', p_sf52_data);
5286: END IF; */
5287: print_sf52('sf52 record after cascade: ', p_sf52_data);
5288: print_sf52('shadow record after cascade: ', l_sf52_shadow);
5289: print_sf52('refresh record after cascade: ', l_sf52_refresh_data);
5290: hr_utility.set_location(l_proc, 150);
5291: -- Bug 3704438 - PTH Issue - Start
5292: IF p_sf52_data.work_schedule in ('F', 'G', 'B', 'I', 'J')
5293: and p_sf52_data.part_time_hours is not null then
5294: p_sf52_data.part_time_hours := null;
5301: ,p_assignment_id => p_sf52_data.employee_assignment_id
5302: ,p_effective_date => p_sf52_data.effective_date
5303: ,p_value => l_retention_allowance
5304: ,p_multiple_error_flag => l_multi_error_flag);
5305: hr_utility.set_location('Retention Allowance on Eff Date'||l_retention_allowance, 164);
5306: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
5307: ,p_input_value_name => 'Amount'
5308: ,p_assignment_id => p_sf52_data.employee_assignment_id
5309: ,p_effective_date => p_sf52_data.effective_date
5308: ,p_assignment_id => p_sf52_data.employee_assignment_id
5309: ,p_effective_date => p_sf52_data.effective_date
5310: ,p_value => l_supervisory_differential
5311: ,p_multiple_error_flag => l_multi_error_flag);
5312: hr_utility.set_location('Supervisory Differential on Eff Date'||l_supervisory_differential, 165);
5313: ghr_api.retrieve_element_entry_value (p_element_name => 'Staffing Differential'
5314: ,p_input_value_name => 'Amount'
5315: ,p_assignment_id => p_sf52_data.employee_assignment_id
5316: ,p_effective_date => p_sf52_data.effective_date
5315: ,p_assignment_id => p_sf52_data.employee_assignment_id
5316: ,p_effective_date => p_sf52_data.effective_date
5317: ,p_value => l_staffing_differential
5318: ,p_multiple_error_flag => l_multi_error_flag);
5319: hr_utility.set_location('Staffing Differential on Eff Date'||l_staffing_differential, 166);
5320:
5321: -- Start Bug 2633367
5322: IF p_sf52_data.first_noa_code in ('810') THEN
5323: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 160);
5319: hr_utility.set_location('Staffing Differential on Eff Date'||l_staffing_differential, 166);
5320:
5321: -- Start Bug 2633367
5322: IF p_sf52_data.first_noa_code in ('810') THEN
5323: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 160);
5324: hr_utility.set_location('to_basic_pay is '||p_sf52_data.to_basic_pay, 161);
5325: hr_utility.set_location('from_basic_pay is '||p_sf52_data.from_basic_pay, 162);
5326: IF nvl(p_sf52_data.from_basic_pay,0) <> nvl(l_bef_basic_pay,0) then
5327: IF p_sf52_data.to_retention_allow_percentage is not null then
5320:
5321: -- Start Bug 2633367
5322: IF p_sf52_data.first_noa_code in ('810') THEN
5323: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 160);
5324: hr_utility.set_location('to_basic_pay is '||p_sf52_data.to_basic_pay, 161);
5325: hr_utility.set_location('from_basic_pay is '||p_sf52_data.from_basic_pay, 162);
5326: IF nvl(p_sf52_data.from_basic_pay,0) <> nvl(l_bef_basic_pay,0) then
5327: IF p_sf52_data.to_retention_allow_percentage is not null then
5328:
5321: -- Start Bug 2633367
5322: IF p_sf52_data.first_noa_code in ('810') THEN
5323: hr_utility.set_location('l_bef_basic_pay is '||l_bef_basic_pay, 160);
5324: hr_utility.set_location('to_basic_pay is '||p_sf52_data.to_basic_pay, 161);
5325: hr_utility.set_location('from_basic_pay is '||p_sf52_data.from_basic_pay, 162);
5326: IF nvl(p_sf52_data.from_basic_pay,0) <> nvl(l_bef_basic_pay,0) then
5327: IF p_sf52_data.to_retention_allow_percentage is not null then
5328:
5329: -- Changed For FWS
5369: nvl(p_sf52_data.to_availability_pay,0) +
5370: nvl(p_sf52_data.to_retention_allowance,0) +
5371: nvl(p_sf52_data.to_supervisory_differential,0) +
5372: nvl(p_sf52_data.to_staffing_differential,0);
5373: hr_utility.set_location('Recalculated Other Pay is '||p_sf52_data.to_other_pay_amount, 166);
5374: if p_sf52_data.to_other_pay_amount = 0 then
5375: p_sf52_data.to_other_pay_amount := null;
5376: end if;
5377: -- End Bug 2633367
5380: /* Commenting this portion of code because recalculation of
5381: retention allowance included in ghr_pay_calc.main_pay_calc
5382: if nvl(p_sf52_data.from_basic_pay,0) <> nvl(p_sf52_data.to_basic_pay,0) and
5383: p_sf52_data.first_noa_code not in ('810','818','819') then
5384: hr_utility.set_location('Change in Basic Pay and Non Other Pay Action', 163);
5385: --Get the retention allowance and supervisory differential on that date
5386: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
5387: ,p_input_value_name => 'Amount'
5388: ,p_assignment_id => p_sf52_data.employee_assignment_id
5388: ,p_assignment_id => p_sf52_data.employee_assignment_id
5389: ,p_effective_date => p_sf52_data.effective_date
5390: ,p_value => l_retention_allowance
5391: ,p_multiple_error_flag => l_multi_error_flag);
5392: hr_utility.set_location('Retention Allowance on Eff Date'||l_retention_allowance, 164);
5393: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
5394: ,p_input_value_name => 'Amount'
5395: ,p_assignment_id => p_sf52_data.employee_assignment_id
5396: ,p_effective_date => p_sf52_data.effective_date
5395: ,p_assignment_id => p_sf52_data.employee_assignment_id
5396: ,p_effective_date => p_sf52_data.effective_date
5397: ,p_value => l_supervisory_differential
5398: ,p_multiple_error_flag => l_multi_error_flag);
5399: hr_utility.set_location('Supervisory Differential on Eff Date'||l_supervisory_differential, 165);
5400: if l_retention_allowance is null then
5401: p_sf52_data.to_retention_allowance := null;
5402: p_sf52_data.to_other_pay_amount := nvl(p_sf52_data.to_au_overtime,0) +
5403: nvl(p_sf52_data.to_availability_pay,0) +
5403: nvl(p_sf52_data.to_availability_pay,0) +
5404: nvl(p_sf52_data.to_retention_allowance,0) +
5405: nvl(p_sf52_data.to_supervisory_differential,0) +
5406: nvl(p_sf52_data.to_staffing_differential,0);
5407: hr_utility.set_location('Recalculated Other Pay is '||p_sf52_data.to_other_pay_amount, 166);
5408: end if;
5409: if l_supervisory_differential is null then
5410: p_sf52_data.to_supervisory_differential := null;
5411: p_sf52_data.to_other_pay_amount := nvl(p_sf52_data.to_au_overtime,0) +
5412: nvl(p_sf52_data.to_availability_pay,0) +
5413: nvl(p_sf52_data.to_retention_allowance,0) +
5414: nvl(p_sf52_data.to_supervisory_differential,0) +
5415: nvl(p_sf52_data.to_staffing_differential,0);
5416: hr_utility.set_location('Recalculated Other Pay is '||p_sf52_data.to_other_pay_amount, 167);
5417: end if;
5418: if p_sf52_data.to_other_pay_amount = 0 then
5419: p_sf52_data.to_other_pay_amount := null;
5420: end if;
5427: redo_Pay_calc ( p_sf52_rec => p_sf52_data,
5428: p_capped_other_pay => l_capped_other_pay);
5429: END IF;
5430:
5431: hr_utility.set_location(l_proc, 170);
5432: ghr_history_conv_rg.convert_sf52_to_shadow (
5433: p_shadow => p_shadow_data,
5434: p_sf52 => l_sf52_shadow);
5435:
5432: ghr_history_conv_rg.convert_sf52_to_shadow (
5433: p_shadow => p_shadow_data,
5434: p_sf52 => l_sf52_shadow);
5435:
5436: hr_utility.set_location('Leaving : ' || l_proc, 180);
5437:
5438: EXCEPTION
5439: WHEN others THEN
5440: -- Reset IN OUT parameters and set OUT parameters
5441:
5442: p_sf52_data := l_sf52_data ;
5443: p_shadow_data :=NULL ;
5444:
5445: hr_utility.set_location('Leaving ' || l_proc,160);
5446: RAISE;
5447:
5448: End refresh_req_shadow ;
5449:
5475: Begin
5476: l_capped_other_pay := p_capped_other_pay; --NOCOPY Changes
5477: l_sf52_rec := p_sf52_rec ;
5478:
5479: hr_utility.set_location( 'Entering : ' || l_proc,10);
5480:
5481: print_sf52('Before redo_pay : ' , p_sf52_rec);
5482: If nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2)
5483: in ('APP', 'CHG_DUTY_STATION', 'CONV_APP', 'POS_CHG',
5486: then
5487: -- and (p_sf52_rec.first_noa_code <> '899') and
5488: -- not (p_sf52_rec.first_noa_code = '002' and
5489: -- p_sf52_rec.second_noa_code = '899')
5490: hr_utility.set_location('Valid Family ' || l_proc, 11);
5491: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5492: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5493: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5494: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5488: -- not (p_sf52_rec.first_noa_code = '002' and
5489: -- p_sf52_rec.second_noa_code = '899')
5490: hr_utility.set_location('Valid Family ' || l_proc, 11);
5491: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5492: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5493: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5494: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5495: l_pay_calc_in_rec.pa_request_id := p_sf52_rec.pa_request_id;
5496: l_pay_calc_in_rec.person_id := p_sf52_rec.person_id;
5489: -- p_sf52_rec.second_noa_code = '899')
5490: hr_utility.set_location('Valid Family ' || l_proc, 11);
5491: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5492: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5493: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5494: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5495: l_pay_calc_in_rec.pa_request_id := p_sf52_rec.pa_request_id;
5496: l_pay_calc_in_rec.person_id := p_sf52_rec.person_id;
5497: l_pay_calc_in_rec.position_id := p_sf52_rec.to_position_id;
5490: hr_utility.set_location('Valid Family ' || l_proc, 11);
5491: If nvl(p_sf52_rec.custom_pay_calc_flag,hr_api.g_varchar2) <> 'Y' then
5492: hr_utility.set_location('Custom Pay Calc is NOT Y ' || l_proc, 12);
5493: hr_utility.set_location('Input PRD : '||p_sf52_rec.input_pay_rate_determinant, 14);
5494: hr_utility.set_location('PRD : '||p_sf52_rec.pay_rate_determinant, 14);
5495: l_pay_calc_in_rec.pa_request_id := p_sf52_rec.pa_request_id;
5496: l_pay_calc_in_rec.person_id := p_sf52_rec.person_id;
5497: l_pay_calc_in_rec.position_id := p_sf52_rec.to_position_id;
5498: l_pay_calc_in_rec.noa_family_code := p_sf52_rec.noa_family_code;
5543: IF p_sf52_rec.noa_family_code like 'GHR_SAL%' AND
5544: p_sf52_rec.pay_rate_determinant IN ('3','4','J','K','U','V') AND
5545: p_sf52_rec.effective_date >= to_date('01/05/2005','dd/mm/yyyy') THEN
5546: l_pay_calc_in_rec.retention_allowance := p_sf52_rec.to_retention_allowance;
5547: hr_utility.set_location('setting retention - fwfa ' || p_sf52_rec.to_retention_allowance,120);
5548: ELSE
5549: ghr_api.retrieve_element_entry_value
5550: (p_element_name => 'Retention Allowance'
5551: ,p_input_value_name => 'Amount'
5566: l_pay_calc_in_rec.current_basic_pay := p_sf52_rec.from_basic_pay;
5567: l_pay_calc_in_rec.current_adj_basic_pay := p_sf52_rec.from_adj_basic_pay;
5568: l_pay_calc_in_rec.current_step_or_rate := p_sf52_rec.from_step_or_rate;
5569:
5570: hr_utility.set_location('Before Main Pay Calc ' || l_proc, 13);
5571: hr_utility.set_location('Pay Calc In PRD : '||l_pay_calc_in_rec.pay_rate_determinant, 14);
5572:
5573: ghr_pay_calc.sql_main_pay_calc
5574: ( p_pay_calc_data => l_pay_calc_in_rec,
5567: l_pay_calc_in_rec.current_adj_basic_pay := p_sf52_rec.from_adj_basic_pay;
5568: l_pay_calc_in_rec.current_step_or_rate := p_sf52_rec.from_step_or_rate;
5569:
5570: hr_utility.set_location('Before Main Pay Calc ' || l_proc, 13);
5571: hr_utility.set_location('Pay Calc In PRD : '||l_pay_calc_in_rec.pay_rate_determinant, 14);
5572:
5573: ghr_pay_calc.sql_main_pay_calc
5574: ( p_pay_calc_data => l_pay_calc_in_rec,
5575: p_pay_calc_out_data => l_pay_calc_out_rec,
5576: p_message_set => l_message_set,
5577: p_calculated => l_calculated
5578: );
5579:
5580: hr_utility.set_location('After Main Pay Calc ' || l_proc, 13);
5581: if l_calculated then
5582: hr_utility.set_location('l_Calculated is TRUE ' || l_proc, 13);
5583: else
5584: hr_utility.set_location('l_Calculated is FASLE ' || l_proc, 13);
5578: );
5579:
5580: hr_utility.set_location('After Main Pay Calc ' || l_proc, 13);
5581: if l_calculated then
5582: hr_utility.set_location('l_Calculated is TRUE ' || l_proc, 13);
5583: else
5584: hr_utility.set_location('l_Calculated is FASLE ' || l_proc, 13);
5585: end if;
5586: If not nvl(l_pay_calc_out_rec.open_pay_fields, FALSE) then
5580: hr_utility.set_location('After Main Pay Calc ' || l_proc, 13);
5581: if l_calculated then
5582: hr_utility.set_location('l_Calculated is TRUE ' || l_proc, 13);
5583: else
5584: hr_utility.set_location('l_Calculated is FASLE ' || l_proc, 13);
5585: end if;
5586: If not nvl(l_pay_calc_out_rec.open_pay_fields, FALSE) then
5587: hr_utility.set_location('pay fields not open',1);
5588:
5583: else
5584: hr_utility.set_location('l_Calculated is FASLE ' || l_proc, 13);
5585: end if;
5586: If not nvl(l_pay_calc_out_rec.open_pay_fields, FALSE) then
5587: hr_utility.set_location('pay fields not open',1);
5588:
5589: If l_calculated then
5590: -- assign
5591: hr_utility.set_location( ' Not Custom Pay Calc : ' || l_proc,12);
5587: hr_utility.set_location('pay fields not open',1);
5588:
5589: If l_calculated then
5590: -- assign
5591: hr_utility.set_location( ' Not Custom Pay Calc : ' || l_proc,12);
5592:
5593: p_sf52_rec.custom_pay_calc_flag := 'N';
5594: -- FWFA Changes Bug#4444609
5595: p_sf52_rec.from_pay_table_identifier := l_pay_calc_out_rec.pay_table_id;
5609: g_step_or_rate := l_pay_calc_out_rec.out_step_or_rate;
5610: IF g_prd is NOT NULL THEN
5611: IF l_pay_calc_out_rec.out_step_or_rate IS NOT NULL THEN
5612: IF nvl(g_prd,'0') not in ('A','B','E','F','U','V') THEN
5613: hr_utility.set_location('Inside G_prd condition',10);
5614: p_sf52_rec.to_step_or_rate :=
5615: NVL(l_pay_calc_out_rec.out_step_or_rate, p_sf52_rec.to_step_or_rate);
5616: ----Bug 2914406 fix start
5617: p_sf52_rec.pay_rate_determinant :=
5618: NVL(l_pay_calc_out_rec.out_pay_rate_determinant, p_sf52_rec.pay_rate_determinant);
5619: ----Bug 2914406 fix End
5620: END IF;
5621: ELSE
5622: hr_utility.set_location('Inside G_prd condition and g_step null',10);
5623: p_sf52_rec.pay_rate_determinant :=
5624: NVL(l_pay_calc_out_rec.out_pay_rate_determinant, p_sf52_rec.pay_rate_determinant);
5625: END IF;
5626: ELSE
5623: p_sf52_rec.pay_rate_determinant :=
5624: NVL(l_pay_calc_out_rec.out_pay_rate_determinant, p_sf52_rec.pay_rate_determinant);
5625: END IF;
5626: ELSE
5627: hr_utility.set_location('Inside G_prd NULL condition',10);
5628: -- FWFA Changes Bug#4444609 Modified the value of PRD.
5629: p_sf52_rec.pay_rate_determinant :=
5630: NVL(p_sf52_rec.input_pay_rate_determinant, p_sf52_rec.pay_rate_determinant);
5631: -- FWFA Changes
5633: NVL(l_pay_calc_out_rec.out_step_or_rate, p_sf52_rec.to_step_or_rate);
5634: END IF;
5635: ELSE
5636: -- FWFA Changes Bug#4444609 Modified the value of PRD
5637: hr_utility.set_location('inside NON 894 Actions ',20);
5638: p_sf52_rec.pay_rate_determinant :=
5639: NVL(l_pay_calc_out_rec.out_pay_rate_determinant,
5640: NVL(p_sf52_rec.input_pay_rate_determinant,p_sf52_rec.pay_rate_determinant)
5641: );
5645: END IF;
5646: -- End Processing for bug 2684176
5647: End if;
5648: Elsif l_pay_calc_out_rec.open_pay_fields then
5649: hr_utility.set_location('open pay fields',1);
5650: hr_utility.set_location( 'Error - Pay Calc failed ' || l_proc, 90);
5651: hr_utility.set_message(8301,'GHR_38401_OPEN_PAY');
5652: hr_utility.raise_error;
5653: -- error; -- send back to user
5646: -- End Processing for bug 2684176
5647: End if;
5648: Elsif l_pay_calc_out_rec.open_pay_fields then
5649: hr_utility.set_location('open pay fields',1);
5650: hr_utility.set_location( 'Error - Pay Calc failed ' || l_proc, 90);
5651: hr_utility.set_message(8301,'GHR_38401_OPEN_PAY');
5652: hr_utility.raise_error;
5653: -- error; -- send back to user
5654:
5647: End if;
5648: Elsif l_pay_calc_out_rec.open_pay_fields then
5649: hr_utility.set_location('open pay fields',1);
5650: hr_utility.set_location( 'Error - Pay Calc failed ' || l_proc, 90);
5651: hr_utility.set_message(8301,'GHR_38401_OPEN_PAY');
5652: hr_utility.raise_error;
5653: -- error; -- send back to user
5654:
5655: End if;
5648: Elsif l_pay_calc_out_rec.open_pay_fields then
5649: hr_utility.set_location('open pay fields',1);
5650: hr_utility.set_location( 'Error - Pay Calc failed ' || l_proc, 90);
5651: hr_utility.set_message(8301,'GHR_38401_OPEN_PAY');
5652: hr_utility.raise_error;
5653: -- error; -- send back to user
5654:
5655: End if;
5656: End if;
5657: Elsif nvl(p_sf52_rec.noa_family_code,hr_api.g_varchar2) = 'OTHER_PAY'
5658: then
5659: -- and (p_sf52_rec.first_noa_code <> '899') and not (p_sf52_rec.first_noa_code = '002' and
5660: -- p_sf52_rec.second_noa_code = '899')
5661: hr_utility.set_location( 'Other Pay Calculation ' || l_proc, 95);
5662: -- fOR OTHER PAY family calculate other_pay_amount and total_pay_amount
5663: p_sf52_rec.to_other_pay_amount := nvl(p_sf52_rec.to_au_overtime , 0) +
5664: nvl(p_sf52_rec.to_availability_pay , 0) +
5665: nvl(p_sf52_rec.to_retention_allowance , 0) +
5671:
5672: End if;
5673: -- VSM temp call
5674: -- Begin Update 34 - Validation Logic
5675: hr_utility.set_location( 'Before calling do_pay_caps_main noa_family_code is ' ||p_sf52_rec.noa_family_code, 95);
5676: ghr_history_api.get_g_session_var( l_session_var);
5677: -- Bug#4486823 RRR Changes. Added GHR_INCENTIVE Family also.
5678: IF not (p_sf52_rec.noa_family_code in
5679: ('POS_REVIEW',
5687: /*BUG 7186053 Commented the below line as it is not required. Code in the if clause should not run for
5688: all the NOA Families mentioned in the condition. */
5689: -- AND l_session_var.noa_id_correct is not NULL) THEN
5690: ) THEN
5691: hr_utility.set_location( 'Before calling do_pay_caps_main ' ||p_capped_other_pay , 95);
5692: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5693: IF p_capped_other_pay <> hr_api.g_number OR
5694: p_capped_other_pay is NULL THEN
5695: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5688: all the NOA Families mentioned in the condition. */
5689: -- AND l_session_var.noa_id_correct is not NULL) THEN
5690: ) THEN
5691: hr_utility.set_location( 'Before calling do_pay_caps_main ' ||p_capped_other_pay , 95);
5692: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5693: IF p_capped_other_pay <> hr_api.g_number OR
5694: p_capped_other_pay is NULL THEN
5695: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5696:
5691: hr_utility.set_location( 'Before calling do_pay_caps_main ' ||p_capped_other_pay , 95);
5692: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5693: IF p_capped_other_pay <> hr_api.g_number OR
5694: p_capped_other_pay is NULL THEN
5695: hr_utility.set_location( 'p_sf52_rec.to_total_salary is ' || p_sf52_rec.to_total_salary, 95);
5696:
5697: ghr_pay_caps.do_pay_caps_main (
5698: p_pa_request_id => p_sf52_rec.pa_request_id,
5699: p_effective_date => NVL(p_sf52_rec.effective_date,TRUNC(sysdate)) ,
5728:
5729: l_temp_ret_allo_percentage := trunc((l_temp_retention_allowance/p_sf52_rec.to_basic_pay)*100,2);
5730:
5731: if l_pay_cap_message then
5732: hr_utility.raise_error;
5733: -- This would show the error message with tokens passed with
5734: -- the values from the sub-program called above - do_pay_caps_main.
5735: -- So no need to explicitly again initiate the error message
5736: -- and set of the tokens seperately. Earlier 38893 message was called here.
5743:
5744: -- End Update 34 - Validation Logic
5745: print_sf52('After redo_pay : ' , p_sf52_rec);
5746:
5747: hr_utility.set_location( 'Leaving : ' || l_proc,100);
5748:
5749: EXCEPTION
5750: WHEN others THEN
5751: -- Reset IN OUT parameters and set OUT parameters
5752:
5753: p_capped_other_pay := l_capped_other_pay;
5754: p_sf52_rec := l_sf52_rec ;
5755:
5756: hr_utility.set_location('Leaving ' || l_proc,101);
5757: RAISE;
5758:
5759: End redo_pay_calc;
5760:
6036: -- Reset IN OUT parameters and set OUT parameters
6037:
6038: p_sf52_data := l_sf52_data ;
6039:
6040: hr_utility.set_location('Leaving Update_rfrs_values ' ,160);
6041: RAISE;
6042:
6043: End Update_rfrs_values;
6044:
6289: -- Reset IN OUT parameters and set OUT parameters
6290:
6291: p_result := NULL;
6292:
6293: hr_utility.set_location('Leaving Update_Shadow_row ' ,100);
6294: RAISE;
6295:
6296: end update_shadow_row;
6297:
6297:
6298: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE)
6299: IS
6300: BEGIN
6301: hr_utility.set_location ('-----------------------------------------------', 10);
6302: hr_utility.set_location (p_proc, 20);
6303: hr_utility.set_location ('-----------------------------------------------', 30);
6304: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6305: , 40);
6298: procedure print_sf52(p_proc VARCHAR2, p_pa_request_rec GHR_PA_REQUESTS%ROWTYPE)
6299: IS
6300: BEGIN
6301: hr_utility.set_location ('-----------------------------------------------', 10);
6302: hr_utility.set_location (p_proc, 20);
6303: hr_utility.set_location ('-----------------------------------------------', 30);
6304: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6305: , 40);
6306: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6299: IS
6300: BEGIN
6301: hr_utility.set_location ('-----------------------------------------------', 10);
6302: hr_utility.set_location (p_proc, 20);
6303: hr_utility.set_location ('-----------------------------------------------', 30);
6304: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6305: , 40);
6306: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6307: , 50);
6300: BEGIN
6301: hr_utility.set_location ('-----------------------------------------------', 10);
6302: hr_utility.set_location (p_proc, 20);
6303: hr_utility.set_location ('-----------------------------------------------', 30);
6304: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6305: , 40);
6306: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6307: , 50);
6308: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6302: hr_utility.set_location (p_proc, 20);
6303: hr_utility.set_location ('-----------------------------------------------', 30);
6304: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6305: , 40);
6306: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6307: , 50);
6308: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6309: , 60);
6310: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6304: hr_utility.set_location(p_proc||'.pa_request_id '||p_pa_request_rec.pa_request_id
6305: , 40);
6306: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6307: , 50);
6308: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6309: , 60);
6310: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6311: , 70);
6312: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6306: hr_utility.set_location(p_proc||'.pa_notification_id '||p_pa_request_rec.pa_notification_id
6307: , 50);
6308: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6309: , 60);
6310: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6311: , 70);
6312: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6313: , 90);
6314: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6308: hr_utility.set_location(p_proc||'.noa_family_code '||p_pa_request_rec.noa_family_code
6309: , 60);
6310: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6311: , 70);
6312: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6313: , 90);
6314: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6315: , 100);
6316: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6310: hr_utility.set_location(p_proc||'.routing_group_id '||p_pa_request_rec.routing_group_id
6311: , 70);
6312: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6313: , 90);
6314: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6315: , 100);
6316: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6317: , 110);
6318: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6312: hr_utility.set_location(p_proc||'.academic_discipline '||p_pa_request_rec.academic_discipline
6313: , 90);
6314: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6315: , 100);
6316: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6317: , 110);
6318: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6319: , 120);
6320: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6314: hr_utility.set_location(p_proc||'.additional_info_person_id '||p_pa_request_rec.additional_info_person_id
6315: , 100);
6316: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6317: , 110);
6318: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6319: , 120);
6320: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6321: , 130);
6322: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6316: hr_utility.set_location(p_proc||'.additional_info_tel_number '||SUBSTR(p_pa_request_rec.additional_info_tel_number,1,40)
6317: , 110);
6318: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6319: , 120);
6320: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6321: , 130);
6322: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6323: , 140);
6324: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6318: hr_utility.set_location(p_proc||'.agency_code '||p_pa_request_rec.agency_code
6319: , 120);
6320: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6321: , 130);
6322: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6323: , 140);
6324: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6325: , 150);
6326: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6320: hr_utility.set_location(p_proc||'.altered_pa_request_id '||p_pa_request_rec.altered_pa_request_id
6321: , 130);
6322: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6323: , 140);
6324: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6325: , 150);
6326: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6327: , 160);
6328: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6322: hr_utility.set_location(p_proc||'.annuitant_indicator '||p_pa_request_rec.annuitant_indicator
6323: , 140);
6324: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6325: , 150);
6326: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6327: , 160);
6328: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6329: , 170);
6330: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6324: hr_utility.set_location(p_proc||'.annuitant_indicator_desc '||substr(p_pa_request_rec.annuitant_indicator_desc,1,40)
6325: , 150);
6326: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6327: , 160);
6328: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6329: , 170);
6330: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6331: , 180);
6332: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6326: hr_utility.set_location(p_proc||'.appropriation_code1 '||p_pa_request_rec.appropriation_code1
6327: , 160);
6328: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6329: , 170);
6330: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6331: , 180);
6332: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6333: , 190);
6334: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6328: hr_utility.set_location(p_proc||'.appropriation_code2 '||p_pa_request_rec.appropriation_code2
6329: , 170);
6330: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6331: , 180);
6332: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6333: , 190);
6334: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6335: , 200);
6336: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6330: hr_utility.set_location(p_proc||'.approval_date '||p_pa_request_rec.approval_date
6331: , 180);
6332: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6333: , 190);
6334: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6335: , 200);
6336: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6337: , 210);
6338: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6332: hr_utility.set_location(p_proc||'.approving_official_work_title '||substr(p_pa_request_rec.approving_official_work_title,1,40)
6333: , 190);
6334: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6335: , 200);
6336: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6337: , 210);
6338: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6339: , 220);
6340: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6334: hr_utility.set_location(p_proc||'.authorized_by_person_id '||p_pa_request_rec.authorized_by_person_id
6335: , 200);
6336: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6337: , 210);
6338: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6339: , 220);
6340: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6341: , 230);
6342: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6336: hr_utility.set_location(p_proc||'.authorized_by_title '||substr(p_pa_request_rec.authorized_by_title,1,40)
6337: , 210);
6338: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6339: , 220);
6340: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6341: , 230);
6342: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6343: , 240);
6344: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6338: hr_utility.set_location(p_proc||'.award_amount '||p_pa_request_rec.award_amount
6339: , 220);
6340: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6341: , 230);
6342: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6343: , 240);
6344: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6345: , 250);
6346: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6340: hr_utility.set_location(p_proc||'.award_uom '||p_pa_request_rec.award_uom
6341: , 230);
6342: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6343: , 240);
6344: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6345: , 250);
6346: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6347: , 260);
6348: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6342: hr_utility.set_location(p_proc||'.bargaining_unit_status '||p_pa_request_rec.bargaining_unit_status
6343: , 240);
6344: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6345: , 250);
6346: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6347: , 260);
6348: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6349: , 270);
6350: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6344: hr_utility.set_location(p_proc||'.citizenship '||p_pa_request_rec.citizenship
6345: , 250);
6346: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6347: , 260);
6348: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6349: , 270);
6350: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6351: , 280);
6352: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6346: hr_utility.set_location(p_proc||'.concurrence_date '||p_pa_request_rec.concurrence_date
6347: , 260);
6348: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6349: , 270);
6350: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6351: , 280);
6352: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6353: , 290);
6354: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6348: hr_utility.set_location(p_proc||'.custom_pay_calc_flag '||p_pa_request_rec.custom_pay_calc_flag
6349: , 270);
6350: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6351: , 280);
6352: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6353: , 290);
6354: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6355: , 300);
6356: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6350: hr_utility.set_location(p_proc||'.duty_station_code '||p_pa_request_rec.duty_station_code
6351: , 280);
6352: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6353: , 290);
6354: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6355: , 300);
6356: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6357: , 310);
6358: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6352: hr_utility.set_location(p_proc||'.duty_station_desc '||substr(p_pa_request_rec.duty_station_desc,1,40)
6353: , 290);
6354: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6355: , 300);
6356: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6357: , 310);
6358: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6359: , 320);
6360: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6354: hr_utility.set_location(p_proc||'.duty_station_id '||p_pa_request_rec.duty_station_id
6355: , 300);
6356: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6357: , 310);
6358: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6359: , 320);
6360: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6361: , 330);
6362: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6356: hr_utility.set_location(p_proc||'.duty_station_location_id '||p_pa_request_rec.duty_station_location_id
6357: , 310);
6358: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6359: , 320);
6360: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6361: , 330);
6362: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6363: , 340);
6364: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6358: hr_utility.set_location(p_proc||'.education_level '||p_pa_request_rec.education_level
6359: , 320);
6360: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6361: , 330);
6362: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6363: , 340);
6364: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6365: , 350);
6366: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6360: hr_utility.set_location(p_proc||'.effective_date '||p_pa_request_rec.effective_date
6361: , 330);
6362: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6363: , 340);
6364: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6365: , 350);
6366: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6367: , 360);
6368: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6362: hr_utility.set_location(p_proc||'.employee_assignment_id '||p_pa_request_rec.employee_assignment_id
6363: , 340);
6364: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6365: , 350);
6366: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6367: , 360);
6368: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6369: , 370);
6370: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6364: hr_utility.set_location(p_proc||'.employee_date_of_birth '||p_pa_request_rec.employee_date_of_birth
6365: , 350);
6366: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6367: , 360);
6368: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6369: , 370);
6370: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6371: , 380);
6372: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6366: hr_utility.set_location(p_proc||'.employee_dept_or_agency '||substr(p_pa_request_rec.employee_dept_or_agency,1,40)
6367: , 360);
6368: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6369: , 370);
6370: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6371: , 380);
6372: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6373: , 390);
6374: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6368: hr_utility.set_location(p_proc||'.employee_first_name '||substr(p_pa_request_rec.employee_first_name,1,40)
6369: , 370);
6370: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6371: , 380);
6372: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6373: , 390);
6374: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6375: , 400);
6376: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6370: hr_utility.set_location(p_proc||'.employee_last_name '||substr(p_pa_request_rec.employee_last_name,1,40)
6371: , 380);
6372: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6373: , 390);
6374: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6375: , 400);
6376: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6377: , 410);
6378: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6372: hr_utility.set_location(p_proc||'.employee_middle_names '||substr(p_pa_request_rec.employee_middle_names,1,40)
6373: , 390);
6374: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6375: , 400);
6376: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6377: , 410);
6378: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6379: , 420);
6380: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6374: hr_utility.set_location(p_proc||'.employee_national_identifier '||p_pa_request_rec.employee_national_identifier
6375: , 400);
6376: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6377: , 410);
6378: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6379: , 420);
6380: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6381: , 430);
6382: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6376: hr_utility.set_location(p_proc||'.fegli '||p_pa_request_rec.fegli
6377: , 410);
6378: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6379: , 420);
6380: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6381: , 430);
6382: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6383: , 440);
6384: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6378: hr_utility.set_location(p_proc||'.fegli_desc '||substr(p_pa_request_rec.fegli_desc,1,40)
6379: , 420);
6380: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6381: , 430);
6382: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6383: , 440);
6384: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6385: , 450);
6386: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6380: hr_utility.set_location(p_proc||'.first_action_la_code1 '||p_pa_request_rec.first_action_la_code1
6381: , 430);
6382: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6383: , 440);
6384: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6385: , 450);
6386: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6387: , 460);
6388: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6382: hr_utility.set_location(p_proc||'.first_action_la_code2 '||p_pa_request_rec.first_action_la_code2
6383: , 440);
6384: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6385: , 450);
6386: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6387: , 460);
6388: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6389: , 470);
6390: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6384: hr_utility.set_location(p_proc||'.first_action_la_desc1 '||substr(p_pa_request_rec.first_action_la_desc1,1,40)
6385: , 450);
6386: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6387: , 460);
6388: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6389: , 470);
6390: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6391: , 480);
6392: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6386: hr_utility.set_location(p_proc||'.first_action_la_desc2 '||substr(p_pa_request_rec.first_action_la_desc2,1,40)
6387: , 460);
6388: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6389: , 470);
6390: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6391: , 480);
6392: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6393: , 490);
6394: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6388: hr_utility.set_location(p_proc||'.first_noa_cancel_or_correct '||p_pa_request_rec.first_noa_cancel_or_correct
6389: , 470);
6390: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6391: , 480);
6392: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6393: , 490);
6394: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6395: , 500);
6396: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6390: hr_utility.set_location(p_proc||'.first_noa_code '||p_pa_request_rec.first_noa_code
6391: , 480);
6392: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6393: , 490);
6394: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6395: , 500);
6396: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6397: , 510);
6398: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6392: hr_utility.set_location(p_proc||'.first_noa_desc '||substr(p_pa_request_rec.first_noa_desc,1,40)
6393: , 490);
6394: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6395: , 500);
6396: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6397: , 510);
6398: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6399: , 520);
6400: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6394: hr_utility.set_location(p_proc||'.first_noa_id '||p_pa_request_rec.first_noa_id
6395: , 500);
6396: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6397: , 510);
6398: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6399: , 520);
6400: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6401: , 530);
6402: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6396: hr_utility.set_location(p_proc||'.first_noa_pa_request_id '||p_pa_request_rec.first_noa_pa_request_id
6397: , 510);
6398: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6399: , 520);
6400: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6401: , 530);
6402: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6403: , 540);
6404: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6398: hr_utility.set_location(p_proc||'.flsa_category '||p_pa_request_rec.flsa_category
6399: , 520);
6400: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6401: , 530);
6402: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6403: , 540);
6404: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6405: , 550);
6406: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6400: hr_utility.set_location(p_proc||'.forwarding_address_line1 '||substr(p_pa_request_rec.forwarding_address_line1,1,40)
6401: , 530);
6402: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6403: , 540);
6404: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6405: , 550);
6406: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6407: , 560);
6408: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6402: hr_utility.set_location(p_proc||'.forwarding_address_line2 '||substr(p_pa_request_rec.forwarding_address_line2,1,40)
6403: , 540);
6404: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6405: , 550);
6406: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6407: , 560);
6408: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6409: , 570);
6410: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6404: hr_utility.set_location(p_proc||'.forwarding_address_line3 '||substr(p_pa_request_rec.forwarding_address_line3,1,40)
6405: , 550);
6406: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6407: , 560);
6408: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6409: , 570);
6410: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6411: , 580);
6412: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6406: hr_utility.set_location(p_proc||'.forwarding_country '||substr(p_pa_request_rec.forwarding_country,1,40)
6407: , 560);
6408: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6409: , 570);
6410: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6411: , 580);
6412: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6413: , 590);
6414: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6408: hr_utility.set_location(p_proc||'.forwarding_country_short_name '||substr(p_pa_request_rec.forwarding_country_short_name,1,40)
6409: , 570);
6410: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6411: , 580);
6412: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6413: , 590);
6414: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6415: , 600);
6416: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6410: hr_utility.set_location(p_proc||'.forwarding_postal_code '||p_pa_request_rec.forwarding_postal_code
6411: , 580);
6412: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6413: , 590);
6414: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6415: , 600);
6416: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6417: , 610);
6418: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6412: hr_utility.set_location(p_proc||'.forwarding_region_2 '||substr(p_pa_request_rec.forwarding_region_2,1,40)
6413: , 590);
6414: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6415: , 600);
6416: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6417: , 610);
6418: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6419: , 610);
6420: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6414: hr_utility.set_location(p_proc||'.forwarding_town_or_city '||p_pa_request_rec.forwarding_town_or_city
6415: , 600);
6416: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6417: , 610);
6418: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6419: , 610);
6420: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6421: , 610);
6422: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6416: hr_utility.set_location(p_proc||'.from_adj_basic_pay '||p_pa_request_rec.from_adj_basic_pay
6417: , 610);
6418: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6419: , 610);
6420: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6421: , 610);
6422: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6423: , 610);
6424: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6418: hr_utility.set_location(p_proc||'.from_agency_code '||p_pa_request_rec.from_agency_code
6419: , 610);
6420: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6421: , 610);
6422: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6423: , 610);
6424: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6425: , 610);
6426: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6420: hr_utility.set_location(p_proc||'.from_agency_desc '||substr(p_pa_request_rec.from_agency_desc,1,40)
6421: , 610);
6422: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6423: , 610);
6424: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6425: , 610);
6426: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6427: , 610);
6428: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6422: hr_utility.set_location(p_proc||'.from_basic_pay '||p_pa_request_rec.from_basic_pay
6423: , 610);
6424: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6425: , 610);
6426: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6427: , 610);
6428: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6429: , 610);
6430: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6424: hr_utility.set_location(p_proc||'.from_grade_or_level '||p_pa_request_rec.from_grade_or_level
6425: , 610);
6426: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6427: , 610);
6428: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6429: , 610);
6430: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6431: , 610);
6432: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6426: hr_utility.set_location(p_proc||'.from_locality_adj '||p_pa_request_rec.from_locality_adj
6427: , 610);
6428: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6429: , 610);
6430: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6431: , 610);
6432: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6433: , 610);
6434: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6428: hr_utility.set_location(p_proc||'.from_occ_code '||substr(p_pa_request_rec.from_occ_code,1,40)
6429: , 610);
6430: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6431: , 610);
6432: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6433: , 610);
6434: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6435: , 710);
6436: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6430: hr_utility.set_location(p_proc||'.from_office_symbol '||p_pa_request_rec.from_office_symbol
6431: , 610);
6432: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6433: , 610);
6434: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6435: , 710);
6436: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6437: , 710);
6438: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6432: hr_utility.set_location(p_proc||'.from_other_pay_amount '||p_pa_request_rec.from_other_pay_amount
6433: , 610);
6434: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6435: , 710);
6436: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6437: , 710);
6438: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6439: --, 710);
6440: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6434: hr_utility.set_location(p_proc||'.from_pay_basis '||p_pa_request_rec.from_pay_basis
6435: , 710);
6436: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6437: , 710);
6438: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6439: --, 710);
6440: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6441: , 710);
6442: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6436: hr_utility.set_location(p_proc||'.from_pay_plan '||p_pa_request_rec.from_pay_plan
6437: , 710);
6438: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6439: --, 710);
6440: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6441: , 710);
6442: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6443: , 710);
6444: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6438: --hr_utility.set_location(p_proc||'.from_pay_table_id '||to_char(p_pa_request_rec.from_pay_table_identifier)
6439: --, 710);
6440: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6441: , 710);
6442: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6443: , 710);
6444: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6445: , 710);
6446: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6440: hr_utility.set_location(p_proc||'.from_position_id '||p_pa_request_rec.from_position_id
6441: , 710);
6442: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6443: , 710);
6444: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6445: , 710);
6446: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6447: , 710);
6448: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6442: hr_utility.set_location(p_proc||'.from_position_org_line1 '||p_pa_request_rec.from_position_org_line1
6443: , 710);
6444: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6445: , 710);
6446: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6447: , 710);
6448: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6449: , 710);
6450: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6444: hr_utility.set_location(p_proc||'.from_position_org_line2 '||p_pa_request_rec.from_position_org_line2
6445: , 710);
6446: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6447: , 710);
6448: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6449: , 710);
6450: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6451: , 710);
6452: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6446: hr_utility.set_location(p_proc||'.from_position_org_line3 '||p_pa_request_rec.from_position_org_line3
6447: , 710);
6448: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6449: , 710);
6450: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6451: , 710);
6452: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6453: , 710);
6454: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6448: hr_utility.set_location(p_proc||'.from_position_org_line4 '||p_pa_request_rec.from_position_org_line4
6449: , 710);
6450: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6451: , 710);
6452: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6453: , 710);
6454: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6455: , 710);
6456: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6450: hr_utility.set_location(p_proc||'.from_position_org_line5 '||p_pa_request_rec.from_position_org_line5
6451: , 710);
6452: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6453: , 710);
6454: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6455: , 710);
6456: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6457: , 710);
6458: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6452: hr_utility.set_location(p_proc||'.from_position_org_line6 '||p_pa_request_rec.from_position_org_line6
6453: , 710);
6454: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6455: , 710);
6456: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6457: , 710);
6458: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6459: , 810);
6460: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6454: hr_utility.set_location(p_proc||'.from_position_number '||p_pa_request_rec.from_position_number
6455: , 710);
6456: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6457: , 710);
6458: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6459: , 810);
6460: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6461: , 810);
6462: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6456: hr_utility.set_location(p_proc||'.from_position_seq_no '||p_pa_request_rec.from_position_seq_no
6457: , 710);
6458: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6459: , 810);
6460: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6461: , 810);
6462: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6463: , 810);
6464: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6458: hr_utility.set_location(p_proc||'.from_position_title '||substr(p_pa_request_rec.from_position_title,1,40)
6459: , 810);
6460: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6461: , 810);
6462: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6463: , 810);
6464: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6465: , 810);
6466: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6460: hr_utility.set_location(p_proc||'.from_step_or_rate '||p_pa_request_rec.from_step_or_rate
6461: , 810);
6462: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6463: , 810);
6464: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6465: , 810);
6466: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6467: , 810); -- Bug 3659193 Added Substr for Notepad.
6468: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6462: hr_utility.set_location(p_proc||'.from_total_salary '||p_pa_request_rec.from_total_salary
6463: , 810);
6464: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6465: , 810);
6466: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6467: , 810); -- Bug 3659193 Added Substr for Notepad.
6468: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6469: , 810);
6470: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6464: hr_utility.set_location(p_proc||'.functional_class '||p_pa_request_rec.functional_class
6465: , 810);
6466: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6467: , 810); -- Bug 3659193 Added Substr for Notepad.
6468: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6469: , 810);
6470: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6471: , 810);
6472: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6466: hr_utility.set_location(p_proc||'.notepad '||SUBSTR(p_pa_request_rec.notepad,1,40)
6467: , 810); -- Bug 3659193 Added Substr for Notepad.
6468: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6469: , 810);
6470: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6471: , 810);
6472: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6473: , 810);
6474: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6468: hr_utility.set_location(p_proc||'.part_time_hours '||p_pa_request_rec.part_time_hours
6469: , 810);
6470: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6471: , 810);
6472: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6473: , 810);
6474: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6475: , 810);
6476: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6470: hr_utility.set_location(p_proc||'.input_pay_rate_determinant '||p_pa_request_rec.input_pay_rate_determinant
6471: , 810);
6472: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6473: , 810);
6474: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6475: , 810);
6476: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6477: , 810);
6478: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6472: hr_utility.set_location(p_proc||'.pay_rate_determinant '||p_pa_request_rec.pay_rate_determinant
6473: , 810);
6474: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6475: , 810);
6476: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6477: , 810);
6478: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6479: , 810);
6480: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6474: hr_utility.set_location(p_proc||'.personnel_office_id '||p_pa_request_rec.personnel_office_id
6475: , 810);
6476: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6477: , 810);
6478: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6479: , 810);
6480: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6481: , 810);
6482: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6476: hr_utility.set_location(p_proc||'.person_id '||p_pa_request_rec.person_id
6477: , 810);
6478: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6479: , 810);
6480: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6481: , 810);
6482: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6483: , 810);
6484: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6478: hr_utility.set_location(p_proc||'.position_occupied '||p_pa_request_rec.position_occupied
6479: , 810);
6480: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6481: , 810);
6482: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6483: , 810);
6484: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6485: , 910);
6486: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6480: hr_utility.set_location(p_proc||'.proposed_effective_asap_flag '||p_pa_request_rec.proposed_effective_asap_flag
6481: , 810);
6482: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6483: , 810);
6484: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6485: , 910);
6486: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6487: , 910);
6488: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6482: hr_utility.set_location(p_proc||'.proposed_effective_date '||p_pa_request_rec.proposed_effective_date
6483: , 810);
6484: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6485: , 910);
6486: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6487: , 910);
6488: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6489: , 910);
6490: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6484: hr_utility.set_location(p_proc||'.requested_by_person_id '||p_pa_request_rec.requested_by_person_id
6485: , 910);
6486: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6487: , 910);
6488: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6489: , 910);
6490: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6491: , 910); -- Bug 3381432 added 'substr'
6492: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6486: hr_utility.set_location(p_proc||'.requested_by_title '||substr(p_pa_request_rec.requested_by_title,1,40)
6487: , 910);
6488: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6489: , 910);
6490: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6491: , 910); -- Bug 3381432 added 'substr'
6492: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6493: , 910);
6494: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6488: hr_utility.set_location(p_proc||'.requested_date '||p_pa_request_rec.requested_date
6489: , 910);
6490: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6491: , 910); -- Bug 3381432 added 'substr'
6492: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6493: , 910);
6494: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6495: , 910);
6496: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6490: hr_utility.set_location(p_proc||'.requesting_office_remarks_desc '||substr(p_pa_request_rec.requesting_office_remarks_desc,1,40)
6491: , 910); -- Bug 3381432 added 'substr'
6492: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6493: , 910);
6494: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6495: , 910);
6496: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6497: , 910); -- Bug 3381432 added 'substr'
6498: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6492: hr_utility.set_location(p_proc||'.requesting_office_remarks_flag '||p_pa_request_rec.requesting_office_remarks_flag
6493: , 910);
6494: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6495: , 910);
6496: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6497: , 910); -- Bug 3381432 added 'substr'
6498: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6499: , 910);
6500: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6494: hr_utility.set_location(p_proc||'.request_number '||p_pa_request_rec.request_number
6495: , 910);
6496: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6497: , 910); -- Bug 3381432 added 'substr'
6498: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6499: , 910);
6500: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6501: , 910); -- Bug 3381432 added 'substr'
6502: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6496: hr_utility.set_location(p_proc||'.resign_and_retire_reason_desc '||substr(p_pa_request_rec.resign_and_retire_reason_desc,1,40)
6497: , 910); -- Bug 3381432 added 'substr'
6498: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6499: , 910);
6500: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6501: , 910); -- Bug 3381432 added 'substr'
6502: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6503: , 910);
6504: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6498: hr_utility.set_location(p_proc||'.retirement_plan '||p_pa_request_rec.retirement_plan
6499: , 910);
6500: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6501: , 910); -- Bug 3381432 added 'substr'
6502: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6503: , 910);
6504: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6505: , 910);
6506: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6500: hr_utility.set_location(p_proc||'.retirement_plan_desc '||substr(p_pa_request_rec.retirement_plan_desc,1,40)
6501: , 910); -- Bug 3381432 added 'substr'
6502: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6503: , 910);
6504: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6505: , 910);
6506: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6507: , 1010);
6508: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6502: hr_utility.set_location(p_proc||'.second_action_la_code1 '||p_pa_request_rec.second_action_la_code1
6503: , 910);
6504: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6505: , 910);
6506: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6507: , 1010);
6508: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6509: , 1010);
6510: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6504: hr_utility.set_location(p_proc||'.second_action_la_code2 '||p_pa_request_rec.second_action_la_code2
6505: , 910);
6506: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6507: , 1010);
6508: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6509: , 1010);
6510: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6511: , 1010);
6512: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6506: hr_utility.set_location(p_proc||'.second_action_la_desc1 '||substr(p_pa_request_rec.second_action_la_desc1,1,40)
6507: , 1010);
6508: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6509: , 1010);
6510: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6511: , 1010);
6512: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6513: , 1010);
6514: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6508: hr_utility.set_location(p_proc||'.second_action_la_desc2 '||substr(p_pa_request_rec.second_action_la_desc2,1,40)
6509: , 1010);
6510: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6511: , 1010);
6512: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6513: , 1010);
6514: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6515: , 1010);
6516: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6510: hr_utility.set_location(p_proc||'.second_noa_cancel_or_correct '||p_pa_request_rec.second_noa_cancel_or_correct
6511: , 1010);
6512: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6513: , 1010);
6514: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6515: , 1010);
6516: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6517: , 1010);
6518: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6512: hr_utility.set_location(p_proc||'.second_noa_code '||p_pa_request_rec.second_noa_code
6513: , 1010);
6514: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6515: , 1010);
6516: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6517: , 1010);
6518: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6519: , 1010);
6520: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6514: hr_utility.set_location(p_proc||'.second_noa_desc '||substr(p_pa_request_rec.second_noa_desc,1,40)
6515: , 1010);
6516: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6517: , 1010);
6518: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6519: , 1010);
6520: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6521: , 1010);
6522: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6516: hr_utility.set_location(p_proc||'.second_noa_id '||p_pa_request_rec.second_noa_id
6517: , 1010);
6518: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6519: , 1010);
6520: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6521: , 1010);
6522: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6523: , 1010);
6524: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6518: hr_utility.set_location(p_proc||'.second_noa_pa_request_id '||p_pa_request_rec.second_noa_pa_request_id
6519: , 1010);
6520: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6521: , 1010);
6522: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6523: , 1010);
6524: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6525: , 1010);
6526: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6520: hr_utility.set_location(p_proc||'.service_comp_date '||p_pa_request_rec.service_comp_date
6521: , 1010);
6522: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6523: , 1010);
6524: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6525: , 1010);
6526: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6527: , 1010);
6528: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6522: hr_utility.set_location(p_proc||'.supervisory_status '||p_pa_request_rec.supervisory_status
6523: , 1010);
6524: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6525: , 1010);
6526: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6527: , 1010);
6528: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6529: , 1010);
6530: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6524: hr_utility.set_location(p_proc||'.tenure '||p_pa_request_rec.tenure
6525: , 1010);
6526: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6527: , 1010);
6528: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6529: , 1010);
6530: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6531: , 1010);
6532: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6526: hr_utility.set_location(p_proc||'.to_adj_basic_pay '||p_pa_request_rec.to_adj_basic_pay
6527: , 1010);
6528: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6529: , 1010);
6530: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6531: , 1010);
6532: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6533: , 1010);
6534: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6528: hr_utility.set_location(p_proc||'.to_ap_premium_pay_indicator '||p_pa_request_rec.to_ap_premium_pay_indicator
6529: , 1010);
6530: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6531: , 1010);
6532: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6533: , 1010);
6534: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6535: , 1010);
6536: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6530: hr_utility.set_location(p_proc||'.to_auo_premium_pay_indicator '||p_pa_request_rec.to_auo_premium_pay_indicator
6531: , 1010);
6532: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6533: , 1010);
6534: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6535: , 1010);
6536: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6537: , 1010);
6538: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6532: hr_utility.set_location(p_proc||'.to_au_overtime '||p_pa_request_rec.to_au_overtime
6533: , 1010);
6534: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6535: , 1010);
6536: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6537: , 1010);
6538: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6539: , 1010);
6540: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6534: hr_utility.set_location(p_proc||'.to_availability_pay '||p_pa_request_rec.to_availability_pay
6535: , 1010);
6536: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6537: , 1010);
6538: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6539: , 1010);
6540: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6541: , 1010);
6542: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6536: hr_utility.set_location(p_proc||'.to_basic_pay '||p_pa_request_rec.to_basic_pay
6537: , 1010);
6538: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6539: , 1010);
6540: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6541: , 1010);
6542: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6543: , 1010);
6544: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6538: hr_utility.set_location(p_proc||'.to_grade_id '||p_pa_request_rec.to_grade_id
6539: , 1010);
6540: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6541: , 1010);
6542: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6543: , 1010);
6544: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6545: , 1010);
6546: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6540: hr_utility.set_location(p_proc||'.to_grade_or_level '||p_pa_request_rec.to_grade_or_level
6541: , 1010);
6542: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6543: , 1010);
6544: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6545: , 1010);
6546: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6547: , 1010);
6548: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6542: hr_utility.set_location(p_proc||'.to_job_id '||p_pa_request_rec.to_job_id
6543: , 1010);
6544: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6545: , 1010);
6546: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6547: , 1010);
6548: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6549: , 1010);
6550: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6544: hr_utility.set_location(p_proc||'.to_locality_adj '||p_pa_request_rec.to_locality_adj
6545: , 1010);
6546: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6547: , 1010);
6548: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6549: , 1010);
6550: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6551: , 1010);
6552: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6546: hr_utility.set_location(p_proc||'.to_occ_code '||substr(p_pa_request_rec.to_occ_code,1,40)
6547: , 1010);
6548: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6549: , 1010);
6550: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6551: , 1010);
6552: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6553: , 1010);
6554: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6548: hr_utility.set_location(p_proc||'.to_office_symbol '||p_pa_request_rec.to_office_symbol
6549: , 1010);
6550: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6551: , 1010);
6552: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6553: , 1010);
6554: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6555: , 1010);
6556: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6550: hr_utility.set_location(p_proc||'.to_organization_id '||p_pa_request_rec.to_organization_id
6551: , 1010);
6552: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6553: , 1010);
6554: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6555: , 1010);
6556: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6557: , 1010);
6558: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6552: hr_utility.set_location(p_proc||'.to_other_pay_amount '||p_pa_request_rec.to_other_pay_amount
6553: , 1010);
6554: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6555: , 1010);
6556: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6557: , 1010);
6558: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6559: --, 1010);
6560: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6554: hr_utility.set_location(p_proc||'.to_pay_basis '||p_pa_request_rec.to_pay_basis
6555: , 1010);
6556: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6557: , 1010);
6558: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6559: --, 1010);
6560: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6561: --, 1010);
6562: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6556: hr_utility.set_location(p_proc||'.to_pay_plan '||p_pa_request_rec.to_pay_plan
6557: , 1010);
6558: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6559: --, 1010);
6560: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6561: --, 1010);
6562: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6563: , 1010);
6564: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6558: --hr_utility.set_location(p_proc||'.to_prd '||p_pa_request_rec.to_pay_rate_determinant
6559: --, 1010);
6560: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6561: --, 1010);
6562: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6563: , 1010);
6564: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6565: , 1010);
6566: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6560: --hr_utility.set_location(p_proc||'.to_pay_table_id '||to_char(p_pa_request_rec.to_pay_table_identifier)
6561: --, 1010);
6562: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6563: , 1010);
6564: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6565: , 1010);
6566: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6567: , 1010);
6568: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6562: hr_utility.set_location(p_proc||'.to_position_id '||p_pa_request_rec.to_position_id
6563: , 1010);
6564: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6565: , 1010);
6566: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6567: , 1010);
6568: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6569: , 1010);
6570: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6564: hr_utility.set_location(p_proc||'.to_position_org_line1 '||p_pa_request_rec.to_position_org_line1
6565: , 1010);
6566: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6567: , 1010);
6568: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6569: , 1010);
6570: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6571: , 1010);
6572: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6566: hr_utility.set_location(p_proc||'.to_position_org_line2 '||p_pa_request_rec.to_position_org_line2
6567: , 1010);
6568: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6569: , 1010);
6570: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6571: , 1010);
6572: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6573: , 1010);
6574: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6568: hr_utility.set_location(p_proc||'.to_position_org_line3 '||p_pa_request_rec.to_position_org_line3
6569: , 1010);
6570: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6571: , 1010);
6572: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6573: , 1010);
6574: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6575: , 1010);
6576: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6570: hr_utility.set_location(p_proc||'.to_position_org_line4 '||p_pa_request_rec.to_position_org_line4
6571: , 1010);
6572: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6573: , 1010);
6574: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6575: , 1010);
6576: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6577: , 1010);
6578: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6572: hr_utility.set_location(p_proc||'.to_position_org_line5 '||p_pa_request_rec.to_position_org_line5
6573: , 1010);
6574: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6575: , 1010);
6576: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6577: , 1010);
6578: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6579: , 1010);
6580: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6574: hr_utility.set_location(p_proc||'.to_position_org_line6 '||p_pa_request_rec.to_position_org_line6
6575: , 1010);
6576: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6577: , 1010);
6578: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6579: , 1010);
6580: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6581: , 1010);
6582: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6576: hr_utility.set_location(p_proc||'.to_position_number '||p_pa_request_rec.to_position_number
6577: , 1010);
6578: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6579: , 1010);
6580: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6581: , 1010);
6582: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6583: , 1010);
6584: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6578: hr_utility.set_location(p_proc||'.to_position_seq_no '||p_pa_request_rec.to_position_seq_no
6579: , 1010);
6580: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6581: , 1010);
6582: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6583: , 1010);
6584: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6585: , 1010);
6586: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6580: hr_utility.set_location(p_proc||'.to_position_title '||substr(p_pa_request_rec.to_position_title,1,40)
6581: , 1010);
6582: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6583: , 1010);
6584: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6585: , 1010);
6586: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6587: , 1010);
6588: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6582: hr_utility.set_location(p_proc||'.to_retention_allowance '||p_pa_request_rec.to_retention_allowance
6583: , 1010);
6584: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6585: , 1010);
6586: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6587: , 1010);
6588: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6589: , 1010);
6590: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6584: hr_utility.set_location(p_proc||'.to_retention_allow_percentage '||p_pa_request_rec.to_retention_allow_percentage
6585: , 1010);
6586: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6587: , 1010);
6588: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6589: , 1010);
6590: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6591: , 1010);
6592: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6586: hr_utility.set_location(p_proc||'.to_staffing_differential '||p_pa_request_rec.to_staffing_differential
6587: , 1010);
6588: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6589: , 1010);
6590: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6591: , 1010);
6592: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6593: , 1010);
6594: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6588: hr_utility.set_location(p_proc||'.to_staffing_diff_percentage '||p_pa_request_rec.to_staffing_diff_percentage
6589: , 1010);
6590: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6591: , 1010);
6592: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6593: , 1010);
6594: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6595: , 1010);
6596: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6590: hr_utility.set_location(p_proc||'.to_step_or_rate '||p_pa_request_rec.to_step_or_rate
6591: , 1010);
6592: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6593: , 1010);
6594: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6595: , 1010);
6596: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6597: , 1010);
6598: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6592: hr_utility.set_location(p_proc||'.to_supervisory_differential '||p_pa_request_rec.to_supervisory_differential
6593: , 1010);
6594: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6595: , 1010);
6596: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6597: , 1010);
6598: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6599: , 1010);
6600: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6594: hr_utility.set_location(p_proc||'.to_supervisory_diff_percentage '||p_pa_request_rec.to_supervisory_diff_percentage
6595: , 1010);
6596: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6597: , 1010);
6598: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6599: , 1010);
6600: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6601: , 1010);
6602: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6596: hr_utility.set_location(p_proc||'.to_total_salary '||p_pa_request_rec.to_total_salary
6597: , 1010);
6598: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6599: , 1010);
6600: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6601: , 1010);
6602: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6603: , 1010);
6604: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6598: hr_utility.set_location(p_proc||'.veterans_preference '||p_pa_request_rec.veterans_preference
6599: , 1010);
6600: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6601: , 1010);
6602: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6603: , 1010);
6604: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6605: , 1010);
6606: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6600: hr_utility.set_location(p_proc||'.veterans_pref_for_rif '||p_pa_request_rec.veterans_pref_for_rif
6601: , 1010);
6602: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6603: , 1010);
6604: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6605: , 1010);
6606: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6607: , 1010);
6608: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6602: hr_utility.set_location(p_proc||'.veterans_status '||p_pa_request_rec.veterans_status
6603: , 1010);
6604: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6605: , 1010);
6606: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6607: , 1010);
6608: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6609: , 1010);
6610: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6604: hr_utility.set_location(p_proc||'.work_schedule '||p_pa_request_rec.work_schedule
6605: , 1010);
6606: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6607: , 1010);
6608: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6609: , 1010);
6610: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6611: , 1010);
6612: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6606: hr_utility.set_location(p_proc||'.work_schedule_desc '||substr(p_pa_request_rec.work_schedule_desc,1,40)
6607: , 1010);
6608: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6609: , 1010);
6610: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6611: , 1010);
6612: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6613: , 1010);
6614: hr_utility.set_location(p_proc||'.payment option: '||p_pa_request_rec.pa_incentive_payment_option
6608: hr_utility.set_location(p_proc||'.year_degree_attained '||p_pa_request_rec.year_degree_attained
6609: , 1010);
6610: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6611: , 1010);
6612: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6613: , 1010);
6614: hr_utility.set_location(p_proc||'.payment option: '||p_pa_request_rec.pa_incentive_payment_option
6615: , 1010);
6616: hr_utility.set_location(p_proc||'.award salary '||p_pa_request_rec.award_salary
6610: hr_utility.set_location(p_proc||'.from_pay_table_identifier '||p_pa_request_rec.from_pay_table_identifier
6611: , 1010);
6612: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6613: , 1010);
6614: hr_utility.set_location(p_proc||'.payment option: '||p_pa_request_rec.pa_incentive_payment_option
6615: , 1010);
6616: hr_utility.set_location(p_proc||'.award salary '||p_pa_request_rec.award_salary
6617: , 1010);
6618:
6612: hr_utility.set_location(p_proc||'.to_pay_table_identifier '||p_pa_request_rec.to_pay_table_identifier
6613: , 1010);
6614: hr_utility.set_location(p_proc||'.payment option: '||p_pa_request_rec.pa_incentive_payment_option
6615: , 1010);
6616: hr_utility.set_location(p_proc||'.award salary '||p_pa_request_rec.award_salary
6617: , 1010);
6618:
6619: END print_sf52;
6620: