APPS.JTF_RS_ROLES_IUHK dependencies on JTF_RS_ROLES_B

Line 12: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

8:
9: /* Internal Procedure for pre processing in case of create resource roles */
10:
11: PROCEDURE create_rs_resource_roles_pre (
12: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
13: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
14: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
15: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
16: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,

Line 13: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

9: /* Internal Procedure for pre processing in case of create resource roles */
10:
11: PROCEDURE create_rs_resource_roles_pre (
12: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
13: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
14: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
15: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
16: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
17: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,

Line 16: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,

12: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
13: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
14: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
15: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
16: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
17: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
18: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
19: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
20: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,

Line 17: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,

13: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
14: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
15: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
16: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
17: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
18: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
19: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
20: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
21: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,

Line 18: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,

14: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
15: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
16: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
17: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
18: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
19: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
20: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
21: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
22: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 19: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,

15: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
16: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
17: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
18: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
19: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
20: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
21: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
22: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
23: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 20: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,

16: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
17: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
18: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
19: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
20: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
21: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
22: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
23: X_MSG_COUNT OUT NOCOPY NUMBER,
24: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 21: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,

17: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
18: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
19: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
20: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
21: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
22: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
23: X_MSG_COUNT OUT NOCOPY NUMBER,
24: X_MSG_DATA OUT NOCOPY VARCHAR2
25: ) IS

Line 35: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

31:
32: /* Internal Procedure for post processing in case of create resource roles */
33:
34: PROCEDURE create_rs_resource_roles_post (
35: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
36: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
37: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
38: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
39: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,

Line 36: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

32: /* Internal Procedure for post processing in case of create resource roles */
33:
34: PROCEDURE create_rs_resource_roles_post (
35: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
36: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
37: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
38: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
39: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
40: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,

Line 39: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,

35: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
36: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
37: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
38: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
39: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
40: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
41: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
42: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
43: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,

Line 40: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,

36: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
37: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
38: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
39: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
40: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
41: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
42: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
43: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
44: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,

Line 41: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,

37: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
38: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
39: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
40: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
41: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
42: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
43: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
44: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
45: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

Line 42: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,

38: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
39: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
40: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
41: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
42: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
43: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
44: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
45: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 43: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,

39: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
40: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
41: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
42: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
43: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
44: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
45: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 44: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,

40: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
41: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
42: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
43: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
44: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
45: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 45: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

41: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
42: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
43: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
44: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
45: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2
49: ) IS

Line 58: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

54:
55: /* Internal Procedure for pre processing in case of update resource roles */
56:
57: PROCEDURE update_rs_resource_roles_pre (
58: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
59: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
60: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
61: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
62: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,

Line 59: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

55: /* Internal Procedure for pre processing in case of update resource roles */
56:
57: PROCEDURE update_rs_resource_roles_pre (
58: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
59: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
60: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
61: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
62: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
63: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,

Line 60: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

56:
57: PROCEDURE update_rs_resource_roles_pre (
58: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
59: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
60: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
61: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
62: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
63: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
64: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,

Line 63: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,

59: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
60: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
61: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
62: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
63: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
64: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
65: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
66: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
67: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,

Line 64: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,

60: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
61: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
62: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
63: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
64: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
65: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
66: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
67: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
68: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,

Line 65: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,

61: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
62: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
63: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
64: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
65: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
66: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
67: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
68: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
69: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 66: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,

62: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
63: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
64: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
65: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
66: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
67: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
68: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
69: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
70: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 67: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,

63: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
64: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
65: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
66: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
67: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
68: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
69: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
70: X_MSG_COUNT OUT NOCOPY NUMBER,
71: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 68: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,

64: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
65: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
66: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
67: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
68: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
69: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
70: X_MSG_COUNT OUT NOCOPY NUMBER,
71: X_MSG_DATA OUT NOCOPY VARCHAR2
72: ) IS

Line 81: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

77:
78: /* Internal Procedure for post processing in case of update resource roles */
79:
80: PROCEDURE update_rs_resource_roles_post (
81: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
82: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
83: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
84: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
85: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,

Line 82: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

78: /* Internal Procedure for post processing in case of update resource roles */
79:
80: PROCEDURE update_rs_resource_roles_post (
81: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
82: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
83: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
84: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
85: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
86: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,

Line 83: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

79:
80: PROCEDURE update_rs_resource_roles_post (
81: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
82: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
83: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
84: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
85: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
86: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
87: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,

Line 86: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,

82: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
83: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
84: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
85: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
86: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
87: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
88: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
89: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
90: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,

Line 87: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,

83: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
84: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
85: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
86: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
87: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
88: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
89: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
90: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
91: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,

Line 88: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,

84: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
85: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
86: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
87: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
88: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
89: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
90: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
91: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
92: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 89: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,

85: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
86: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
87: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
88: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
89: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
90: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
91: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
92: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
93: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 90: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,

86: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
87: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
88: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
89: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
90: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
91: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
92: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
93: X_MSG_COUNT OUT NOCOPY NUMBER,
94: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 91: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,

87: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
88: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
89: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
90: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
91: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
92: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
93: X_MSG_COUNT OUT NOCOPY NUMBER,
94: X_MSG_DATA OUT NOCOPY VARCHAR2
95: ) IS

Line 104: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

100:
101: /* Internal Procedure for pre processing in case of delete resource roles */
102:
103: PROCEDURE delete_rs_resource_roles_pre (
104: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
105: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
106: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
107: X_MSG_COUNT OUT NOCOPY NUMBER,
108: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 105: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

101: /* Internal Procedure for pre processing in case of delete resource roles */
102:
103: PROCEDURE delete_rs_resource_roles_pre (
104: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
105: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
106: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
107: X_MSG_COUNT OUT NOCOPY NUMBER,
108: X_MSG_DATA OUT NOCOPY VARCHAR2
109: ) IS

Line 118: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

114:
115: /* Internal Procedure for post processing in case of delete resource roles */
116:
117: PROCEDURE delete_rs_resource_roles_post (
118: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
119: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
120: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121: X_MSG_COUNT OUT NOCOPY NUMBER,
122: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 119: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

115: /* Internal Procedure for post processing in case of delete resource roles */
116:
117: PROCEDURE delete_rs_resource_roles_post (
118: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
119: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
120: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121: X_MSG_COUNT OUT NOCOPY NUMBER,
122: X_MSG_DATA OUT NOCOPY VARCHAR2
123: ) IS