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