DBA Data[Home] [Help]

APPS.HR_ENTRY dependencies on HR_GENERAL

Line 668: hr_general.assert_condition (all_parameters_are_valid);

664: l_eligibility varchar2 (1) := 'N';
665: --
666: begin
667: --
668: hr_general.assert_condition (all_parameters_are_valid);
669: --
670: open csr_eligibility;
671: fetch csr_eligibility into l_eligibility;
672: close csr_eligibility;

Line 886: hr_general.assert_condition (all_parameters_are_valid

882: --
883: -- Check that the parameters are valid (doing it here allows us to
884: -- encompass a check that the cursors returned values correctly)
885: --
886: hr_general.assert_condition (all_parameters_are_valid
887: and l_assignment.asgt_start is not null -- p_assignment_id is a valid row
888: and l_link.link_start is not null -- p_element_link_id is a valid row
889: );
890: --

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

963: -- time period, since non-recurring entries CANNOT exist beyond the time
964: -- period they are created in.
965: --
966: -- Default the time period start date to the 'start of time' if null...
967: l_time_period_start_date := nvl(p_time_period_start_date, hr_general.start_of_time);
968: -- Default the time period end date to the 'end of time' if null...
969: l_time_period_end_date := nvl(p_time_period_end_date, hr_general.end_of_time);
970: --
971: if g_debug then

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

965: --
966: -- Default the time period start date to the 'start of time' if null...
967: l_time_period_start_date := nvl(p_time_period_start_date, hr_general.start_of_time);
968: -- Default the time period end date to the 'end of time' if null...
969: l_time_period_end_date := nvl(p_time_period_end_date, hr_general.end_of_time);
970: --
971: if g_debug then
972: hr_utility.trace(' l_time_period_start_date: '||to_char(l_time_period_start_date,'DD-MON-YYYY'));
973: hr_utility.trace(' l_time_period_end_date: '||to_char(l_time_period_end_date,'DD-MON-YYYY'));

Line 1232: hr_general.assert_condition (p_assignment_id is not null

1228: g_debug := hr_utility.debug_enabled;
1229: --
1230: -- Ensure all mandatory parameters exist.
1231: --
1232: hr_general.assert_condition (p_assignment_id is not null
1233: and p_element_link_id is not null
1234: and p_session_date is not null
1235: and p_session_date = trunc (p_session_date));
1236: --

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

1368: --
1369: -- Get the termination rule date
1370: --
1371: if v_post_termination_rule = 'L' then
1372: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);
1373: elsif v_post_termination_rule = 'F' then
1374: v_element_term_rule_date := nvl(v_final_process_date, hr_general.end_of_time);
1375: else
1376: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);

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

1370: --
1371: if v_post_termination_rule = 'L' then
1372: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);
1373: elsif v_post_termination_rule = 'F' then
1374: v_element_term_rule_date := nvl(v_final_process_date, hr_general.end_of_time);
1375: else
1376: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);
1377: end if;
1378: --

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

1372: v_element_term_rule_date := nvl(v_last_standard_process_date, hr_general.end_of_time);
1373: elsif v_post_termination_rule = 'F' then
1374: v_element_term_rule_date := nvl(v_final_process_date, hr_general.end_of_time);
1375: else
1376: v_element_term_rule_date := nvl(v_actual_termination_date, hr_general.end_of_time);
1377: end if;
1378: --
1379: -- Bug 382760. If termination rule is Actual Termination or Last Standard
1380: -- Process and element is Nonrecurring then entries close down on the last day

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

1403: when no_data_found then
1404: -- It's possible a NO_DATA_FOUND error was raised by the period end
1405: -- date fetch, in which case we want to retain the (unmodified)
1406: -- v_element_term_rule_date. A 'NVL' achieves this for us...
1407: v_element_term_rule_date := nvl(v_element_term_rule_date,hr_general.end_of_time);
1408: --
1409: end;
1410: --
1411: end if;

Line 1469: v_element_term_rule_date := hr_general.end_of_time;

1465: -- As the employee assignment does have the 'END' status the element
1466: -- termination processing rule will always be the effective_start_date.
1467: --
1468: if v_asg_term_date is null then
1469: v_element_term_rule_date := hr_general.end_of_time;
1470: else
1471: v_element_term_rule_date := v_asg_term_date;
1472: end if;
1473: --

Line 1588: v_element_term_rule_date := hr_general.end_of_time;

1584: hr_utility.trace(' employee NOT terminated');
1585: hr_utility.trace(' PRIMARY assignment');
1586: end if;
1587: --
1588: v_element_term_rule_date := hr_general.end_of_time;
1589: --
1590: end if;
1591: --
1592: if g_debug then

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

1595: --
1596: -- check to see if the v_element_term_rule_date is being set to before
1597: -- the session date.
1598: --
1599: if ((v_element_term_rule_date <> hr_general.end_of_time) and
1600: (v_element_term_rule_date < p_session_date) and p_entry_mode) then
1601: --
1602: hr_utility.set_message(801, 'HR_6370_ELE_ENTRY_NO_TERM');
1603: hr_utility.raise_error;

Line 1742: v_future_recurring_end_date := hr_general.end_of_time;

1738: g_debug := hr_utility.debug_enabled;
1739: --
1740: -- Initialiize local parameters
1741: --
1742: v_future_recurring_end_date := hr_general.end_of_time;
1743: v_error_flag := 'N';
1744: --
1745: -- Ensure all mandatory parameters exist.
1746: --

Line 1747: hr_general.assert_condition (p_assignment_id is not null

1743: v_error_flag := 'N';
1744: --
1745: -- Ensure all mandatory parameters exist.
1746: --
1747: hr_general.assert_condition (p_assignment_id is not null
1748: and p_element_link_id is not null
1749: and p_session_date is not null
1750: and p_session_date = trunc (p_session_date));
1751: --

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

1779: end if;
1780: begin
1781: -- INDEX hint added following NHS project recommendation
1782: select /*+ INDEX(pee, pay_element_entries_f_n51) */
1783: nvl(min(pee.effective_start_date) - 1, hr_general.end_of_time)
1784: into v_future_recurring_end_date
1785: from pay_element_entries_f pee
1786: where pee.entry_type = 'E'
1787: and pee.assignment_id = p_assignment_id

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

2535: g_debug := hr_utility.debug_enabled;
2536: if g_debug then
2537: hr_utility.set_location ('hr_entry.chk_mandatory_input_value',1);
2538: end if;
2539: hr_general.assert_condition (p_session_date = trunc (p_session_date)
2540: and p_input_value_id is not null
2541: and p_session_date is not null);
2542: --
2543: if (p_input_value_id is not null and

Line 2629: hr_general.assert_condition (

2625: begin
2626: if g_debug then
2627: hr_utility.set_location ('hr_entry.chk_mandatory_entry_values',1);
2628: end if;
2629: hr_general.assert_condition (
2630: p_validation_start_date = trunc (p_validation_start_date));
2631: --
2632: -- For every entry value make sure that a value has been supplied if it
2633: -- is mandatory.

Line 2939: p_validation_end_date = hr_general.end_of_time)) then

2935: --
2936: if ((p_usage = 'INSERT' or
2937: p_dt_delete_mode = 'FUTURE_CHANGE') or
2938: (p_dt_delete_mode = 'DELETE_NEXT_CHANGE' and
2939: p_validation_end_date = hr_general.end_of_time)) then
2940: --
2941: if g_debug then
2942: hr_utility.set_location('hr_entry.chk_element_entry_main', 10);
2943: end if;

Line 3025: p_validation_end_date = hr_general.end_of_time)) then

3021: --
3022: if ((p_usage = 'INSERT' or
3023: p_dt_delete_mode = 'FUTURE_CHANGE') or
3024: (p_dt_delete_mode = 'DELETE_NEXT_CHANGE' and
3025: p_validation_end_date = hr_general.end_of_time)) then
3026: --
3027: if g_debug then
3028: hr_utility.set_location('hr_entry.chk_element_entry_main', 20);
3029: end if;

Line 3385: p_validation_end_date = hr_general.end_of_time)) then

3381: v_processing_type = 'R' and
3382: ((p_usage = 'INSERT' or
3383: p_dt_delete_mode = 'FUTURE_CHANGE') or
3384: (p_dt_delete_mode = 'DELETE_NEXT_CHANGE' and
3385: p_validation_end_date = hr_general.end_of_time)) then
3386: p_effective_end_date := v_validation_end_date;
3387: elsif (p_entry_type = 'E' and v_processing_type = 'N') or
3388: p_entry_type <> 'E' then
3389: p_effective_start_date := greatest(v_validation_start_date,

Line 4153: if p_validation_end_date = hr_general.end_of_time then

4149: and ben.effective_end_date = p_validation_start_date -1;
4150: --
4151: begin
4152: --
4153: if p_validation_end_date = hr_general.end_of_time then
4154: --
4155: -- If the validation end date is the end of time then we are on the
4156: -- last date-effective row and we must be extending it out to the end
4157: -- of time. In this case only, also extend the child beneficiary rows

Line 4197: if p_validation_start_date = hr_general.end_of_time then

4193: and dep.effective_end_date = p_validation_start_date -1;
4194: --
4195: begin
4196: --
4197: if p_validation_start_date = hr_general.end_of_time then
4198: --
4199: -- If the validation end date is the end of time then we are on the
4200: -- last date-effective row and we must be extending it out to the end
4201: -- of time. In this case only, also extend the child dependant rows

Line 4511: hr_general.assert_condition (p_processing_type is not null

4507: begin
4508: if g_debug then
4509: hr_utility.set_location('hr_entry.upd_3p_entry_values', 1);
4510: end if;
4511: hr_general.assert_condition (p_processing_type is not null
4512: and p_dt_update_mode is not null
4513: and p_element_entry_id is not null
4514: and p_element_type_id is not null
4515: and p_element_link_id is not null