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

Line 18: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

14: /* Vertical Industry Procedure for pre processing in case of
15: create resource team */
16:
17: PROCEDURE create_resource_team_pre
18: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
19: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
20: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
21: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
22: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 19: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

15: create resource team */
16:
17: PROCEDURE create_resource_team_pre
18: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
19: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
20: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
21: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
22: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 20: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

16:
17: PROCEDURE create_resource_team_pre
18: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
19: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
20: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
21: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
22: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 21: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

17: PROCEDURE create_resource_team_pre
18: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
19: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
20: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
21: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
22: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2
25: )IS

Line 22: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

18: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
19: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
20: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
21: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
22: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2
25: )IS
26: BEGIN

Line 23: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

19: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
20: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
21: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
22: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
23: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
24: X_RETURN_STATUS OUT NOCOPY VARCHAR2
25: )IS
26: BEGIN
27: x_return_status := fnd_api.g_ret_sts_success;

Line 34: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,

30: /* Vertical Industry Procedure for post processing in case of
31: create resource team */
32:
33: PROCEDURE create_resource_team_post
34: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
35: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
36: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

Line 35: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

31: create resource team */
32:
33: PROCEDURE create_resource_team_post
34: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
35: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
36: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 36: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

32:
33: PROCEDURE create_resource_team_post
34: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
35: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
36: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 37: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

33: PROCEDURE create_resource_team_post
34: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
35: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
36: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 38: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

34: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
35: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
36: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2
42: )IS

Line 39: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

35: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
36: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2
42: )IS
43: BEGIN

Line 40: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

36: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
37: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
38: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
39: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
40: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
41: X_RETURN_STATUS OUT NOCOPY VARCHAR2
42: )IS
43: BEGIN
44: x_return_status := fnd_api.g_ret_sts_success;

Line 52: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,

48: /* Vertical Industry Procedure for pre processing in case of
49: update resource team */
50:
51: PROCEDURE update_resource_team_pre
52: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
53: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
54: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
55: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
56: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

Line 53: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

49: update resource team */
50:
51: PROCEDURE update_resource_team_pre
52: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
53: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
54: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
55: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
56: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 54: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

50:
51: PROCEDURE update_resource_team_pre
52: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
53: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
54: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
55: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
56: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 55: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

51: PROCEDURE update_resource_team_pre
52: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
53: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
54: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
55: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
56: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 56: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

52: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
53: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
54: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
55: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
56: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2
60: )IS

Line 57: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

53: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
54: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
55: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
56: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2
60: )IS
61: l_old_start_date_active DATE ;

Line 58: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

54: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
55: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
56: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2
60: )IS
61: l_old_start_date_active DATE ;
62: l_old_end_date_active DATE;

Line 91: from jtf_rs_teams_vl

87: mo_global.set_policy_context('S', o.org_id);
88:
89: select start_date_active, end_date_active
90: into l_old_start_date_active, l_old_end_date_active
91: from jtf_rs_teams_vl
92: where team_id = P_TEAM_ID;
93:
94: cn_api.get_date_range_diff_action
95: ( start_date_new => P_START_DATE_ACTIVE

Line 130: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,

126: /* Vertical Industry Procedure for post processing in case of
127: update resource team */
128:
129: PROCEDURE update_resource_team_post
130: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
131: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
132: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
133: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
134: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

Line 131: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

127: update resource team */
128:
129: PROCEDURE update_resource_team_post
130: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
131: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
132: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
133: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
134: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
135: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 132: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

128:
129: PROCEDURE update_resource_team_post
130: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
131: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
132: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
133: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
134: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
135: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
136: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 133: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

129: PROCEDURE update_resource_team_post
130: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
131: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
132: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
133: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
134: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
135: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
136: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
137: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 134: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

130: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
131: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
132: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
133: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
134: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
135: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
136: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
137: X_RETURN_STATUS OUT NOCOPY VARCHAR2
138: )IS

Line 135: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

131: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
132: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
133: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
134: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
135: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
136: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
137: X_RETURN_STATUS OUT NOCOPY VARCHAR2
138: )IS
139: BEGIN

Line 136: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

132: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
133: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
134: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
135: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
136: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
137: X_RETURN_STATUS OUT NOCOPY VARCHAR2
138: )IS
139: BEGIN
140: x_return_status := fnd_api.g_ret_sts_success;