1 PACKAGE jtm_rs_group_member_vuhk AS
2 /* $Header: jtmhkgms.pls 120.1 2005/08/24 02:12:19 saradhak noship $ */
3
4
5 /* Vertcal Industry Procedure for pre processing in case of
6 create resource group members */
7
8 PROCEDURE create_group_members_pre
9 (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
10 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
11 X_RETURN_STATUS OUT NOCOPY VARCHAR2
12 );
13
14 /* Vertcal Industry Procedure for post processing in case of
15 create resource group members */
16
17 PROCEDURE create_group_members_post
18 (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
19 P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
20 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
21 X_RETURN_STATUS OUT NOCOPY VARCHAR2
22 );
23
24
25 /* Vertcal Industry Procedure for pre processing in case of
26 update resource group members */
27
28 PROCEDURE update_group_members_pre
29 (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
30 X_RETURN_STATUS OUT NOCOPY VARCHAR2
31 );
32
33 /* Vertcal Industry Procedure for post processing in case of
34 update resource group members */
35
36 PROCEDURE update_group_members_post
37 (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
38 X_RETURN_STATUS OUT NOCOPY VARCHAR2
39 );
40
41
42 /* Vertcal Industry Procedure for pre processing in case of
43 delete resource group members */
44
45 PROCEDURE delete_group_members_pre
46 (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
47 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
48 X_RETURN_STATUS OUT NOCOPY VARCHAR2
49 );
50
51
52 /* Vertcal Industry Procedure for post processing in case of
53 delete resource group members */
54
55 PROCEDURE delete_group_members_post
56 (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
57 P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
58 X_RETURN_STATUS OUT NOCOPY VARCHAR2
59 );
60
61 END jtm_rs_group_member_vuhk;