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_ENTRY dependencies on HR_GENERAL

Line 724: hr_general.assert_condition (all_parameters_are_valid);

720: hr_utility.trace(' p_effective_date : '|| p_effective_date);
721: hr_utility.trace(' p_creator_type : '|| p_creator_type);
722: end if;
723: --
724: hr_general.assert_condition (all_parameters_are_valid);
725: --
726: open csr_eligibility;
727: fetch csr_eligibility into l_eligibility;
728: close csr_eligibility;

Line 1004: hr_general.assert_condition (all_parameters_are_valid

1000: --
1001: -- Check that the parameters are valid (doing it here allows us to
1002: -- encompass a check that the cursors returned values correctly)
1003: --
1004: hr_general.assert_condition (all_parameters_are_valid
1005: and l_assignment.asgt_start is not null -- p_assignment_id is a valid row
1006: and l_link.link_start is not null -- p_element_link_id is a valid row
1007: );
1008: --

Line 1085: l_time_period_start_date := nvl(p_time_period_start_date, hr_general.start_of_time);

1081: -- time period, since non-recurring entries CANNOT exist beyond the time
1082: -- period they are created in.
1083: --
1084: -- Default the time period start date to the 'start of time' if null...
1085: l_time_period_start_date := nvl(p_time_period_start_date, hr_general.start_of_time);
1086: -- Default the time period end date to the 'end of time' if null...
1087: l_time_period_end_date := nvl(p_time_period_end_date, hr_general.end_of_time);
1088: --
1089: if g_debug then

Line 1087: l_time_period_end_date := nvl(p_time_period_end_date, hr_general.end_of_time);

1083: --
1084: -- Default the time period start date to the 'start of time' if null...
1085: l_time_period_start_date := nvl(p_time_period_start_date, hr_general.start_of_time);
1086: -- Default the time period end date to the 'end of time' if null...
1087: l_time_period_end_date := nvl(p_time_period_end_date, hr_general.end_of_time);
1088: --
1089: if g_debug then
1090: hr_utility.trace(' l_time_period_start_date: '||to_char(l_time_period_start_date,'DD-MON-YYYY'));
1091: hr_utility.trace(' l_time_period_end_date: '||to_char(l_time_period_end_date,'DD-MON-YYYY'));

Line 1180: and nvl(ser.actual_termination_date, hr_general.end_of_time);

1176: where ser.person_id = (select distinct person_id
1177: from per_all_assignments_f
1178: where assignment_id = p_assignment_id)
1179: and (c1rec.effective_start_date - 1) between ser.date_start
1180: and nvl(ser.actual_termination_date, hr_general.end_of_time);
1181:
1182: -- Get terminaation rule for element
1183: select pet.post_termination_rule
1184: into l_post_termination_rule

Line 1424: hr_general.assert_condition (p_assignment_id is not null

1420: g_debug := hr_utility.debug_enabled;
1421: --
1422: -- Ensure all mandatory parameters exist.
1423: --
1424: hr_general.assert_condition (p_assignment_id is not null
1425: and p_element_link_id is not null
1426: and p_session_date is not null
1427: and p_session_date = trunc (p_session_date));
1428: --

Line 1572: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);

1568: --
1569: -- Get the termination rule date
1570: --
1571: if v_post_termination_rule = 'L' then
1572: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);
1573: elsif v_post_termination_rule = 'F' then
1574: v_element_term_rule_date := nvl(v_final_process_date, hr_general.end_of_time);
1575: else
1576: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);

Line 1574: v_element_term_rule_date := nvl(v_final_process_date, hr_general.end_of_time);

1570: --
1571: if v_post_termination_rule = 'L' then
1572: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);
1573: elsif v_post_termination_rule = 'F' then
1574: v_element_term_rule_date := nvl(v_final_process_date, hr_general.end_of_time);
1575: else
1576: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);
1577: end if;
1578: --

Line 1576: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);

1572: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);
1573: elsif v_post_termination_rule = 'F' then
1574: v_element_term_rule_date := nvl(v_final_process_date, hr_general.end_of_time);
1575: else
1576: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);
1577: end if;
1578: --
1579: -- Bug 382760. If termination rule is Actual Termination or Last Standard
1580: -- Process and element is Nonrecurring then entries close down on the last day

Line 1607: v_element_term_rule_date := nvl(v_element_term_rule_date,hr_general.end_of_time);

1603: when no_data_found then
1604: -- It's possible a NO_DATA_FOUND error was raised by the period end
1605: -- date fetch, in which case we want to retain the (unmodified)
1606: -- v_element_term_rule_date. A 'NVL' achieves this for us...
1607: v_element_term_rule_date := nvl(v_element_term_rule_date,hr_general.end_of_time);
1608: --
1609: end;
1610: --
1611: end if;

Line 1677: v_element_term_rule_date := hr_general.end_of_time;

1673: -- As the employee assignment does have the 'END' status the element
1674: -- termination processing rule will always be the effective_start_date.
1675: --
1676: if v_asg_term_date is null then
1677: v_element_term_rule_date := hr_general.end_of_time;
1678: else
1679: v_element_term_rule_date := v_asg_term_date;
1680: end if;
1681: --

Line 1799: -- v_element_term_rule_date := hr_general.end_of_time;

1795: -- hr_utility.trace(' employee NOT terminated');
1796: -- hr_utility.trace(' PRIMARY assignment');
1797: -- end if;
1798: --
1799: -- v_element_term_rule_date := hr_general.end_of_time;
1800: --
1801: /*End Comment*/
1802: end if;
1803: --

Line 1811: if ((v_element_term_rule_date <> hr_general.end_of_time) and

1807: --
1808: -- check to see if the v_element_term_rule_date is being set to before
1809: -- the session date.
1810: --
1811: if ((v_element_term_rule_date <> hr_general.end_of_time) and
1812: (v_element_term_rule_date < p_session_date) and p_entry_mode) then
1813: --
1814: hr_utility.set_message(801, 'HR_6370_ELE_ENTRY_NO_TERM');
1815: hr_utility.raise_error;

Line 1965: v_future_recurring_end_date := hr_general.end_of_time;

1961: end if;
1962: --
1963: -- Initialiize local parameters
1964: --
1965: v_future_recurring_end_date := hr_general.end_of_time;
1966: v_error_flag := 'N';
1967: --
1968: -- Ensure all mandatory parameters exist.
1969: --

Line 1970: hr_general.assert_condition (p_assignment_id is not null

1966: v_error_flag := 'N';
1967: --
1968: -- Ensure all mandatory parameters exist.
1969: --
1970: hr_general.assert_condition (p_assignment_id is not null
1971: and p_element_link_id is not null
1972: and p_session_date is not null
1973: and p_session_date = trunc (p_session_date));
1974: --

Line 2008: nvl(min(pee.effective_start_date) - 1, hr_general.end_of_time)

2004: end if;
2005: begin
2006: -- INDEX hint added following NHS project recommendation
2007: select /*+ INDEX(pee, pay_element_entries_f_n51) */
2008: nvl(min(pee.effective_start_date) - 1, hr_general.end_of_time)
2009: into v_future_recurring_end_date
2010: from pay_element_entries_f pee
2011: where pee.entry_type = 'E'
2012: and pee.assignment_id = p_assignment_id

Line 2790: hr_general.assert_condition (p_session_date = trunc (p_session_date)

2786: g_debug := hr_utility.debug_enabled;
2787: if g_debug then
2788: hr_utility.set_location ('hr_entry.chk_mandatory_input_value',1);
2789: end if;
2790: hr_general.assert_condition (p_session_date = trunc (p_session_date)
2791: and p_input_value_id is not null
2792: and p_session_date is not null);
2793: --
2794: if (p_input_value_id is not null and

Line 2880: hr_general.assert_condition (

2876: begin
2877: if g_debug then
2878: hr_utility.set_location ('hr_entry.chk_mandatory_entry_values',1);
2879: end if;
2880: hr_general.assert_condition (
2881: p_validation_start_date = trunc (p_validation_start_date));
2882: --
2883: -- For every entry value make sure that a value has been supplied if it
2884: -- is mandatory.

Line 3231: p_validation_end_date = hr_general.end_of_time)) then

3227: --
3228: if ((p_usage = 'INSERT' or
3229: p_dt_delete_mode = 'FUTURE_CHANGE') or
3230: (p_dt_delete_mode = 'DELETE_NEXT_CHANGE' and
3231: p_validation_end_date = hr_general.end_of_time)) then
3232: --
3233: if g_debug then
3234: hr_utility.set_location('hr_entry.chk_element_entry_main', 10);
3235: end if;

Line 3396: p_validation_end_date = hr_general.end_of_time)) then

3392: --
3393: if ((p_usage = 'INSERT' or
3394: p_dt_delete_mode = 'FUTURE_CHANGE') or
3395: (p_dt_delete_mode = 'DELETE_NEXT_CHANGE' and
3396: p_validation_end_date = hr_general.end_of_time)) then
3397: --
3398: if g_debug then
3399: hr_utility.set_location('hr_entry.chk_element_entry_main', 20);
3400: end if;

Line 3761: p_validation_end_date = hr_general.end_of_time)) then

3757: v_processing_type = 'R' and
3758: ((p_usage = 'INSERT' or
3759: p_dt_delete_mode = 'FUTURE_CHANGE') or
3760: (p_dt_delete_mode = 'DELETE_NEXT_CHANGE' and
3761: p_validation_end_date = hr_general.end_of_time)) then
3762: p_effective_end_date := v_validation_end_date;
3763: elsif (p_entry_type = 'E' and v_processing_type = 'N') or
3764: p_entry_type <> 'E' then
3765: p_effective_start_date := greatest(v_validation_start_date,

Line 4529: if p_validation_end_date = hr_general.end_of_time then

4525: and ben.effective_end_date = p_validation_start_date -1;
4526: --
4527: begin
4528: --
4529: if p_validation_end_date = hr_general.end_of_time then
4530: --
4531: -- If the validation end date is the end of time then we are on the
4532: -- last date-effective row and we must be extending it out to the end
4533: -- of time. In this case only, also extend the child beneficiary rows

Line 4573: if p_validation_start_date = hr_general.end_of_time then

4569: and dep.effective_end_date = p_validation_start_date -1;
4570: --
4571: begin
4572: --
4573: if p_validation_start_date = hr_general.end_of_time then
4574: --
4575: -- If the validation end date is the end of time then we are on the
4576: -- last date-effective row and we must be extending it out to the end
4577: -- of time. In this case only, also extend the child dependant rows

Line 4887: hr_general.assert_condition (p_processing_type is not null

4883: begin
4884: if g_debug then
4885: hr_utility.set_location('hr_entry.upd_3p_entry_values', 1);
4886: end if;
4887: hr_general.assert_condition (p_processing_type is not null
4888: and p_dt_update_mode is not null
4889: and p_element_entry_id is not null
4890: and p_element_type_id is not null
4891: and p_element_link_id is not null