eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_ROLES_PVT dependencies on JTF_RS_ROLES_B

Line 15: (ROLE_ID JTF_RS_ROLES_B.ROLE_ID%TYPE,

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,

Line 16: ROLE_CODE JTF_RS_ROLES_B.ROLE_CODE%TYPE,

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,

Line 17: ROLE_TYPE_CODE JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

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,

Line 20: ACTIVE_FLAG JTF_RS_ROLES_B.ACTIVE_FLAG%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

Line 21: MEMBER_FLAG JTF_RS_ROLES_B.MEMBER_FLAG%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: );

Line 22: ADMIN_FLAG JTF_RS_ROLES_B.ADMIN_FLAG%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:

Line 23: LEAD_FLAG JTF_RS_ROLES_B.LEAD_FLAG%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

Line 24: MANAGER_FLAG JTF_RS_ROLES_B.MANAGER_FLAG%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:

Line 33: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

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

Line 34: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

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

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

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

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

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

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

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,

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

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,

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

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,

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

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,

Line 43: P_ATTRIBUTE1 IN JTF_RS_ROLES_B.ATTRIBUTE1%TYPE DEFAULT NULL,

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,

Line 44: P_ATTRIBUTE2 IN JTF_RS_ROLES_B.ATTRIBUTE2%TYPE DEFAULT NULL,

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,

Line 45: P_ATTRIBUTE3 IN JTF_RS_ROLES_B.ATTRIBUTE3%TYPE DEFAULT NULL,

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,

Line 46: P_ATTRIBUTE4 IN JTF_RS_ROLES_B.ATTRIBUTE4%TYPE DEFAULT NULL,

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,

Line 47: P_ATTRIBUTE5 IN JTF_RS_ROLES_B.ATTRIBUTE5%TYPE DEFAULT NULL,

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,

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

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

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

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

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

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

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

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

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

Line 57: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%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,

Line 58: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%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

Line 62: X_ROLE_ID OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE

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:

Line 71: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

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,

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

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,

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

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,

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

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,

Line 77: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%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,

Line 78: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%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,

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

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

Line 81: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 96: P_ATTRIBUTE15 IN JTF_RS_ROLES_B.ATTRIBUTE15%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,

Line 97: P_ATTRIBUTE_CATEGORY IN JTF_RS_ROLES_B.ATTRIBUTE_CATEGORY%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

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

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: );

Line 110: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

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,

Line 111: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

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

Line 112: P_OBJECT_VERSION_NUMBER IN JTF_RS_ROLES_B.OBJECT_VERSION_NUMBER%TYPE,

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: );