eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_TEAMS_PUB dependencies on JTF_RS_TEAMS_VL

Line 27: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

23: PROCEDURE create_resource_team
24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
28: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT NULL,
29: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
30: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 28: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT NULL,

24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
28: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT NULL,
29: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
30: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 29: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',

25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
28: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT NULL,
29: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
30: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 30: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,

26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
28: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT NULL,
29: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
30: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 31: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

27: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
28: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT NULL,
29: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
30: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 32: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

28: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT NULL,
29: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
30: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
31: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
32: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_TEAM_ID OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_ID%TYPE,

Line 36: X_TEAM_ID OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_ID%TYPE,

32: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_TEAM_ID OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
37: X_TEAM_NUMBER OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE
38: ) IS
39:
40: l_api_version CONSTANT NUMBER := 1.0;

Line 37: X_TEAM_NUMBER OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE

33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2,
36: X_TEAM_ID OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
37: X_TEAM_NUMBER OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE
38: ) IS
39:
40: l_api_version CONSTANT NUMBER := 1.0;
41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';

Line 42: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;

38: ) IS
39:
40: l_api_version CONSTANT NUMBER := 1.0;
41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';
42: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
43: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
44: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;

Line 43: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;

39:
40: l_api_version CONSTANT NUMBER := 1.0;
41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';
42: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
43: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
44: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;

Line 44: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');

40: l_api_version CONSTANT NUMBER := 1.0;
41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';
42: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
43: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
44: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
48: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;

Line 45: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;

41: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';
42: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
43: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
44: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
48: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
49: current_record INTEGER;

Line 46: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;

42: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
43: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
44: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
48: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
49: current_record INTEGER;
50:

Line 47: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;

43: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
44: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := nvl(p_exclusive_flag, 'N');
45: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
46: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
47: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
48: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;
49: current_record INTEGER;
50:
51:

Line 188: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,

184: PROCEDURE update_resource_team
185: (P_API_VERSION IN NUMBER,
186: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
187: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
188: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
189: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
190: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 189: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,

185: (P_API_VERSION IN NUMBER,
186: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
187: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
188: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
189: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
190: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 190: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

186: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
187: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
188: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
189: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
190: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 191: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,

187: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
188: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
189: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
190: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
195: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

188: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
189: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
190: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
195: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
196: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,

Line 193: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

189: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
190: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
195: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
196: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,
197: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 194: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

190: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
195: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
196: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,
197: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
198: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 195: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

191: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
195: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
196: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,
197: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
198: X_MSG_COUNT OUT NOCOPY NUMBER,
199: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 196: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,

192: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
195: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
196: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,
197: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
198: X_MSG_COUNT OUT NOCOPY NUMBER,
199: X_MSG_DATA OUT NOCOPY VARCHAR2
200: ) IS

Line 204: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;

200: ) IS
201:
202: l_api_version CONSTANT NUMBER := 1.0;
203: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM';
204: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
205: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
206: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
207: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;

Line 205: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;

201:
202: l_api_version CONSTANT NUMBER := 1.0;
203: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM';
204: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
205: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
206: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
207: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
209: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;

Line 206: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;

202: l_api_version CONSTANT NUMBER := 1.0;
203: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM';
204: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
205: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
206: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
207: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
209: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
210: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;

Line 207: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;

203: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM';
204: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
205: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
206: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
207: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
209: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
210: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
211: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;

Line 208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;

204: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
205: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
206: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
207: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
209: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
210: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
211: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
212: l_object_version_num jtf_rs_teams_vl.object_version_number%TYPE := p_object_version_num;

Line 209: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;

205: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
206: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
207: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
209: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
210: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
211: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
212: l_object_version_num jtf_rs_teams_vl.object_version_number%TYPE := p_object_version_num;
213: -- added for NOCOPY

Line 210: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;

206: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
207: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
209: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
210: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
211: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
212: l_object_version_num jtf_rs_teams_vl.object_version_number%TYPE := p_object_version_num;
213: -- added for NOCOPY
214: l_team_id_out jtf_rs_teams_vl.team_id%TYPE;

Line 211: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;

207: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
209: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
210: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
211: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
212: l_object_version_num jtf_rs_teams_vl.object_version_number%TYPE := p_object_version_num;
213: -- added for NOCOPY
214: l_team_id_out jtf_rs_teams_vl.team_id%TYPE;
215:

Line 212: l_object_version_num jtf_rs_teams_vl.object_version_number%TYPE := p_object_version_num;

208: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
209: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
210: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
211: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
212: l_object_version_num jtf_rs_teams_vl.object_version_number%TYPE := p_object_version_num;
213: -- added for NOCOPY
214: l_team_id_out jtf_rs_teams_vl.team_id%TYPE;
215:
216: BEGIN

Line 214: l_team_id_out jtf_rs_teams_vl.team_id%TYPE;

210: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := p_start_date_active;
211: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := p_end_date_active;
212: l_object_version_num jtf_rs_teams_vl.object_version_number%TYPE := p_object_version_num;
213: -- added for NOCOPY
214: l_team_id_out jtf_rs_teams_vl.team_id%TYPE;
215:
216: BEGIN
217:
218: