14: -- Vertical Industry Procedure for pre processing in case of create
15: -- resource roles
16:
17: PROCEDURE create_rs_resource_roles_pre
18: (P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
19: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
20: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
21: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
22: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
15: -- resource roles
16:
17: PROCEDURE create_rs_resource_roles_pre
18: (P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
19: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
20: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
21: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
22: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
23: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
18: (P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
19: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
20: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
21: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
22: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
23: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
24: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
25: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
26: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
19: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
20: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
21: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
22: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
23: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
24: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
25: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
26: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
27: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
20: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
21: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
22: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
23: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
24: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
25: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
26: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
27: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
21: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
22: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
23: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
24: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
25: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
26: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
27: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29: X_MSG_COUNT OUT NOCOPY NUMBER,
22: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
23: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
24: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
25: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
26: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
27: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29: X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
23: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
24: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
25: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
26: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
27: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29: X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
31: BEGIN
35: -- Vertical Industry Procedure for post processing in case of create
36: -- resource roles
37:
38: PROCEDURE create_rs_resource_roles_post
39: (P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
40: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
41: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
42: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
43: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
36: -- resource roles
37:
38: PROCEDURE create_rs_resource_roles_post
39: (P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
40: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
41: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
42: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
43: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
44: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
39: (P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
40: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
41: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
42: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
43: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
44: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
45: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
46: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
47: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
40: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
41: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
42: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
43: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
44: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
45: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
46: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
47: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
48: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
41: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
42: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
43: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
44: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
45: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
46: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
47: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
48: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
49: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
42: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
43: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
44: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
45: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
46: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
47: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
48: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
49: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
50: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
44: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
45: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
46: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
47: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
48: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
49: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
50: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
51: X_MSG_COUNT OUT NOCOPY NUMBER,
44: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
45: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
46: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
47: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
48: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
49: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
50: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
51: X_MSG_COUNT OUT NOCOPY NUMBER,
52: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
45: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
46: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
47: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
48: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
49: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
50: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
51: X_MSG_COUNT OUT NOCOPY NUMBER,
52: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
53:
57:
58: -- Vertical Industry Procedure for pre processing in case of update
59: -- resource roles
60: PROCEDURE update_rs_resource_roles_pre
61: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
62: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
63: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
64: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
65: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
58: -- Vertical Industry Procedure for pre processing in case of update
59: -- resource roles
60: PROCEDURE update_rs_resource_roles_pre
61: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
62: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
63: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
64: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
65: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
66: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
59: -- resource roles
60: PROCEDURE update_rs_resource_roles_pre
61: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
62: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
63: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
64: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
65: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
66: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
67: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
62: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
63: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
64: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
65: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
66: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
67: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
68: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
69: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
70: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
63: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
64: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
65: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
66: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
67: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
68: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
69: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
70: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
71: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
64: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
65: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
66: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
67: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
68: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
69: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
70: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
71: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
72: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
65: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
66: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
67: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
68: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
69: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
70: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
71: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
72: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
73: X_MSG_COUNT OUT NOCOPY NUMBER,
66: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
67: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
68: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
69: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
70: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
71: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
72: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
73: X_MSG_COUNT OUT NOCOPY NUMBER,
74: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
67: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
68: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
69: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
70: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
71: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
72: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
73: X_MSG_COUNT OUT NOCOPY NUMBER,
74: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
75:
72: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
73: X_MSG_COUNT OUT NOCOPY NUMBER,
74: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
75:
76: l_manager_flag jtf_rs_roles_b.manager_flag%TYPE;
77: l_member_flag jtf_rs_roles_b.member_flag%TYPE;
78:
79: l_action_link_id NUMBER;
80: l_event_log_id NUMBER;
73: X_MSG_COUNT OUT NOCOPY NUMBER,
74: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
75:
76: l_manager_flag jtf_rs_roles_b.manager_flag%TYPE;
77: l_member_flag jtf_rs_roles_b.member_flag%TYPE;
78:
79: l_action_link_id NUMBER;
80: l_event_log_id NUMBER;
81: l_api_name VARCHAR2(30) := 'update_rs_resource_roles_pre';
93:
94: -- cursor to get the old manager_flag
95: CURSOR mem_mgr_flag IS
96: SELECT manager_flag, member_flag
97: FROM jtf_rs_roles_b
98: WHERE role_id = p_role_id
99: AND role_type_code = 'SALES_COMP';
100:
101: CURSOR srp_periods IS
300: -- Vertical Industry Procedure for post processing in case of update
301: -- resource roles
302:
303: PROCEDURE update_rs_resource_roles_post
304: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
305: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
306: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
307: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
308: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
301: -- resource roles
302:
303: PROCEDURE update_rs_resource_roles_post
304: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
305: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
306: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
307: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
308: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
309: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
302:
303: PROCEDURE update_rs_resource_roles_post
304: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
305: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
306: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
307: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
308: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
309: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
310: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
305: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,
306: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
307: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
308: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
309: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
310: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
311: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
312: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
313: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
306: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
307: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
308: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
309: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
310: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
311: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
312: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
313: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
314: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
307: P_ROLE_NAME IN JTF_RS_ROLES_TL.ROLE_NAME%TYPE,
308: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
309: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
310: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
311: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
312: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
313: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
314: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
315: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
308: P_ROLE_DESC IN JTF_RS_ROLES_TL.ROLE_DESC%TYPE,
309: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
310: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
311: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
312: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
313: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
314: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
315: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
316: X_MSG_COUNT OUT NOCOPY NUMBER,
309: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_FLAG%TYPE,
310: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
311: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
312: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
313: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
314: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
315: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
316: X_MSG_COUNT OUT NOCOPY NUMBER,
317: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
310: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_FLAG%TYPE,
311: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_FLAG%TYPE,
312: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
313: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%TYPE,
314: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_FLAG%TYPE,
315: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
316: X_MSG_COUNT OUT NOCOPY NUMBER,
317: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
318: BEGIN
322: -- Vertical Industry Procedure for pre processing in case of delete
323: -- resource roles
324:
325: PROCEDURE delete_rs_resource_roles_pre
326: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
327: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
328: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
329: X_MSG_COUNT OUT NOCOPY NUMBER,
330: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
323: -- resource roles
324:
325: PROCEDURE delete_rs_resource_roles_pre
326: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
327: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
328: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
329: X_MSG_COUNT OUT NOCOPY NUMBER,
330: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
331:
342: -- Vertical Industry Procedure for post processing in case of delete
343: -- resource roles
344:
345: PROCEDURE delete_rs_resource_roles_post
346: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
347: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
348: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
349: X_MSG_COUNT OUT NOCOPY NUMBER,
350: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
343: -- resource roles
344:
345: PROCEDURE delete_rs_resource_roles_post
346: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
347: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
348: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
349: X_MSG_COUNT OUT NOCOPY NUMBER,
350: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
351: BEGIN