1 PACKAGE pay_ae_element_template_pkg AS
2 /* $Header: pyaeeltm.pkh 120.1 2006/02/01 02:24:53 abppradh noship $ */
3
4 FUNCTION get_rate_from_tab_id
5 (p_assignment_id IN NUMBER
6 ,p_date_earned IN DATE
7 ,p_business_group_id IN NUMBER
8 ,p_rate_id IN NUMBER)
9 RETURN NUMBER;
10
11 FUNCTION get_rate_from_tab_name
12 (p_assignment_id IN NUMBER
13 ,p_date_earned IN DATE
14 ,p_business_group_id IN NUMBER
15 ,p_rate_table IN VARCHAR2
16 ,p_table_exists OUT NOCOPY VARCHAR2)
17 RETURN NUMBER;
18
19 FUNCTION get_employee_details
20 (p_assignment_id IN NUMBER
21 ,p_date_earned IN DATE
22 ,p_info_type IN VARCHAR2)
23 RETURN VARCHAR2;
24
25 FUNCTION get_absence_days
26 (p_assignment_id IN NUMBER
27 ,p_date_earned IN DATE
28 ,p_business_group_id IN NUMBER
29 ,p_start_date IN DATE
30 ,p_end_date IN DATE)
31 RETURN NUMBER;
32
33 PROCEDURE element_template_post_process
34 (p_template_id IN NUMBER);
35
36 PROCEDURE create_templates;
37
38 PROCEDURE create_flat_amt_template;
39
40 PROCEDURE create_perc_template;
41
42 PROCEDURE create_basic_sal_template;
43
44 PROCEDURE create_hsg_allw_template;
45
46 PROCEDURE create_trn_allw_template;
47
48 PROCEDURE create_col_allw_template;
49
50 PROCEDURE create_child_allw_template;
51
52 PROCEDURE create_social_allw_template;
53
54 PROCEDURE create_shift_allw_template;
55
56 PROCEDURE create_hrly_basic_sal_template;
57
58 PROCEDURE create_ot_allw_template;
59
60 PROCEDURE create_unp_leave_dedn_template;
61
62 END pay_ae_element_template_pkg;
63