1 PACKAGE zx_hr_locations_gnr_hook AUTHID CURRENT_USER AS
2 /* $Header: zxlocgnrs.pls 120.1 2006/05/18 22:31:47 sachandr ship $*/
3
4 PROCEDURE create_gnr (p_location_id IN NUMBER,
5 p_country IN VARCHAR2,
6 p_region_1 IN VARCHAR2,
7 p_region_2 IN VARCHAR2,
8 p_region_3 IN VARCHAR2,
9 p_town_or_city IN VARCHAR2,
10 p_postal_code IN VARCHAR2,
11 p_style IN VARCHAR2
12 );
13
14 PROCEDURE update_gnr (p_location_id IN NUMBER,
15 p_country IN VARCHAR2,
16 p_region_1 IN VARCHAR2,
17 p_region_2 IN VARCHAR2,
18 p_region_3 IN VARCHAR2,
19 p_town_or_city IN VARCHAR2,
20 p_postal_code IN VARCHAR2,
21 p_style_o IN VARCHAR2,
22 p_country_o IN VARCHAR2,
23 p_region_1_o IN VARCHAR2,
24 p_region_2_o IN VARCHAR2,
25 p_region_3_o IN VARCHAR2,
26 p_town_or_city_o IN VARCHAR2,
27 p_postal_code_o IN VARCHAR2);
28
29 END zx_hr_locations_gnr_hook;