10: END IF;
11: END restore_context;
12:
13: PROCEDURE create_team_members_post
14: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
15: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
16: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
17: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
11: END restore_context;
12:
13: PROCEDURE create_team_members_post
14: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
15: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
16: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
17: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
19:
12:
13: PROCEDURE create_team_members_post
14: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
15: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
16: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
17: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
19:
20: t_team_name cn_comp_teams.name%type;
13: PROCEDURE create_team_members_post
14: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
15: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
16: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
17: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
18: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
19:
20: t_team_name cn_comp_teams.name%type;
21: t_start_date_active cn_comp_teams.start_date_active%type;
74: restore_context(l_orig_acc_mode, l_orig_org_id);
75: END create_team_members_post;
76:
77: PROCEDURE delete_team_members_pre
78: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
79: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
80: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
82:
75: END create_team_members_post;
76:
77: PROCEDURE delete_team_members_pre
78: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
79: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
80: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
82:
83: l_dummy NUMBER;
76:
77: PROCEDURE delete_team_members_pre
78: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
79: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
80: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
81: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
82:
83: l_dummy NUMBER;
84: t_team_name cn_comp_teams.name%type;
142: restore_context(l_orig_acc_mode, l_orig_org_id);
143: END delete_team_members_pre;
144:
145: PROCEDURE update_team_members_pre
146: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
147: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
148: BEGIN
149: x_return_status := fnd_api.g_ret_sts_success;
150: END update_team_members_pre;
149: x_return_status := fnd_api.g_ret_sts_success;
150: END update_team_members_pre;
151:
152: PROCEDURE update_team_members_post
153: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
154: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
155: BEGIN
156: x_return_status := fnd_api.g_ret_sts_success;
157: END update_team_members_post;
156: x_return_status := fnd_api.g_ret_sts_success;
157: END update_team_members_post;
158:
159: PROCEDURE delete_team_members_post
160: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
161: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
162: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
163: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
164: BEGIN
157: END update_team_members_post;
158:
159: PROCEDURE delete_team_members_post
160: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
161: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
162: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
163: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
164: BEGIN
165: x_return_status := fnd_api.g_ret_sts_success;
158:
159: PROCEDURE delete_team_members_post
160: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
161: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
162: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
163: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
164: BEGIN
165: x_return_status := fnd_api.g_ret_sts_success;
166: END delete_team_members_post;
165: x_return_status := fnd_api.g_ret_sts_success;
166: END delete_team_members_post;
167:
168: PROCEDURE create_team_members_pre
169: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
170: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
171: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
172: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
173: BEGIN
166: END delete_team_members_post;
167:
168: PROCEDURE create_team_members_pre
169: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
170: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
171: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
172: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
173: BEGIN
174: x_return_status := fnd_api.g_ret_sts_success;
167:
168: PROCEDURE create_team_members_pre
169: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
170: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
171: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
172: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
173: BEGIN
174: x_return_status := fnd_api.g_ret_sts_success;
175: END create_team_members_pre;