1 PACKAGE jtf_rs_roles_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspos.pls 120.0 2005/05/11 08:21:19 appldev ship $ */
3 /*#
4 * Package containing procedures for maintaining resource roles
5 * @rep:scope internal
6 * @rep:product JTF
7 * @rep:displayname Resource Roles Package
8 * @rep:category BUSINESS_ENTITY JTF_RS_ROLE
9 * @rep:businessevent oracle.apps.jtf.jres.role.create
10 * @rep:businessevent oracle.apps.jtf.jres.role.update
11 * @rep:businessevent oracle.apps.jtf.jres.role.delete
12 */
13
14
15 /*****************************************************************************************
16 This is a public API that caller will invoke.
17 It provides PROCEDUREs for managing resource roles, like
18 create, update and delete resource roles from other modules.
19 Its main PROCEDUREs are as following:
20 Create Resource Roles
21 Update Resource Roles
22 Delete Resource Roles
23 ******************************************************************************************/
24
25 --PROCEDURE to create the resource roles based on input values passed by calling routines
26
27 /*#
28 * Procedure to create a resource role
29 * @param P_API_VERSION API version number
30 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
31 * @param P_COMMIT Flag to commit at the end of the procedure
32 * @param P_ROLE_TYPE_CODE Code of the role type
33 * @param P_ROLE_CODE Unique Code for the role
34 * @param P_ROLE_NAME Name for the role
35 * @param P_ROLE_DESC Description for the role
36 * @param P_ACTIVE_FLAG Is Role Active
37 * @param P_SEEDED_FLAG Is Role Seeded
38 * @param P_MEMBER_FLAG Does role gives member privileges
39 * @param P_ADMIN_FLAG Does role give admin privileges
40 * @param P_LEAD_FLAG Does role give lead privileges
41 * @param P_MANAGER_FLAG Does role give manager privileges
42 * @param X_RETURN_STATUS Output parameter for return status
43 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
44 * @param X_MSG_DATA Output parameter containing last user message from this procedure
45 * @param X_ROLE_ID ID Output parameter containing unique internal ID of the newly created role
46 * @rep:scope internal
47 * @rep:displayname Create Resource Role
48 * @rep:businessevent oracle.apps.jtf.jres.role.create
49 */
50 PROCEDURE create_rs_resource_roles (
51 P_API_VERSION IN NUMBER,
52 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54 P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
55 P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
56 P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
57 P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
58 P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
59 P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
60 P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
61 P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
62 P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
63 P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
64 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
65 X_MSG_COUNT OUT NOCOPY NUMBER,
66 X_MSG_DATA OUT NOCOPY VARCHAR2,
67 X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
68 );
69
70 --PROCEDURE to update the resource roles based on input values passed by calling routines
71
72 /*#
73 * Update Resource Role information
74 * @param P_API_VERSION API version number
75 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
76 * @param P_COMMIT Flag to commit at the end of the procedure
77 * @param P_ROLE_ID Unique internal ID for the role to update
78 * @param P_ROLE_TYPE_CODE Code of the role type
79 * @param P_ROLE_CODE Unique Code for the role
80 * @param P_ROLE_NAME Name for the role
81 * @param P_ROLE_DESC Description for the role
82 * @param P_SEEDED_FLAG Is Role Seeded
83 * @param P_ACTIVE_FLAG Is Role Active
84 * @param P_MEMBER_FLAG Does role gives member privileges
85 * @param P_ADMIN_FLAG Does role give admin privileges
86 * @param P_LEAD_FLAG Does role give lead privileges
87 * @param P_MANAGER_FLAG Does role give manager privileges
88 * @param P_OBJECT_VERSION_NUMBER object version number for the record
89 * @param X_RETURN_STATUS Output parameter for return status
90 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
91 * @param X_MSG_DATA Output parameter containing last user message from this procedure
92 * @rep:scope internal
93 * @rep:displayname Update Resource Role
94 * @rep:businessevent oracle.apps.jtf.jres.role.update
95 */
96 PROCEDURE update_rs_resource_roles (
97 P_API_VERSION IN NUMBER,
98 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
99 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100 P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
101 P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
102 P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
103 P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
104 P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
105 P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
106 P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
107 P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
108 P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
109 P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
110 P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
111 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
112 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
113 X_MSG_COUNT OUT NOCOPY NUMBER,
114 X_MSG_DATA OUT NOCOPY VARCHAR2
115 );
116
117 --PROCEDURE to delete the resource roles
118
119 /*#
120 * Delete a resource role
121 * @param P_API_VERSION API version number
122 * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
123 * @param P_COMMIT Flag to commit at the end of the procedure
124 * @param P_ROLE_ID Internal unique ID for the role to update
125 * @param P_ROLE_CODE Unique Code for the role
126 * @param P_OBJECT_VERSION_NUMBER object version number for the record
127 * @param X_RETURN_STATUS Output parameter for return status
128 * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
129 * @param X_MSG_DATA Output parameter containing last user message from this procedure
130 * @rep:scope internal
131 * @rep:displayname Delete Resource Role
132 * @rep:businessevent oracle.apps.jtf.jres.role.delete
133 */
134 PROCEDURE delete_rs_resource_roles (
135 P_API_VERSION IN NUMBER,
136 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
138 P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
139 P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
140 P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
141 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
142 X_MSG_COUNT OUT NOCOPY NUMBER,
143 X_MSG_DATA OUT NOCOPY VARCHAR2
144 );
145
146 END jtf_rs_roles_pub;