APPS.SSP_SMP_SUPPORT_PKG dependencies on HR_GENERAL

Line 198: if p_date is not null and p_date <> hr_general.end_of_time

194: hr_utility.set_location('Entering:'||l_proc,1);
195: --
196: hr_utility.trace(' p_date: '||to_char (p_date));
197: --
198: if p_date is not null and p_date <> hr_general.end_of_time
199: then
200: if rtrim (to_char (p_date, 'DAY')) <> l_sunday_txt then
201: l_Sunday := next_day (p_date, l_sunday_txt) -7;
202: end if;

Line 226: if p_date is not null and p_date <> hr_general.end_of_time

222: hr_utility.set_location('Entering:'||l_proc,1);
223: --
224: hr_utility.trace(' p_date: '||to_char (p_date));
225: --
226: if p_date is not null and p_date <> hr_general.end_of_time
227: then
228: if rtrim (to_char (p_date, 'DAY')) <> l_saturday_txt then
229: l_Saturday := next_day (p_date, l_saturday_txt);
230: end if;

Line 258: if p_date is not null and p_date <> hr_general.end_of_time

254: hr_utility.trace(' p_date: '||to_char (p_date));
255: --
256: if p_start_date is not null then
257: l_day_txt := rtrim(to_char(p_start_date -1,'DAY'));
258: if p_date is not null and p_date <> hr_general.end_of_time
259: then
260: if rtrim (to_char (p_date, 'DAY')) <> l_day_txt then
261: l_date := next_day (p_date, l_day_txt);
262: end if;

Line 299: hr_general.assert_condition (all_parameters_valid);

295: --
296: hr_utility.trace (l_proc||' p_effective_date = '
297: ||to_char (p_effective_date));
298: --
299: hr_general.assert_condition (all_parameters_valid);
300: --
301: end check_parameters;
302: --
303: begin

Line 702: l_last_process_date date := nvl (p_last_process_date,hr_general.end_of_time);

698: l_closed_period date;
699: l_effective_date date := null;
700: l_effective_start_date date := null;
701: l_effective_end_date date := null;
702: l_last_process_date date := nvl (p_last_process_date,hr_general.end_of_time);
703: --
704: l_payroll_id number := null;
705: --
706: --

Line 733: max(nvl(effective_end_date,hr_general.end_of_time))

729: cursor csr_assignment_duration(p_date date,
730: p_asg_id number,
731: p_pay_id number) is
732: select min(effective_start_date),
733: max(nvl(effective_end_date,hr_general.end_of_time))
734: from per_all_assignments_f
735: where assignment_id = p_asg_id
736: and primary_flag = 'Y'
737: and assignment_type = 'E'

Line 751: min(nvl(period.end_date,hr_general.end_of_time))

747: --
748: -- Get period details
749: cursor csr_payroll_period is
750: select min(period.start_date),
751: min(nvl(period.end_date,hr_general.end_of_time))
752: from per_time_periods period
753: where period.payroll_id = l_payroll_id
754: and period.start_date > l_closed_period
755: --6959669 begin

Line 785: hr_general.assert_condition (all_parameters_valid);

781: hr_utility.trace (' p_element_link_id = '||to_char (p_element_link_id));
782: hr_utility.trace (' p_assignment_id = '||to_char (p_assignment_id));
783: hr_utility.trace (' p_pay_as_lump_sum = '||p_pay_as_lump_sum);
784: --
785: hr_general.assert_condition (all_parameters_valid);
786: --
787: end check_parameters;
788: --
789: begin