[Home] [Help]
PACKAGE: APPS.JTF_RS_ROLES_PVT
Source
1 PACKAGE jtf_rs_roles_pvt AS
2 /* $Header: jtfrsvos.pls 120.0 2005/05/11 08:23:12 appldev ship $ */
3
4 /*****************************************************************************************
5 This is a private API that caller will invoke.
6 It provides procedures for managing resource roles, like
7 create, update and delete resource roles from other modules.
8 Its main procedures are as following:
9 Create Resource Roles
10 Update Resource Roles
11 Delete Resource Roles
12 ******************************************************************************************/
13
14 TYPE Resource_Role_Rec_type IS RECORD
15 (ROLE_ID JTF_RS_ROLES_B.ROLE_ID%TYPE,
16 ROLE_CODE JTF_RS_ROLES_B.ROLE_CODE%TYPE,
17 ROLE_TYPE_CODE JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
18 ROLE_NAME JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
19 ROLE_DESC JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
20 ACTIVE_FLAG JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
21 MEMBER_FLAG JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
22 ADMIN_FLAG JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
23 LEAD_FLAG JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
24 MANAGER_FLAG JTF_RS_ROLES_B.MANAGER_FLAG%TYPE
25 );
26
27 --Procedure to create the resource roles based on input values passed by calling routines
28
29 PROCEDURE create_rs_resource_roles (
30 P_API_VERSION IN NUMBER,
31 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
32 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
33 P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
34 P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
35 P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
36 P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
37 P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
38 P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
39 P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
40 P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
41 P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
42 P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
43 P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
44 P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
45 P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
46 P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
47 P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
48 P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
49 P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
50 P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
51 P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
52 P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
53 P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
54 P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
55 P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE DEFAULT NULL,
56 P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE DEFAULT NULL,
57 P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE DEFAULT NULL,
58 P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
59 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60 X_MSG_COUNT OUT NOCOPY NUMBER,
61 X_MSG_DATA OUT NOCOPY VARCHAR2,
62 X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
63 );
64
65 --Procedure to update the resource roles based on input values passed by calling routines
66
67 PROCEDURE update_rs_resource_roles (
68 P_API_VERSION IN NUMBER,
69 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71 P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
72 P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
73 P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
74 P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
75 P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
76 P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
77 P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
78 P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
79 P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
80 P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
81 P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
82 P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
83 P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
84 P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
85 P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
86 P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
87 P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
88 P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
89 P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
90 P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
91 P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
92 P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
93 P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
94 P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
95 P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
96 P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
97 P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
98 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
99 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
100 X_MSG_COUNT OUT NOCOPY NUMBER,
101 X_MSG_DATA OUT NOCOPY VARCHAR2
102 );
103
104 --Procedure to delete the resource roles
105
106 PROCEDURE delete_rs_resource_roles (
107 P_API_VERSION IN NUMBER,
108 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
109 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
110 P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
111 P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
112 P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
113 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
114 X_MSG_COUNT OUT NOCOPY NUMBER,
115 X_MSG_DATA OUT NOCOPY VARCHAR2
116 );
117
118 END jtf_rs_roles_pvt;