DBA Data[Home] [Help]

APPS.JTF_RS_TEAM_MEMBER_VUHK dependencies on JTF_RS_TEAM_MEMBERS

Line 14: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,

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

Line 15: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,

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:

Line 16: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,

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;

Line 17: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%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;

Line 78: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%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:

Line 79: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,

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;

Line 80: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

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;

Line 146: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%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;

Line 153: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,

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;

Line 160: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,

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

Line 161: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,

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;

Line 162: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

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;

Line 169: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,

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

Line 170: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,

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;

Line 171: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,

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;