[Home] [Help]
1: package body hr_payrolls as
2: /* $Header: pypyroll.pkb 120.1.12010000.1 2008/07/27 23:31:37 appldev ship $ */
3: --
4: -- Package constants, denoting the base period types.
5: --
28: procedure get_period_details (p_proc_period_type in varchar2,
29: p_base_period_type out nocopy varchar2,
30: p_multiple out nocopy number) is
31: --
32: proc_name CONSTANT varchar2(50) := 'hr_payrolls.get_period_details';
33: --
34: no_periods per_time_period_types.number_per_fiscal_year%type;
35: --
36: begin
88: return date is
89: day_of_month varchar2(2);
90: last_of_month date;
91: temp_day varchar2(2);
92: func_name CONSTANT varchar2(50) := 'hr_payrolls.next_semi_month';
93: begin
94: hr_utility.set_location(func_name, 1);
95: day_of_month := substr(to_char(p_fpe_date, 'DD-MON-YYYY'), 1, 2);
96: if (day_of_month = '15') OR (last_day(p_fpe_date) = p_fpe_date) then
135: day_of_month varchar2(2);
136: last_of_month date;
137: temp_date date;
138: temp_day varchar2(2);
139: func_name CONSTANT varchar2(50) := 'hr_payrolls.prev_semi_month';
140: begin
141: -- Get the day of the current month.
142: hr_utility.set_location(func_name, 1);
143: day_of_month := substr(to_char(p_fpe_date, 'DD-MON-YYYY'), 1, 2);
301: p_regular_pay_mode boolean default false,
302: p_pay_date_offset number default null)
303: return date is
304: --
305: func_name CONSTANT varchar2(50) := 'hr_payrolls.add_multiple_of_base';
306: rest_of_date varchar2(9);
307: temp_date date;
308: -- Bug 5935976 for 10 Payroll
309: l_date2 date;
426: -- count on the payroll details record being populated.
427: --
428: procedure derive_payroll_dates(p_pay_det in out nocopy payroll_rec_type) is
429: --
430: proc_name CONSTANT varchar2(50) := 'hr_payrolls.derive_payroll_dates';
431: --
432: earliest_start_date date;
433: latest_end_date date;
434: no_periods number;
499: ,p_next_leg_start_date in date
500: ,p_period_end_date in out nocopy per_time_periods.end_date%type
501: ,p_no_of_weeks_reset in out nocopy number ) IS
502: --
503: proc_name CONSTANT varchar2(50) := 'hr_payrolls.chk_reset';
504: --
505: --
506: l_no_of_weeks number := 0;
507: l_week_number number;
609: END chk_reset;
610: --
611: PROCEDURE clear_warnings IS
612: --
613: proc_name CONSTANT varchar2(50) := 'hr_payrolls.clear_warnings';
614: --
615: BEGIN
616: --
617: hr_utility.set_location(proc_name, 1);
632: ,p_no_of_weeks_reset IN OUT nocopy number
633: ,p_reset_period_name IN OUT nocopy per_time_periods.period_name%type
634: ,p_new_end_date IN OUT nocopy per_time_periods.end_date%type ) IS
635: --
636: proc_name CONSTANT varchar2(50) := 'hr_payrolls.get_warnings';
637: --
638: BEGIN
639: --
640: hr_utility.set_location(proc_name, 1);
676: p_created_by in number default -1,
677: p_creation_date in date default sysdate,
678: p_first_gen_date out nocopy date) is
679: --
680: proc_name CONSTANT varchar2(50) := 'hr_payrolls.insert_proc_periods';
681: --
682: per_num number; -- Monotonic period number, not displayed.
683: payroll_start_date pay_all_payrolls_f.effective_start_date%type;
684: payroll_end_date pay_all_payrolls_f.effective_end_date%type;
1226: p_last_update_login in number,
1227: p_created_by in number,
1228: p_creation_date in date) is
1229: --
1230: proc_name CONSTANT varchar2(50) := 'hr_payrolls.create_payroll_proc_periods';
1231: --
1232: payroll_details payroll_rec_type;
1233: l_first_gen_end_date date;
1234: --
1318: p_created_by in number,
1319: p_creation_date in date,
1320: p_effective_date in date ) is
1321: --
1322: proc_name CONSTANT varchar2(50) := 'hr_payrolls.create_payroll_proc_periods';
1323: --
1324: payroll_details payroll_rec_type;
1325: l_first_gen_end_date date;
1326: --
1495: BEGIN
1496: g_constant_end_date := p_constant_end_date ;
1497: END set_globals;
1498: --
1499: end hr_payrolls;