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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,