PACKAGE: APPS.WSH_RU_ACTIONS

Source

1 PACKAGE WSH_RU_ACTIONS AUTHID CURRENT_USER AS
2 /* $Header: WSHRUACS.pls 120.0 2005/05/26 17:19:36 appldev noship $ */
3 
4   TYPE Privileges_Type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
5 
6   TYPE Role_Definition_Type IS RECORD (
7 	ROLE_ID			NUMBER(15),
8 	NAME			VARCHAR2(30),
9 	DESCRIPTION		VARCHAR2(240),
10 	CREATED_BY		NUMBER(15),
11 	CREATION_DATE		DATE,
12 	LAST_UPDATED_BY		NUMBER(15),
13 	LAST_UPDATE_DATE	DATE,
14 	LAST_UPDATE_LOGIN	NUMBER(15),
15 	PRIVILEGES		Privileges_Type
16   );
17 
18   TYPE Custom_message_rec is RECORD
19        (customized_activity_mesg_id wsh_customized_activity_msgs.customized_activity_mesg_id %TYPE
20        ,role_id                     wsh_customized_activity_msgs.role_id%TYPE
21        ,activity_code               wsh_customized_activity_msgs.activity_code%TYPE
22        ,validation_code             wsh_customized_activity_msgs.validation_code%TYPE
23        ,return_status               wsh_customized_activity_msgs.return_status%TYPE);
24 
25   TYPE custom_message_cache_rec is RECORD
26        (user_id         number
27        ,activity_code   wsh_customized_activity_msgs.activity_code%TYPE
28        ,validation_code wsh_customized_activity_msgs.validation_code%TYPE
29        ,return_status   wsh_customized_activity_msgs.return_status%TYPE );
30 
31   TYPE custom_message_cache_tbl is table of custom_message_cache_rec index by binary_integer;
32 
33   PROCEDURE Create_Role_Definition(
34 	p_role_def_record	IN  Role_Definition_Type,
35 	x_rowid			OUT NOCOPY  VARCHAR2,
36 	x_role_id		OUT NOCOPY  NUMBER,
37 	x_return_status 	OUT NOCOPY  VARCHAR2);
38 
39   PROCEDURE Lock_Role_Definition(
40 	p_role_def_record	IN  Role_Definition_Type,
41         p_row_id                IN  Varchar2);
42 
43   PROCEDURE Update_Role_Definition(
44 	p_role_def_record	IN  OUT NOCOPY Role_Definition_Type,
45 	x_return_status 	OUT NOCOPY  VARCHAR2);
46 
47   PROCEDURE Delete_Role_Definition(
48 	p_role_def_record	IN  Role_Definition_Type,
49 	x_return_status 	OUT NOCOPY  VARCHAR2);
50 
51   PROCEDURE Get_Organization_Privileges(
52         p_organization_id       IN  NUMBER,
53         x_privileges            OUT NOCOPY  Privileges_Type,
54         x_return_status         OUT NOCOPY  VARCHAR2);
55 
56   PROCEDURE Entity_Access_In_Organization(
57         p_entity_type           IN  VARCHAR2,
58         p_organization_id       IN  NUMBER,
59         x_access_type           OUT NOCOPY  VARCHAR2,
60         x_return_status         OUT NOCOPY  VARCHAR2);
61 
62   PROCEDURE insert_customized_msgs(
63         p_custom_message_rec    IN OUT NOCOPY custom_message_rec
64        ,x_error_message         OUT NOCOPY VARCHAR2
65        ,x_return_status         OUT NOCOPY VARCHAR2 );
66 
67   PROCEDURE update_customized_msgs(
68         p_custom_message_rec    IN OUT NOCOPY custom_message_rec
69        ,x_error_message         OUT NOCOPY VARCHAR2
70        ,x_return_status         OUT NOCOPY VARCHAR2 );
71 
72   PROCEDURE delete_customized_msgs(
73         p_custom_message_rec    IN OUT NOCOPY custom_message_rec
74        ,x_error_message         OUT NOCOPY VARCHAR2
75        ,x_return_status         OUT NOCOPY VARCHAR2 );
76 
77   FUNCTION get_message_severity (
78         p_activity_code         IN VARCHAR2
79        ,p_validation_code       IN VARCHAR2) return VARCHAR2;
80 
81 
82 END WSH_RU_ACTIONS;