DBA Data[Home] [Help]

APPS.JTF_RS_ROLES_PVT 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,
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,

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

Line 29: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_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,

Line 30: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_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,

Line 31: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_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,

Line 32: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%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,

Line 33: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%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,

Line 34: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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,
38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,

Line 35: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%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,

Line 36: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%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,

Line 37: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%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,

Line 38: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%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,

Line 39: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%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,

Line 40: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%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,

Line 41: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%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,

Line 42: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%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,

Line 43: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%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,

Line 44: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%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,

Line 45: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%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,

Line 46: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%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,

Line 47: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%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,

Line 48: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%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,
52: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 49: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%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,
53: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 50: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%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,
54: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE

Line 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;

Line 614: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

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,

Line 615: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%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,

Line 616: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%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,

Line 619: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_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,

Line 620: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_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,

Line 621: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_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,

Line 622: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%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,

Line 623: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%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,

Line 624: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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,
628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE,

Line 625: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%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,

Line 626: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%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,

Line 627: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%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,

Line 628: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%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,

Line 629: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%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,

Line 630: P_ATTRIBUTE6 IN JTF_RS_ROLES_B.ATTRIBUTE6%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,

Line 631: P_ATTRIBUTE7 IN JTF_RS_ROLES_B.ATTRIBUTE7%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,

Line 632: P_ATTRIBUTE8 IN JTF_RS_ROLES_B.ATTRIBUTE8%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,

Line 633: P_ATTRIBUTE9 IN JTF_RS_ROLES_B.ATTRIBUTE9%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,

Line 634: P_ATTRIBUTE10 IN JTF_RS_ROLES_B.ATTRIBUTE10%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,

Line 635: P_ATTRIBUTE11 IN JTF_RS_ROLES_B.ATTRIBUTE11%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,

Line 636: P_ATTRIBUTE12 IN JTF_RS_ROLES_B.ATTRIBUTE12%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,

Line 637: P_ATTRIBUTE13 IN JTF_RS_ROLES_B.ATTRIBUTE13%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,

Line 638: P_ATTRIBUTE14 IN JTF_RS_ROLES_B.ATTRIBUTE14%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,

Line 639: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%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,
643: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 640: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%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,
644: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 641: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%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
645: )

Line 1299: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

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,

Line 1300: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

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

Line 1301: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,

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