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_VUHK dependencies on JTF_RS_ROLES_B

Line 18: (P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

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,

Line 19: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%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,

Line 22: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_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,

Line 23: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_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,

Line 24: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_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,

Line 25: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%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,
29: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 26: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%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,
30: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 27: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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
31: BEGIN

Line 39: (P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

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,

Line 40: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%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,

Line 43: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_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,

Line 44: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_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,

Line 45: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_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,

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

Line 47: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%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,
51: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 48: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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,
52: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 49: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%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
53:

Line 61: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

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,

Line 62: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%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,

Line 63: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%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,

Line 66: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_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,

Line 67: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_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,

Line 68: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_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,

Line 69: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%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,
73: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 70: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%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,
74: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 71: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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
75:

Line 76: l_manager_flag 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:
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;

Line 77: l_member_flag jtf_rs_roles_b.member_flag%TYPE;

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

Line 97: FROM jtf_rs_roles_b

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

Line 304: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

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,

Line 305: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%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,

Line 306: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%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,

Line 309: P_ACTIVE_FLAG IN JTF_RS_ROLES_B.ACTIVE_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,

Line 310: P_SEEDED_FLAG IN JTF_RS_ROLES_B.SEEDED_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,

Line 311: P_MEMBER_FLAG IN JTF_RS_ROLES_B.MEMBER_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,

Line 312: P_ADMIN_FLAG IN JTF_RS_ROLES_B.ADMIN_FLAG%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,
316: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 313: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%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,
317: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 314: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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
318: BEGIN

Line 326: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

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

Line 327: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

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:

Line 346: (P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

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

Line 347: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

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