14: /* Vertcal Industry Procedure for pre processing in case of
15: create resource group members */
16:
17: PROCEDURE create_group_members_pre
18: (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
19: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
20: X_RETURN_STATUS OUT NOCOPY VARCHAR2
21: ) IS
22: BEGIN
15: create resource group members */
16:
17: PROCEDURE create_group_members_pre
18: (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
19: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
20: X_RETURN_STATUS OUT NOCOPY VARCHAR2
21: ) IS
22: BEGIN
23: x_return_status := fnd_api.g_ret_sts_success;
27: /* Vertcal Industry Procedure for post processing in case of
28: create resource group members */
29:
30: PROCEDURE create_group_members_post
31: (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
32: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
33: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: ) IS
28: create resource group members */
29:
30: PROCEDURE create_group_members_post
31: (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
32: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
33: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: ) IS
36: l_enable_flag varchar2(20);
29:
30: PROCEDURE create_group_members_post
31: (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
32: P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
33: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: ) IS
36: l_enable_flag varchar2(20);
37: l_cursorid INTEGER;
80: /* Vertcal Industry Procedure for pre processing in case of
81: update resource group members */
82:
83: PROCEDURE update_group_members_pre
84: (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
85: X_RETURN_STATUS OUT NOCOPY VARCHAR2
86: ) IS
87: BEGIN
88: x_return_status := fnd_api.g_ret_sts_success;
92: /* Vertcal Industry Procedure for post processing in case of
93: update resource group members */
94:
95: PROCEDURE update_group_members_post
96: (P_GROUP_MEMBER_ID IN JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
97: X_RETURN_STATUS OUT NOCOPY VARCHAR2
98: ) IS
99: BEGIN
100: x_return_status := fnd_api.g_ret_sts_success;
104: /* Vertcal Industry Procedure for pre processing in case of
105: delete resource group members */
106:
107: PROCEDURE delete_group_members_pre
108: (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
109: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
110: X_RETURN_STATUS OUT NOCOPY VARCHAR2
111: ) IS
112: l_enable_flag varchar2(20);
105: delete resource group members */
106:
107: PROCEDURE delete_group_members_pre
108: (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
109: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
110: X_RETURN_STATUS OUT NOCOPY VARCHAR2
111: ) IS
112: l_enable_flag varchar2(20);
113: l_cursorid INTEGER;
158: /* Vertical Industry Procedure for post processing in case of
159: delete resource group members */
160:
161: PROCEDURE delete_group_members_post
162: (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
163: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
164: X_RETURN_STATUS OUT NOCOPY VARCHAR2
165: ) IS
166: BEGIN
159: delete resource group members */
160:
161: PROCEDURE delete_group_members_post
162: (P_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
163: P_RESOURCE_ID IN JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
164: X_RETURN_STATUS OUT NOCOPY VARCHAR2
165: ) IS
166: BEGIN
167: x_return_status := fnd_api.g_ret_sts_success;