[Home] [Help]
PACKAGE: APPS.PER_PL_ADDRESS
Source
1 PACKAGE per_pl_address AUTHID CURRENT_USER AS
2 /* $Header: pepllhpa.pkh 120.0.12000000.1 2007/01/22 01:39:57 appldev noship $ */
3 --
4 --
5 --
6 PROCEDURE check_address_unique
7 ( p_address_ID NUMBER ,
8 p_address_type VARCHAR2,
9 p_date_from DATE,
10 p_date_to DATE,
11 p_person_id NUMBER,
12 p_pradd_ovlapval_override in boolean default FALSE);
13 --
14 PROCEDURE check_pl_address (
15 p_address_ID NUMBER ,
16 p_address_type VARCHAR2,
17 p_date_from DATE,
18 p_date_to DATE,
19 p_person_id NUMBER,
20 p_address_line1 IN VARCHAR2,
21 p_address_line2 IN VARCHAR2,
22 p_pradd_ovlapval_override in boolean
23 ) ;
24 --
25 PROCEDURE create_pl_address (p_style IN VARCHAR2,
26 p_address_type VARCHAR2,
27 p_date_from DATE,
28 p_date_to DATE,
29 p_person_id NUMBER,
30 p_address_line1 IN VARCHAR2,
31 p_address_line2 IN VARCHAR2,
32 p_pradd_ovlapval_override in boolean
33 );
34 --
35 PROCEDURE update_pl_address (p_address_id IN NUMBER,
36 p_address_type VARCHAR2,
37 p_date_from DATE,
38 p_date_to DATE,
39 p_address_line1 IN VARCHAR2,
40 p_address_line2 IN VARCHAR2);
41 --
42 PROCEDURE update_pl_address_style(p_address_id IN NUMBER,
43 p_style IN VARCHAR2,
44 p_address_type VARCHAR2,
45 p_date_from DATE,
46 p_date_to DATE,
47 p_address_line1 IN VARCHAR2,
48 p_address_line2 IN VARCHAR2);
49 --
50 END per_pl_address;