1 PACKAGE pay_us_rsrw_upgrev AUTHID CURRENT_USER AS
2 /* $Header: payusrsrwupg.pkh 120.4 2010/05/21 13:19:53 pmatamsr noship $ */
3
4 /******************************************************************************
5 ******************************************************************
6 * *
7 * Copyright (C) 1996 Oracle Corporation. *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation, *
17 * 500 Oracle Parkway, Redwood City, CA, 94065. *
18 * *
19 ******************************************************************
20
21 Name : pay_us_rsrw_upgrev
22
23 Description : This package is called by a concurrent program.
24 In this package we upgrade Old Seeded Earnings
25 Elements "Regular Salary" and "Regular Wages"
26 to New Architecture (with Enabled Functionality
27 of Core Proration) for US Legislation.
28
29 NOTE : Customer needs to Re-Compile Fast Formula
30 'REGULAR_SALARY', 'REGULAR_WAGES' after Upgradation.
31
32 Change List
33 -----------
34 Date Name Ver Bug No Description
35 ----------- -------- ------- --------- -------------------------------
36 11-Aug-2008 sudedas 115.0 5895804
37 3556204
38 ER 3855241 Created.
39 27-Apr-2009 sudedas 115.1 8464127 Added functions get_upgrade_flag
40 and get_payprd_per_fiscal_yr.
41 22-Jun-2009 sudedas 115.2 Added fnc get_assignment_status.
42 06-Jul-2009 sudedas 115.3 8637053 Added context element_type_id to
43 function get_payprd_per_fiscal_yr
44
45 ******************************************************************************/
46
47 /*****************************************************************************
48 Name : upgrade_reg_salarywages
49
50 Description : This Procedure is responsible for Upgrading Seeded Earnings
51 Elements "Regular Salary" or, "Regular Salary" depending on
52 the parameter passed p_ele_name. This would be called by
53 Concurrent Program "Upgrade Seeded Earnings Element for US"
54 and later will be converted into Generic Upgrade Mechanism
55 *****************************************************************************/
56
57 PROCEDURE upgrade_reg_salarywages(errbuf out nocopy varchar2
58 ,retcode out nocopy number);
59
60 /*****************************************************************************
61 Name : revert_upg_reg_salarywages
62
63 Description : This Procedure is responsible for Reverting Back the Upgradation
64 of Seeded Earnings Elements "Regular Salary" and "Regula Wages"
65 done by the earlier Upgradation Process. This is called by
66 Concurrent Program "Revert back upgradation of Seeded Earnings
67 Elements for US" and a temporary arrangement. This will be
68 removed once the program will be transferred to Generic Upgrade
69 Mechanism.
70 *****************************************************************************/
71
72 PROCEDURE revert_upg_reg_salarywages(errbuf out nocopy varchar2
73 ,retcode out nocopy number);
74
75 /*****************************************************************************
76 Name : get_upgrade_flag
77
78 Description : This Function checks record from pay_upgrade_status and
79 pay_upgrade_definitions tables for Upgrade of seeded
80 Regular Earnings elements "Regular Salary" and "Regular
81 Wages" and return 'Y' or 'N' to be used by respective
82 Fast Formula to determine what logic is to be used.
83 *****************************************************************************/
84
85 FUNCTION get_upgrade_flag(p_ctx_ele_typ_id IN NUMBER) RETURN VARCHAR2;
86
87 /*****************************************************************************
88 Name : get_payprd_per_fiscal_yr
89
90 Description : This Function returns number of pay periods in the current
91 fiscal year. This can be different from standard number
92 of pay periods per fiscal year especially in case of
93 "Weekly" and "Bi-Weekly" payroll.
94 *****************************************************************************/
95
96 FUNCTION get_payprd_per_fiscal_yr(p_ctx_bg_id in number
97 ,p_ctx_payroll_id in number
98 ,p_eletyp_ctx_id in number
99 ,p_period_end_date in date) RETURN NUMBER;
100
101 /*****************************************************************************
102 Name : get_assignment_status
103
104 Description : This function checks system status type for assignment
105 effective on the prorate_end date passed to it as parameter.
106 *****************************************************************************/
107
108 FUNCTION get_assignment_status(p_ctx_asg_id IN NUMBER
109 ,p_prorate_end_dt IN DATE) RETURN VARCHAR2;
110
111 end pay_us_rsrw_upgrev;