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: );
27:
28: /* Internal Procedure for post processing in case of create resource roles */
29:
30: PROCEDURE create_rs_resource_roles_post (
31: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
32: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
33: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
34: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
35: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
28: /* Internal Procedure for post processing in case of create resource roles */
29:
30: PROCEDURE create_rs_resource_roles_post (
31: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
32: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
33: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
34: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
35: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
36: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
31: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
32: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
33: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
34: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
35: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
36: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
37: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
38: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
39: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
32: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
33: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
34: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
35: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
36: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
37: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
38: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
39: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
40: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
33: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
34: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
35: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
36: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
37: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
38: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
39: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
40: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
41: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
34: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
35: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
36: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
37: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
38: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
39: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
40: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
41: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
36: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
37: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
38: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
39: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
40: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
41: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
36: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
37: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
38: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
39: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
40: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
41: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
44: X_MSG_DATA OUT NOCOPY VARCHAR2
37: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
38: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
39: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
40: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
41: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
44: X_MSG_DATA OUT NOCOPY VARCHAR2
45: );
46:
47: /* Internal Procedure for pre processing in case of update resource roles */
48:
49: PROCEDURE update_rs_resource_roles_pre (
50: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
51: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
52: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
53: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
54: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
47: /* Internal Procedure for pre processing in case of update resource roles */
48:
49: PROCEDURE update_rs_resource_roles_pre (
50: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
51: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
52: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
53: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
54: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
55: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
48:
49: PROCEDURE update_rs_resource_roles_pre (
50: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
51: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
52: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
53: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
54: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
55: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
56: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
51: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
52: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
53: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
54: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
55: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
56: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
57: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
58: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
59: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
52: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
53: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
54: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
55: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
56: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
57: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
58: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
59: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
60: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
53: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
54: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
55: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
56: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
57: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
58: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
59: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
60: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
54: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
55: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
56: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
57: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
58: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
59: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
60: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62: X_MSG_COUNT OUT NOCOPY NUMBER,
55: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
56: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
57: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
58: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
59: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
60: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62: X_MSG_COUNT OUT NOCOPY NUMBER,
63: X_MSG_DATA OUT NOCOPY VARCHAR2
56: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
57: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
58: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
59: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
60: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62: X_MSG_COUNT OUT NOCOPY NUMBER,
63: X_MSG_DATA OUT NOCOPY VARCHAR2
64: );
65:
66: /* Internal Procedure for post processing in case of update resource roles */
67:
68: PROCEDURE update_rs_resource_roles_post (
69: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
70: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
71: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
72: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
73: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
66: /* Internal Procedure for post processing in case of update resource roles */
67:
68: PROCEDURE update_rs_resource_roles_post (
69: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
70: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
71: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
72: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
73: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
74: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
67:
68: PROCEDURE update_rs_resource_roles_post (
69: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
70: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
71: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
72: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
73: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
74: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
75: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
70: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
71: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
72: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
73: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
74: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
75: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
76: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
77: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
78: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
71: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
72: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
73: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
74: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
75: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
76: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
77: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
78: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
79: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
72: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
73: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
74: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
75: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
76: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
77: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
78: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
79: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
80: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
73: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
74: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
75: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
76: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
77: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
78: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
79: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
80: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
81: X_MSG_COUNT OUT NOCOPY NUMBER,
74: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
75: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
76: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
77: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
78: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
79: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
80: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
81: X_MSG_COUNT OUT NOCOPY NUMBER,
82: X_MSG_DATA OUT NOCOPY VARCHAR2
75: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
76: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
77: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
78: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
79: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
80: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
81: X_MSG_COUNT OUT NOCOPY NUMBER,
82: X_MSG_DATA OUT NOCOPY VARCHAR2
83: );
84:
85: /* Internal Procedure for pre processing in case of delete resource roles */
86:
87: PROCEDURE delete_rs_resource_roles_pre (
88: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
89: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
90: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
91: X_MSG_COUNT OUT NOCOPY NUMBER,
92: X_MSG_DATA OUT NOCOPY VARCHAR2
85: /* Internal Procedure for pre processing in case of delete resource roles */
86:
87: PROCEDURE delete_rs_resource_roles_pre (
88: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
89: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
90: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
91: X_MSG_COUNT OUT NOCOPY NUMBER,
92: X_MSG_DATA OUT NOCOPY VARCHAR2
93: );
94:
95: /* Internal Procedure for post processing in case of delete resource roles */
96:
97: PROCEDURE delete_rs_resource_roles_post (
98: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
99: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
100: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
101: X_MSG_COUNT OUT NOCOPY NUMBER,
102: X_MSG_DATA OUT NOCOPY VARCHAR2
95: /* Internal Procedure for post processing in case of delete resource roles */
96:
97: PROCEDURE delete_rs_resource_roles_post (
98: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
99: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
100: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
101: X_MSG_COUNT OUT NOCOPY NUMBER,
102: X_MSG_DATA OUT NOCOPY VARCHAR2
103: );