21: PROCEDURE create_rs_resource_roles (
22: P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2,
24: P_COMMIT IN VARCHAR2,
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,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
22: P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2,
24: P_COMMIT IN VARCHAR2,
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,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
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,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%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,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%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,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
28: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,
45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,
53: X_MSG_DATA OUT NOCOPY VARCHAR2,
46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
47: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
48: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
49: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,
53: X_MSG_DATA OUT NOCOPY VARCHAR2,
54: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
50: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
51: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52: X_MSG_COUNT OUT NOCOPY NUMBER,
53: X_MSG_DATA OUT NOCOPY VARCHAR2,
54: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
55: )
56: IS
57:
58: l_api_version CONSTANT NUMBER := 1.0;
610: PROCEDURE update_rs_resource_roles (
611: P_API_VERSION IN NUMBER,
612: P_INIT_MSG_LIST IN VARCHAR2,
613: P_COMMIT IN VARCHAR2,
614: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
615: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
616: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
617: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
611: P_API_VERSION IN NUMBER,
612: P_INIT_MSG_LIST IN VARCHAR2,
613: P_COMMIT IN VARCHAR2,
614: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
615: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
616: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
617: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
612: P_INIT_MSG_LIST IN VARCHAR2,
613: P_COMMIT IN VARCHAR2,
614: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
615: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
616: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
617: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
615: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
616: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
617: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
616: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
617: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
617: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
618: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE,
626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE,
627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,
629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE,
630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%TYPE,
631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
638: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%TYPE,
632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
638: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
639: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%TYPE,
633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
638: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
639: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
640: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%TYPE,
634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
638: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
639: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
640: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
641: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%TYPE,
635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
638: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
639: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
640: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
641: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
642: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%TYPE,
636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
638: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
639: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
640: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
641: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
642: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
643: X_MSG_COUNT OUT NOCOPY NUMBER,
636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%TYPE,
637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
638: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
639: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
640: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
641: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
642: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
643: X_MSG_COUNT OUT NOCOPY NUMBER,
644: X_MSG_DATA OUT NOCOPY VARCHAR2
637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%TYPE,
638: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%TYPE,
639: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%TYPE,
640: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%TYPE,
641: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
642: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
643: X_MSG_COUNT OUT NOCOPY NUMBER,
644: X_MSG_DATA OUT NOCOPY VARCHAR2
645: )
1295: PROCEDURE delete_rs_resource_roles
1296: (P_API_VERSION IN NUMBER,
1297: P_INIT_MSG_LIST IN VARCHAR2,
1298: P_COMMIT IN VARCHAR2,
1299: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
1300: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
1301: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
1302: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1303: X_MSG_COUNT OUT NOCOPY NUMBER,
1296: (P_API_VERSION IN NUMBER,
1297: P_INIT_MSG_LIST IN VARCHAR2,
1298: P_COMMIT IN VARCHAR2,
1299: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
1300: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
1301: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
1302: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1303: X_MSG_COUNT OUT NOCOPY NUMBER,
1304: X_MSG_DATA OUT NOCOPY VARCHAR2
1297: P_INIT_MSG_LIST IN VARCHAR2,
1298: P_COMMIT IN VARCHAR2,
1299: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
1300: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
1301: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,
1302: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1303: X_MSG_COUNT OUT NOCOPY NUMBER,
1304: X_MSG_DATA OUT NOCOPY VARCHAR2
1305: ) IS