DBA Data[Home] [Help]

PACKAGE: APPS.PAY_AU_TERM_REP

Source


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;