DBA Data[Home] [Help]

APPS.JTF_RS_ROLES_CUHK dependencies on JTF_RS_ROLES_B

Line 12: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

8:
9: /* Customer 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: /* Customer 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: );

Line 31: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

27:
28: /* Customer 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,

Line 32: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

28: /* Customer 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,

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

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

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

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

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

Line 40: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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,
44: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 41: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%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
45: );

Line 50: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

46:
47: /* Customer 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,

Line 51: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

47: /* Customer 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,

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

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

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

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

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

Line 59: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%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,
63: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 60: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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
64: );

Line 69: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

65:
66: /* Customer 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,

Line 70: P_ROLE_TYPE_CODE IN JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE,

66: /* Customer 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,

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

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

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

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

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

Line 78: P_LEAD_FLAG IN JTF_RS_ROLES_B.LEAD_FLAG%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,
82: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 79: P_MANAGER_FLAG IN JTF_RS_ROLES_B.MANAGER_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
83: );

Line 88: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

84:
85: /* Customer 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

Line 89: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

85: /* Customer 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: );

Line 98: P_ROLE_ID IN JTF_RS_ROLES_B.ROLE_ID%TYPE,

94:
95: /* Customer 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

Line 99: P_ROLE_CODE IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,

95: /* Customer 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: );