1 PACKAGE POS_SUPPLIER_USER_REG_PKG AUTHID CURRENT_USER AS
2 /* $Header: POSUREGS.pls 120.2.12010000.2 2009/04/04 09:21:18 sthoppan ship $ */
3
4 PROCEDURE approve
5 (p_registration_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 PROCEDURE reject
12 (p_registration_id IN NUMBER,
13 x_return_status OUT nocopy VARCHAR2,
14 x_msg_count OUT nocopy NUMBER,
15 x_msg_data OUT nocopy VARCHAR2
16 );
17
18 PROCEDURE invite
19 (p_registration_id IN NUMBER,
20 x_return_status OUT nocopy VARCHAR2,
21 x_msg_count OUT nocopy NUMBER,
22 x_msg_data OUT nocopy VARCHAR2
23 );
24
25 PROCEDURE respond
26 (p_registration_id IN NUMBER,
27 x_return_status OUT nocopy VARCHAR2,
28 x_msg_count OUT nocopy NUMBER,
29 x_msg_data OUT nocopy VARCHAR2
30 );
31
32 -- The following methods are exposed in spec to allow debugging.
33 -- There are not meant to be used by other packages
34 FUNCTION is_invited (p_registration_id IN NUMBER) RETURN VARCHAR2;
35
36 FUNCTION set_initial_password(l_reg_id NUMBER) RETURN varchar2;
37
38 PROCEDURE set_profile_opt_ext_user
39 (p_userid in number);
40
41 -- Bug 8325979 - Replacing the message subject and body with FND Message and its tokens
42
43 FUNCTION GET_APPRV_REG_USR_SUBJECT(p_enterprise_name IN VARCHAR2) RETURN VARCHAR2;
44
45 PROCEDURE GENERATE_APPRV_REG_USR_BODY(p_document_id IN VARCHAR2,
46 display_type IN VARCHAR2,
47 document IN OUT NOCOPY CLOB,
48 document_type IN OUT NOCOPY VARCHAR2);
49
50
51 END pos_supplier_user_reg_pkg;