1 PACKAGE PAY_GB_NICAT_UPD AUTHID CURRENT_USER AS
2 /* $Header: paygbnicatupd.pkh 120.0 2011/11/17 07:24:19 appldev noship $ */
3 /* This package performs the updation of NI category and pension basis
4 for the NI categories F,G,S w.e.f 06-APR-2012.
5 From 06-APR-2012 NI categories F,G,S will be upated to the user given
6 values and the pension basis of these categories is changed to the
7 corresponding pension basis of the new category.
8 Also Pension basis A (APP)-> A (Not Contracted Out)
9 is changed to N ->Not contracted out.
10 NI Categories Can be changed as below.
11 F -> A,D
12 G -> B,E
13 S -> J,L
14 **/
15 -- -------------------------------------------------------------------------------------------
16 -- The main update.
17 -- -------------------------------------------------------------------------------------------
18 -- Package Variables
19 p_package_name varchar2(30) := 'PAY_GB_NICAT_UPD';
20 PROCEDURE update_ni_category_pension(
21 errbuf OUT NOCOPY VARCHAR2,
22 retcode OUT NOCOPY NUMBER ,
23 p_paye_ref in varchar2,
24 p_bg_id IN NUMBER,
25 p_payroll_id in number,
26 p_f_category in varchar2,
27 p_g_category in varchar2,
28 p_s_category in varchar2,
29 p_mode in varchar2
30 );
31
32 END PAY_GB_NICAT_UPD;