1 PACKAGE pay_au_term_rep AS
2 /* $Header: pyautrm.pkh 120.1 2007/11/29 12:25:34 tbakashi noship $ */
3 /*
4 **
5 ** Copyright (c) 1999 Oracle Corporation
6 ** All Rights Reserved
7 **
8 ** Procedures and functions used in AU terminations reporting
9 **
10 ** Change List
11 ** ===========
12 **
13 ** Date Author Reference Description
14 ** ====================================================
15 ** 05-NOV-2000 rayyadev 115.0 Created.
16 ** 06-NOV-2000 rayyadev 115.1 Changed the Name of the package.
17 ** 07-JUL-2001 apunekar 115.2 Added function to get invalidity balances.
18 ** 10-OCT-2001 ragovind 115.3 Added parameter p_invalidity_component to the
19 ** function ETP_PREPAYMENT_INFORMATION
20 ** 05-DEC-2001 nnaresh 115.5 Updated for GSCC Standards.
21 ** 04-DEC-2002 Ragovind 115.6 Added NOCOPY for the functions etp_payment_information,etp_prepayment_information
22 ** 23-JUL-2003 Nanuradh 115.7 Bug#2984390 - Added an extra parameter to the function ETP_prepayment_information - ETP Pre/post Enhancement
23 ** 21-Nov-2007 tbakashi 115.8 Bug#6470561 - STATUTORY UPDATE: MUTIPLE ETP IMPACT ON TERMINATION REPORT
24 ** ============== Formula Fuctions ====================
25 ** Package contains Reporting Details for the Termination
26 ** report in AU localisatons.
27 */
28 --
29 -------------------------------------------------------------------------------------------------
30 --
31 -- FUNCTION ETP_prepayment_information
32 --
33 -- Returns :
34 -- 1 if function runs successfully
35 -- 0 otherwise
36 --
37 -- Purpose : Return the Values of ETP Prepayment information
38 --
39 -- In : p_assignment_id - assignment which is terminated for
40 -- which report is requiered
41 -- p_Hire_date - date Of commencement of the assignment
42 -- p_Termination_date - date Of Termination Date
43 --
44 -- Out : p_pre_01Jul1983_days - no Of Days in the Pre Jul 1983
45 -- p_post_30jun1983_days - no Of Days in the Post Jul 1983
46 -- p_pre_01jul1983_ratio -ratio Of Days in the Pre Jul 1983
47 -- p_post_30jun1983_ratio -ratio Of Days in the Post Jul 1983
48 -- P_Gross_ETP -gross ETP With out super annuation
49 -- P_Maximum_Rollover -Maximum rollover amount
50 -- p_Lump_sum_d -Lump sum D Tax free amount
51 -- P_INVALIDITY_COMPONENT -Invalidity Component amount
52 --
53 -- Uses :
54 -- pay_au_terminations
55 -- hr_utility
56 --
57 ------------------------------------------------------------------------------------------------
58
59 function ETP_prepayment_information
60 (p_assignment_id in number
61 ,P_hire_date in Date
62 ,p_Termination_date in date
63 ,P_Assignment_action_id in Number
64 ,p_pre_01Jul1983_days out NOCOPY number
65 ,p_post_30jun1983_days out NOCOPY number
66 ,p_pre_01jul1983_ratio out NOCOPY number
67 ,p_post_30jun1983_ratio out NOCOPY number
68 ,P_Gross_ETP out NOCOPY number
69 ,P_Maximum_Rollover out NOCOPY number
70 ,p_Lump_sum_d out NOCOPY number
71 ,p_invalidity_component out NOCOPY number
72 ,p_etp_service_date out NOCOPY date /* Bug#2984390 */
73 ) return number;
74
75 function ETP_payment_information
76 (p_assignment_id in number
77 ,P_hire_date in Date
78 ,p_Termination_date in date
79 ,P_Assignment_action_id in Number
80 ,P_transitional in varchar2 /* 6470561 */
81 ,P_ETP_Payment out NOCOPY number
82 ,P_superAnnuation_rollover out NOCOPY number
83 ,p_Lump_sum_d out NOCOPY number
84 ,P_ETP_TAX out NOCOPY number
85 ,p_invalidity_component out NOCOPY number /* 6470561 */
86 )
87 return number ;
88
89 --function to get the invalidity balance
90 function get_invalidity_pay_bal(p_assignment_action_id in number,
91 p_assignment_id in number
92 ) return number;
93 end pay_au_term_rep;