1 PACKAGE per_ro_address AUTHID CURRENT_USER AS
2 /* $Header: perrousrhk.pkh 120.0.12020000.2 2013/03/22 07:02:26 ssanjays noship $ */
3 PROCEDURE check_address_unique(
4 p_address_ID IN NUMBER ,
5 p_address_type IN VARCHAR2,
6 p_date_from IN DATE,
7 p_date_to IN DATE,
8 p_person_id IN NUMBER
9 );
10 --
11 PROCEDURE check_ro_address (
12 p_address_ID IN NUMBER ,
13 p_address_type IN VARCHAR2,
14 p_date_from IN DATE,
15 p_date_to IN DATE,
16 p_person_id IN NUMBER,
17 p_address_line1 IN VARCHAR2,
18 p_address_line2 IN VARCHAR2,
19 p_address_line3 IN VARCHAR2
20 ) ;
21 --
22 PROCEDURE create_ro_address (
23 p_style IN VARCHAR2,
24 p_address_type IN VARCHAR2,
25 p_date_from IN DATE,
26 p_date_to IN DATE,
27 p_person_id IN NUMBER,
28 p_address_line1 IN VARCHAR2,
29 p_address_line2 IN VARCHAR2,
30 p_address_line3 IN VARCHAR2
31 );
32 --
33 PROCEDURE update_ro_address (
34 p_address_id IN NUMBER,
35 p_address_type IN VARCHAR2,
36 p_date_from IN DATE,
37 p_date_to IN DATE,
38 p_address_line1 IN VARCHAR2,
39 p_address_line2 IN VARCHAR2,
40 p_address_line3 IN VARCHAR2
41 );
42 --
43 PROCEDURE update_ro_address_style( p_address_id IN NUMBER,
44 p_style IN VARCHAR2,
45 p_address_type IN VARCHAR2,
46 p_date_from IN DATE,
47 p_date_to IN DATE,
48 p_address_line1 IN VARCHAR2,
49 p_address_line2 IN VARCHAR2,
50 p_address_line3 IN VARCHAR2
51 );
52 --
53 END per_ro_address;
54