DBA Data[Home] [Help]

APPS.JTF_RS_ROLES_PUB dependencies on JTF_RS_ROLES_B

Line 25: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

21: PROCEDURE create_rs_resource_roles (
22: P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
26: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
27: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',

Line 26: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

22: P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
25: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
26: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
27: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',

Line 29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',

25: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
26: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
27: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',

Line 30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',

26: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
27: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',

Line 31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',

27: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',

28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT NULL,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',

29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT 'Y',
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: X_MSG_COUNT OUT NOCOPY NUMBER,
37: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',

30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT 'N',
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT 'N',
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT 'N',
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT 'N',
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: X_MSG_COUNT OUT NOCOPY NUMBER,
37: X_MSG_DATA OUT NOCOPY VARCHAR2,
38: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE

Line 38: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE

34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT 'N',
35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: X_MSG_COUNT OUT NOCOPY NUMBER,
37: X_MSG_DATA OUT NOCOPY VARCHAR2,
38: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
39: )
40: IS
41:
42: l_api_version CONSTANT NUMBER := 1.0;

Line 127: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

123: PROCEDURE update_rs_resource_roles (
124: P_API_VERSION IN NUMBER,
125: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
127: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
128: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
130: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
131: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 128: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

124: P_API_VERSION IN NUMBER,
125: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
127: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
128: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
130: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
131: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 129: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

125: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
127: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
128: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
130: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
131: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 132: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

128: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
129: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
130: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
131: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 133: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

129: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
130: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
131: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 134: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

130: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
131: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,

Line 135: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

131: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
132: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 136: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

132: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
133: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 137: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

133: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
134: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140: X_MSG_COUNT OUT NOCOPY NUMBER,
141: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 138: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,

134: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
135: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
136: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
137: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
138: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140: X_MSG_COUNT OUT NOCOPY NUMBER,
141: X_MSG_DATA OUT NOCOPY VARCHAR2
142: )

Line 230: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

226: PROCEDURE delete_rs_resource_roles
227: (P_API_VERSION IN NUMBER,
228: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
231: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
232: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
233: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
234: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 231: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

227: (P_API_VERSION IN NUMBER,
228: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
231: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
232: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
233: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
234: X_MSG_COUNT OUT NOCOPY NUMBER,
235: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 232: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,

228: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
231: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
232: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
233: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
234: X_MSG_COUNT OUT NOCOPY NUMBER,
235: X_MSG_DATA OUT NOCOPY VARCHAR2
236: ) IS