1 PACKAGE HZ_PARTY_SITE_V2PUB AS
2 /*$Header: ARH2PSSS.pls 120.12 2006/08/17 10:14:29 idali noship $ */
3 /*#
4 * This package includes the create and update procedures for all party site information.
5 * @rep:scope public
6 * @rep:product HZ
7 * @rep:displayname Party Site
8 * @rep:category BUSINESS_ENTITY HZ_ADDRESS
9 * @rep:lifecycle active
10 * @rep:doccd 120hztig.pdf Party Site APIs, Oracle Trading Community Architecture Technical Implementation Guide
11 */
12
13 TYPE party_site_rec_type IS RECORD(
14 party_site_id NUMBER,
15 party_id NUMBER,
16 location_id NUMBER,
17 party_site_number VARCHAR2(30),
18 orig_system_reference VARCHAR2(240),
19 orig_system VARCHAR2(30),
20 mailstop VARCHAR2(60),
21 identifying_address_flag VARCHAR2(1),
22 status VARCHAR2(1),
23 party_site_name VARCHAR2(240),
24 attribute_category VARCHAR2(30),
25 attribute1 VARCHAR2(150),
26 attribute2 VARCHAR2(150),
27 attribute3 VARCHAR2(150),
28 attribute4 VARCHAR2(150),
29 attribute5 VARCHAR2(150),
30 attribute6 VARCHAR2(150),
31 attribute7 VARCHAR2(150),
32 attribute8 VARCHAR2(150),
33 attribute9 VARCHAR2(150),
34 attribute10 VARCHAR2(150),
35 attribute11 VARCHAR2(150),
36 attribute12 VARCHAR2(150),
37 attribute13 VARCHAR2(150),
38 attribute14 VARCHAR2(150),
39 attribute15 VARCHAR2(150),
40 attribute16 VARCHAR2(150),
41 attribute17 VARCHAR2(150),
42 attribute18 VARCHAR2(150),
43 attribute19 VARCHAR2(150),
44 attribute20 VARCHAR2(150),
45 language VARCHAR2(4),
46 addressee VARCHAR2(150),
47 created_by_module VARCHAR2(150),
48 application_id NUMBER,
49 global_location_number VARCHAR2(40),
50 duns_number_c VARCHAR2(30)
51 );
52
53 TYPE party_site_use_rec_type IS RECORD(
54 party_site_use_id NUMBER,
55 comments VARCHAR2(240),
56 site_use_type VARCHAR2(30),
57 party_site_id NUMBER,
58 primary_per_type VARCHAR2(1),
59 status VARCHAR2(1),
60 created_by_module VARCHAR2(150),
61 application_id NUMBER
62 );
63
64 -------------------------------------------------------------------------
65 /*#
66 * Use this routine to create a party site for a party. A party site relates
67 * an existing party from the HZ_PARTIES table with an address location in the
68 * HZ_LOCATIONS table. This API creates a record in the HZ_PARTY_SITES table. You
69 * can create multiple party sites with multiple locations and mark one of those
70 * party sites as the identifying party site for that party. The identifying party site
71 * address components are denormalized into the HZ_PARTIES table. If orig_system is
72 * passed in, then the API also creates a record in the HZ_ORIG_SYS_REFERENCES table
73 * to store the mapping between the source system reference and the TCA primary
74 * key.
75 * @rep:scope public
76 * @rep:lifecycle active
77 * @rep:displayname Create Party Site
78 * @rep:businessevent oracle.apps.ar.hz.PartySite.create
79 * @rep:doccd 120hztig.pdf Party Site APIs, Oracle Trading Community Architecture Technical Implementation Guide
80 */
81 PROCEDURE create_party_site (
82 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83 p_party_site_rec IN PARTY_SITE_REC_TYPE,
84 x_party_site_id OUT NOCOPY NUMBER,
85 x_party_site_number OUT NOCOPY VARCHAR2,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 /*#
92 * Use this routine to update a party site. This API updates a record in the
93 * HZ_PARTY_SITES table. You cannot change an identifying address flag to `N' to unmark
94 * the party site as identifying. You must set the flag for another site to be the
95 * identifying site. This makes any other party site for that party to be non-
96 * identifying. The identifying party site address components are denormalized
97 * into the HZ_PARTIES table. If the primary key is not passed in, then get the
98 * primary key from the HZ_ORIG_SYS_REFERENCES table, based the unique and not null
99 * orig_system and orig_system_reference.
100 * @rep:scope public
101 * @rep:lifecycle active
102 * @rep:displayname Update Party Site
103 * @rep:businessevent oracle.apps.ar.hz.PartySite.update
104 * @rep:doccd 120hztig.pdf Party Site APIs, Oracle Trading Community Architecture Technical Implementation Guide
105 */
106 PROCEDURE update_party_site (
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108 p_party_site_rec IN PARTY_SITE_REC_TYPE,
109 p_object_version_number IN OUT NOCOPY NUMBER,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115 /*#
116 * Use this routine to create a use for a party site. This API creates a record in the
117 * HZ_PARTY_SITE_USES table. A party site use defines a business purpose, such as `BILL_TO'
118 * or `SHIP_TO' for a party site. You can create a party site use for a party site stored
119 * in the HZ_PARTY_SITES table.
120 * @rep:scope public
121 * @rep:lifecycle active
122 * @rep:displayname Create Party Site Use
123 * @rep:businessevent oracle.apps.ar.hz.PartySiteUse.create
124 * @rep:doccd 120hztig.pdf Party Site APIs, Oracle Trading Community Architecture Technical Implementation Guide
125 */
126 PROCEDURE create_party_site_use (
127 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128 p_party_site_use_rec IN PARTY_SITE_USE_REC_TYPE,
129 x_party_site_use_id OUT NOCOPY NUMBER,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135 /*#
136 * Use this routine to update a party site use. This API updates records in
137 * the HZ_PARTY_SITE_USES table.
138 * @rep:scope public
139 * @rep:lifecycle active
140 * @rep:displayname Update Party Site Use
141 * @rep:businessevent oracle.apps.ar.hz.PartySiteUse.update
142 * @rep:doccd 120hztig.pdf Party Site APIs, Oracle Trading Community Architecture Technical Implementation Guide
143 */
144 PROCEDURE update_party_site_use (
145 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146 p_party_site_use_rec IN PARTY_SITE_USE_REC_TYPE,
147 p_object_version_number IN OUT NOCOPY NUMBER,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2
151 );
152
153 PROCEDURE get_party_site_rec (
154 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155 p_party_site_id IN NUMBER,
156 x_party_site_rec OUT NOCOPY PARTY_SITE_REC_TYPE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2
160 );
161
162 PROCEDURE get_party_site_use_rec (
163 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164 p_party_site_use_id IN NUMBER,
165 x_party_site_use_rec OUT NOCOPY PARTY_SITE_USE_REC_TYPE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2
169 );
170
171 END HZ_PARTY_SITE_V2PUB;