1 PACKAGE pay_in_india_benefits AUTHID CURRENT_USER AS
2 /* $Header: pyinmed.pkh 120.9.12020000.2 2012/07/04 23:14:36 amnaraya ship $ */
3
4 -- Global Variables Section
5 type t_element_values_rec is record
6 (element_name pay_element_types_f.element_name%TYPE
7 ,input_name pay_input_values_f.name%TYPE
8 ,planned_val pay_element_entry_values.screen_entry_value%TYPE
9 ,actual_val pay_element_entry_values.screen_entry_value%TYPE
10 );
11
12 type t_element_values_tab is table of t_element_values_rec
13 index by binary_integer;
14
15 type t_tab_entry_details_rec is record
16 (entry_id pay_element_entries_f.element_entry_id%TYPE
17 ,input1_value pay_element_entry_values.screen_entry_value%TYPE
18 ,input2_value pay_element_entry_values.screen_entry_value%TYPE
19 ,input3_value pay_element_entry_values.screen_entry_value%TYPE
20 );
21
22 type t_entry_details_tab is table of t_tab_entry_details_rec
23 index by binary_integer;
24
25 FUNCTION get_med_submitted(p_assignment_id NUMBER
26 ,p_tax_yr VARCHAR2
27 ,p_created_from DATE DEFAULT NULL
28 ,p_created_to DATE DEFAULT NULL
29 ,p_approval_status VARCHAR2 DEFAULT NULL)
30 RETURN NUMBER ;
31
32 FUNCTION get_med_exempted(p_assignment_id NUMBER
33 ,p_tax_yr VARCHAR2
34 ,p_created_from DATE DEFAULT NULL
35 ,p_created_to DATE DEFAULT NULL
36 ,p_approval_status VARCHAR2 DEFAULT NULL)
37 RETURN NUMBER ;
38
39 FUNCTION get_ltc_submitted(p_assignment_id NUMBER
40 ,p_tax_yr VARCHAR2
41 ,p_created_from DATE DEFAULT NULL
42 ,p_created_to DATE DEFAULT NULL
43 ,p_approval_status VARCHAR2 DEFAULT NULL
44 ,p_carry_over IN VARCHAR2 )
45 RETURN NUMBER ;
46
47
48 FUNCTION get_ltc_exempted(p_assignment_id NUMBER
49 ,p_tax_yr VARCHAR2
50 ,p_created_from DATE DEFAULT NULL
51 ,p_created_to DATE DEFAULT NULL
52 ,p_approval_status VARCHAR2 DEFAULT NULL
53 ,p_carry_over IN VARCHAR2 )
54 RETURN NUMBER ;
55
56
57 FUNCTION get_med_bill_date(p_assignment_id NUMBER
58 ,p_tax_yr VARCHAR2
59 ,p_created_from DATE DEFAULT NULL
60 ,p_created_to DATE DEFAULT NULL
61 ,p_approval_status VARCHAR2 DEFAULT NULL)
62 RETURN VARCHAR2;
63
64
65 FUNCTION get_last_updated_date(p_assignment_id IN NUMBER
66 ,p_block IN VARCHAR2
67 ,p_asg_info_type IN VARCHAR2
68 ,p_created_from IN DATE DEFAULT NULL
69 ,p_created_to IN DATE DEFAULT NULL
70 ,p_approved IN VARCHAR2 DEFAULT NULL
71 ,p_carry_over IN VARCHAR2 default null )
72 RETURN DATE;
73
74 FUNCTION get_entry_value(p_assignment_id IN NUMBER
75 ,p_entry_id IN NUMBER
76 ,p_input_name IN VARCHAR2
77 ,p_date IN DATE)
78 RETURN VARCHAR2 ;
79
80
81
82 FUNCTION get_relationship(p_person_id IN NUMBER
83 ,p_business_group_id IN NUMBER)
84 RETURN VARCHAR2;
85
86
87
88 PROCEDURE set_profile(p_person_id IN NUMBER);
89
90
91 PROCEDURE delete_medical_bill_entry(
92 p_asg_extra_info_id IN NUMBER);
93
94 PROCEDURE medical_bill_entry(p_asg_id IN NUMBER
95 ,p_financial_yr IN VARCHAR2 DEFAULT NULL /* needed mainly for PU*/
96 ,p_bill_date IN DATE DEFAULT NULL
97 ,p_person_id IN NUMBER
98 ,p_con_person_id IN NUMBER DEFAULT NULL
99 ,p_old_bill_amt IN NUMBER DEFAULT NULL
100 ,p_new_bill_amt IN NUMBER DEFAULT NULL
101 ,p_old_exempt_amt IN NUMBER DEFAULT NULL
102 ,p_new_exempt_amt IN NUMBER DEFAULT NULL
103 ,p_element_entry_id IN NUMBER DEFAULT NULL
104 ,p_bill_number IN VARCHAR2 DEFAULT NULL
105 ,p_asg_extra_info_id IN NUMBER DEFAULT NULL
106 ,p_ovn IN NUMBER DEFAULT NULL
107 ,p_business_group_id IN NUMBER
108 ,p_element_entry_date IN DATE
109 ,p_super_user IN VARCHAR2
110 ,p_ee_comments IN VARCHAR2
111 ,p_er_comments IN VARCHAR2
112 );
113
114 PROCEDURE ltc_bill_entry(p_asg_id IN NUMBER
115 ,p_ltc_block IN VARCHAR2 DEFAULT NULL /* needed mainly for PU*/
116 ,p_ben_name IN VARCHAR2 DEFAULT NULL
117 ,p_place_from IN VARCHAR2 DEFAULT NULL
118 ,p_bill_number IN VARCHAR2 DEFAULT NULL
119 ,p_ee_comments IN VARCHAR2
120 ,p_er_comments IN VARCHAR2
121 ,p_place_to IN VARCHAR2 DEFAULT NULL
122 ,p_travel_mode IN VARCHAR2 DEFAULT NULL
123 ,p_bill_amt IN NUMBER DEFAULT NULL
124 ,p_exempt_amt IN NUMBER DEFAULT NULL
125 ,p_element_entry_id IN OUT NOCOPY NUMBER
126 ,p_start_date IN DATE
127 ,p_end_date IN DATE
128 ,p_carry_over_flag IN VARCHAR2 DEFAULT NULL
129 ,p_asg_extra_info_id IN NUMBER DEFAULT NULL
130 ,p_element_entry_date IN DATE
134 ,p_emp_element_entry_id IN NUMBER
131 ,p_super_user IN VARCHAR2
132 ,p_person_id IN NUMBER
133 ,p_employer_Contribution IN NUMBER
135 ,p_emp_carry_over_flag IN VARCHAR2 DEFAULT NULL
136 ,p_create_flag OUT NOCOPY VARCHAR2
137 , p_warnings OUT NOCOPY VARCHAR2
138 );
139 FUNCTION get_medical_balance( p_asg_id IN NUMBER,
140 p_tax_year IN VARCHAR2,
141 p_balance_name IN VARCHAR2)
142 RETURN NUMBER;
143
144 FUNCTION get_ltc_balance (p_asg_id IN NUMBER,
145 p_ltc_block IN VARCHAR2,
146 p_balance_name IN VARCHAR2)
147 RETURN NUMBER ;
148
149 PROCEDURE is_locked( p_person_id IN NUMBER
150 ,p_ltc_or_med IN VARCHAR2
151 ,p_locked OUT NOCOPY VARCHAR2 ) ;
152
153 PROCEDURE update_ltc_empCont(
154 p_benefit IN NUMBER
155 ,p_carry IN VARCHAR2
156 ,p_assignment_id IN NUMBER
157 ,p_element_entry_id IN NUMBER DEFAULT NULL
158 );
159 PROCEDURE update_ltc_element
160 (
161 p_employee_number IN VARCHAR2
162 ,p_full_name IN VARCHAR2
163 ,p_start_date IN DATE
164 ,p_effective_end_date IN DATE DEFAULT NULL
165 ,p_fare IN NUMBER
166 ,p_blockYr IN VARCHAR2
167 ,p_carry IN VARCHAR2
168 ,p_benefit IN NUMBER
169 ,p_assignment_id IN NUMBER
170 ,p_element_entry_id IN NUMBER DEFAULT NULL
171 ,p_warnings OUT NOCOPY VARCHAR2
172 );
173
174 END pay_in_india_benefits;