1 PACKAGE pay_in_exc AUTHID CURRENT_USER AS
2 /* $Header: pyinexc.pkh 120.1.12020000.2 2012/07/06 11:06:00 vmaripal ship $ */
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 get_td_start(p_effective_date in date,
50 p_start_date out nocopy date,
51 p_bus_grp in number default null,
52 p_payroll_id in number default null,
53 p_asg_action in number default null);
54
55 PROCEDURE start_code_pmth ( p_effective_date IN DATE
56 , p_start_date OUT NOCOPY DATE
57 , p_payroll_id IN NUMBER
58 , p_bus_grp IN NUMBER
59 , p_asg_action IN NUMBER
60 );
61
62 PROCEDURE start_code_p10mth ( p_effective_date IN DATE
63 , p_start_date OUT NOCOPY DATE
64 , p_payroll_id IN NUMBER
65 , p_bus_grp IN NUMBER
66 , p_asg_action IN NUMBER
67 );
68
69
70 END pay_in_exc;