1 package hr_payrolls AUTHID CURRENT_USER as
2 /* $Header: pypyroll.pkh 120.0.12010000.1 2008/07/27 23:31:39 appldev ship $ */
3 --
4 --
5 -- The record fields are self-explanatory, with the exception of:
6 --
7 -- base_period_type - the base period type of the processing period
8 -- type (weekly, semi-monthly or monthly).
9 -- multiple - multiple of base period type in period type.
10 -- Has special meaning for Semi-Monthly, adding
11 -- periods if +ve, else subtracting.
12 -- first_start_date - start date of the very first period either
13 -- generated or to be generated for the payroll.
14 -- first_end_date - end date of the very first period either
15 -- generated or to be generated for the payroll.
16 -- first_gen_start_date - start date of the first period to be generated
17 -- in this invocation (= first_start_date if no
18 -- periods currently exist).
19 -- first_gen_end_date - end date of the first period to be generated
20 -- in this invocation (= first_end_date if no
21 -- periods currently exist).
22 --
23 type payroll_rec_type is record
24 (
25 payroll_id pay_all_payrolls_f.payroll_id%type,
26 legislation_code fnd_territories_vl.territory_code%type,
27 no_years pay_all_payrolls_f.number_of_years%type,
28 period_type pay_all_payrolls_f.period_type%type,
29 pay_date_offset pay_all_payrolls_f.pay_date_offset%type,
30 cut_off_date_offset pay_all_payrolls_f.cut_off_date_offset%type,
31 pay_advice_date_offset pay_all_payrolls_f.pay_advice_date_offset%type,
32 direct_deposit_date_offset pay_all_payrolls_f.direct_deposit_date_offset%type,
33 base_period_type varchar2(1),
34 multiple number,
35 first_start_date date,
36 first_end_date date,
37 first_gen_start_date date,
38 first_gen_end_date date,
39 period_reset_years pay_all_payrolls_f.period_reset_years%type,
40 payslip_view_date_offset pay_all_payrolls_f.payslip_view_date_offset%type
41 );
42 --
43 -- The entry point to the package, both for initial creation of
44 -- periods and creaion of further periods.
45 --
46 procedure create_payroll_proc_periods (p_payroll_id in number,
47 p_last_update_date in date,
48 p_last_updated_by in number,
49 p_last_update_login in number,
50 p_created_by in number,
51 p_creation_date in date);
52 --
53 --This is a overloaded version of create_payroll_proc_periods with
54 --additional parameter p_effective_date and using PAY_ALL_PAYROLLS_F
55 --table instead of PAY_ALL_PAYROLLS view.
56 --
57 procedure create_payroll_proc_periods (p_payroll_id in number,
58 p_last_update_date in date,
59 p_last_updated_by in number,
60 p_last_update_login in number,
61 p_created_by in number,
62 p_creation_date in date,
63 p_effective_date in date );
64 --
65 -- This procedure does not currently use PER_TIME_PERIOD_RULES, since that
66 -- table is subject to some change.
67 --
68 procedure get_period_details (p_proc_period_type in varchar2,
69 p_base_period_type out nocopy varchar2,
70 p_multiple out nocopy number);
71 --
72 -- This function displays the correct format of period_name
73 -- depending on ACTION_TYPE.
74 --
75 FUNCTION display_period_name (p_payroll_action_id in number)
76 RETURN VARCHAR2;
77 PRAGMA RESTRICT_REFERENCES(display_period_name,WNDS,WNPS);
78 --
79 -- Added by Ed Jones 12/3/2001
80 PROCEDURE enable_display_fetch(p_mode IN BOOLEAN);
81 FUNCTION display_period_name_forced(p_payroll_action_id IN NUMBER)
82 RETURN VARCHAR2;
83 PRAGMA RESTRICT_REFERENCES(display_period_name_forced,WNDS,WNPS);
84 --
85 procedure derive_payroll_dates(p_pay_det in out nocopy payroll_rec_type);
86 --
87 procedure get_warnings ( p_weeks_reset_warn IN OUT nocopy boolean
88 ,p_end_date_changed_warn IN OUT nocopy boolean
89 ,p_no_of_weeks_reset IN OUT nocopy number
90 ,p_reset_period_name IN OUT nocopy per_time_periods.period_name%type
91 ,p_new_end_date IN OUT nocopy per_time_periods.end_date%type );
92 --
93 procedure clear_warnings ;
94 --
95 procedure set_globals ( p_constant_end_date in boolean ) ;
96 --
97 function prev_semi_month(p_semi_month_date in date, p_fpe_date in date)
98 return date;
99 --
100 function next_semi_month(p_semi_month_date in date, p_fpe_date in date)
101 return date;
102 --
103 end hr_payrolls;