eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.POS_PROFILE_CHANGE_REQUEST_PKG

Source


1 PACKAGE POS_PROFILE_CHANGE_REQUEST_PKG AUTHID CURRENT_USER AS
2 /* $Header: POSPCRS.pls 120.19 2012/01/24 13:19:23 ramkandu 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_alt_contact_name  IN VARCHAR2,
187     p_JOB_TITLE		IN VARCHAR2,
188     p_department                         IN VARCHAR2,
189     p_email_address	IN VARCHAR2,
190 	p_url 		IN VARCHAR2,
191     p_phone_area_code 	IN VARCHAR2,
192     p_phone_number 	IN VARCHAR2,
193     p_phone_extension  	IN VARCHAR2,
194     p_alt_area_code     IN VARCHAR2,
195     p_alt_phone_number  IN VARCHAR2,
196     p_fax_area_code 	IN VARCHAR2,
197     p_fax_number 	IN VARCHAR2,
198     x_return_status OUT nocopy VARCHAR2,
199     x_msg_count     OUT nocopy NUMBER,
200     x_msg_data      OUT nocopy VARCHAR2
201  );
202 
203 PROCEDURE reject_mult_cont_addr_reqs
204 (     p_cont_req_id       IN  NUMBER,
205       p_req_id_tbl        IN  po_tbl_number,
206       x_return_status     OUT nocopy VARCHAR2,
207       x_msg_count         OUT nocopy NUMBER,
208       x_msg_data          OUT nocopy VARCHAR2
209 );
210 
211 PROCEDURE new_contact_req_approval
212 (  p_request_id    	IN NUMBER,
213    p_contact_title  	IN VARCHAR2,
214    p_first_name		IN VARCHAR2,
215    p_middle_name 	IN VARCHAR2,
216    p_last_name		IN VARCHAR2,
217    p_job_title		IN VARCHAR2,
218    p_email_address	IN VARCHAR2,
219    p_phone_area_code 	IN VARCHAR2,
220    p_phone_number 	IN VARCHAR2,
221    p_phone_extension  	IN VARCHAR2,
222    p_fax_area_code 	IN VARCHAR2,
223    p_fax_number 	IN VARCHAR2,
224    p_create_user_acc 	IN VARCHAR2,
225    p_user_name		IN VARCHAR2,
226    x_user_id 	   OUT nocopy NUMBER,
227    x_cont_party_id OUT nocopy NUMBER,
228    x_return_status OUT nocopy VARCHAR2,
229    x_msg_count     OUT nocopy NUMBER,
230    x_msg_data      OUT nocopy VARCHAR2,
231    p_inactive_date IN DATE DEFAULT NULL,
232    p_department  IN VARCHAR2 DEFAULT NULL,
233    p_alt_contact_name IN VARCHAR2 DEFAULT NULL,
234    p_alt_area_code IN VARCHAR2 DEFAULT NULL,
235    p_alt_phone_number IN VARCHAR2 DEFAULT NULL,
236    p_url IN VARCHAR2 DEFAULT NULL
237 );
238 
239 PROCEDURE assign_mult_address_to_contact
240 (    p_site_id_tbl        IN  po_tbl_number,
241      p_cont_party_id 	 IN  NUMBER,
242      p_vendor_id	 IN  NUMBER,
243      x_return_status     OUT nocopy VARCHAR2,
244      x_msg_count         OUT nocopy NUMBER,
245      x_msg_data          OUT nocopy VARCHAR2
246 );
247 
248 PROCEDURE assign_user_sec_attr
249 (    p_req_id_tbl        IN  po_tbl_number,
250      p_usr_id 		 IN  NUMBER,
251      p_code_name	 IN  VARCHAR2,
252      x_return_status     OUT nocopy VARCHAR2,
253      x_msg_count         OUT nocopy NUMBER,
254      x_msg_data          OUT nocopy VARCHAR2
255 );
256 
257 PROCEDURE approve_contact_req
258 (	p_request_id    IN  NUMBER,
259  	p_user_name	IN  VARCHAR2,
260    	x_return_status OUT nocopy VARCHAR2,
261    	x_msg_count     OUT nocopy NUMBER,
262    	x_msg_data      OUT nocopy VARCHAR2,
263    	x_password      OUT nocopy VARCHAR2,
264 	p_inactive_date IN DATE DEFAULT NULL
265 );
266 
267 PROCEDURE update_addr_req_status
268 (
269 	p_request_id    IN  NUMBER,
270         p_party_site_id IN  NUMBER,
271 	p_req_status    IN  VARCHAR2,
272 	x_return_status OUT nocopy VARCHAR2,
273 	x_msg_count     OUT nocopy NUMBER,
274 	x_msg_data      OUT nocopy VARCHAR2
275 );
276 
277 PROCEDURE get_ou_count
278 (
279 	x_ou_count      OUT nocopy NUMBER,
280 	x_return_status OUT nocopy VARCHAR2,
281 	x_msg_count     OUT nocopy NUMBER,
282 	x_msg_data      OUT nocopy VARCHAR2
283 );
284 
285 PROCEDURE upd_address_to_contact_rel
286 (    p_mapping_id        IN  NUMBER,
287      p_cont_party_id     IN  NUMBER,
288      p_cont_req_id       IN  NUMBER,
289      p_addr_req_id       IN  NUMBER,
290      p_party_site_id     IN  NUMBER,
291      p_request_type      IN  VARCHAR2,
292      x_return_status     OUT nocopy VARCHAR2,
293      x_msg_data          OUT nocopy VARCHAR2
294 );
295 
296 FUNCTION get_cont_req_id(
297     p_contact_party_id                    IN NUMBER
298  ) RETURN NUMBER;
299 
300 END pos_profile_change_request_pkg;