1 PACKAGE pay_in_tax_declaration AUTHID CURRENT_USER AS
2 /* $Header: pyintaxd.pkh 120.14.12020000.5 2012/07/23 12:08:17 pthummal 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 -- Bug 3886086
16 -- Record to store the details of tabular details like
17 -- Section 80DD, 80G and life insurace.
18 --
19 type t_tab_entry_details_rec is record
20 (entry_id pay_element_entries_f.element_entry_id%TYPE
21 ,input1_value pay_element_entry_values.screen_entry_value%TYPE
22 ,input2_value pay_element_entry_values.screen_entry_value%TYPE
23 ,input3_value pay_element_entry_values.screen_entry_value%TYPE
24 ,input4_value pay_element_entry_values.screen_entry_value%TYPE
25 );
26
27 type t_entry_details_tab is table of t_tab_entry_details_rec
28 index by binary_integer;
29
30 --------------------------------------------------------------------------
31 -- --
32 -- Name : IS_LOCKING_PERIOD --
33 -- Type : PROCEDURE --
34 -- Access : Public --
35 -- Description : The procedure is responsible for returning the --
36 -- freeze period details like start date, along with --
37 -- a flag to indicate if it is the freeze period. --
38 -- --
39 -- Parameters : --
40 -- IN : p_person_id per_people_f.person_id%TYPE --
41 -- OUT : p_locked VARCHAR2 --
42 -- p_lock_start DATE --
43 -- --
44 --------------------------------------------------------------------------
45 PROCEDURE is_locking_period
46 (p_person_id IN per_people_f.person_id%TYPE
47 ,p_locked OUT NOCOPY VARCHAR2
48 ,p_lock_start OUT NOCOPY DATE);
49
50 --------------------------------------------------------------------------
51 -- --
52 -- Name : IS_APPROVED --
53 -- Type : PROCEDURE --
54 -- Access : Public --
55 -- Description : The procedure is responsible for returning the --
56 -- the flag stating if the employee tax declaration --
57 -- details have been approved or not. . --
58 -- --
59 -- Parameters : --
60 -- IN : p_person_id per_people_f.person_id%TYPE --
61 -- p_effective_date DATE --
62 -- OUT : p_status VARCHAR2 --
63 -- --
64 --------------------------------------------------------------------------
65 PROCEDURE is_approved
66 (p_person_id IN NUMBER
67 ,p_effective_date IN DATE default null
68 ,p_status OUT NOCOPY VARCHAR2);
69
70 --------------------------------------------------------------------------
71 -- --
72 -- Name : GET_CITY_TYPE --
73 -- Type : FUNCTION --
74 -- Access : Public --
75 -- Description : The function is responsible for quering the city --
76 -- type of the primary address of the employee if the --
77 -- primary address is not available then return NA. --
78 -- --
79 -- Parameters : --
80 -- IN : p_person_id per_people_f.person_id%TYPE --
81 -- p_effective_date DATE --
82 -- RETURN : VARCHAR2 --
83 -- --
84 --------------------------------------------------------------------------
85 FUNCTION get_city_type
86 (p_person_id IN number
87 ,p_effective_date IN date)
88 RETURN varchar2;
89
90 --------------------------------------------------------------------------
91 -- --
92 -- Name : GET_TAX_YEAR --
93 -- Type : FUNCTION --
94 -- Access : Public --
95 -- Description : The function is responsible returning the tax year --
96 -- created based on the effective date passed to it. --
97 -- --
98 -- Parameters : --
99 -- IN : p_effective_date DATE --
100 -- RETURN : VARCHAR2 --
101 -- --
102 --------------------------------------------------------------------------
103 FUNCTION get_tax_year(p_effective_date IN DATE)
104 RETURN VARCHAR2;
105
106 --------------------------------------------------------------------------
107 -- --
108 -- Name : GET_APPROVAL_STATUS --
109 -- Type : FUNCTION --
110 -- Access : Public --
111 -- Description : The procedure is responsible for returning the --
112 -- the flag stating if the employee tax declaration --
113 -- details have been approved or not. . --
114 -- --
115 -- Parameters : --
116 -- IN : p_assignment_id per_assignments_f.assignment_id --
117 -- p_tax_year VARCHAR2 --
118 -- p_extra_info_id assignment_extra_info_id --
119 -- RETURN : VARCHAR2 --
120 -- --
121 --------------------------------------------------------------------------
122 FUNCTION get_approval_status
123 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
124 ,p_tax_year IN VARCHAR2
125 ,p_extra_info_id OUT NOCOPY per_assignment_extra_info.assignment_extra_info_id%TYPE)
126 RETURN VARCHAR2;
127
128 --------------------------------------------------------------------------
129 -- --
130 -- Name : GET_DONATION_TYPE --
131 -- Type : FUNCTION --
132 -- Access : Public --
133 -- Description : The function has the same code which is used to --
134 -- validate teh donation type details entered. Further --
135 -- is used to validate the same in self-service --
136 -- --
137 -- Parameters : --
138 -- IN : p_lookup_code VARCHAR2 --
139 -- RETURN : pay_user_column_instances_f.value%TYPE --
140 -- --
141 --------------------------------------------------------------------------
142 FUNCTION get_donation_type(p_lookup_code IN VARCHAR2)
143 RETURN pay_user_column_instances_f.value%TYPE;
144
145 --------------------------------------------------------------------------
146 -- --
147 -- Name : GET_PLANNED_VALUE --
148 -- Type : FUNCTION --
149 -- Access : Public --
150 -- Description : The function calculates the value of an element --
151 -- entries's input value on a date which is before the --
152 -- freeze date for the financial year. --
153 -- --
154 -- Parameters : --
155 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
156 -- p_actual_value VARCHAR2 --
157 -- p_ele_entry_id element_entry_id%TYPE --
158 -- p_input_value_id input_value_id%TYPE --
159 -- RETURN : VARCHAR2 --
160 -- --
161 --------------------------------------------------------------------------
162 FUNCTION get_planned_value
163 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
164 ,p_actual_value IN VARCHAR2
165 ,p_ele_entry_id IN pay_element_entries_f.element_entry_id%TYPE
166 ,p_input_value_id IN pay_input_values_f.input_value_id%TYPE)
167 RETURN VARCHAR2;
168
169 --------------------------------------------------------------------------
170 -- --
171 -- Name : GET_VALUE --
172 -- Type : FUNCTION --
173 -- Access : Public --
174 -- Description : The function calculates the planned and the actual --
175 -- values of the following elements and stores then in --
176 -- the cache when the function is first called on sub- --
177 -- sequent calls it would used the cached value. --
178 -- 1. Rebates under Section 88 --
179 -- 2. Tuition Fee --
180 -- 3. Deductions under Chapter VI A and --
181 -- 4. Other Income --
182 -- --
183 -- Parameters : --
184 -- IN : p_assignment_id NUMBER --
185 -- p_element_name VARCHAR2 --
186 -- p_input_name VARCHAR2 --
187 -- p_effective_date DATE --
188 -- p_actual_value VARCHAR2 --
189 -- RETURN : VARCHAR2 --
190 -- --
191 --------------------------------------------------------------------------
192 FUNCTION get_value
193 (p_assignment_id IN number
194 ,p_element_name IN varchar2
195 ,p_input_name IN varchar2
196 ,p_effective_date IN date
197 ,p_actual_value IN varchar2
198 )
199 RETURN VARCHAR2;
200
201 --------------------------------------------------------------------------
202 -- --
203 -- Name : GET_NUMERIC_VALUE --
204 -- Type : FUNCTION --
205 -- Access : Public --
206 -- Description : The function calls get_value internally, but the --
207 -- value returned would be converted to number using --
208 -- to_number and the numeric value returned. --
209 -- --
210 -- Parameters : --
211 -- IN : p_assignment_id NUMBER --
212 -- p_element_name VARCHAR2 --
213 -- p_input_name VARCHAR2 --
214 -- p_effective_date DATE --
215 -- p_actual_value VARCHAR2 --
216 -- RETURN : NUMBER --
217 -- --
218 --------------------------------------------------------------------------
219 FUNCTION get_numeric_value
220 (p_assignment_id IN number
221 ,p_element_name IN varchar2
222 ,p_input_name IN varchar2
223 ,p_effective_date IN date
224 ,p_actual_value IN varchar2
225 )
226 RETURN NUMBER;
227
228 --------------------------------------------------------------------------
229 -- --
230 -- Name : GET_LAST_UPDATED_DATE --
231 -- Type : FUNCTION --
232 -- Access : Public --
233 -- Description : The is called with one of these values and returns --
234 -- the last updated date of the associated element for --
235 -- element type in question. The valid element types --
236 -- are: --
237 -- 1. HOUSE --
238 -- 2. CHAPTER6 --
239 -- 3. SECTION88 --
240 -- 4. OTHER --
241 -- 5. ALL --
242 -- --
243 -- Parameters : --
244 -- IN : p_person_id NUMBER --
245 -- p_effective_date DATE --
246 -- p_element_type VARCHAR2 --
247 -- RETURN : NUMBER --
248 -- --
249 --------------------------------------------------------------------------
250 FUNCTION get_last_updated_date
251 (p_person_id IN NUMBER
252 ,p_effective_date IN DATE
253 ,p_element_type IN VARCHAR2)
254 RETURN DATE;
255
256 --------------------------------------------------------------------------
257 -- --
258 -- Name : DECLARE_HOUSE_RENT --
259 -- Type : PROCEDURE --
260 -- Access : Public --
261 -- Description : The procedure is responsible for storing the detials--
262 -- in 'House Rent Information' element. --
263 -- --
264 -- Parameters : --
265 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
266 -- p_apr NUMBER --
267 -- p_may NUMBER --
268 -- p_jun NUMBER --
269 -- p_jul NUMBER --
270 -- p_aug NUMBER --
271 -- p_sep NUMBER --
272 -- p_oct NUMBER --
273 -- p_nov NUMBER --
274 -- p_dec NUMBER --
275 -- p_jan NUMBER --
276 -- p_feb NUMBER --
277 -- p_mar NUMBER --
278 -- p_effective_date DATE --
279 -- OUT : p_warnings BOOLEAN --
280 -- --
281 --------------------------------------------------------------------------
282 PROCEDURE declare_house_rent
283 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
284 ,p_apr IN NUMBER
285 ,p_may IN NUMBER
286 ,p_jun IN NUMBER
287 ,p_jul IN NUMBER
288 ,p_aug IN NUMBER
289 ,p_sep IN NUMBER
290 ,p_oct IN NUMBER
291 ,p_nov IN NUMBER
292 ,p_dec IN NUMBER
293 ,p_jan IN NUMBER
294 ,p_feb IN NUMBER
295 ,p_mar IN NUMBER
296 ,p_effective_date IN DATE DEFAULT NULL
297 ,p_warnings OUT NOCOPY BOOLEAN);
298
299 --------------------------------------------------------------------------
300 -- --
301 -- Name : DECLARE_CHAPTER6A --
302 -- Type : PROCEDURE --
303 -- Access : Public --
304 -- Description : The procedure calculates the value of permanent --
305 -- disability 80u and then stores the detials in the --
306 -- 'Deductions under Chapter VI A' element. --
307 -- --
308 -- Parameters : --
309 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
310 -- p_pension_fund_80ccc NUMBER --
311 -- p_medical_insurance_prem_80d NUMBER --
312 -- p_sec_80ddb_senior_citizen VARCHAR2 --
313 -- p_disease_treatment_80ddb NUMBER --
314 -- p_sec_80d_senior_citizen VARCHAR2 --
315 -- p_higher_education_loan_80e NUMBER --
316 -- p_claim_exemp_under_sec_80gg VARCHAR2 --
317 -- p_donation_for_research_80gga NUMBER --
318 -- p_int_on_gen_investment_80L NUMBER --
319 -- p_int_on_securities_80L NUMBER --
320 -- p_effective_date DATE --
321 -- OUT : p_warnings BOOLEAN --
322 -- --
323 --------------------------------------------------------------------------
324 PROCEDURE declare_chapter6a
325 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
326 ,p_pension_fund_80ccc IN NUMBER
327 ,p_medical_insurance_prem_80d IN NUMBER
328 ,p_sec_80ddb_senior_citizen IN VARCHAR2
329 ,p_disease_treatment_80ddb IN NUMBER
330 ,p_sec_80d_senior_citizen IN VARCHAR2
331 ,p_higher_education_loan_80e IN NUMBER
332 ,p_claim_exemp_under_sec_80gg IN VARCHAR2
333 ,p_donation_for_research_80gga IN NUMBER
334 ,p_int_on_gen_investment_80L IN NUMBER
335 ,p_int_on_securities_80L IN NUMBER
336 ,p_effective_date IN DATE DEFAULT NULL
337 ,p_warnings OUT NOCOPY BOOLEAN);
338
339 --------------------------------------------------------------------------
340 -- --
341 -- Name : DECLARE_SECTION88 --
342 -- Type : PROCEDURE --
343 -- Access : Public --
344 -- Description : The procedure is responsible for storing the detials--
345 -- in 'Rebates under Section 88' element. --
346 -- --
347 -- Parameters : --
348 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
349 -- p_public_provident_fund NUMBER --
350 -- p_post_office_savings_scheme NUMBER --
351 -- p_deposit_in_nsc_vi_issue NUMBER --
352 -- p_deposit_in_nsc_viii_issue NUMBER --
353 -- p_interest_on_nsc_reinvested NUMBER --
354 -- p_house_loan_repayment NUMBER --
355 -- p_notified_mutual_fund_or_uti NUMBER --
356 -- p_national_housing_bank_scheme NUMBER --
357 -- p_unit_linked_insurance_plan NUMBER --
358 -- p_notified_annuity_plan NUMBER --
359 -- p_notified_pension_fund NUMBER --
360 -- p_public_sector_company_scheme NUMBER --
361 -- p_approved_superannuation_fund NUMBER --
362 -- p_infrastructure_bond NUMBER --
363 -- p_effective_date DATE --
364 -- OUT : p_warnings BOOLEAN --
365 -- --
366 --------------------------------------------------------------------------
367 PROCEDURE declare_section88
368 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
369 ,p_deferred_annuity IN NUMBER
370 ,p_senior_citizen_sav_scheme IN NUMBER
371 ,p_public_provident_fund IN NUMBER
372 ,p_post_office_savings_scheme IN NUMBER
373 ,p_deposit_in_nsc_vi_issue IN NUMBER
374 ,p_deposit_in_nsc_viii_issue IN NUMBER
375 ,p_interest_on_nsc_reinvested IN NUMBER
376 ,p_house_loan_repayment IN NUMBER
377 ,p_notified_mutual_fund_or_uti IN NUMBER
378 ,p_national_housing_bank_scheme IN NUMBER
379 ,p_unit_linked_insurance_plan IN NUMBER
380 ,p_notified_annuity_plan IN NUMBER
381 ,p_notified_pension_fund IN NUMBER
382 ,p_public_sector_company_scheme IN NUMBER
383 ,p_approved_superannuation_fund IN NUMBER
384 ,p_infrastructure_bond IN NUMBER
385 ,p_effective_date IN DATE DEFAULT NULL
386 ,p_warnings OUT NOCOPY BOOLEAN);
387
388 --------------------------------------------------------------------------
389 -- --
390 -- Name : DECLARE_OTHER_INCOME --
391 -- Type : PROCEDURE --
392 -- Access : Public --
393 -- Description : The procedure is responsible for storing the --
394 -- detials in 'Other Income' element. --
395 -- --
396 -- Parameters : --
397 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
398 -- p_income_from_house_property NUMBER --
399 -- p_profit_and_gain_from_busines NUMBER --
400 -- p_long_term_capital_gain NUMBER --
401 -- p_short_term_capital_gain NUMBER --
402 -- p_income_from_any_other_source NUMBER --
403 -- p_tds_paid_on_other_income NUMBER --
404 -- p_interest_on_deposits NUMBER --
405 -- p_effective_date DATE --
406 -- OUT : p_warnings BOOLEAN --
407 -- --
408 --------------------------------------------------------------------------
409 PROCEDURE declare_other_income
410 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
411 ,p_income_from_house_property IN NUMBER
412 ,p_profit_and_gain_from_busines IN NUMBER
413 ,p_long_term_capital_gain IN NUMBER
414 ,p_short_term_capital_gain IN NUMBER
415 ,p_income_from_any_other_source IN NUMBER
416 ,p_tds_paid_on_other_income IN NUMBER
417 ,p_interest_on_deposits IN NUMBER
418 ,p_effective_date IN DATE DEFAULT NULL
419 ,p_warnings OUT NOCOPY BOOLEAN);
420
421 --------------------------------------------------------------------------
422 -- --
423 -- Name : DECLARE_SECTION80DD --
424 -- Type : PROCEDURE --
425 -- Access : Public --
426 -- Description : The procedure is responsible for storing the --
427 -- detials in 'Deduction under Section 80DD' element. --
428 -- --
429 -- Parameters : --
430 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
431 -- p_disability_type VARCHAR2 --
432 -- p_disability_percentage VARCHAR2 --
433 -- p_treatment_amount NUMBER --
434 -- p_effective_date DATE --
435 -- p_element_entry_id element_entry_id%TYPE --
436 -- OUT : p_warnings BOOLEAN --
437 -- --
438 --------------------------------------------------------------------------
439 PROCEDURE declare_section80dd
440 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
441 ,p_disability_type IN VARCHAR2
442 ,p_disability_percentage IN VARCHAR2
443 ,p_treatment_amount IN NUMBER
444 ,p_effective_date IN DATE default null
445 ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
446 ,p_warnings OUT NOCOPY VARCHAR2);
447
448 --------------------------------------------------------------------------
449 -- --
450 -- Name : DECLARE_SECTION80G --
451 -- Type : PROCEDURE --
452 -- Access : Public --
453 -- Description : The procedure is responsible for storing the --
454 -- detials in 'Deduction under Section 80G' element. --
455 -- --
456 -- Parameters : --
457 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
458 -- p_donation_type VARCHAR2 --
459 -- p_donation_amount NUMBER --
460 -- p_effective_date DATE --
461 -- p_element_entry_id element_entry_id%TYPE --
462 -- OUT : p_warnings BOOLEAN --
463 -- --
464 --------------------------------------------------------------------------
465 PROCEDURE declare_section80g
466 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
467 ,p_donation_type IN VARCHAR2
468 ,p_donation_amount IN NUMBER
469 ,p_effective_date IN DATE default null
470 ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
471 ,p_warnings OUT NOCOPY VARCHAR2);
472
473 --------------------------------------------------------------------------
474 -- --
475 -- Name : DECLARE_SECTION80CCE --
476 -- Type : PROCEDURE --
477 -- Access : Public --
478 -- Description : The procedure is responsible for storing the --
479 -- detials in 'Deduction under Section 80CCE' element. --
480 -- --
481 -- Parameters : --
482 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
483 -- p_investment_type VARCHAR2 --
484 -- p_investment_amount NUMBER --
485 -- p_effective_date DATE --
486 -- p_element_entry_id element_entry_id%TYPE --
487 -- OUT : p_warnings BOOLEAN --
488 -- --
489 --------------------------------------------------------------------------
490 PROCEDURE declare_section80cce
491 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
492 ,p_investment_type IN VARCHAR2
493 ,p_investment_amount IN NUMBER
494 ,p_effective_date IN DATE default null
495 ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
496 ,p_warnings OUT NOCOPY VARCHAR2);
497
498 --------------------------------------------------------------------------
499 -- --
500 -- Name : DECLARE_LIFE_INSURANCE_PREMIUM --
501 -- Type : PROCEDURE --
502 -- Access : Public --
503 -- Description : The procedure is responsible for storing the --
504 -- detials in 'Life Insurance Premium' element. --
505 -- --
506 -- Parameters : --
507 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
508 -- p_premium_paid VARCHAR2 --
509 -- p_sum_assured NUMBER --
510 -- p_effective_date DATE --
511 -- p_element_entry_id element_entry_id%TYPE --
512 -- OUT : p_warnings BOOLEAN --
513 -- --
514 --------------------------------------------------------------------------
515 PROCEDURE declare_life_insurance_premium
516 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
517 ,p_premium_paid IN VARCHAR2
518 ,p_sum_assured IN NUMBER
519 ,p_effective_date IN DATE default null
520 ,p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE default null
521 ,p_policy_number IN VARCHAR2
522 ,p_policy_start_date IN DATE default null
523 ,p_warnings OUT NOCOPY VARCHAR2);
524
525 --------------------------------------------------------------------------
526 -- --
527 -- Name : DECLARE_VPF
528 -- Type : PROCEDURE --
529 -- Access : Public --
530 -- Description : The procedure is responsible for storing the --
531 -- details in 'PF Information' element. --
532 -- --
533 -- Parameters : --
534 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
535 -- p_effective_date DATE --
536 -- p_ee_vol_pf_amount NUMBER --
537 -- p_ee_vol_pf_percent NUMBER
538 -- OUT : p_warnings BOOLEAN --
539 -- --
540 --------------------------------------------------------------------------
541
542 PROCEDURE declare_vpf
543 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
544 ,p_effective_date IN DATE DEFAULT NULL
545 ,p_ee_vol_pf_amount IN NUMBER
546 ,p_ee_vol_pf_percent IN NUMBER
547 ,p_warnings OUT NOCOPY BOOLEAN);
548
549 --------------------------------------------------------------------------
550 -- --
551 -- Name : DECLARE_TUITION_FEE --
552 -- Type : PROCEDURE --
553 -- Access : Public --
554 -- Description : The procedure is responsible for storing the --
555 -- detials in 'Tuition Fee' element. --
556 -- --
557 -- Parameters : --
558 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
559 -- p_tuition_fee_for_child_1 NUMBER --
560 -- p_tuition_fee_for_child_2 NUMBER --
561 -- p_effective_date DATE --
562 -- p_element_entry_id element_entry_id%TYPE --
563 -- OUT : p_warnings BOOLEAN --
564 -- --
565 --------------------------------------------------------------------------
566 PROCEDURE declare_tuition_fee
567 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
568 ,p_tuition_fee_for_child_1 IN NUMBER
569 ,p_tuition_fee_for_child_2 IN NUMBER
570 ,p_effective_date IN DATE DEFAULT NULL
571 ,p_warnings OUT NOCOPY BOOLEAN);
572
573 PROCEDURE declare_tax
574 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
575 ,p_is_monthly_rent_changed IN VARCHAR2
576 ,p_apr IN NUMBER default null
577 ,p_may IN NUMBER default null
578 ,p_jun IN NUMBER default null
579 ,p_jul IN NUMBER default null
580 ,p_aug IN NUMBER default null
581 ,p_sep IN NUMBER default null
582 ,p_oct IN NUMBER default null
583 ,p_nov IN NUMBER default null
584 ,p_dec IN NUMBER default null
585 ,p_jan IN NUMBER default null
586 ,p_feb IN NUMBER default null
587 ,p_mar IN NUMBER default null
588 ,p_is_chapter6a_changed IN VARCHAR2
589 ,p_pension_fund_80ccc IN NUMBER default null
590 ,p_medical_insurance_prem_80d IN NUMBER default null
591 ,p_med_par_insurance_prem_80d IN NUMBER default NULL
592 ,p_health_checkup_self IN NUMBER DEFAULT NULL
593 ,p_health_checkup_parents IN NUMBER DEFAULT NULL
594 ,p_80d_par_prem_changed IN VARCHAR2 DEFAULT NULL
595 ,p_sec_80d_par_senior_citizen IN VARCHAR2 default null
596 ,p_80d_par_snr_changed IN VARCHAR2 DEFAULT NULL
597 ,p_sec_80ddb_senior_citizen IN VARCHAR2 default null
598 ,p_disease_treatment_80ddb IN NUMBER default null
599 ,p_sec_80d_senior_citizen IN VARCHAR2 default null
600 ,p_higher_education_loan_80e IN NUMBER default null
601 ,p_claim_exemp_under_sec_80gg IN VARCHAR2 default null
602 ,p_donation_for_research_80gga IN NUMBER default null
603 ,p_80gg_changed IN VARCHAR2 DEFAULT NULL
604 ,p_80e_changed IN VARCHAR2 DEFAULT NULL
605 ,p_80gga_changed IN VARCHAR2 DEFAULT NULL
606 ,p_80d_changed IN VARCHAR2 DEFAULT NULL
607 ,p_80d_hcs_changed IN VARCHAR2 DEFAULT NULL
608 ,p_80d_hcp_changed IN VARCHAR2 DEFAULT NULL
609 ,p_80dsc_planned_value IN VARCHAR2 DEFAULT NULL
610 ,p_80ddb_changed IN VARCHAR2 DEFAULT NULL
611 ,p_80ddbsc_planned_value IN VARCHAR2 DEFAULT NULL
612 ,p_int_on_gen_investment_80L IN NUMBER default null
613 ,p_int_on_securities_80L IN NUMBER default null
614 ,p_80ccf_changed IN Varchar2 default null
615 ,p_infrastructure_bonds_80ccf IN NUMBER default null
616 ,p_ee_vol_pf_amount IN NUMBER default null
617 ,p_ee_vol_pf_percent IN NUMBER default null
618 ,p_ee_pf_amt_changed IN VARCHAR2 DEFAULT NULL
619 ,p_ee_pf_percent_changed IN VARCHAR2 DEFAULT NULL
620 ,p_is_section88_changed IN VARCHAR2 DEFAULT NULL
621 ,p_deferred_annuity IN NUMBER default null
622 ,p_senior_citizen_sav_scheme IN NUMBER default null
623 ,p_public_provident_fund IN NUMBER default null
624 ,p_post_office_savings_scheme IN NUMBER default null
625 ,p_deposit_in_nsc_vi_issue IN NUMBER default null
626 ,p_deposit_in_nsc_viii_issue IN NUMBER default null
627 ,p_interest_on_nsc_reinvested IN NUMBER default null
628 ,p_house_loan_repayment IN NUMBER default null
629 ,p_notified_mutual_fund_or_uti IN NUMBER default null
630 ,p_national_housing_bank_scheme IN NUMBER default null
631 ,p_unit_linked_insurance_plan IN NUMBER default null
632 ,p_notified_annuity_plan IN NUMBER default null
633 ,p_notified_pension_fund IN NUMBER default null
634 ,p_public_sector_company_scheme IN NUMBER default null
635 ,p_approved_superannuation_fund IN NUMBER default null
636 ,p_infrastructure_bond IN NUMBER default null
637 ,p_tuition_fee_for_child_1 IN NUMBER default null
638 ,p_tuition_fee_for_child_2 IN NUMBER default null
639 ,p_is_other_income_changed IN VARCHAR2 default null
640 ,p_income_from_house_property IN NUMBER default null
641 ,p_profit_and_gain_from_busines IN NUMBER default null
642 ,p_long_term_capital_gain IN NUMBER default null
643 ,p_short_term_capital_gain IN NUMBER default null
644 ,p_income_from_any_other_source IN NUMBER default null
645 ,p_tds_paid_on_other_income IN NUMBER default null
646 ,p_interest_on_deposits IN NUMBER default null
647 ,p_80ccg_amt_changed IN Varchar2 default null
648 ,p_investment_amt_80ccg IN NUMBER default null
649 ,p_80ccg_date_changed IN Varchar2 default null
650 ,p_investment_date_80ccg IN DATE default null
651 ,p_approved_flag IN VARCHAR2 default null
652 ,p_comment_text IN VARCHAR2 default null
653 ,p_effective_date IN DATE default null
654 ,p_warnings OUT NOCOPY VARCHAR2);
655
656 --------------------------------------------------------------------------
657 -- --
658 -- Name : DELETE_DECLARATION --
659 -- Type : PROCEDURE --
660 -- Access : Public --
661 -- Description : The procedure is responsible for deletion of --
662 -- element entries as of the effective date. --
663 -- --
664 -- Parameters : --
665 -- IN : p_element_entry_id element_entry_id%TYPE --
666 -- p_effective_date DATE --
667 -- OUT : p_warnings BOOLEAN --
668 -- --
669 --------------------------------------------------------------------------
670 PROCEDURE delete_declaration
671 (p_element_entry_id IN NUMBER
672 ,p_effective_date IN DATE DEFAULT NULL
673 ,p_warnings OUT NOCOPY VARCHAR2
674 ,p_deletion_mode IN VARCHAR2 DEFAULT NULL);
675
676 --------------------------------------------------------------------------
677 -- --
678 -- Name : APPROVE_DECLARATION --
679 -- Type : PROCEDURE --
680 -- Access : Public --
681 -- Description : The procedure is responsible for approval of --
682 -- tax declaration for the assignment in question. --
683 -- --
684 -- Parameters : --
685 -- IN :p_assignment_id per_assignments_f.assignment_id%TYPE--
686 -- p_approval_flag VARCHAR2 --
687 -- p_effective_date DATE --
688 -- p_comment_text VARCHAR2 --
689 -- --
690 --------------------------------------------------------------------------
691 PROCEDURE approve_declaration
692 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
693 ,p_approval_flag IN VARCHAR2
694 ,p_effective_date IN DATE
695 ,p_comment_text IN VARCHAR2);
696
697 --------------------------------------------------------------------------
698 -- --
699 -- Name : GET_VALUE --
700 -- Type : PROCEDURE --
701 -- Access : Public --
702 -- Description : The procedure is responsible for retrieval of --
703 -- tax declaration details for the assignment. --
704 -- --
705 --------------------------------------------------------------------------
706 FUNCTION get_value
707 (p_assignment_id IN number
708 ,p_index IN number
709 ,p_element_name IN varchar2
710 ,p_input_name IN varchar2
711 ,p_effective_date IN date
712 )
713 RETURN VARCHAR2;
714
715 --------------------------------------------------------------------------
716 -- --
717 -- Name : WEB_ADI_DECLARE_TAX --
718 -- Type : PROCEDURE --
719 -- Access : Public --
720 -- Description : The procedure is responsible for storing the --
721 -- tax declaration details for the assignment. --
722 -- This is called from Web ADI. --
723 --------------------------------------------------------------------------
724 PROCEDURE web_adi_declare_tax
725 (p_assignment_id IN number
726 ,p_effective_date IN date default null
727 ,p_april IN number default null
728 ,p_may IN number default null
729 ,p_june IN number default null
730 ,p_july IN number default null
731 ,p_august IN number default null
732 ,p_september IN number default null
733 ,p_october IN number default null
734 ,p_november IN number default null
735 ,p_december IN number default null
736 ,p_january IN number default null
737 ,p_february IN number default null
738 ,p_march IN number default null
739 ,p_cce_ee_id1 IN number default null
740 ,p_cce_component1 IN varchar2 default null
741 ,p_investment_amount1 IN number default null
742 ,p_cce_ee_id2 IN number default null
743 ,p_cce_component2 IN varchar2 default null
744 ,p_investment_amount2 IN number default null
745 ,p_cce_ee_id3 IN number default null
746 ,p_cce_component3 IN varchar2 default null
747 ,p_investment_amount3 IN number default null
748 ,p_cce_ee_id4 IN number default null
749 ,p_cce_component4 IN varchar2 default null
750 ,p_investment_amount4 IN number default null
751 ,p_cce_ee_id5 IN number default null
752 ,p_cce_component5 IN varchar2 default null
753 ,p_investment_amount5 IN number default null
754 ,p_cce_ee_id6 IN number default null
755 ,p_cce_component6 IN varchar2 default null
756 ,p_investment_amount6 IN number default null
757 ,p_cce_ee_id7 IN number default null
758 ,p_cce_component7 IN varchar2 default null
759 ,p_investment_amount7 IN number default null
760 ,p_cce_ee_id8 IN number default null
761 ,p_cce_component8 IN varchar2 default null
762 ,p_investment_amount8 IN number default null
763 ,p_cce_ee_id9 IN number default null
764 ,p_cce_component9 IN varchar2 default null
765 ,p_investment_amount9 IN number default null
766 ,p_cce_ee_id10 IN number default null
767 ,p_cce_component10 IN varchar2 default null
768 ,p_investment_amount10 IN number default null
769 ,p_cce_ee_id11 IN number default null
770 ,p_cce_component11 IN varchar2 default null
771 ,p_investment_amount11 IN number default null
772 ,p_cce_ee_id12 IN number default null
773 ,p_cce_component12 IN varchar2 default null
774 ,p_investment_amount12 IN number default null
775 ,p_cce_ee_id13 IN number default null
776 ,p_cce_component13 IN varchar2 default null
777 ,p_investment_amount13 IN number default null
778 ,p_cce_ee_id14 IN number default null
779 ,p_cce_component14 IN varchar2 default null
780 ,p_investment_amount14 IN number default null
781 ,p_cce_ee_id15 IN number default null
782 ,p_cce_component15 IN varchar2 default null
783 ,p_investment_amount15 IN number default null
784 ,p_cce_ee_id16 IN number default null
785 ,p_cce_component16 IN varchar2 default null
786 ,p_investment_amount16 IN number default null
787 ,p_cce_ee_id17 IN number default null
788 ,p_cce_component17 IN varchar2 default null
789 ,p_investment_amount17 IN number default null
790 ,p_cce_ee_id18 IN number default null
791 ,p_cce_component18 IN varchar2 default null
792 ,p_investment_amount18 IN number default null
793 ,p_cce_ee_id19 IN number default null
794 ,p_cce_component19 IN varchar2 default null
795 ,p_investment_amount19 IN number default null
796 ,p_cce_ee_id20 IN number default null
797 ,p_cce_component20 IN varchar2 default null
798 ,p_investment_amount20 IN number default null
799 ,p_cce_ee_id21 IN number default null
800 ,p_cce_component21 IN varchar2 default null
801 ,p_investment_amount21 IN number default null
802 ,p_higher_education_loan IN number default null
803 ,p_donation_for_research IN number default null
804 ,p_claim_exemption_sec_80gg IN varchar2 default null
805 ,p_premium_amount IN number default null
806 ,p_premium_covers_sc IN varchar2 default null
807 ,p_treatment_amount IN number default null
808 ,p_treatment_covers_sc IN varchar2 default null
809 ,p_income_from_house_property IN number default null
810 ,p_profit_and_gain IN number default null
811 ,p_long_term_capital_gain IN number default null
812 ,p_short_term_capital_gain IN number default null
813 ,p_income_from_other_sources IN number default null
814 ,p_tds_paid IN number default null
815 ,p_disease_entry_id1 IN number default null
816 ,p_disability_type1 IN varchar2 default null
817 ,p_disability_percentage1 IN varchar2 default null
818 ,p_treatment_amount1 IN number default null
819 ,p_disease_entry_id2 IN number default null
820 ,p_disability_type2 IN varchar2 default null
821 ,p_disability_percentage2 IN varchar2 default null
822 ,p_treatment_amount2 IN number default null
823 ,p_donation_entry_id1 IN number default null
824 ,p_donation_type1 IN varchar2 default null
825 ,p_donation_amount1 IN number default null
826 ,p_donation_entry_id2 IN number default null
827 ,p_donation_type2 IN varchar2 default null
828 ,p_donation_amount2 IN number default null
829 ,p_lic_entry_id1 IN number default null
830 ,p_premium_paid1 IN number default null
831 ,p_sum_assured1 IN number default null
832 ,p_lic_entry_id2 IN number default null
833 ,p_premium_paid2 IN number default null
834 ,p_sum_assured2 IN number default null
835 ,p_lic_entry_id3 IN number default null
836 ,p_premium_paid3 IN number default null
837 ,p_sum_assured3 IN number default null
838 ,p_lic_entry_id4 IN number default null
839 ,p_premium_paid4 IN number default null
840 ,p_sum_assured4 IN number default null
841 ,p_lic_entry_id5 IN number default null
842 ,p_premium_paid5 IN number default null
843 ,p_sum_assured5 IN number default null
844 ,p_comment_text IN varchar2 default NULL
845 ,P_PERSON_ID IN number default null
846 ,P_FULL_NAME IN varchar2 default NULL
847 ,P_EMPLOYEE_NUMBER IN varchar2 default NULL
848 ,P_ASSIGNMENT_NUMBER IN varchar2 default NULL
849 ,P_DEPARTMENT IN varchar2 default NULL
850 ,P_LAST_UPDATED_DATE IN date default null
851 ,P_ORGANIZATION_ID IN number default null
852 ,P_BUSINESS_GROUP_ID IN number default null
853 ,P_START_DATE IN date default null
854 ,P_GRADE_ID IN number default null
855 ,P_JOB_ID IN number default null
856 ,P_POSITION_ID IN number default null
857 ,P_TAX_AREA_NUMBER IN varchar2 default NULL
858 ,P_APPROVAL_STATUS IN varchar2 default NULL
859 ,P_TAX_YEAR IN varchar2 default NULL
860 ,p_parent_premium IN number default null
861 ,p_parent_sc IN varchar2 default null
862 ,p_isb_amount IN Number default null
863 ,p_policy_number2 IN Varchar2 default null
864 ,p_policy_number3 IN Varchar2 default null
865 ,p_policy_number4 IN Varchar2 default null
866 ,p_policy_number5 IN Varchar2 default null
867 ,p_vpf_amount IN number default null
868 ,p_vpf_percent IN number default null
869 ,p_policy_number1 IN Varchar2 default null
870 ,p_cce_ee_id22 IN number default null
871 ,p_cce_component22 IN varchar2 default null
872 ,p_investment_amount22 IN number default null
873 ,p_cce_ee_id23 IN number default null
874 ,p_cce_component23 IN varchar2 default null
875 ,p_investment_amount23 IN number default null
876 ,p_policy_number6 IN Varchar2 default null
877 ,p_lic_entry_id6 IN number default null
878 ,p_premium_paid6 IN number default null
879 ,p_sum_assured6 IN number default null
880 ,p_policy_number7 IN Varchar2 default null
881 ,p_lic_entry_id7 IN number default null
882 ,p_premium_paid7 IN number default null
883 ,p_sum_assured7 IN number default null
884 ,p_policy_number8 IN Varchar2 default null
885 ,p_lic_entry_id8 IN number default null
886 ,p_premium_paid8 IN number default null
887 ,p_sum_assured8 IN number default null
888 ,p_policy_number9 IN Varchar2 default null
889 ,p_lic_entry_id9 IN number default null
890 ,p_premium_paid9 IN number default null
891 ,p_sum_assured9 IN number default null
892 ,p_policy_number10 IN Varchar2 default null
893 ,p_lic_entry_id10 IN number default null
894 ,p_premium_paid10 IN number default null
895 ,p_sum_assured10 IN number default null
896 ,p_policy_number11 IN Varchar2 default null
897 ,p_lic_entry_id11 IN number default null
898 ,p_premium_paid11 IN number default null
899 ,p_sum_assured11 IN number default null
900 ,p_policy_number12 IN Varchar2 default null
901 ,p_lic_entry_id12 IN number default null
902 ,p_premium_paid12 IN number default null
903 ,p_sum_assured12 IN number default null
904 ,p_policy_start_date1 IN Varchar2 default null
905 ,p_policy_start_date2 IN Varchar2 default null
906 ,p_policy_start_date3 IN Varchar2 default null
907 ,p_policy_start_date4 IN Varchar2 default null
908 ,p_policy_start_date5 IN Varchar2 default null
909 ,p_policy_start_date6 IN Varchar2 default null
910 ,p_policy_start_date7 IN Varchar2 default null
911 ,p_policy_start_date8 IN Varchar2 default null
912 ,p_policy_start_date9 IN Varchar2 default null
913 ,p_policy_start_date10 IN Varchar2 default null
914 ,p_policy_start_date11 IN Varchar2 default null
915 ,p_policy_start_date12 IN Varchar2 default null
916 ,p_health_checkup IN number default null
917 ,p_health_checkup_for_parents IN number default null
918 ,P_SEC80TTA IN number default null
919 ,P_SEC80CCG IN number default null
920 ,P_80CCG_INVESTMENT_DATE IN Varchar2 default null
921
922 );
923
924 --------------------------------------------------------------------------
925 -- --
926 -- Name : DECLARE_SECTION80GG --
927 -- Type : PROCEDURE --
928 -- Access : Public --
929 -- Description : The procedure is responsible for storing the --
930 -- detials in 'Deduction under Section 80GG' element. --
931 -- --
932 -- Parameters : --
933 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
934 -- p_effective_date DATE --
935 -- p_claim_exemp_under_sec_80gg VARCHAR2 --
936 -- OUT : p_warnings BOOLEAN --
937 -- --
938 --------------------------------------------------------------------------
939 PROCEDURE declare_section80gg
940 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
941 ,p_effective_date IN DATE DEFAULT NULL
942 ,p_claim_exemp_under_sec_80gg IN VARCHAR2
943 ,p_warnings OUT NOCOPY BOOLEAN);
944
945 --------------------------------------------------------------------------
946 -- --
947 -- Name : DECLARE_SECTION80E --
948 -- Type : PROCEDURE --
949 -- Access : Public --
950 -- Description : The procedure is responsible for storing the --
951 -- detials in 'Deduction under Section 80E' element. --
952 -- --
953 -- Parameters : --
954 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
955 -- p_effective_date DATE --
956 -- p_higher_education_loan_80e NUMBER --
957 -- OUT : p_warnings BOOLEAN --
958 -- --
959 --------------------------------------------------------------------------
960 PROCEDURE declare_section80e
961 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
962 ,p_effective_date IN DATE DEFAULT NULL
963 ,p_higher_education_loan_80e IN NUMBER DEFAULT NULL
964 ,p_warnings OUT NOCOPY BOOLEAN);
965
966 --------------------------------------------------------------------------
967 -- --
968 -- Name : DECLARE_SECTION80CCF --
969 -- Type : PROCEDURE --
970 -- Access : Public --
971 -- Description : The procedure is responsible for storing the --
972 -- detials in 'Deduction under Section 80CCF' element. --
973 -- --
974 -- Parameters : --
975 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
976 -- p_effective_date DATE --
977 -- p_infrastructure_bonds_80ccf NUMBER --
978 -- OUT : p_warnings BOOLEAN --
979 -- --
980 --------------------------------------------------------------------------
981 PROCEDURE declare_section80ccf
982 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
983 ,p_effective_date IN DATE DEFAULT NULL
984 ,p_infrastructure_bonds_80ccf IN NUMBER DEFAULT NULL
985 ,p_warnings OUT NOCOPY BOOLEAN);
986
987
988 PROCEDURE declare_section80ccg
989 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
990 ,p_effective_date IN DATE DEFAULT NULL
991 ,p_investment_amt_80ccg IN NUMBER DEFAULT NULL
992 ,p_investment_date_80ccg IN DATE DEFAULT NULL
993 ,p_warnings OUT NOCOPY BOOLEAN);
994
995 --------------------------------------------------------------------------
996 -- --
997 -- Name : DECLARE_SECTION80GGA --
998 -- Type : PROCEDURE --
999 -- Access : Public --
1000 -- Description : The procedure is responsible for storing the --
1001 -- detials in 'Deduction under Section 80GGA' element. --
1002 -- --
1003 -- Parameters : --
1004 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1005 -- p_effective_date DATE --
1006 -- p_donation_for_research_80gga NUMBER --
1007 -- OUT : p_warnings BOOLEAN --
1008 -- --
1009 --------------------------------------------------------------------------
1010 PROCEDURE declare_section80gga
1011 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1012 ,p_effective_date IN DATE DEFAULT NULL
1013 ,p_donation_for_research_80gga IN NUMBER DEFAULT NULL
1014 ,p_warnings OUT NOCOPY BOOLEAN);
1015
1016 --------------------------------------------------------------------------
1017 -- --
1018 -- Name : DECLARE_SECTION80D --
1019 -- Type : PROCEDURE --
1020 -- Access : Public --
1021 -- Description : The procedure is responsible for storing the --
1022 -- detials in 'Deduction under Section 80D' element. --
1023 -- --
1024 -- Parameters : --
1025 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1026 -- p_effective_date DATE --
1027 -- p_medical_insurance_prem_80d NUMBER --
1028 -- p_sec_80d_senior_citizen VARCHAR2 --
1029 -- OUT : p_warnings BOOLEAN --
1030 -- --
1031 --------------------------------------------------------------------------
1032 PROCEDURE declare_section80d
1033 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1034 ,p_effective_date IN DATE DEFAULT NULL
1035 ,p_medical_insurance_prem_80d IN NUMBER DEFAULT NULL
1036 ,p_sec_80d_senior_citizen IN VARCHAR2 DEFAULT NULL
1037 ,p_med_par_insurance_prem_80d IN NUMBER DEFAULT NULL
1038 ,p_sec_80d_par_senior_citizen IN VARCHAR2 DEFAULT NULL
1039 ,p_health_checkup_self IN NUMBER DEFAULT NULL
1040 ,p_health_checkup_parents IN NUMBER DEFAULT NULL
1041 ,p_warnings OUT NOCOPY BOOLEAN);
1042
1043 --------------------------------------------------------------------------
1044 -- --
1045 -- Name : DECLARE_SECTION80DDB --
1046 -- Type : PROCEDURE --
1047 -- Access : Public --
1048 -- Description : The procedure is responsible for storing the --
1049 -- detials in 'Deduction under Section 80DDB' element. --
1050 -- --
1051 -- Parameters : --
1052 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1053 -- p_effective_date DATE --
1054 -- p_disease_treatment_80ddb NUMBER --
1055 -- p_sec_80ddb_senior_citizen VARCHAR2 --
1056 -- OUT : p_warnings BOOLEAN --
1057 -- --
1058 --------------------------------------------------------------------------
1059 PROCEDURE declare_section80ddb
1060 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1061 ,p_effective_date IN DATE DEFAULT NULL
1062 ,p_disease_treatment_80ddb IN NUMBER DEFAULT NULL
1063 ,p_sec_80ddb_senior_citizen IN VARCHAR2 DEFAULT NULL
1064 ,p_warnings OUT NOCOPY BOOLEAN);
1065
1066 --------------------------------------------------------------------------
1067 -- --
1068 -- Name : DECLARE_SECTION80U --
1069 -- Type : PROCEDURE --
1070 -- Access : Public --
1071 -- Description : The procedure is responsible for storing the --
1072 -- detials in 'Deduction under Section 80U' element. --
1073 -- --
1074 -- Parameters : --
1075 -- IN : p_assignment_id per_assignments_f.assignment_id%TYPE--
1076 -- p_effective_date DATE --
1077 -- OUT : p_warnings BOOLEAN --
1078 -- --
1079 --------------------------------------------------------------------------
1080 PROCEDURE declare_section80U
1081 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
1082 ,p_effective_date IN DATE DEFAULT NULL
1083 ,p_warnings OUT NOCOPY BOOLEAN);
1084
1085
1086 --------------------------------------------------------------------------
1087 -- --
1088 -- Name : GET_UPDATE_MODE --
1089 -- Type : FUNCTION --
1090 -- Access : Public --
1091 -- Description : Determines the update mode --
1092 -- --
1093 -- --
1094 -- Parameters : --
1095 -- IN : p_element_entry_id pay_element_entries_f.element_entry_id%TYPE--
1096 -- p_effective_date DATE --
1097 -- OUT : --
1098 -- --
1099 --------------------------------------------------------------------------
1100 FUNCTION get_update_mode
1101 (p_element_entry_id IN pay_element_entries_f.element_entry_id%TYPE
1102 ,p_effective_date IN DATE)
1103 RETURN VARCHAR2;
1104
1105
1106 END pay_in_tax_declaration;
[Home] [Help]