1 PACKAGE pay_in_exc AS
2 /* $Header: pyinexc.pkh 120.1 2008/06/03 11:21:49 rsaharay noship $ */
3
4 PROCEDURE date_ec ( p_owner_payroll_action_id IN NUMBER
5 , p_user_payroll_action_id IN NUMBER
6 , p_owner_assignment_action_id IN NUMBER
7 , p_user_assignment_action_id IN NUMBER
8 , p_owner_effective_date IN DATE
9 , p_user_effective_date IN DATE
10 , p_dimension_name IN VARCHAR2
11 , p_expiry_information OUT NOCOPY NUMBER
12 );
13
14 PROCEDURE date_ec ( p_owner_payroll_action_id IN NUMBER
15 , p_user_payroll_action_id IN NUMBER
16 , p_owner_assignment_action_id IN NUMBER
17 , p_user_assignment_action_id IN NUMBER
18 , p_owner_effective_date IN DATE
19 , p_user_effective_date IN DATE
20 , p_dimension_name IN VARCHAR2
21 , p_expiry_information OUT NOCOPY DATE
22 );
23
24 PROCEDURE cal_hy_start(p_effective_date IN DATE ,
25 p_start_date OUT NOCOPY DATE,
26 p_start_date_code IN VARCHAR2 DEFAULT NULL,
27 p_payroll_id IN NUMBER DEFAULT NULL,
28 p_bus_grp IN NUMBER DEFAULT NULL,
29 p_action_type IN VARCHAR2 DEFAULT NULL,
30 p_asg_action IN NUMBER DEFAULT NULL);
31
32
33 PROCEDURE prov_ytd_start(p_effective_date IN DATE ,
34 p_start_date OUT NOCOPY DATE,
35 p_start_date_code IN VARCHAR2 DEFAULT NULL,
36 p_payroll_id IN NUMBER DEFAULT NULL,
37 p_bus_grp IN NUMBER DEFAULT NULL,
38 p_action_type IN VARCHAR2 DEFAULT NULL,
39 p_asg_action IN NUMBER DEFAULT NULL);
40
41 PROCEDURE hytd_start(p_effective_date IN DATE ,
42 p_start_date OUT NOCOPY DATE,
43 p_start_date_code IN VARCHAR2 DEFAULT NULL,
44 p_payroll_id IN NUMBER DEFAULT NULL,
45 p_bus_grp IN NUMBER DEFAULT NULL,
46 p_action_type IN VARCHAR2 DEFAULT NULL,
47 p_asg_action IN NUMBER DEFAULT NULL);
48
49 PROCEDURE start_code_pmth ( p_effective_date IN DATE
50 , p_start_date OUT NOCOPY DATE
51 , p_payroll_id IN NUMBER
52 , p_bus_grp IN NUMBER
53 , p_asg_action IN NUMBER
54 );
55
56 PROCEDURE start_code_p10mth ( p_effective_date IN DATE
57 , p_start_date OUT NOCOPY DATE
58 , p_payroll_id IN NUMBER
59 , p_bus_grp IN NUMBER
60 , p_asg_action IN NUMBER
61 );
62
63
64 END pay_in_exc;