[Home] [Help]
PACKAGE: APPS.AMS_ACTPARTNER_PVT
Source
1 PACKAGE AMS_ActPartner_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvapns.pls 120.0 2005/05/31 14:54:28 appldev noship $ */
3
4 TYPE act_partner_rec_type IS RECORD
5 (
6 activity_partner_id NUMBER,
7 last_update_date DATE,
8 last_updated_by NUMBER,
9 creation_date DATE,
10 created_by NUMBER,
11 last_update_login NUMBER,
12 object_version_number NUMBER,
13 act_partner_used_by_id NUMBER,
14 arc_act_partner_used_by VARCHAR2(30),
15 partner_id NUMBER,
16 partner_type VARCHAR2(240),
17 description VARCHAR2(4000),
18 attribute_category VARCHAR2(30),
19 primary_flag VARCHAR2(1),
20 preferred_vad_id NUMBER,
21 partner_party_id NUMBER,
22 partner_address_id NUMBER,
23 primary_contact_id NUMBER,
24 attribute1 VARCHAR2(150),
25 attribute2 VARCHAR2(150),
26 attribute3 VARCHAR2(150),
27 attribute4 VARCHAR2(150),
28 attribute5 VARCHAR2(150),
29 attribute6 VARCHAR2(150),
30 attribute7 VARCHAR2(150),
31 attribute8 VARCHAR2(150),
32 attribute9 VARCHAR2(150),
33 attribute10 VARCHAR2(150),
34 attribute11 VARCHAR2(150),
35 attribute12 VARCHAR2(150),
36 attribute13 VARCHAR2(150),
37 attribute14 VARCHAR2(150),
38 attribute15 VARCHAR2(150)
39 );
40
41 ---------------------------------------------------------------------
42 -- PROCEDURE
43 -- create_act_partner
44 --
45 -- PURPOSE
46 -- Create a new partner association.
47 --
48 -- PARAMETERS
49 -- p_act_partner_rec: the new record to be inserted
50 -- x_act_partner_id: return the activity_partner_id of the new activity partner
51 --
52 -- NOTES
53 -- 1. object_version_number will be set to 1.
54 -- 2. If activity_partner_id is passed in, the uniqueness will be checked.
55 -- Raise exception in case of duplicates.
56 -- 3. If activity_partner_id is not passed in, generate a unique one from
57 -- the sequence.
58 -- 4. Please don't pass in any FND_API.g_mess_char/num/date.
59 ---------------------------------------------------------------------
60
61 PROCEDURE create_act_partner
62 (
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
65 p_commit IN VARCHAR2 := FND_API.g_false,
66 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
67
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71
72 p_act_partner_rec IN act_partner_rec_type,
73 x_act_partner_id OUT NOCOPY NUMBER
74 );
75
76 ---------------------------------------------------------------------
77 -- PROCEDURE
78 -- update_act_partner
79 --
80 -- PURPOSE
81 -- Update an activity partner.
82 --
83 -- PARAMETERS
84 -- p_act_partner_rec: the record with new items
85 --
86 -- NOTES
87 -- 1. Raise exception if the object_version_number doesn't match.
88 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
89 -- that column won't be updated.
90 ----------------------------------------------------------------------
91
92 PROCEDURE update_act_partner
93 (
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96 p_commit IN VARCHAR2 := FND_API.g_false,
97 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98 --p_object_version_number IN NUMBER,
99
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103
104 p_act_partner_rec IN act_partner_rec_type
105 );
106
107
108 --------------------------------------------------------------------
109 -- PROCEDURE
110 -- delete_act_partner
111 --
112 -- PURPOSE
113 -- Delete an acticity partner.
114 --
115 -- PARAMETERS
116 -- p_act_partner_id: the act_partner_id
117 -- p_object_version: the object_version_number
118 --
119 -- NOTES
120 -- 1. Raise exception if the object_version_number doesn't match.
121 --------------------------------------------------------------------
122
123 PROCEDURE delete_act_partner
124 (
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
127 p_commit IN VARCHAR2 := FND_API.g_false,
128
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132
133 p_act_partner_id IN NUMBER,
134 p_object_version IN NUMBER
135 );
136
137 -------------------------------------------------------------------
138 -- PROCEDURE
139 -- lock_act_partner
140 --
141 -- PURPOSE
142 -- Lock an activity_partner.
143 --
144 -- PARAMETERS
145 -- p_act_partner_id: the act_partner_id
146 -- p_object_version: the object_version_number
147 --
148 -- NOTES
149 -- 1. Raise exception if the object_version_number doesn't match.
150 --------------------------------------------------------------------
151
152 PROCEDURE lock_act_partner
153 (
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
156
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160
161 p_act_partner_id IN NUMBER,
162 p_object_version IN NUMBER
163 );
164
165 ---------------------------------------------------------------------
166 -- PROCEDURE
167 -- validate_act_partner
168 --
169 -- PURPOSE
170 -- Validate an activity partner record.
171 --
172 -- PARAMETERS
173 -- p_act_partner_rec: the activity partner record to be validated
174 --
175 -- NOTES
176 -- 1. p_act_partner_rec should be the complete activity partner record.
177 -- There should not be any FND_API.g_miss_char/num/date in it.
178 ----------------------------------------------------------------------
179
180 PROCEDURE validate_act_partner
181 (
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
184 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189
190 p_act_partner_rec IN act_partner_rec_type
191 );
192
193 ---------------------------------------------------------------------
194 -- PROCEDURE
195 -- check_act_partner_items
196 --
197 -- HISTORY
198 -- 04/24/2000 khung@us created
199 ---------------------------------------------------------------------
200 PROCEDURE check_act_partner_items
201 (
202 p_act_partner_rec IN act_partner_rec_type,
203 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
204 x_return_status OUT NOCOPY VARCHAR2
205 );
206
207 ---------------------------------------------------------------------
208 -- PROCEDURE
209 -- check_act_partner_record
210 --
211 -- HISTORY
212 -- 04/24/2000 khung@us created
213 ---------------------------------------------------------------------
214
215 PROCEDURE check_act_partner_record
216 (
217 p_act_partner_rec IN act_partner_rec_type,
218 p_complete_rec IN act_partner_rec_type := NULL,
219 x_return_status OUT NOCOPY VARCHAR2
220 );
221
222 ---------------------------------------------------------------------
223 -- PROCEDURE
224 -- init_act_partner_rec
225 --
226 -- PURPOSE
227 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
228 ---------------------------------------------------------------------
229 PROCEDURE init_act_partner_rec(
230 x_act_partner_rec OUT NOCOPY act_partner_rec_type
231 );
232
233 ---------------------------------------------------------------------
234 -- PROCEDURE
235 -- complete_act_partner_rec
236 --
237 -- PURPOSE
238 -- For update_act_partner, some attributes may be passed in as
239 -- FND_API.g_miss_char/num/date if the user doesn't want to
240 -- update those attributes. This procedure will replace the
241 -- "g_miss" attributes with current database values.
242 --
243 -- PARAMETERS
244 -- p_act_partner_rec: the record which may contain attributes as
245 -- FND_API.g_miss_char/num/date
246 -- x_complete_rec: the complete record after all "g_miss" items
247 -- have been replaced by current database values
248 ---------------------------------------------------------------------
249 PROCEDURE complete_act_partner_rec
250 (
251 p_act_partner_rec IN act_partner_rec_type,
252 x_complete_rec OUT NOCOPY act_partner_rec_type
253 );
254
255 END AMS_ActPartner_PVT;