[Home] [Help]
PACKAGE: APPS.POS_PROFILE_CHANGE_REQUEST_PKG
Source
1 PACKAGE POS_PROFILE_CHANGE_REQUEST_PKG AS
2 /* $Header: POSPCRS.pls 120.15 2007/11/17 07:46:54 puppulur ship $ */
3
4 PROCEDURE approve_address_req
5 (p_request_id IN NUMBER,
6 x_return_status OUT nocopy VARCHAR2,
7 x_msg_count OUT nocopy NUMBER,
8 x_msg_data OUT nocopy VARCHAR2
9 );
10
11 -- If the request is a new contact request with user account,
12 -- x_password will have the generated password; otherwise it is null
13 PROCEDURE approve_contact_req
14 (p_request_id IN NUMBER,
15 x_return_status OUT nocopy VARCHAR2,
16 x_msg_count OUT nocopy NUMBER,
17 x_msg_data OUT nocopy VARCHAR2,
18 x_password OUT nocopy VARCHAR2
19 );
20
21 PROCEDURE approve_bus_class_req
22 (p_request_id IN NUMBER,
23 x_return_status OUT nocopy VARCHAR2,
24 x_msg_count OUT nocopy NUMBER,
25 x_msg_data OUT nocopy VARCHAR2
26 );
27
28 PROCEDURE approve_ps_req
29 (p_request_id IN NUMBER,
30 x_return_status OUT nocopy VARCHAR2,
31 x_msg_count OUT nocopy NUMBER,
32 x_msg_data OUT nocopy VARCHAR2
33 );
34
35 PROCEDURE reject_address_req
36 (p_request_id IN NUMBER,
37 x_return_status OUT nocopy VARCHAR2,
38 x_msg_count OUT nocopy NUMBER,
39 x_msg_data OUT nocopy VARCHAR2
40 );
41
42 PROCEDURE reject_contact_req
43 (p_request_id IN NUMBER,
44 x_return_status OUT nocopy VARCHAR2,
45 x_msg_count OUT nocopy NUMBER,
46 x_msg_data OUT nocopy VARCHAR2
47 );
48
49 PROCEDURE reject_bus_class_req
50 (p_request_id IN NUMBER,
51 x_return_status OUT nocopy VARCHAR2,
52 x_msg_count OUT nocopy NUMBER,
53 x_msg_data OUT nocopy VARCHAR2
54 );
55
56 PROCEDURE reject_ps_req
57 (p_request_id IN NUMBER,
58 x_return_status OUT nocopy VARCHAR2,
59 x_msg_count OUT nocopy NUMBER,
60 x_msg_data OUT nocopy VARCHAR2
61 );
62
63 PROCEDURE reject_mult_address_reqs
64 (
65 p_req_id_tbl IN po_tbl_number,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2
69 );
70
71 PROCEDURE reject_mult_contact_reqs
72 (
73 p_req_id_tbl IN po_tbl_number,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE reject_mult_bus_class_reqs
80 (
81 p_req_id_tbl IN po_tbl_number,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 PROCEDURE reject_mult_ps_reqs
88 (
89 p_req_id_tbl IN po_tbl_number,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95 PROCEDURE approve_mult_address_reqs
96 (
97 p_req_id_tbl IN po_tbl_number,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE approve_mult_contact_reqs
104 (
105 p_req_id_tbl IN po_tbl_number,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2
109 );
110
111 PROCEDURE approve_mult_bus_class_reqs
112 (
113 p_req_id_tbl IN po_tbl_number,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2
117 );
118
119 PROCEDURE approve_mult_ps_reqs
120 (
121 p_req_id_tbl IN po_tbl_number,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2
125 );
126
127
128
129 PROCEDURE approve_update_mult_bc_reqs
130 (
131 p_pos_bus_rec_tbl IN pos_bus_rec_tbl,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137
138 PROCEDURE chg_address_req_approval
139 (p_request_id IN NUMBER,
140 p_party_site_name IN VARCHAR2,
141 p_country IN VARCHAR2,
142 p_address_line1 IN VARCHAR2,
143 p_address_line2 IN VARCHAR2,
144 p_address_line3 IN VARCHAR2,
145 p_address_line4 IN VARCHAR2,
146 p_city IN VARCHAR2,
147 p_county IN VARCHAR2,
148 p_state IN VARCHAR2,
149 p_province IN VARCHAR2,
150 p_postal_code IN VARCHAR2,
151 p_phone_area_code IN VARCHAR2,
152 p_phone_number IN VARCHAR2,
153 p_fax_area_code IN VARCHAR2,
154 p_fax_number IN VARCHAR2,
155 p_email_address IN VARCHAR2,
156 p_rfq_flag IN VARCHAR2,
157 p_pay_flag IN VARCHAR2,
158 p_pur_flag IN VARCHAR2,
159 p_status IN VARCHAR2,
160 x_return_status OUT nocopy VARCHAR2,
161 x_msg_count OUT nocopy NUMBER,
162 x_msg_data OUT nocopy VARCHAR2
163 );
164
165
166 FUNCTION format_address(
167 p_address_line1 IN VARCHAR2 DEFAULT NULL,
168 p_address_line2 IN VARCHAR2 DEFAULT NULL,
169 p_address_line3 IN VARCHAR2 DEFAULT NULL,
170 p_address_line4 IN VARCHAR2 DEFAULT NULL,
171 p_addr_city IN VARCHAR2 DEFAULT NULL,
172 p_addr_postal_code IN VARCHAR2 DEFAULT NULL,
173 p_addr_state IN VARCHAR2 DEFAULT NULL,
174 p_addr_province IN VARCHAR2 DEFAULT NULL,
175 p_addr_county IN VARCHAR2 DEFAULT NULL,
176 p_addr_country IN VARCHAR2 DEFAULT NULL
177 ) RETURN VARCHAR2;
178
179
180 PROCEDURE chg_contact_req_approval
181 ( p_request_id IN NUMBER,
182 p_CONTACT_TITLE IN VARCHAR2,
183 p_FIRST_NAME IN VARCHAR2,
184 p_MIDDLE_NAME IN VARCHAR2,
185 p_LAST_NAME IN VARCHAR2,
186 p_JOB_TITLE IN VARCHAR2,
187 p_email_address IN VARCHAR2,
188 p_phone_area_code IN VARCHAR2,
189 p_phone_number IN VARCHAR2,
190 p_phone_extension IN VARCHAR2,
191 p_fax_area_code IN VARCHAR2,
192 p_fax_number IN VARCHAR2,
193 x_return_status OUT nocopy VARCHAR2,
194 x_msg_count OUT nocopy NUMBER,
195 x_msg_data OUT nocopy VARCHAR2
196 );
197
198 PROCEDURE reject_mult_cont_addr_reqs
199 ( p_cont_req_id IN NUMBER,
200 p_req_id_tbl IN po_tbl_number,
201 x_return_status OUT nocopy VARCHAR2,
202 x_msg_count OUT nocopy NUMBER,
203 x_msg_data OUT nocopy VARCHAR2
204 );
205
206 PROCEDURE new_contact_req_approval
207 ( p_request_id IN NUMBER,
208 p_contact_title IN VARCHAR2,
209 p_first_name IN VARCHAR2,
210 p_middle_name IN VARCHAR2,
211 p_last_name IN VARCHAR2,
212 p_job_title IN VARCHAR2,
213 p_email_address IN VARCHAR2,
214 p_phone_area_code IN VARCHAR2,
215 p_phone_number IN VARCHAR2,
216 p_phone_extension IN VARCHAR2,
217 p_fax_area_code IN VARCHAR2,
218 p_fax_number IN VARCHAR2,
219 p_create_user_acc IN VARCHAR2,
220 p_user_name IN VARCHAR2,
221 x_user_id OUT nocopy NUMBER,
222 x_cont_party_id OUT nocopy NUMBER,
223 x_return_status OUT nocopy VARCHAR2,
224 x_msg_count OUT nocopy NUMBER,
225 x_msg_data OUT nocopy VARCHAR2,
226 p_inactive_date IN DATE DEFAULT NULL
227 );
228
229 PROCEDURE assign_mult_address_to_contact
230 ( p_site_id_tbl IN po_tbl_number,
231 p_cont_party_id IN NUMBER,
232 p_vendor_id IN NUMBER,
233 x_return_status OUT nocopy VARCHAR2,
234 x_msg_count OUT nocopy NUMBER,
235 x_msg_data OUT nocopy VARCHAR2
236 );
237
238 PROCEDURE assign_user_sec_attr
239 ( p_req_id_tbl IN po_tbl_number,
240 p_usr_id IN NUMBER,
241 p_code_name IN VARCHAR2,
242 x_return_status OUT nocopy VARCHAR2,
243 x_msg_count OUT nocopy NUMBER,
244 x_msg_data OUT nocopy VARCHAR2
245 );
246
247 PROCEDURE approve_contact_req
248 ( p_request_id IN NUMBER,
249 p_user_name IN VARCHAR2,
250 x_return_status OUT nocopy VARCHAR2,
251 x_msg_count OUT nocopy NUMBER,
252 x_msg_data OUT nocopy VARCHAR2,
253 x_password OUT nocopy VARCHAR2,
254 p_inactive_date IN DATE DEFAULT NULL
255 );
256
257 PROCEDURE update_addr_req_status
258 (
259 p_request_id IN NUMBER,
260 p_party_site_id IN NUMBER,
261 p_req_status IN VARCHAR2,
262 x_return_status OUT nocopy VARCHAR2,
263 x_msg_count OUT nocopy NUMBER,
264 x_msg_data OUT nocopy VARCHAR2
265 );
266
267 PROCEDURE get_ou_count
268 (
269 x_ou_count OUT nocopy NUMBER,
270 x_return_status OUT nocopy VARCHAR2,
271 x_msg_count OUT nocopy NUMBER,
272 x_msg_data OUT nocopy VARCHAR2
273 );
274
275 PROCEDURE upd_address_to_contact_rel
276 ( p_mapping_id IN NUMBER,
277 p_cont_party_id IN NUMBER,
278 p_cont_req_id IN NUMBER,
279 p_addr_req_id IN NUMBER,
280 p_party_site_id IN NUMBER,
281 p_request_type IN VARCHAR2,
282 x_return_status OUT nocopy VARCHAR2,
283 x_msg_data OUT nocopy VARCHAR2
284 );
285
286 FUNCTION get_cont_req_id(
287 p_contact_party_id IN NUMBER
288 ) RETURN NUMBER;
289
290 END pos_profile_change_request_pkg;