1 PACKAGE BODY jtf_rs_roles_iuhk AS
2 /* $Header: jtfrsnob.pls 120.0 2005/05/11 08:20:53 appldev ship $ */
3
4 /*****************************************************************************************
5 This is the Internal User Hook API.
6 The Internal Groups can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
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,
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
26
27 BEGIN
28 NULL;
29 END create_rs_resource_roles_pre;
30
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,
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
49 ) IS
50
51 BEGIN
52 NULL;
53 END create_rs_resource_roles_post;
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,
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
72 ) IS
73
74 BEGIN
75 NULL;
76 END update_rs_resource_roles_pre;
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,
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
95 ) IS
96
97 BEGIN
98 NULL;
99 END update_rs_resource_roles_post;
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
109 ) IS
110
111 BEGIN
112 NULL;
113 END delete_rs_resource_roles_pre;
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
123 ) IS
124
125 BEGIN
126 NULL;
127 END delete_rs_resource_roles_post;
128
129 END jtf_rs_roles_iuhk;