1 PACKAGE pay_in_ff_pkg AS
2 /* $Header: pyindedn.pkh 120.3.12010000.3 2008/10/10 09:17:07 mdubasi ship $ */
3
4 FUNCTION check_retainer (p_assignment_id IN NUMBER
5 ,p_payroll_action_id IN NUMBER)
6 RETURN NUMBER;
7
8 FUNCTION check_edli(p_assignment_id IN NUMBER
9 ,p_effective_date IN DATE)
10 RETURN VARCHAR2;
11
12 FUNCTION get_esi_cont_amt(p_assignment_action_id IN NUMBER
13 ,p_assignment_id IN NUMBER
14 ,p_date_earned IN DATE
15 ,p_eligible_amt IN NUMBER)
16 RETURN NUMBER;
17 FUNCTION round_to_5paise( p_number IN NUMBER)
18 RETURN NUMBER;
19
20 FUNCTION get_net_accrual ( p_assignment_id IN NUMBER
21 ,p_payroll_id IN NUMBER
22 ,p_business_group_id IN NUMBER
23 ,p_calculation_date IN DATE
24 ,p_plan_category IN VARCHAR2
25 ,p_message OUT NOCOPY VARCHAR2
26 )
27 RETURN NUMBER;
28
29 FUNCTION get_period_number (p_payroll_id IN NUMBER
30 ,p_term_date IN DATE )
31 RETURN NUMBER;
32
33 FUNCTION sec_80dd_percent ( p_assignment_id IN per_all_assignments_f.assignment_id%type
34 ,p_date_earned IN date)
35 RETURN VARCHAR2;
36
37 PROCEDURE check_pf_update
38 (p_effective_date IN DATE
39 ,p_dt_mode IN VARCHAR2
40 ,p_assignment_id IN NUMBER
41 ,p_gre_org IN VARCHAR2
42 ,p_pf_org IN VARCHAR2
43 ,p_esi_org IN VARCHAR2
44 ,p_message OUT NOCOPY VARCHAR2
45 ,p_gre IN NUMBER
46 ,p_pf IN NUMBER
47 ,p_esi IN NUMBER
48 );
49
50 PROCEDURE check_esi_update
51 (p_effective_date IN DATE
52 ,p_dt_mode IN VARCHAR2
53 ,p_assignment_id IN NUMBER
54 ,p_esi_org IN VARCHAR2
55 ,p_message OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE check_father_husband_name
59 (p_assignment_id IN NUMBER
60 ,p_effective_date IN DATE
61 ,p_message_name OUT NOCOPY VARCHAR2
62 ,p_token_value OUT NOCOPY VARCHAR2);
63
64 Function in_reset_input_values(p_assignment_id NUMBER
65 ,p_business_group_id NUMBER
66 ,p_element_type_id NUMBER
67 ,p_element_entry_id NUMBER
68 ,p_date DATE
69 ,p_input_value VARCHAR2)
70
71 Return Number ;
72
73 PROCEDURE check_pf_location
74 (p_organization_id IN NUMBER
75 ,p_calling_procedure IN VARCHAR2
76 ,p_message_name OUT NOCOPY VARCHAR2
77 ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
78 ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
79
80 FUNCTION get_lwf_state
81 (p_organization_id IN NUMBER) RETURN VARCHAR2;
82
83 FUNCTION get_esi_disability_details( p_assignment_id in number
84 ,p_date_earned in date
85 ,p_disable_proof out NOCOPY varchar2)
86 Return Number;
87
88 END pay_in_ff_pkg;
89