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.HREMPTER dependencies on STANDARD

Line 86: If legislation is 'US' and Last_standard

82: flag to allow only some of Term
83: details to be deleted.
84: 70.18 25-APR-95 TMathers 276096 Added legislation code to terminate_alus
85: and terminate employee so that
86: If legislation is 'US' and Last_standard
87: process is null the package will
88: not fall over.
89: 70.19 12-MAY-95 TMathers 281104 added rest of fields save notified
90: and projected to clear_details update.

Line 229: last_standard_process for US legislature.

225: Added support for life event triggers for OAB.
226: 115.22 23-OCT-00 SBIRNAGE Added an extra line to two where clauses to fix bug
227: 1406063.
228: 115.23 29-MAR-01 vshukhat Bug 1711085. Commented out nocopy code that disables
229: last_standard_process for US legislature.
230: 115.24 09-APR-01 Reverted back some previous changes.
231: 115.25 09-MAY-01 MGettins Reverse out nocopy changes for bug 1363723
232: 115.26 10-jul-01 rvydyana TAR 1660650.999
233: 115.27 06-Jul-01 pbodla - Bug 1877018 : added final_process_date

Line 938: p_last_standard_date DATE,

934: -- =================== terminate_entries_and_alus overload ============
935: -- VT 11/01/96 #306710 procedure overload
936: PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
937: p_actual_term_date DATE,
938: p_last_standard_date DATE,
939: p_final_process_date DATE,
940: p_legislation_code VARCHAR2 DEFAULT
941: NULL)
942: IS

Line 948: ,p_last_standard_date

944: l_entries_changed_ov VARCHAR2(1) := 'N';
945: BEGIN
946: terminate_entries_and_alus(p_assignment_id
947: ,p_actual_term_date
948: ,p_last_standard_date
949: ,p_final_process_date
950: ,p_legislation_code
951: ,l_entries_changed_ov);
952: END terminate_entries_and_alus;

Line 960: p_last_standard_date DATE,

956: -- =================== terminate_entries_and_alus overload ===================
957: --
958: PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
959: p_actual_term_date DATE,
960: p_last_standard_date DATE,
961: p_final_process_date DATE,
962: p_legislation_code VARCHAR2 DEFAULT
963: NULL,
964: p_entries_changed_warning

Line 974: ,p_last_standard_date

970: BEGIN
971: --
972: terminate_entries_and_alus(p_assignment_id
973: ,p_actual_term_date
974: ,p_last_standard_date
975: ,p_final_process_date
976: ,p_legislation_code
977: ,p_entries_changed_warning
978: ,l_alu_change_warning_ovl);

Line 988: p_last_standard_date DATE,

984: -- ========================= terminate_entries_and_alus ======================
985: --
986: PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
987: p_actual_term_date DATE,
988: p_last_standard_date DATE,
989: p_final_process_date DATE,
990: p_legislation_code VARCHAR2 DEFAULT
991: NULL,
992: p_entries_changed_warning

Line 1928: -- Actual Last Standard

1924: --
1925: -- Validates the combination of dates passed. The valid combinations are
1926: --
1927: -- Actual (if legislation US)
1928: -- Actual Last Standard
1929: -- Actual Last Standard Final Process
1930: -- Actual Final Process(if legislation US)
1931: -- Final Process
1932: --

Line 1929: -- Actual Last Standard Final Process

1925: -- Validates the combination of dates passed. The valid combinations are
1926: --
1927: -- Actual (if legislation US)
1928: -- Actual Last Standard
1929: -- Actual Last Standard Final Process
1930: -- Actual Final Process(if legislation US)
1931: -- Final Process
1932: --
1933: -- 288341. Removed unnecessary clause "p_legislation_code <> 'US'", which

Line 1938: -- in association with last_standard_process.

1934: -- was causing the check to fail when p_legislation_code was NULL.
1935: -- RMF 03.07.95.
1936: --
1937: -- Bug 1711085. VS. 29-Mar-01. Removed references to US legislation
1938: -- in association with last_standard_process.
1939: --
1940: -- Bug 2784295 : commenting the code which requires LSPD to be not null
1941: -- for non-US legislations
1942: IF p_actual_term_date IS NOT NULL THEN

Line 1944: p_last_standard_date IS NOT NULL) THEN */

1940: -- Bug 2784295 : commenting the code which requires LSPD to be not null
1941: -- for non-US legislations
1942: IF p_actual_term_date IS NOT NULL THEN
1943: /* (p_legislation_code = 'US' or
1944: p_last_standard_date IS NOT NULL) THEN */
1945: --
1946: -- Valid combination of parameters
1947: NULL;
1948: --

Line 1952: p_last_standard_date IS NULL THEN

1948: --
1949: ELSIF
1950: p_final_process_date IS NOT NULL AND
1951: p_actual_term_date IS NULL AND
1952: p_last_standard_date IS NULL THEN
1953: --
1954: -- Valid combination of parameters
1955: NULL;
1956: --

Line 2014: -- post termination rule of 'Last Standard Process'

2010: --
2011: hr_utility.set_location(l_proc,6);
2012: --
2013: -- Shut down all element entries and ALU's for element types which have a
2014: -- post termination rule of 'Last Standard Process'
2015: IF p_last_standard_date IS NOT NULL THEN
2016: --
2017: hr_utility.set_location(l_proc,7);
2018: --

Line 2015: IF p_last_standard_date IS NOT NULL THEN

2011: hr_utility.set_location(l_proc,6);
2012: --
2013: -- Shut down all element entries and ALU's for element types which have a
2014: -- post termination rule of 'Last Standard Process'
2015: IF p_last_standard_date IS NOT NULL THEN
2016: --
2017: hr_utility.set_location(l_proc,7);
2018: --
2019: l_cur_entries := 'N';

Line 2021: p_last_standard_date,

2017: hr_utility.set_location(l_proc,7);
2018: --
2019: l_cur_entries := 'N';
2020: delete_entries(p_assignment_id,
2021: p_last_standard_date,
2022: 'L',
2023: p_final_process_date,
2024: l_cur_entries);
2025: if l_cur_entries = 'S' then

Line 2042: p_last_standard_date,

2038: -- hence commented out the followings.
2039: /******
2040: l_cur_alus := 'N';
2041: delete_alus(p_assignment_id,
2042: p_last_standard_date,
2043: 'L',
2044: l_cur_alus,
2045: p_alu_change_warning);
2046: ******/

Line 2048: END IF; -- IF p_last_standard_date ...

2044: l_cur_alus,
2045: p_alu_change_warning);
2046: ******/
2047: --
2048: END IF; -- IF p_last_standard_date ...
2049: --
2050: hr_utility.set_location(l_proc,9);
2051: --
2052: -- Shut down all element entries and ALU's for element types which have a

Line 2126: ,p_last_standard_process_date DATE

2122: ,p_business_group_id NUMBER
2123: ,p_person_id NUMBER
2124: ,p_assignment_status_type_id NUMBER
2125: ,p_actual_termination_date DATE
2126: ,p_last_standard_process_date DATE
2127: ,p_final_process_date DATE)
2128: IS
2129: --
2130: l_current_applicant_flag VARCHAR2(30);

Line 2190: p_last_standard_process_date IS NOT NULL)

2186: --
2187: -- Bug 1711085. VS. Removed reference to US legislature.
2188: -- if (l_legislation_code <> 'US') then
2189: if (p_actual_termination_date IS NOT NULL AND
2190: p_last_standard_process_date IS NOT NULL)
2191: then null;
2192: else
2193: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2194: hr_utility.set_message_token('PROCEDURE','TERMINATE_EMPLOYEE');

Line 2200: if (p_actual_termination_date <= p_last_standard_process_date

2196: hr_utility.raise_error;
2197: end if;
2198: --
2199: hr_utility.set_location(l_proc,5);
2200: if (p_actual_termination_date <= p_last_standard_process_date
2201: AND p_last_standard_process_date <=
2202: nvl(p_final_process_date,to_date('31/12/4712','DD/MM/YYYY')))
2203: then null;
2204: else

Line 2201: AND p_last_standard_process_date <=

2197: end if;
2198: --
2199: hr_utility.set_location(l_proc,5);
2200: if (p_actual_termination_date <= p_last_standard_process_date
2201: AND p_last_standard_process_date <=
2202: nvl(p_final_process_date,to_date('31/12/4712','DD/MM/YYYY')))
2203: then null;
2204: else
2205: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 2240: ,p_last_standard_process_date

2236: hr_utility.set_location(l_proc,20);
2237: -- VT 06/04/96 changed function call
2238: l_action_chk := hrempter.check_for_compl_actions(p_person_id
2239: ,p_actual_termination_date
2240: ,p_last_standard_process_date
2241: ,p_final_process_date);
2242: IF l_action_chk = 'W' THEN
2243: hr_utility.set_message(801,'HR_6516_EMP_TERM_ACTIONS_EXIST');
2244: hr_utility.set_warning;

Line 2623: ,p_last_standard_process_date

2619: -- VT 10/07/96 bug #306710 new parameter
2620: l_ent_loop := 'N';
2621: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id
2622: ,p_actual_termination_date
2623: ,p_last_standard_process_date
2624: ,p_final_process_date
2625: ,l_legislation_code
2626: ,l_ent_loop);
2627: if l_ent_loop = 'S' then

Line 2967: l_last_standard_process_date DATE := NULL;

2963: l_current_employee_flag VARCHAR2(30);
2964: l_max_end_date DATE;
2965: l_actual_termination_date DATE;
2966: l_action_chk VARCHAR2(1) := 'N';
2967: l_last_standard_process_date DATE := NULL;
2968: --
2969: l_entries_changed VARCHAR2(1) := 'N';
2970: l_ent_loop VARCHAR2(1) := 'N';
2971: --

Line 3019: ,l_last_standard_process_date

3015: hr_utility.set_location(l_proc,5);
3016: -- VT 06/04/96 changed function call
3017: l_action_chk := hrempter.check_for_compl_actions(p_person_id
3018: ,l_actual_termination_date
3019: ,l_last_standard_process_date
3020: ,p_final_process_date);
3021: --
3022: IF l_action_chk = 'W' THEN
3023: hr_utility.set_message(801,'HR_6517_EMP_FPD_ACTIONS_EXIST');

Line 3360: l_last_standard_process_date DATE;

3356: IS
3357: --
3358: --
3359: l_final_process_date DATE;
3360: l_last_standard_process_date DATE;
3361: l_per_system_status VARCHAR2(30);
3362: l_max_end_date DATE;
3363: l_effective_end_date DATE;
3364: l_action_chk VARCHAR2(1) := 'N';

Line 3533: , pos.last_standard_process_date

3529: , pos.business_group_id
3530: , pos.leaving_reason
3531: , pos.date_start
3532: , pos.final_process_date
3533: , pos.last_standard_process_date
3534: INTO l_period_of_service_id
3535: , l_business_group_id
3536: , l_old_leaving_reason
3537: , l_date_start

Line 3539: , l_last_standard_process_date

3535: , l_business_group_id
3536: , l_old_leaving_reason
3537: , l_date_start
3538: , l_final_process_date
3539: , l_last_standard_process_date
3540: FROM per_periods_of_service pos
3541: WHERE pos.person_id = p_person_id
3542: AND pos.actual_termination_date = p_actual_termination_date;
3543: --

Line 3576: ,l_last_standard_process_date

3572: hr_utility.set_location(l_proc,99);
3573: -- VT 06/04/96 changed function call
3574: l_action_chk := hrempter.check_for_compl_actions(p_person_id
3575: ,p_actual_termination_date
3576: ,l_last_standard_process_date
3577: ,l_final_process_date);
3578: --
3579: IF l_action_chk = 'W' THEN
3580: --

Line 3714: , pos.last_standard_process_date = null

3710: -- END WWBUG fix for 1390173
3711: --
3712: UPDATE per_periods_of_service pos
3713: SET pos.actual_termination_date = null
3714: , pos.last_standard_process_date = null
3715: , pos.final_process_date = null
3716: , pos.termination_accepted_person_id = null
3717: , pos.leaving_reason = null
3718: , pos.accepted_termination_date = null

Line 3768: , pos.last_standard_process_date = null

3764: -- END WWBUG fix for 1390173
3765: --
3766: UPDATE per_periods_of_service pos
3767: SET pos.actual_termination_date = null
3768: , pos.last_standard_process_date = null
3769: , pos.final_process_date = null
3770: , pos.termination_accepted_person_id = null
3771: , pos.leaving_reason = null
3772: , pos.notified_termination_date = null

Line 4304: ,l_last_standard_process_date

4300: hrentmnt.maintain_entries_asg(c_ass_rec.assignment_id
4301: ,c_ass_rec.business_group_id
4302: ,'CNCL_TERM'
4303: ,p_actual_termination_date
4304: ,l_last_standard_process_date
4305: ,l_final_process_date
4306: ,'DELETE_NEXT_CHANGE'
4307: ,null
4308: ,null);