1 PACKAGE PAY_US_EXTRA_PER_INFO_LEG_HOOK AUTHID CURRENT_USER AS
2 /* $Header: pyusnra.pkh 120.2.12010000.1 2008/07/27 23:54:07 appldev ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Package Name : PAY_US_EXTRA_PER_INFO_LEG_HOOK
21 Package File Name : pui_pkb.pkb
22
23 Description : This package will be called from Before Process Hook
24 hr_person_extra_info_api.create_person_extra_info and
25 hr_person_extra_info_api.update_person_extra_info for US
26 legislation. It is used to check for the Non Resident Status
27 of the employee.
28
29
30 Name Date Version Bug Text
31 ------------- ----------- ------- ------- ------------------------------
32 vaprakas 21-NOV-2006 115.0 5601735 Created.
33 vaprakas 06-DEC-2006 115.1 5607135 Corrected rem dbdrv comments
34 vaprakas 11-DEC-2006 115.2 5607135 Corrected rem dbdrv comments
35
36 */
37
38 /*procedure update_tax_rules(p_period_of_service_id in number,
39 p_final_process_date in date) ;
40 */
41 procedure person_check_nra_status_create(P_PERSON_ID in NUMBER
42 ,P_INFORMATION_TYPE in VARCHAR2
43 ,P_PEI_INFORMATION_CATEGORY in VARCHAR2
44 ,P_PEI_INFORMATION5 in VARCHAR2
45 ,P_PEI_INFORMATION9 in VARCHAR2);
46
47
48 procedure person_check_nra_status_update(P_PERSON_EXTRA_INFO_ID in NUMBER
49 ,P_PEI_INFORMATION_CATEGORY in VARCHAR2
50 ,P_PEI_INFORMATION1 in VARCHAR2
51 ,P_PEI_INFORMATION2 in VARCHAR2
52 ,P_PEI_INFORMATION5 in VARCHAR2
53 ,P_PEI_INFORMATION9 in VARCHAR2);
54
55 end PAY_US_EXTRA_PER_INFO_LEG_HOOK ;