PACKAGE: APPS.PAY_PYEPFREQ_PKG

Source

1 PACKAGE pay_pyepfreq_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyepf01t.pkh 120.2 2006/10/02 07:48:23 susivasu noship $ */
3 --
4 Type g_freq_rule_rec_type Is Record
5   (
6   element_type_id                   number(9),
7   payroll_id                        number(9),
8   business_group_id                 number(15),
9   period_1                          varchar2(1),
10   period_2                          varchar2(1),
11   period_3                          varchar2(1),
12   period_4                          varchar2(1),
13   period_5                          varchar2(1),
14   period_6                          varchar2(1),
15   rule_date_code                    varchar2(1)
16   );
17 --
18 TYPE g_freq_rule_table_type IS TABLE OF g_freq_rule_rec_type
19      INDEX BY BINARY_INTEGER;
20 
21 g_freq_rule_table g_freq_rule_table_type;
22 g_freq_rule_rec   g_freq_rule_rec_type;
23 
24 --
25 PROCEDURE hr_ele_pay_freq_rules (
26 				p_context	IN VARCHAR2,
27 				p_eletype_id	IN NUMBER,
28 				p_payroll_id	IN NUMBER,
29 				p_period_type	IN VARCHAR2,
30 				p_bg_id		IN NUMBER,
31 				p_period_1	IN OUT NOCOPY VARCHAR2,
32 				p_period_2	IN OUT NOCOPY VARCHAR2,
33 				p_period_3	IN OUT NOCOPY VARCHAR2,
34 				p_period_4	IN OUT NOCOPY VARCHAR2,
35 				p_period_5	IN OUT NOCOPY VARCHAR2,
36 				p_period_6	IN OUT NOCOPY VARCHAR2,
37 				p_eff_date	IN DATE	    DEFAULT NULL,
38                                 p_rule_date_code IN VARCHAR2 DEFAULT NULL,
39                                 p_leg_code       IN VARCHAR2 DEFAULT NULL);
40 --
41 FUNCTION get_freq_rule_period( p_ele_type_id IN NUMBER,
42                                p_payroll_id IN NUMBER,
43                                p_bus_grp_id IN NUMBER,
44                                p_period_num IN NUMBER)
45          RETURN VARCHAR2;
46 --
47 PROCEDURE remove_freq_rule_period(p_ele_type_id IN NUMBER,
48                                   p_payroll_id IN NUMBER);
49 --
50 PROCEDURE initialise_freqrule_table;
51 --
52 END pay_pyepfreq_pkg;