eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_EX_EMPLOYEE_API dependencies on STANDARD

Line 178: ,p_last_standard_process_date in out nocopy date

174: ,p_effective_date in date
175: ,p_period_of_service_id in number
176: ,p_object_version_number in out nocopy number
177: ,p_actual_termination_date in date
178: ,p_last_standard_process_date in out nocopy date
179: ,p_person_type_id in number default hr_api.g_number
180: ,p_assignment_status_type_id in number default hr_api.g_number
181: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
182: ,p_supervisor_warning out nocopy boolean

Line 203: if p_last_standard_process_date is null

199: begin
200:
201: hr_utility.set_location('Entering '||l_proc,10);
202:
203: if p_last_standard_process_date is null
204: then
205: /* No LSPD has been passed. To preserve the previous
206: ** behaviour we need to pass g_date to the latest ATE API.
207: */

Line 212: l_last_std_process_date_in := p_last_standard_process_date;

208: l_last_std_process_date_in := hr_api.g_date;
209: else
210: /* Otherwise pass through the value provided.
211: */
212: l_last_std_process_date_in := p_last_standard_process_date;
213: end if;
214:
215: actual_termination_emp(
216: p_validate => p_validate

Line 221: ,p_last_standard_process_date => l_last_std_process_date_in

217: ,p_effective_date => p_effective_date
218: ,p_period_of_service_id => p_period_of_service_id
219: ,p_object_version_number => p_object_version_number
220: ,p_actual_termination_date => p_actual_termination_date
221: ,p_last_standard_process_date => l_last_std_process_date_in
222: ,p_person_type_id => p_person_type_id
223: ,p_assignment_status_type_id => p_assignment_status_type_id
224: ,p_leaving_reason => p_leaving_reason
225: ,p_last_std_process_date_out => l_last_std_process_date_out

Line 237: p_last_standard_process_date := l_last_std_process_date_out;

233: ,p_pay_proposal_warning => p_pay_proposal_warning
234: ,p_dod_warning => p_dod_warning
235: ,p_alu_change_warning => l_alu_change_warning);
236:
237: p_last_standard_process_date := l_last_std_process_date_out;
238:
239: hr_utility.set_location('Leaving '||l_proc,40);
240:
241: end actual_termination_emp;

Line 255: ,p_last_standard_process_date in out nocopy date

251: ,p_effective_date in date
252: ,p_period_of_service_id in number
253: ,p_object_version_number in out nocopy number
254: ,p_actual_termination_date in date
255: ,p_last_standard_process_date in out nocopy date
256: ,p_person_type_id in number default hr_api.g_number
257: ,p_assignment_status_type_id in number default hr_api.g_number
258: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
259: --

Line 294: if p_last_standard_process_date is null

290: begin
291:
292: hr_utility.set_location('Entering '||l_proc,10);
293:
294: if p_last_standard_process_date is null
295: then
296: /* No LSPD has been passed. To preserve the previous
297: ** behaviour we need to pass g_date to the latest ATE API.
298: */

Line 303: l_last_std_process_date_in := p_last_standard_process_date;

299: l_last_std_process_date_in := hr_api.g_date;
300: else
301: /* Otherwise pass through the value provided.
302: */
303: l_last_std_process_date_in := p_last_standard_process_date;
304: end if;
305:
306: actual_termination_emp(
307: p_validate => p_validate

Line 312: ,p_last_standard_process_date => l_last_std_process_date_in

308: ,p_effective_date => p_effective_date
309: ,p_period_of_service_id => p_period_of_service_id
310: ,p_object_version_number => p_object_version_number
311: ,p_actual_termination_date => p_actual_termination_date
312: ,p_last_standard_process_date => l_last_std_process_date_in
313: ,p_person_type_id => p_person_type_id
314: ,p_assignment_status_type_id => p_assignment_status_type_id
315: ,p_leaving_reason => p_leaving_reason
316: --

Line 344: p_last_standard_process_date := l_last_std_process_date_out;

340: --
341: -- 120.2 (END)
342: --
343:
344: p_last_standard_process_date := l_last_std_process_date_out;
345:
346: hr_utility.set_location('Leaving '||l_proc,40);
347:
348: end actual_termination_emp;

Line 363: ,p_last_standard_process_date in date default hr_api.g_date

359: ,p_effective_date in date
360: ,p_period_of_service_id in number
361: ,p_object_version_number in out nocopy number
362: ,p_actual_termination_date in date
363: ,p_last_standard_process_date in date default hr_api.g_date
364: ,p_person_type_id in number default hr_api.g_number
365: ,p_assignment_status_type_id in number default hr_api.g_number
366: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 441: ,p_last_standard_process_date => p_last_standard_process_date

437: ,p_effective_date => p_effective_date
438: ,p_period_of_service_id => p_period_of_service_id
439: ,p_object_version_number => p_object_version_number
440: ,p_actual_termination_date => p_actual_termination_date
441: ,p_last_standard_process_date => p_last_standard_process_date
442: ,p_person_type_id => p_person_type_id
443: ,p_assignment_status_type_id => p_assignment_status_type_id
444: ,p_leaving_reason => p_leaving_reason
445: ,p_attribute_category => p_attribute_category

Line 528: ,p_last_standard_process_date in date default hr_api.g_date

524: ,p_effective_date in date
525: ,p_period_of_service_id in number
526: ,p_object_version_number in out nocopy number
527: ,p_actual_termination_date in date
528: ,p_last_standard_process_date in date default hr_api.g_date
529: ,p_person_type_id in number default hr_api.g_number
530: ,p_assignment_status_type_id in number default hr_api.g_number
531: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
532: --

Line 619: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;

615: l_asg_future_changes_warning boolean := FALSE;
616: l_entries_changed_warning varchar2(1) := 'N';
617: l_event_warning boolean := FALSE;
618: l_interview_warning boolean := FALSE;
619: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
620: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
621: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
622: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
623: l_recruiter_warning boolean := FALSE;

Line 620: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;

616: l_entries_changed_warning varchar2(1) := 'N';
617: l_event_warning boolean := FALSE;
618: l_interview_warning boolean := FALSE;
619: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
620: l_last_std_process_date_in per_periods_of_service.last_standard_process_date%TYPE;
621: l_pds_object_version_number per_assignments_f.object_version_number%TYPE;
622: l_ovn per_assignments_f.object_version_number%TYPE := p_object_version_number;
623: l_recruiter_warning boolean := FALSE;
624: l_review_warning boolean := FALSE;

Line 679: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;

675: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
676: l_action_chk VARCHAR2(1) := 'N';
677:
678: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;
679: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;
680: l_person_id2 number := -1;
681: --
682:
683:

Line 742: , pds.last_standard_process_date

738: , per.object_version_number
739: , pet.system_person_type
740: , per.npw_number
741: , pds.actual_termination_date
742: , pds.last_standard_process_date
743: from per_all_people_f per
744: , per_business_groups bus
745: , per_periods_of_service pds
746: , per_person_types pet

Line 962: l_last_standard_process_date := trunc(p_last_standard_process_date);

958: --
959: -- Initialise local varaibles
960: --
961: l_assignment_status_type_id := p_assignment_status_type_id;
962: l_last_standard_process_date := trunc(p_last_standard_process_date);
963: l_last_std_process_date_in := l_last_standard_process_date;
964: l_pds_object_version_number := p_object_version_number;
965: l_person_type_id := p_person_type_id;
966: l_actual_termination_date := trunc(p_actual_termination_date);

Line 963: l_last_std_process_date_in := l_last_standard_process_date;

959: -- Initialise local varaibles
960: --
961: l_assignment_status_type_id := p_assignment_status_type_id;
962: l_last_standard_process_date := trunc(p_last_standard_process_date);
963: l_last_std_process_date_in := l_last_standard_process_date;
964: l_pds_object_version_number := p_object_version_number;
965: l_person_type_id := p_person_type_id;
966: l_actual_termination_date := trunc(p_actual_termination_date);
967: l_effective_date := trunc(p_effective_date);

Line 1089: ,p_last_standard_process_date => l_last_standard_process_date

1085: (p_effective_date => l_effective_date
1086: ,p_period_of_service_id => p_period_of_service_id
1087: ,p_object_version_number => p_object_version_number
1088: ,p_actual_termination_date => l_actual_termination_date
1089: ,p_last_standard_process_date => l_last_standard_process_date
1090: ,p_person_type_id => p_person_type_id
1091: ,p_assignment_status_type_id => p_assignment_status_type_id
1092: ,p_business_group_id => l_business_group_id
1093: ,p_attribute_category => p_attribute_category

Line 1159: hr_utility.set_location('Passed LSPD: '||l_last_standard_process_date, 51);

1155: --
1156: hr_utility.set_location(l_proc, 50);
1157: hr_utility.set_location('Saved ATD: '||l_saved_atd, 51);
1158: hr_utility.set_location('Saved LSPD: '||l_saved_lspd, 51);
1159: hr_utility.set_location('Passed LSPD: '||l_last_standard_process_date, 51);
1160: --
1161: -- Determine if we are setting LSPD as a separate call to the API. i.e. ATD
1162: -- has already been saved with a null LSPD,
1163: --

Line 1166: l_last_standard_process_date is not null then

1162: -- has already been saved with a null LSPD,
1163: --
1164: if l_saved_atd is not null and
1165: l_saved_lspd is null and
1166: l_last_standard_process_date is not null then
1167: --
1168: -- We are processing a save to LSPD as a separate call to this API.
1169: --
1170: if p_last_standard_process_date = hr_api.g_date

Line 1170: if p_last_standard_process_date = hr_api.g_date

1166: l_last_standard_process_date is not null then
1167: --
1168: -- We are processing a save to LSPD as a separate call to this API.
1169: --
1170: if p_last_standard_process_date = hr_api.g_date
1171: then
1172: hr_utility.set_location(l_proc, 60);
1173: --
1174: -- Last standard process date is the default value i.e.

Line 1174: -- Last standard process date is the default value i.e.

1170: if p_last_standard_process_date = hr_api.g_date
1171: then
1172: hr_utility.set_location(l_proc, 60);
1173: --
1174: -- Last standard process date is the default value i.e.
1175: -- it was not passed to the API => derive it.
1176: --
1177: -- Find the max tpe end date of any payrolls that are assigned.
1178: --

Line 1208: -- A time period end date has been found, so set the last standard

1204: then
1205: --
1206: hr_utility.set_location(l_proc, 90);
1207: --
1208: -- A time period end date has been found, so set the last standard
1209: -- process date to that.
1210: --
1211: l_last_standard_process_date := l_max_tpe_end_date;
1212: else

Line 1211: l_last_standard_process_date := l_max_tpe_end_date;

1207: --
1208: -- A time period end date has been found, so set the last standard
1209: -- process date to that.
1210: --
1211: l_last_standard_process_date := l_max_tpe_end_date;
1212: else
1213: --
1214: hr_utility.set_location(l_proc, 100);
1215: --

Line 1221: l_last_standard_process_date := l_actual_termination_date;

1217: -- there was no time period for that payroll as of the actual
1218: -- termination date. It doesn't matter which as we will default
1219: -- the LSPD to the ATD.
1220: --
1221: l_last_standard_process_date := l_actual_termination_date;
1222: end if;
1223:
1224: end if;
1225: --

Line 1230: ,p_last_standard_process_date => l_last_standard_process_date

1226: -- Save PDS update
1227: --
1228: per_pds_upd.upd
1229: (p_period_of_service_id => p_period_of_service_id
1230: ,p_last_standard_process_date => l_last_standard_process_date
1231: ,p_object_version_number => l_pds_object_version_number
1232: ,p_effective_date => l_last_standard_process_date + 1
1233: ,p_validate => p_validate
1234: ,p_attribute_category => p_attribute_category

Line 1232: ,p_effective_date => l_last_standard_process_date + 1

1228: per_pds_upd.upd
1229: (p_period_of_service_id => p_period_of_service_id
1230: ,p_last_standard_process_date => l_last_standard_process_date
1231: ,p_object_version_number => l_pds_object_version_number
1232: ,p_effective_date => l_last_standard_process_date + 1
1233: ,p_validate => p_validate
1234: ,p_attribute_category => p_attribute_category
1235: ,p_attribute1 => p_attribute1
1236: ,p_attribute2 => p_attribute2

Line 1296: ,p_last_standard_date => l_last_standard_process_date

1292:
1293: hrempter.terminate_entries_and_alus
1294: (p_assignment_id => csr_rec.assignment_id
1295: ,p_actual_term_date => l_saved_atd
1296: ,p_last_standard_date => l_last_standard_process_date
1297: ,p_final_process_date => null
1298: ,p_legislation_code => l_legislation_code
1299: ,p_entries_changed_warning => l_cr_entries_changed_warn
1300: --

Line 1423: -- Validate/derive the last standard process date.

1419: );
1420: --
1421: hr_utility.set_location(l_proc, 190);
1422: --
1423: -- Validate/derive the last standard process date.
1424: --
1425: --
1426: hr_utility.set_location(l_proc, 200);
1427: --

Line 1429: -- for l_last_standard_process_date or it will be NULL. It can only be

1425: --
1426: hr_utility.set_location(l_proc, 200);
1427: --
1428: -- At the end of the following code we will either have a valid date
1429: -- for l_last_standard_process_date or it will be NULL. It can only be
1430: -- NULL if explicitly passed as such to the API.
1431: --
1432: if l_last_standard_process_date is not null and
1433: l_last_standard_process_date <> hr_api.g_date

Line 1432: if l_last_standard_process_date is not null and

1428: -- At the end of the following code we will either have a valid date
1429: -- for l_last_standard_process_date or it will be NULL. It can only be
1430: -- NULL if explicitly passed as such to the API.
1431: --
1432: if l_last_standard_process_date is not null and
1433: l_last_standard_process_date <> hr_api.g_date
1434: then
1435: --
1436: hr_utility.set_location(l_proc, 210);

Line 1433: l_last_standard_process_date <> hr_api.g_date

1429: -- for l_last_standard_process_date or it will be NULL. It can only be
1430: -- NULL if explicitly passed as such to the API.
1431: --
1432: if l_last_standard_process_date is not null and
1433: l_last_standard_process_date <> hr_api.g_date
1434: then
1435: --
1436: hr_utility.set_location(l_proc, 210);
1437: --

Line 1438: -- Check that the last standard process date is on or after the actual

1434: then
1435: --
1436: hr_utility.set_location(l_proc, 210);
1437: --
1438: -- Check that the last standard process date is on or after the actual
1439: -- termination date.
1440: --
1441: if not l_last_standard_process_date >= l_actual_termination_date
1442: then

Line 1441: if not l_last_standard_process_date >= l_actual_termination_date

1437: --
1438: -- Check that the last standard process date is on or after the actual
1439: -- termination date.
1440: --
1441: if not l_last_standard_process_date >= l_actual_termination_date
1442: then
1443: --
1444: hr_utility.set_location(l_proc, 220);
1445: --

Line 1449: elsif l_last_standard_process_date = hr_api.g_date then

1445: --
1446: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
1447: hr_utility.raise_error;
1448: end if;
1449: elsif l_last_standard_process_date = hr_api.g_date then
1450: --
1451: hr_utility.set_location(l_proc, 230);
1452: --
1453: -- Last standard process date is the default value i.e.

Line 1453: -- Last standard process date is the default value i.e.

1449: elsif l_last_standard_process_date = hr_api.g_date then
1450: --
1451: hr_utility.set_location(l_proc, 230);
1452: --
1453: -- Last standard process date is the default value i.e.
1454: -- it was not passed to the API => derive it.
1455: --
1456: -- Find the max tpe end date of any payrolls that are assigned.
1457: --

Line 1487: -- A time period end date has been found, so set the last standard

1483: then
1484: --
1485: hr_utility.set_location(l_proc, 260);
1486: --
1487: -- A time period end date has been found, so set the last standard
1488: -- process date to that.
1489: --
1490: l_last_standard_process_date := l_max_tpe_end_date;
1491: else

Line 1490: l_last_standard_process_date := l_max_tpe_end_date;

1486: --
1487: -- A time period end date has been found, so set the last standard
1488: -- process date to that.
1489: --
1490: l_last_standard_process_date := l_max_tpe_end_date;
1491: else
1492: --
1493: hr_utility.set_location(l_proc, 270);
1494: --

Line 1500: l_last_standard_process_date := l_actual_termination_date;

1496: -- there was no time period for that payroll as of the actual
1497: -- termination date. It doesn't matter which as we will default
1498: -- the LSPD to the ATD.
1499: --
1500: l_last_standard_process_date := l_actual_termination_date;
1501: end if;
1502: end if;
1503: --
1504: --2478758 implement check for payroll actions

Line 1509: ,p_lsp_date => l_last_standard_process_date

1505: --
1506: l_action_chk := hr_ex_employee_api.check_for_compl_actions
1507: (p_person_id => l_person_id
1508: ,p_act_date => l_actual_termination_date
1509: ,p_lsp_date => l_last_standard_process_date
1510: ,p_fpr_date => null --not known to this API
1511: );
1512: --
1513: -- Bug# 2958006 Start Here

Line 1590: -- Update actual termination date and last standard process date in

1586: );
1587:
1588: hr_utility.set_location(l_proc, 290);
1589: --
1590: -- Update actual termination date and last standard process date in
1591: -- periods of service table.
1592:
1593: per_pds_upd.upd
1594: (p_period_of_service_id => p_period_of_service_id

Line 1596: ,p_last_standard_process_date => l_last_standard_process_date

1592:
1593: per_pds_upd.upd
1594: (p_period_of_service_id => p_period_of_service_id
1595: ,p_actual_termination_date => l_actual_termination_date
1596: ,p_last_standard_process_date => l_last_standard_process_date
1597: ,p_leaving_reason => p_leaving_reason
1598: ,p_object_version_number => l_pds_object_version_number
1599: ,p_effective_date => p_actual_termination_date + 1
1600: ,p_attribute_category => p_attribute_category

Line 1802: ,p_last_standard_process_date => l_last_standard_process_date

1798: hr_assignment_internal.actual_term_emp_asg_sup
1799: (p_assignment_id => csr_rec.assignment_id
1800: ,p_object_version_number => csr_rec.object_version_number
1801: ,p_actual_termination_date => l_actual_termination_date
1802: ,p_last_standard_process_date => l_last_standard_process_date
1803: ,p_assignment_status_type_id => l_assignment_status_type_id
1804: ,p_effective_start_date => l_effective_start_date
1805: ,p_effective_end_date => l_effective_end_date
1806: ,p_asg_future_changes_warning => l_cr_asg_future_changes_warn

Line 1988: ,p_last_standard_process_date => l_last_std_process_date_in

1984: (p_effective_date => l_effective_date
1985: ,p_period_of_service_id => p_period_of_service_id
1986: ,p_object_version_number => l_pds_object_version_number
1987: ,p_actual_termination_date => l_actual_termination_date
1988: ,p_last_standard_process_date => l_last_std_process_date_in
1989: ,p_person_type_id => p_person_type_id
1990: ,p_assignment_status_type_id => p_assignment_status_type_id
1991: ,p_attribute_category => p_attribute_category
1992: ,p_attribute1 => p_attribute1

Line 2043: ,p_last_std_process_date_out => l_last_standard_process_date

2039: ,p_pds_information27 => p_pds_information27
2040: ,p_pds_information28 => p_pds_information28
2041: ,p_pds_information29 => p_pds_information29
2042: ,p_pds_information30 => p_pds_information30
2043: ,p_last_std_process_date_out => l_last_standard_process_date
2044: ,p_supervisor_warning => l_supervisor_warning
2045: ,p_event_warning => l_event_warning
2046: ,p_interview_warning => l_interview_warning
2047: ,p_review_warning => l_review_warning

Line 2086: p_last_std_process_date_out := l_last_standard_process_date;

2082: p_alu_change_warning := l_alu_change_warning;
2083: --
2084: -- 120.2 (END)
2085: --
2086: p_last_std_process_date_out := l_last_standard_process_date;
2087: p_object_version_number := l_pds_object_version_number;
2088: --
2089: --
2090: hr_utility.set_location(' Leaving:'||l_proc, 440);

Line 2108: -- p_object_version_number and p_last_standard_process_date

2104: p_entries_changed_warning := l_entries_changed_warning;
2105: p_pay_proposal_warning := l_pay_proposal_warn;
2106: p_dod_warning := l_dod_warning;
2107: --
2108: -- p_object_version_number and p_last_standard_process_date
2109: -- should return their IN values, they still hold their IN values
2110: -- so do nothing here.
2111: --
2112: --

Line 2177: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;

2173: l_cr_org_now_no_manager_warn boolean := FALSE;
2174: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
2175: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
2176: l_exists varchar2(1);
2177: l_last_standard_process_date per_periods_of_service.last_standard_process_date%TYPE;
2178: l_legislation_code per_business_groups.legislation_code%TYPE;
2179: l_object_version_number per_periods_of_service.object_version_number%TYPE;
2180: l_person_id per_all_people_f.person_id%TYPE;
2181: l_proc varchar2(72) := g_package || 'final_process_emp';

Line 2188: , pds.last_standard_process_date

2184: --
2185: cursor csr_get_derived_details is
2186: select bus.legislation_code
2187: , pds.actual_termination_date
2188: , pds.last_standard_process_date
2189: , pds.person_id
2190: , pds.object_version_number
2191: from per_business_groups bus
2192: , per_periods_of_service pds

Line 2289: ,l_last_standard_process_date

2285: open csr_get_derived_details;
2286: fetch csr_get_derived_details
2287: into l_legislation_code
2288: ,l_actual_termination_date
2289: ,l_last_standard_process_date
2290: ,l_person_id
2291: ,l_object_version_number;
2292: --
2293: if csr_get_derived_details%NOTFOUND

Line 2338: -- Add one day to the last standard process date to get the

2334: -- Default the FPD to the LSPD
2335: --
2336: l_final_process_date := l_actual_termination_date;
2337: --
2338: -- Add one day to the last standard process date to get the
2339: -- validation date
2340: --
2341: -- Set the EX Employee effective date to the FPD + 1
2342: --

Line 2353: l_final_process_date := l_last_standard_process_date;

2349: then
2350: --
2351: -- Default the FPD to the LSPD
2352: --
2353: l_final_process_date := l_last_standard_process_date;
2354: --
2355: -- Add one day to the last standard process date to get the
2356: -- validation date
2357: --

Line 2355: -- Add one day to the last standard process date to get the

2351: -- Default the FPD to the LSPD
2352: --
2353: l_final_process_date := l_last_standard_process_date;
2354: --
2355: -- Add one day to the last standard process date to get the
2356: -- validation date
2357: --
2358: -- Set the EX Employee effective date to the FPD + 1
2359: --

Line 2413: ,p_lsp_date => l_last_standard_process_date

2409: --
2410: l_action_chk := hr_ex_employee_api.check_for_compl_actions
2411: (p_person_id => l_person_id
2412: ,p_act_date => l_actual_termination_date
2413: ,p_lsp_date => l_last_standard_process_date
2414: ,p_fpr_date => l_final_process_date
2415: );
2416: --
2417: IF l_action_chk = 'N' THEN