1 PACKAGE pay_in_form_24q_web_adi AS
2 /* $Header: pyinwadi.pkh 120.6 2007/11/22 06:32:22 rsaharay noship $ */
3 --Global Variable
4 g_assessment_year VARCHAR2(20);
5 --------------------------------------------------------------------------
6 -- --
7 -- Name : GET_ASSESSMENT_YEAR --
8 -- Type : FUNCTION --
9 -- Access : Public --
10 -- Description : Function to return the assessment year --
11 -- --
12 -- Parameters : --
13 -- IN : --
14 -- RETURN : VARCHAR2 --
15 ---------------------------------------------------------------------------
16 FUNCTION get_assessment_year
17 RETURN VARCHAR2;
18
19 --------------------------------------------------------------------------
20 -- --
21 -- Name : SET_ASSESSMENT_YEAR --
22 -- Type : PROCEDURE --
23 -- Access : Public --
24 -- Description : Function to set the assessment year --
25 -- --
26 -- Parameters : --
27 -- IN : VARCHAR2 --
28 ---------------------------------------------------------------------------
29 PROCEDURE set_assessment_year(p_assessment_year VARCHAR2);
30
31 --------------------------------------------------------------------------
32 -- --
33 -- Name : GET_DATE_EARNED --
34 -- Type : FUNCTION --
35 -- Access : Public --
36 -- Description : Function to return the date earned --
37 -- --
38 -- Parameters : --
39 -- IN : p_assignment_action_id NUMBER --
40 -- RETURN : DATE --
41 ---------------------------------------------------------------------------
42 FUNCTION get_date_earned
43 (p_assignment_action_id IN NUMBER
44 )
45 RETURN DATE;
46 --------------------------------------------------------------------------
47 -- --
48 -- Name : GET_DATE_EARNED_EE --
49 -- Type : FUNCTION --
50 -- Access : Public --
51 -- Description : Function to return the date earned --
52 -- --
53 -- Parameters : --
54 -- IN : p_element_entry_id NUMBER --
55 -- RETURN : DATE --
56 ---------------------------------------------------------------------------
57 FUNCTION get_date_earned_ee
58 (p_element_entry_id IN NUMBER
59 )
60 RETURN DATE;
61 --------------------------------------------------------------------------
62 -- --
63 -- Name : GET_EE_VALUE --
64 -- Type : FUNCTION --
65 -- Access : Public --
66 -- Description : Function to return the element entry value --
67 -- --
68 -- Parameters : --
69 -- IN : p_element_entry_id NUMBER --
70 -- p_input_name VARCHAR2 --
71 -- p_effective_date DATE --
72 -- RETURN : VARCHAR2 --
73 ---------------------------------------------------------------------------
74 FUNCTION get_ee_value
75 (p_element_entry_id IN NUMBER
76 ,p_input_name IN VARCHAR2
77 ,p_effective_date IN DATE
78 )
79 RETURN VARCHAR2;
80
81 --------------------------------------------------------------------------
82 -- --
83 -- Name : GET_TAN_NUMBER --
84 -- Type : FUNCTION --
85 -- Access : Public --
86 -- Description : Function to return the tan number for an organization-
87 -- --
88 -- Parameters : --
89 -- IN : p_assignment_id NUMBER --
90 -- p_effective_date DATE --
91 -- RETURN : VARCHAR2 --
92 ---------------------------------------------------------------------------
93 FUNCTION get_tan_number
94 (p_assignment_id IN NUMBER
95 ,p_effective_date IN DATE
96 )
97 RETURN VARCHAR2;
98
99 --------------------------------------------------------------------------
100 -- --
101 -- Name : GET_TAN_NUMBER_EE --
102 -- Type : FUNCTION --
103 -- Access : Public --
104 -- Description : Function to return the tan number for an organization-
105 -- --
106 -- Parameters : --
107 -- IN : p_element_entry_id NUMBER --
108 -- RETURN : VARCHAR2 --
109 ---------------------------------------------------------------------------
110 FUNCTION get_tan_number_ee
111 (p_element_entry_id IN NUMBER
112 )
113 RETURN VARCHAR2;
114
115 --------------------------------------------------------------------------
116 -- --
117 -- Name : GET_ORG_ID --
118 -- Type : FUNCTION --
119 -- Access : Public --
120 -- Description : Function to return the organization id -
121 -- --
122 -- Parameters : --
123 -- IN : p_tan_number VARCHAR2 --
124 -- RETURN : VARCHAR2 --
125 ---------------------------------------------------------------------------
126 FUNCTION get_org_id
127 (p_tan_number IN VARCHAR2
128 )
129 RETURN VARCHAR2;
130
131 --------------------------------------------------------------------------
132 -- --
133 -- Name : GET_BALANCE_VALUE --
134 -- Type : FUNCTION --
135 -- Access : Public --
136 -- Description : Function to return the balance value --
137 -- --
138 ---------------------------------------------------------------------------
139 FUNCTION get_balance_value(p_assignment_action_id IN NUMBER
140 ,p_balance_name IN VARCHAR2
141 ,p_dimension IN VARCHAR2
142 )
143 RETURN VARCHAR2;
144
145 --------------------------------------------------------------------------
146 -- --
147 -- Name : GET_TOTAL_TAX_DEPOSITED --
148 -- Type : FUNCTION --
149 -- Access : Public --
150 -- Description : Function to return the total tax deposited --
151 -- --
152 ---------------------------------------------------------------------------
153 FUNCTION get_total_tax_deposited(p_assignment_action_id IN NUMBER
154 ,p_element_entry_id IN NUMBER
155 ,p_effective_date IN DATE DEFAULT NULL
156 )
157 RETURN VARCHAR2;
158
159 --------------------------------------------------------------------------
160 -- --
161 -- Name : CREATE_FORM_24 --
162 -- Type : PROCEDURE --
163 -- Access : Public --
164 -- Description : Function to create the element as per the details --
165 -- passed from the Web ADI Excel Sheet. --
166 -- --
167 ---------------------------------------------------------------------------
168 PROCEDURE create_form_24
169 (p_assessment_year IN VARCHAR2 DEFAULT NULL
170 ,p_payroll_name IN VARCHAR2 DEFAULT NULL
171 ,p_period IN VARCHAR2 DEFAULT NULL
172 ,p_earned_date IN DATE DEFAULT NULL
173 ,p_pre_payment_date IN DATE
174 ,p_employee_id IN VARCHAR2
175 ,p_employee_name IN VARCHAR2 DEFAULT NULL
176 ,p_taxable_income IN NUMBER DEFAULT NULL
177 ,p_income_tax_deducted IN NUMBER DEFAULT NULL
178 ,p_surcharge_deducted IN NUMBER DEFAULT NULL
179 ,p_education_cess_deducted IN NUMBER DEFAULT NULL
180 ,p_total_tax_deducted IN NUMBER DEFAULT NULL
181 ,p_amount_deposited IN NUMBER
182 ,p_voucher_number IN VARCHAR2
183 ,p_correction_flag IN VARCHAR2
184 ,p_last_updated_date IN DATE DEFAULT NULL
185 ,p_element_entry_id IN NUMBER DEFAULT NULL
186 ,p_tan_number IN VARCHAR2 DEFAULT NULL
187 ,p_purge_record IN VARCHAR2 DEFAULT NULL
188 ,p_assignment_id IN NUMBER
189 );
190
191 --------------------------------------------------------------------------
192 -- --
193 -- Name : GET_BG_ID --
194 -- Type : FUNCTION --
195 -- Access : Public --
196 -- Description : Function to return the business group id --
197 -- --
198 -- Parameters : --
199 -- IN : --
200 -- RETURN : VARCHAR2 --
201 ---------------------------------------------------------------------------
202 FUNCTION get_bg_id
203 RETURN NUMBER;
204
205 END pay_in_form_24q_web_adi;