DBA Data[Home] [Help]

PACKAGE: APPS.HR_US_PYZIPCHK

Source


1 PACKAGE HR_US_PYZIPCHK AUTHID CURRENT_USER AS
2 /* $Header: pyzipchk.pkh 120.0 2005/05/29 10:37:26 appldev noship $ */
3 --
4 --
5 --
6 PROCEDURE  inval_per_addr (     p_address_id    in number,
7                                 p_state_abbrev in varchar2 default null,
8                                 p_county_name  in varchar2 default null,
9                                 p_city_name    in varchar2 default null,
10                                 p_zip_code     in varchar2 default null);
11 
12 PROCEDURE  inval_hr_addr (p_location_id  in number,
13                           p_state_abbrev in varchar2 default null,
14                           p_county_name  in varchar2 default null,
15                           p_city_name    in varchar2 default null,
16                           p_zip_code     in varchar2 default null);
17 procedure  chkzipcode;
18 
19 END HR_US_PYZIPCHK;