1 PACKAGE pay_mx_payroll_arch AS
2 /* $Header: paymxpaysliparch.pkh 120.1 2005/10/10 10:43:37 vmehta noship $ */
3 --
4
5 PROCEDURE get_payroll_action_info(p_payroll_action_id in NUMBER
6 ,p_end_date OUT NOCOPY DATE
7 ,p_start_date OUT NOCOPY DATE
8 ,p_business_group_id OUT NOCOPY NUMBER
9 ,p_cons_set_id OUT NOCOPY NUMBER
10 ,p_payroll_id OUT NOCOPY NUMBER
11 );
12
13 PROCEDURE range_code(p_payroll_action_id IN NUMBER
14 ,p_sqlstr OUT NOCOPY VARCHAR2);
15
16 PROCEDURE assignment_action_code(p_payroll_action_id IN NUMBER
17 ,p_start_person_id IN NUMBER
18 ,p_end_person_id IN NUMBER
19 ,p_chunk IN NUMBER);
20
21 PROCEDURE archive_code(p_xfr_action_id IN NUMBER,
22 p_effective_date IN DATE);
23
24
25 PROCEDURE initialization_code(p_payroll_action_id IN NUMBER);
26
27 gv_act_param_val VARCHAR2(240);
28 gn_np_sepchk_run_type_id NUMBER;
29 gn_sepchk_run_type_id NUMBER;
30 run_bal_stat pay_ac_action_arch.run_bal_stat_tab;
31
32 TYPE def_bal IS RECORD ( act_info_category VARCHAR2(50),
33 bal_name VARCHAR2(240),
34 bal_type_id NUMBER(10),
35 pymt_def_bal_id NUMBER(10),
36 gre_ytd_def_bal_id NUMBER(10),
37 run_def_bal_id NUMBER(10),
38 jurisdiction_cd VARCHAR2(30));
39
40 TYPE def_bal_tbl IS TABLE OF def_bal INDEX BY BINARY_INTEGER;
41
42 END pay_mx_payroll_arch;