1 PACKAGE pay_au_term_rep AUTHID CURRENT_USER AS
2 /* $Header: pyautrm.pkh 120.5.12020000.2 2012/09/05 05:19:42 skshin ship $ */
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 ** 07-Sep-2009 pmatamsr 115.9 Bug#8769345 - Added a new function get_etp_pre_post_components
28 ** as part of statutory changes to ETP Super rollover.
29 ** 07-Sep-2009 pmatamsr 115.10 Bug#8769345 - Added two new output parameters for ETP_prepayment_information and ETP_payment_information
30 ** functions.
31 ** 28-Jan-2010 pmatamsr 115.11 Bug#9322314 - Added two new input parameters to function get_etp_pre_post_components.
32 ** 20-Jul-2011 skshin 115.13 Bug#12583457 - Added p_etp_pretax_SIL parameter to ETP_payment_information function for Termination Report (Australia)
33 ** 05-Sep-2012 skshin 115.14 Bug#14358180 - Added p_etp_type parameter to ETP_payment_information function
34 */
35 --
36 -------------------------------------------------------------------------------------------------
37 --
38 -- FUNCTION ETP_prepayment_information
39 --
40 -- Returns :
41 -- 1 if function runs successfully
42 -- 0 otherwise
43 --
44 -- Purpose : Return the Values of ETP Prepayment information
45 --
46 -- In : p_assignment_id - assignment which is terminated for
47 -- which report is requiered
48 -- p_Hire_date - date Of commencement of the assignment
49 -- p_Termination_date - date Of Termination Date
50 --
51 -- Out : p_pre_01Jul1983_days - no Of Days in the Pre Jul 1983
52 -- p_post_30jun1983_days - no Of Days in the Post Jul 1983
53 -- p_pre_01jul1983_ratio -ratio Of Days in the Pre Jul 1983
54 -- p_post_30jun1983_ratio -ratio Of Days in the Post Jul 1983
55 -- P_Gross_ETP -gross ETP With out super annuation
56 -- P_Maximum_Rollover -Maximum rollover amount
57 -- p_Lump_sum_d -Lump sum D Tax free amount
58 -- P_INVALIDITY_COMPONENT -Invalidity Component amount
59 --
60 -- Uses :
61 -- pay_au_terminations
62 -- hr_utility
63 --
64 ------------------------------------------------------------------------------------------------
65
66 function ETP_prepayment_information
67 (p_assignment_id in number
68 ,P_hire_date in Date
69 ,p_Termination_date in date
70 ,P_Assignment_action_id in Number
71 ,p_pre_01Jul1983_days out NOCOPY number
72 ,p_post_30jun1983_days out NOCOPY number
73 ,p_pre_01jul1983_ratio out NOCOPY number
74 ,p_post_30jun1983_ratio out NOCOPY number
75 ,P_Gross_ETP out NOCOPY number
76 ,P_Maximum_Rollover out NOCOPY number
77 ,p_Lump_sum_d out NOCOPY number
78 ,p_invalidity_component out NOCOPY number
79 ,p_etp_service_date out NOCOPY date /* Bug#2984390 */
80 ,p_taxable_max_rollover out NOCOPY number /* Start 8769345 */
81 ,p_tax_free_max_rollover out NOCOPY number /* End 8769345 */
82
83 ) return number;
84
85 function ETP_payment_information
86 (p_assignment_id in number
87 ,P_hire_date in Date
88 ,p_Termination_date in date
89 ,P_Assignment_action_id in Number
90 ,P_transitional in varchar2 /* 6470561 */
91 ,p_etp_type in varchar2 /* 14358180 */
92 ,P_ETP_Payment out NOCOPY number
93 ,P_superAnnuation_rollover out NOCOPY number
94 ,p_Lump_sum_d out NOCOPY number
95 ,P_ETP_TAX out NOCOPY number
96 ,p_invalidity_component out NOCOPY number /* 6470561 */
97 ,p_taxable_rollover out NOCOPY number /* Start 8769345 */
98 ,p_tax_free_rollover out NOCOPY number /* End 8769345 */
99 ,p_etp_pretax_SIL out NOCOPY number /* 12583457 */
100 )
101 return number ;
102
103 --function to get the invalidity balance
104 function get_invalidity_pay_bal(p_assignment_action_id in number,
105 p_assignment_id in number
106 ) return number;
107
108 /* Bug 8769345 - Added new function which will be called from Termination report to retrieve
109 the values of taxable and tax-free components after rollover for transitional ETP */
110
111 /* Bug 9322314 - Added two input parameters to the function to pass pre and post '83 ratios
112 for calculating ETP taxable and tax free components */
113
114 function get_etp_pre_post_components(p_assignment_action_id in number,
115 p_assignment_id in number,
116 p_pre_jul83_ratio in number,
117 p_post_jun83_ratio in number,
118 p_etp_tax_free_amt out nocopy number,
119 p_etp_taxable_amt out nocopy number
120 ) return number ;
121
122 end pay_au_term_rep;