1 PACKAGE IGS_PE_PERSON_ADDR_PKG AS
2 /* $Header: IGSNI12S.pls 120.0 2005/06/01 15:56:10 appldev noship $ */
3
4 procedure INSERT_ROW (
5 p_action IN VARCHAR2,
6 p_rowid IN OUT NOCOPY VARCHAR2,
7 p_location_id IN OUT NOCOPY NUMBER,
8 p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,
9 p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,
10 p_country IN VARCHAR2,
11 p_address_style IN VARCHAR2,
12 p_addr_line_1 IN VARCHAR2,
13 p_addr_line_2 IN VARCHAR2,
14 p_addr_line_3 IN VARCHAR2,
15 p_addr_line_4 IN VARCHAR2,
16 p_date_last_verified IN DATE,
17 p_correspondence IN VARCHAR2,
18 p_city IN VARCHAR2,
19 p_state IN VARCHAR2,
20 p_province IN VARCHAR2,
21 p_county IN VARCHAR2,
22 p_postal_code IN VARCHAR2,
23 p_address_lines_phonetic IN VARCHAR2,
24 p_delivery_point_code IN VARCHAR2,
25 p_other_details_1 IN VARCHAR2,
26 p_other_details_2 IN VARCHAR2,
27 p_other_details_3 IN VARCHAR2,
28 l_return_status OUT NOCOPY VARCHAR2,
29 l_msg_data OUT NOCOPY VARCHAR2,
30 p_party_id IN NUMBER,
31 p_party_site_id IN OUT NOCOPY NUMBER,
32 p_party_type IN VARCHAR2,
33 p_last_update_date IN OUT NOCOPY DATE,
34 p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
35 p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
36 p_status IN hz_party_sites.status%TYPE DEFAULT 'A'
37 );
38
39
40 procedure UPDATE_ROW (
41 p_action IN VARCHAR2,
42 p_rowid IN OUT NOCOPY VARCHAR2,
43 p_location_id IN OUT NOCOPY NUMBER,
44 p_start_dt IN igs_pe_hz_pty_sites.start_date%TYPE,
45 p_end_dt IN igs_pe_hz_pty_sites.end_date%TYPE,
46 p_country IN VARCHAR2,
47 p_address_style IN VARCHAR2,
48 p_addr_line_1 IN VARCHAR2,
49 p_addr_line_2 IN VARCHAR2,
50 p_addr_line_3 IN VARCHAR2,
51 p_addr_line_4 IN VARCHAR2,
52 p_date_last_verified IN DATE,
53 p_correspondence IN VARCHAR2,
54 p_city IN VARCHAR2,
55 p_state IN VARCHAR2,
56 p_province IN VARCHAR2,
57 p_county IN VARCHAR2,
58 p_postal_code IN VARCHAR2,
59 p_address_lines_phonetic IN VARCHAR2,
60 p_delivery_point_code IN VARCHAR2,
61 p_other_details_1 IN VARCHAR2,
62 p_other_details_2 IN VARCHAR2,
63 p_other_details_3 IN VARCHAR2,
64 l_return_status OUT NOCOPY VARCHAR2,
65 l_msg_data OUT NOCOPY VARCHAR2,
66 p_party_id IN NUMBER,
67 p_party_site_id IN OUT NOCOPY NUMBER,
68 p_party_type IN VARCHAR2,
69 p_last_update_date IN OUT NOCOPY DATE,
70 p_party_site_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
71 p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
72 p_status IN hz_party_sites.status%TYPE DEFAULT 'A'
73 );
74
75 END igs_pe_person_addr_pkg;
[Home] [Help]