1 PACKAGE jtf_rs_roles_vuhk AS
2 /* $Header: jtfrsios.pls 120.0 2005/05/11 08:20:18 appldev ship $ */
3
4 /*****************************************************************************************
5 This is the Vertical Industry User Hook API.
6 The Vertical Industry can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
9 /* Vertical Industry 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 );
26
27
28 /* Vertical Industry 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,
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 /* Vertical Industry 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,
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 /* Vertical Industry 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,
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 /* Vertical Industry 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 /* Vertical Industry 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 );
104
105 END jtf_rs_roles_vuhk;