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 920: p_last_standard_date DATE,

916: -- =================== terminate_entries_and_alus overload ============
917: -- VT 11/01/96 #306710 procedure overload
918: PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
919: p_actual_term_date DATE,
920: p_last_standard_date DATE,
921: p_final_process_date DATE,
922: p_legislation_code VARCHAR2 DEFAULT
923: NULL)
924: IS

Line 930: ,p_last_standard_date

926: l_entries_changed_ov VARCHAR2(1) := 'N';
927: BEGIN
928: terminate_entries_and_alus(p_assignment_id
929: ,p_actual_term_date
930: ,p_last_standard_date
931: ,p_final_process_date
932: ,p_legislation_code
933: ,l_entries_changed_ov);
934: END terminate_entries_and_alus;

Line 942: p_last_standard_date DATE,

938: -- =================== terminate_entries_and_alus overload ===================
939: --
940: PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
941: p_actual_term_date DATE,
942: p_last_standard_date DATE,
943: p_final_process_date DATE,
944: p_legislation_code VARCHAR2 DEFAULT
945: NULL,
946: p_entries_changed_warning

Line 956: ,p_last_standard_date

952: BEGIN
953: --
954: terminate_entries_and_alus(p_assignment_id
955: ,p_actual_term_date
956: ,p_last_standard_date
957: ,p_final_process_date
958: ,p_legislation_code
959: ,p_entries_changed_warning
960: ,l_alu_change_warning_ovl);

Line 970: p_last_standard_date DATE,

966: -- ========================= terminate_entries_and_alus ======================
967: --
968: PROCEDURE terminate_entries_and_alus(p_assignment_id NUMBER,
969: p_actual_term_date DATE,
970: p_last_standard_date DATE,
971: p_final_process_date DATE,
972: p_legislation_code VARCHAR2 DEFAULT
973: NULL,
974: p_entries_changed_warning

Line 1910: -- Actual Last Standard

1906: --
1907: -- Validates the combination of dates passed. The valid combinations are
1908: --
1909: -- Actual (if legislation US)
1910: -- Actual Last Standard
1911: -- Actual Last Standard Final Process
1912: -- Actual Final Process(if legislation US)
1913: -- Final Process
1914: --

Line 1911: -- Actual Last Standard Final Process

1907: -- Validates the combination of dates passed. The valid combinations are
1908: --
1909: -- Actual (if legislation US)
1910: -- Actual Last Standard
1911: -- Actual Last Standard Final Process
1912: -- Actual Final Process(if legislation US)
1913: -- Final Process
1914: --
1915: -- 288341. Removed unnecessary clause "p_legislation_code <> 'US'", which

Line 1920: -- in association with last_standard_process.

1916: -- was causing the check to fail when p_legislation_code was NULL.
1917: -- RMF 03.07.95.
1918: --
1919: -- Bug 1711085. VS. 29-Mar-01. Removed references to US legislation
1920: -- in association with last_standard_process.
1921: --
1922: -- Bug 2784295 : commenting the code which requires LSPD to be not null
1923: -- for non-US legislations
1924: IF p_actual_term_date IS NOT NULL THEN

Line 1926: p_last_standard_date IS NOT NULL) THEN */

1922: -- Bug 2784295 : commenting the code which requires LSPD to be not null
1923: -- for non-US legislations
1924: IF p_actual_term_date IS NOT NULL THEN
1925: /* (p_legislation_code = 'US' or
1926: p_last_standard_date IS NOT NULL) THEN */
1927: --
1928: -- Valid combination of parameters
1929: NULL;
1930: --

Line 1934: p_last_standard_date IS NULL THEN

1930: --
1931: ELSIF
1932: p_final_process_date IS NOT NULL AND
1933: p_actual_term_date IS NULL AND
1934: p_last_standard_date IS NULL THEN
1935: --
1936: -- Valid combination of parameters
1937: NULL;
1938: --

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

1992: --
1993: hr_utility.set_location(l_proc,6);
1994: --
1995: -- Shut down all element entries and ALU's for element types which have a
1996: -- post termination rule of 'Last Standard Process'
1997: IF p_last_standard_date IS NOT NULL THEN
1998: --
1999: hr_utility.set_location(l_proc,7);
2000: --

Line 1997: IF p_last_standard_date IS NOT NULL THEN

1993: hr_utility.set_location(l_proc,6);
1994: --
1995: -- Shut down all element entries and ALU's for element types which have a
1996: -- post termination rule of 'Last Standard Process'
1997: IF p_last_standard_date IS NOT NULL THEN
1998: --
1999: hr_utility.set_location(l_proc,7);
2000: --
2001: l_cur_entries := 'N';

Line 2003: p_last_standard_date,

1999: hr_utility.set_location(l_proc,7);
2000: --
2001: l_cur_entries := 'N';
2002: delete_entries(p_assignment_id,
2003: p_last_standard_date,
2004: 'L',
2005: p_final_process_date,
2006: l_cur_entries);
2007: if l_cur_entries = 'S' then

Line 2024: p_last_standard_date,

2020: -- hence commented out the followings.
2021: /******
2022: l_cur_alus := 'N';
2023: delete_alus(p_assignment_id,
2024: p_last_standard_date,
2025: 'L',
2026: l_cur_alus,
2027: p_alu_change_warning);
2028: ******/

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

2026: l_cur_alus,
2027: p_alu_change_warning);
2028: ******/
2029: --
2030: END IF; -- IF p_last_standard_date ...
2031: --
2032: hr_utility.set_location(l_proc,9);
2033: --
2034: -- Shut down all element entries and ALU's for element types which have a

Line 2108: ,p_last_standard_process_date DATE

2104: ,p_business_group_id NUMBER
2105: ,p_person_id NUMBER
2106: ,p_assignment_status_type_id NUMBER
2107: ,p_actual_termination_date DATE
2108: ,p_last_standard_process_date DATE
2109: ,p_final_process_date DATE)
2110: IS
2111: --
2112: l_current_applicant_flag VARCHAR2(30);

Line 2172: p_last_standard_process_date IS NOT NULL)

2168: --
2169: -- Bug 1711085. VS. Removed reference to US legislature.
2170: -- if (l_legislation_code <> 'US') then
2171: if (p_actual_termination_date IS NOT NULL AND
2172: p_last_standard_process_date IS NOT NULL)
2173: then null;
2174: else
2175: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2176: hr_utility.set_message_token('PROCEDURE','TERMINATE_EMPLOYEE');

Line 2182: if (p_actual_termination_date <= p_last_standard_process_date

2178: hr_utility.raise_error;
2179: end if;
2180: --
2181: hr_utility.set_location(l_proc,5);
2182: if (p_actual_termination_date <= p_last_standard_process_date
2183: AND p_last_standard_process_date <=
2184: nvl(p_final_process_date,to_date('31/12/4712','DD/MM/YYYY')))
2185: then null;
2186: else

Line 2183: AND p_last_standard_process_date <=

2179: end if;
2180: --
2181: hr_utility.set_location(l_proc,5);
2182: if (p_actual_termination_date <= p_last_standard_process_date
2183: AND p_last_standard_process_date <=
2184: nvl(p_final_process_date,to_date('31/12/4712','DD/MM/YYYY')))
2185: then null;
2186: else
2187: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 2222: ,p_last_standard_process_date

2218: hr_utility.set_location(l_proc,20);
2219: -- VT 06/04/96 changed function call
2220: l_action_chk := hrempter.check_for_compl_actions(p_person_id
2221: ,p_actual_termination_date
2222: ,p_last_standard_process_date
2223: ,p_final_process_date);
2224: IF l_action_chk = 'W' THEN
2225: hr_utility.set_message(801,'HR_6516_EMP_TERM_ACTIONS_EXIST');
2226: hr_utility.set_warning;

Line 2605: ,p_last_standard_process_date

2601: -- VT 10/07/96 bug #306710 new parameter
2602: l_ent_loop := 'N';
2603: hrempter.terminate_entries_and_alus(c_ass_rec.assignment_id
2604: ,p_actual_termination_date
2605: ,p_last_standard_process_date
2606: ,p_final_process_date
2607: ,l_legislation_code
2608: ,l_ent_loop);
2609: if l_ent_loop = 'S' then

Line 2949: l_last_standard_process_date DATE := NULL;

2945: l_current_employee_flag VARCHAR2(30);
2946: l_max_end_date DATE;
2947: l_actual_termination_date DATE;
2948: l_action_chk VARCHAR2(1) := 'N';
2949: l_last_standard_process_date DATE := NULL;
2950: --
2951: l_entries_changed VARCHAR2(1) := 'N';
2952: l_ent_loop VARCHAR2(1) := 'N';
2953: --

Line 3001: ,l_last_standard_process_date

2997: hr_utility.set_location(l_proc,5);
2998: -- VT 06/04/96 changed function call
2999: l_action_chk := hrempter.check_for_compl_actions(p_person_id
3000: ,l_actual_termination_date
3001: ,l_last_standard_process_date
3002: ,p_final_process_date);
3003: --
3004: IF l_action_chk = 'W' THEN
3005: hr_utility.set_message(801,'HR_6517_EMP_FPD_ACTIONS_EXIST');

Line 3342: l_last_standard_process_date DATE;

3338: IS
3339: --
3340: --
3341: l_final_process_date DATE;
3342: l_last_standard_process_date DATE;
3343: l_per_system_status VARCHAR2(30);
3344: l_max_end_date DATE;
3345: l_effective_end_date DATE;
3346: l_action_chk VARCHAR2(1) := 'N';

Line 3466: , pos.last_standard_process_date

3462: , pos.business_group_id
3463: , pos.leaving_reason
3464: , pos.date_start
3465: , pos.final_process_date
3466: , pos.last_standard_process_date
3467: INTO l_period_of_service_id
3468: , l_business_group_id
3469: , l_old_leaving_reason
3470: , l_date_start

Line 3472: , l_last_standard_process_date

3468: , l_business_group_id
3469: , l_old_leaving_reason
3470: , l_date_start
3471: , l_final_process_date
3472: , l_last_standard_process_date
3473: FROM per_periods_of_service pos
3474: WHERE pos.person_id = p_person_id
3475: AND pos.actual_termination_date = p_actual_termination_date;
3476: --

Line 3509: ,l_last_standard_process_date

3505: hr_utility.set_location(l_proc,99);
3506: -- VT 06/04/96 changed function call
3507: l_action_chk := hrempter.check_for_compl_actions(p_person_id
3508: ,p_actual_termination_date
3509: ,l_last_standard_process_date
3510: ,l_final_process_date);
3511: --
3512: IF l_action_chk = 'W' THEN
3513: --

Line 3596: , pos.last_standard_process_date = null

3592: -- END WWBUG fix for 1390173
3593: --
3594: UPDATE per_periods_of_service pos
3595: SET pos.actual_termination_date = null
3596: , pos.last_standard_process_date = null
3597: , pos.final_process_date = null
3598: , pos.termination_accepted_person_id = null
3599: , pos.leaving_reason = null
3600: , pos.accepted_termination_date = null

Line 3650: , pos.last_standard_process_date = null

3646: -- END WWBUG fix for 1390173
3647: --
3648: UPDATE per_periods_of_service pos
3649: SET pos.actual_termination_date = null
3650: , pos.last_standard_process_date = null
3651: , pos.final_process_date = null
3652: , pos.termination_accepted_person_id = null
3653: , pos.leaving_reason = null
3654: , pos.notified_termination_date = null

Line 4154: ,l_last_standard_process_date

4150: hrentmnt.maintain_entries_asg(c_ass_rec.assignment_id
4151: ,c_ass_rec.business_group_id
4152: ,'CNCL_TERM'
4153: ,p_actual_termination_date
4154: ,l_last_standard_process_date
4155: ,l_final_process_date
4156: ,'DELETE_NEXT_CHANGE'
4157: ,null
4158: ,null);