1 PACKAGE PVX_PRTNR_PRFLS_PVT AUTHID CURRENT_USER AS
2 /* $Header: pvxvppfs.pls 115.15 2003/07/15 08:13:34 nramu ship $ */
3
4 TYPE prtnr_prfls_rec_type IS RECORD
5 (
6 partner_profile_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 ,partner_id number
14 ,target_revenue_amt number
15 ,actual_revenue_amt number
16 ,target_revenue_pct number
17 ,actual_revenue_pct number
18 ,orig_system_reference varchar2(240)
19 ,orig_system_type varchar2(30)
20 ,capacity_size varchar2(30)
21 ,capacity_amount varchar2(30)
22 ,auto_match_allowed_flag varchar2(1)
23 ,purchase_method varchar2(30)
24 ,cm_id number
25 ,ph_support_rep number
26 --,security_group_id number
27 ,lead_sharing_status varchar2(30)
28 ,lead_share_appr_flag varchar2(1)
29 ,partner_relationship_id number
30 ,partner_level varchar2(30)
31 ,preferred_vad_id number
32 ,partner_group_id number
33 ,partner_resource_id number
34 ,partner_group_number varchar2(30)
35 ,partner_resource_number varchar2(30)
36 ,sales_partner_flag varchar2(1)
37 ,indirectly_managed_flag varchar2(1)
38 ,channel_marketing_manager number
39 ,related_partner_id number
40 ,max_users number
41 ,partner_party_id number
42 ,status varchar2(1)
43 );
44
45
46 ---------------------------------------------------------------------
47 -- PROCEDURE
48 -- Create_Prtnr_Prfls
49 --
50 -- PURPOSE
51 -- Create a new Partner Profile Record
52 --
53 -- PARAMETERS
54 -- p_prtnr_prfls_rec: the new record to be inserted
55 -- x_partner_profile_id: return the partner_profile_id of the new record.
56 --
57 -- NOTES
58 -- 1. object_version_number will be set to 1.
59 -- 2. If partner_profile_id is passed in, the uniqueness will be checked.
60 -- Raise exception in case of duplicates.
61 -- 3. If partner_profile_id is not passed in, generate a unique one from
62 -- the sequence.
63 -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
64 -- Raise exception for invalid flag.
65 -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
66 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
67 ---------------------------------------------------------------------
68 PROCEDURE Create_Prtnr_Prfls(
69 p_api_version IN NUMBER
70 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
71 ,p_commit IN VARCHAR2 := FND_API.g_false
72 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
73
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_msg_count OUT NOCOPY NUMBER
76 ,x_msg_data OUT NOCOPY VARCHAR2
77
78 ,p_prtnr_prfls_rec IN prtnr_prfls_rec_type
79 ,x_partner_profile_id OUT NOCOPY NUMBER
80 );
81
82
83 --------------------------------------------------------------------
84 -- PROCEDURE
85 -- Delete_Prtnr_Prfls
86 --
87 -- PURPOSE
88 -- Delete a prtnr_prfls.
89 --
90 -- PARAMETERS
91 -- p_partner_profile_id: the partner_profile_id
92 -- p_object_version: the object_version_number
93 --
94 -- NOTES
95 -- 1. Raise exception if the object_version_number doesn't match.
96 --------------------------------------------------------------------
97 PROCEDURE Delete_Prtnr_Prfls(
98 p_api_version IN NUMBER
99 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
100 ,p_commit IN VARCHAR2 := FND_API.g_false
101
102 ,x_return_status OUT NOCOPY VARCHAR2
103 ,x_msg_count OUT NOCOPY NUMBER
104 ,x_msg_data OUT NOCOPY VARCHAR2
105
106 ,p_partner_profile_id IN NUMBER
107 ,p_object_version IN NUMBER
108 );
109
110
111 -------------------------------------------------------------------
112 -- PROCEDURE
113 -- Lock_Prtnr_Prfls
114 --
115 -- PURPOSE
116 -- Lock a prtnr_prfls.
117 --
118 -- PARAMETERS
119 -- p_partner_profile_id:
120 -- p_object_version: the object_version_number
121 --
122 -- NOTES
123 -- 1. Raise exception if the object_version_number doesn't match.
124 --------------------------------------------------------------------
125 PROCEDURE Lock_Prtnr_Prfls(
126 p_api_version IN NUMBER
127 ,p_init_msg_list 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_partner_profile_id IN NUMBER
134 ,p_object_version IN NUMBER
135 );
136
137
138 ---------------------------------------------------------------------
139 -- PROCEDURE
140 -- Update_Prtnr_Prfls
141 --
142 -- PURPOSE
143 -- Update a prtnr_prfls.
144 --
145 -- PARAMETERS
146 -- p_prtnr_prfls_rec: the record with new items.
147 -- p_mode : determines what sort of validation is to be performed during update.
148 --
149 -- NOTES
150 -- 1. Raise exception if the object_version_number doesn't match.
151 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
152 -- that column won't be updated.
153 ----------------------------------------------------------------------
154 PROCEDURE Update_Prtnr_Prfls(
155 p_api_version IN NUMBER
156 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
157 ,p_commit IN VARCHAR2 := FND_API.g_false
158 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
159
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ,x_msg_count OUT NOCOPY NUMBER
162 ,x_msg_data OUT NOCOPY VARCHAR2
163 ,p_prtnr_prfls_rec IN prtnr_prfls_rec_type
164 );
165
166
167 ---------------------------------------------------------------------
168 -- PROCEDURE
169 -- Validate_Prtnr_Prfls
170 --
171 -- PURPOSE
172 -- Validate a prtnr_prfls record.
173 --
174 -- PARAMETERS
175 -- p_prtnr_prfls_rec: the record to be validated
176 --
177 -- NOTES
178 -- 1. p_prtnr_prfls_rec should be the complete record. There
179 -- should not be any FND_API.g_miss_char/num/date in it.
180 ----------------------------------------------------------------------
181 PROCEDURE Validate_Prtnr_Prfls(
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_prtnr_prfls_rec IN prtnr_prfls_rec_type
191 );
192
193
194 ---------------------------------------------------------------------
195 -- PROCEDURE
196 -- Check_prtnr_prfls_items
197 --
198 -- PURPOSE
199 -- Perform the item level checking including unique keys,
200 -- required columns, foreign keys, domain constraints.
201 --
202 -- PARAMETERS
203 -- p_prtnr_prfls_rec: the record to be validated
204 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
205 ---------------------------------------------------------------------
206 PROCEDURE Check_Prtnr_Prfls_Items(
207 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
208 ,x_return_status OUT NOCOPY VARCHAR2
209 ,p_prtnr_prfls_rec IN prtnr_prfls_rec_type
210 );
211
212
213 ---------------------------------------------------------------------
214 -- PROCEDURE
215 -- Check_Prtnr_Prfls_Record
216 --
217 -- PURPOSE
218 -- Check the record level business rules.
219 --
220 -- PARAMETERS
221 -- p_prtnr_prfls_rec: the record to be validated; may contain attributes
222 -- as FND_API.g_miss_char/num/date
223 -- p_complete_rec: the complete record after all "g_miss" items
224 -- have been replaced by current database values
225 ---------------------------------------------------------------------
226 PROCEDURE Check_Prtnr_Prfls_Record(
227 p_prtnr_prfls_rec IN prtnr_prfls_rec_type
228 ,p_complete_rec IN prtnr_prfls_rec_type := NULL
229 ,p_mode IN VARCHAR2 := 'INSERT'
230 ,x_return_status OUT NOCOPY VARCHAR2
231 );
232
233
234 ---------------------------------------------------------------------
235 -- PROCEDURE
236 -- Init_Prtnr_Prfls_rec
237 --
238 -- PURPOSE
239 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
240 ---------------------------------------------------------------------
241 PROCEDURE Init_Prtnr_Prfls_Rec(
242 x_prtnr_prfls_rec OUT NOCOPY prtnr_prfls_rec_type
243 );
244
245
246 ---------------------------------------------------------------------
247 -- PROCEDURE
248 -- Complete_Prtnr_Prfls_Rec
249 --
250 -- PURPOSE
251 -- For update, some attributes may be passed in as
252 -- FND_API.g_miss_char/num/date if the user doesn't want to
253 -- update those attributes. This procedure will replace the
254 -- "g_miss" attributes with current database values.
255 --
256 -- PARAMETERS
257 -- p_prtnr_prfls_rec: the record which may contain attributes as
258 -- FND_API.g_miss_char/num/date
259 -- x_complete_rec: the complete record after all "g_miss" items
260 -- have been replaced by current database values
261 ---------------------------------------------------------------------
262 PROCEDURE Complete_Prtnr_Prfls_Rec(
263 p_prtnr_prfls_rec IN prtnr_prfls_rec_type
264 ,x_complete_rec OUT NOCOPY prtnr_prfls_rec_type
265 );
266
267 ---------------------------------------------------------------------
268 -- PROCEDURE
269 -- Determine_Partner_Status
270 --
271 ---------------------------------------------------------------------
272 PROCEDURE Determine_Partner_Status(
273 p_prtnr_prfls_rec IN prtnr_prfls_rec_type
274 ,x_partner_status OUT NOCOPY VARCHAR2
275 );
276
277
278 END PVX_PRTNR_PRFLS_PVT;