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_PVT dependencies on JTF_RS_TEAMS_VL

Line 25: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

21: PROCEDURE create_resource_team
22: (P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2,
24: P_COMMIT IN VARCHAR2,
25: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
26: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
27: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 26: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

22: (P_API_VERSION IN NUMBER,
23: P_INIT_MSG_LIST IN VARCHAR2,
24: P_COMMIT IN VARCHAR2,
25: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
26: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
27: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 27: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

23: P_INIT_MSG_LIST IN VARCHAR2,
24: P_COMMIT IN VARCHAR2,
25: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
26: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
27: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,

Line 28: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

24: P_COMMIT IN VARCHAR2,
25: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
26: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
27: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,

Line 29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

25: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
26: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
27: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,

Line 30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

26: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
27: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,

Line 31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,

27: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
28: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,

Line 32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,

28: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,

Line 33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,

29: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,

Line 34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,

30: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,

Line 35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,

31: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,

Line 36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,

32: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,

Line 37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,

33: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,

Line 38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,

34: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,

Line 39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,

35: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
43: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,

Line 40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,

36: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
43: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
44: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,

Line 41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,

37: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
43: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
44: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
45: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,

Line 42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,

38: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
43: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
44: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
45: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
46: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,

Line 43: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,

39: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
43: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
44: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
45: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
46: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 44: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,

40: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
43: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
44: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
45: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
46: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 45: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,

41: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
43: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
44: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
45: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
46: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48: X_MSG_COUNT OUT NOCOPY NUMBER,
49: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 46: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,

42: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
43: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
44: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
45: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
46: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48: X_MSG_COUNT OUT NOCOPY NUMBER,
49: X_MSG_DATA OUT NOCOPY VARCHAR2,
50: X_TEAM_ID OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_ID%TYPE,

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

46: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48: X_MSG_COUNT OUT NOCOPY NUMBER,
49: X_MSG_DATA OUT NOCOPY VARCHAR2,
50: X_TEAM_ID OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
51: X_TEAM_NUMBER OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE
52: ) IS
53:
54: l_api_version CONSTANT NUMBER := 1.0;

Line 51: X_TEAM_NUMBER OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE

47: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
48: X_MSG_COUNT OUT NOCOPY NUMBER,
49: X_MSG_DATA OUT NOCOPY VARCHAR2,
50: X_TEAM_ID OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
51: X_TEAM_NUMBER OUT NOCOPY JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE
52: ) IS
53:
54: l_api_version CONSTANT NUMBER := 1.0;
55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';

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

53:
54: l_api_version CONSTANT NUMBER := 1.0;
55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';
56: l_rowid ROWID;
57: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
58: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
59: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
60: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
61: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);

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

54: l_api_version CONSTANT NUMBER := 1.0;
55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';
56: l_rowid ROWID;
57: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
58: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
59: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
60: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
61: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
62: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);

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

55: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM';
56: l_rowid ROWID;
57: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
58: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
59: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
60: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
61: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
62: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
63: l_team_id jtf_rs_teams_vl.team_id%TYPE;

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

56: l_rowid ROWID;
57: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
58: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
59: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
60: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
61: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
62: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
63: l_team_id jtf_rs_teams_vl.team_id%TYPE;
64: l_team_number jtf_rs_teams_vl.team_number%TYPE;

Line 61: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);

57: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
58: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
59: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
60: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
61: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
62: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
63: l_team_id jtf_rs_teams_vl.team_id%TYPE;
64: l_team_number jtf_rs_teams_vl.team_number%TYPE;
65: l_return_status VARCHAR2(1);

Line 62: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);

58: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
59: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
60: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
61: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
62: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
63: l_team_id jtf_rs_teams_vl.team_id%TYPE;
64: l_team_number jtf_rs_teams_vl.team_number%TYPE;
65: l_return_status VARCHAR2(1);
66: l_msg_data VARCHAR2(2000);

Line 63: l_team_id jtf_rs_teams_vl.team_id%TYPE;

59: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
60: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
61: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
62: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
63: l_team_id jtf_rs_teams_vl.team_id%TYPE;
64: l_team_number jtf_rs_teams_vl.team_number%TYPE;
65: l_return_status VARCHAR2(1);
66: l_msg_data VARCHAR2(2000);
67: l_msg_count NUMBER;

Line 64: l_team_number jtf_rs_teams_vl.team_number%TYPE;

60: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
61: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
62: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
63: l_team_id jtf_rs_teams_vl.team_id%TYPE;
64: l_team_number jtf_rs_teams_vl.team_number%TYPE;
65: l_return_status VARCHAR2(1);
66: l_msg_data VARCHAR2(2000);
67: l_msg_count NUMBER;
68: l_check_char VARCHAR2(1);

Line 591: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,

587: PROCEDURE update_resource_team
588: (P_API_VERSION IN NUMBER,
589: P_INIT_MSG_LIST IN VARCHAR2,
590: P_COMMIT IN VARCHAR2,
591: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
592: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
593: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
594: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

Line 592: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

588: (P_API_VERSION IN NUMBER,
589: P_INIT_MSG_LIST IN VARCHAR2,
590: P_COMMIT IN VARCHAR2,
591: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
592: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
593: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
594: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 593: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

589: P_INIT_MSG_LIST IN VARCHAR2,
590: P_COMMIT IN VARCHAR2,
591: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
592: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
593: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
594: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 594: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

590: P_COMMIT IN VARCHAR2,
591: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
592: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
593: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
594: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,

Line 595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

591: P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
592: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
593: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
594: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,

Line 596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

592: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
593: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
594: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,

Line 597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

593: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
594: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,

Line 598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,

594: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,

Line 599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,

595: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,

Line 600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,

596: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,

Line 601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,

597: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,

Line 602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,

598: P_ATTRIBUTE1 IN JTF_RS_TEAMS_VL.ATTRIBUTE1%TYPE,
599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,

Line 603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,

599: P_ATTRIBUTE2 IN JTF_RS_TEAMS_VL.ATTRIBUTE2%TYPE,
600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,

Line 604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,

600: P_ATTRIBUTE3 IN JTF_RS_TEAMS_VL.ATTRIBUTE3%TYPE,
601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,

Line 605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,

601: P_ATTRIBUTE4 IN JTF_RS_TEAMS_VL.ATTRIBUTE4%TYPE,
602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,

Line 606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,

602: P_ATTRIBUTE5 IN JTF_RS_TEAMS_VL.ATTRIBUTE5%TYPE,
603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,

Line 607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,

603: P_ATTRIBUTE6 IN JTF_RS_TEAMS_VL.ATTRIBUTE6%TYPE,
604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
611: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,

Line 608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,

604: P_ATTRIBUTE7 IN JTF_RS_TEAMS_VL.ATTRIBUTE7%TYPE,
605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
611: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
612: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,

Line 609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,

605: P_ATTRIBUTE8 IN JTF_RS_TEAMS_VL.ATTRIBUTE8%TYPE,
606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
611: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
612: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
613: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,

Line 610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,

606: P_ATTRIBUTE9 IN JTF_RS_TEAMS_VL.ATTRIBUTE9%TYPE,
607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
611: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
612: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
613: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
614: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,

Line 611: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,

607: P_ATTRIBUTE10 IN JTF_RS_TEAMS_VL.ATTRIBUTE10%TYPE,
608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
611: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
612: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
613: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
614: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,
615: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 612: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,

608: P_ATTRIBUTE11 IN JTF_RS_TEAMS_VL.ATTRIBUTE11%TYPE,
609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
611: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
612: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
613: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
614: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,
615: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
616: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 613: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,

609: P_ATTRIBUTE12 IN JTF_RS_TEAMS_VL.ATTRIBUTE12%TYPE,
610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
611: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
612: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
613: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
614: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,
615: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
616: X_MSG_COUNT OUT NOCOPY NUMBER,
617: X_MSG_DATA OUT NOCOPY VARCHAR2

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

610: P_ATTRIBUTE13 IN JTF_RS_TEAMS_VL.ATTRIBUTE13%TYPE,
611: P_ATTRIBUTE14 IN JTF_RS_TEAMS_VL.ATTRIBUTE14%TYPE,
612: P_ATTRIBUTE15 IN JTF_RS_TEAMS_VL.ATTRIBUTE15%TYPE,
613: P_ATTRIBUTE_CATEGORY IN JTF_RS_TEAMS_VL.ATTRIBUTE_CATEGORY%TYPE,
614: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TEAMS_VL.OBJECT_VERSION_NUMBER%TYPE,
615: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
616: X_MSG_COUNT OUT NOCOPY NUMBER,
617: X_MSG_DATA OUT NOCOPY VARCHAR2
618: ) IS

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

618: ) IS
619:
620: l_api_version CONSTANT NUMBER := 1.0;
621: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM';
622: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
623: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
624: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
625: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
626: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;

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

619:
620: l_api_version CONSTANT NUMBER := 1.0;
621: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM';
622: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
623: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
624: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
625: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
626: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
627: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);

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

620: l_api_version CONSTANT NUMBER := 1.0;
621: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM';
622: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
623: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
624: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
625: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
626: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
627: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
628: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);

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

621: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE_TEAM';
622: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
623: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
624: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
625: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
626: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
627: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
628: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
629: l_object_version_num jtf_rs_teams_vl.object_version_number%type := p_object_version_num;

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

622: l_team_id jtf_rs_teams_vl.team_id%TYPE := p_team_id;
623: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
624: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
625: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
626: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
627: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
628: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
629: l_object_version_num jtf_rs_teams_vl.object_version_number%type := p_object_version_num;
630:

Line 627: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);

623: l_team_name jtf_rs_teams_vl.team_name%TYPE := p_team_name;
624: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
625: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
626: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
627: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
628: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
629: l_object_version_num jtf_rs_teams_vl.object_version_number%type := p_object_version_num;
630:
631: l_max_end_date DATE;

Line 628: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);

624: l_team_desc jtf_rs_teams_vl.team_desc%TYPE := p_team_desc;
625: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
626: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
627: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
628: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
629: l_object_version_num jtf_rs_teams_vl.object_version_number%type := p_object_version_num;
630:
631: l_max_end_date DATE;
632: l_min_start_date DATE;

Line 629: l_object_version_num jtf_rs_teams_vl.object_version_number%type := p_object_version_num;

625: l_exclusive_flag jtf_rs_teams_vl.exclusive_flag%TYPE := p_exclusive_flag;
626: l_email_address jtf_rs_teams_vl.email_address%TYPE := p_email_address;
627: l_start_date_active jtf_rs_teams_vl.start_date_active%TYPE := trunc(p_start_date_active);
628: l_end_date_active jtf_rs_teams_vl.end_date_active%TYPE := trunc(p_end_date_active);
629: l_object_version_num jtf_rs_teams_vl.object_version_number%type := p_object_version_num;
630:
631: l_max_end_date DATE;
632: l_min_start_date DATE;
633: l_check_char VARCHAR2(1);

Line 666: FROM jtf_rs_teams_vl

662: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
663: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
664: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
665: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
666: FROM jtf_rs_teams_vl
667: WHERE team_id = l_team_id;
668:
669: team_rec c_team_update%ROWTYPE;
670:

Line 728: FROM jtf_rs_teams_vl T1,

724: CURSOR c_exclusive_team_check(
725: l_team_id IN NUMBER )
726: IS
727: SELECT 'Y'
728: FROM jtf_rs_teams_vl T1,
729: jtf_rs_teams_vl T2,
730: jtf_rs_team_members TM1,
731: jtf_rs_team_members TM2,
732: jtf_rs_team_usages TU1,

Line 729: jtf_rs_teams_vl T2,

725: l_team_id IN NUMBER )
726: IS
727: SELECT 'Y'
728: FROM jtf_rs_teams_vl T1,
729: jtf_rs_teams_vl T2,
730: jtf_rs_team_members TM1,
731: jtf_rs_team_members TM2,
732: jtf_rs_team_usages TU1,
733: jtf_rs_team_usages TU2,