DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_TEAM_IUHK dependencies on JTF_RS_TEAMS_VL

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

9: /* Internal Industry Procedure for pre processing in case of
10: create resource team */
11:
12: PROCEDURE create_resource_team_pre
13: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
14: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 14: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

10: create resource team */
11:
12: PROCEDURE create_resource_team_pre
13: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
14: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 15: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

11:
12: PROCEDURE create_resource_team_pre
13: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
14: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 16: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

12: PROCEDURE create_resource_team_pre
13: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
14: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2
20: );

Line 17: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

13: (P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
14: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2
20: );
21:

Line 18: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

14: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
15: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
16: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
17: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
18: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2
20: );
21:
22:

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

23: /* Internal Industry Procedure for post processing in case of
24: create resource team */
25:
26: PROCEDURE create_resource_team_post
27: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
28: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
29: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
30: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
31: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

Line 28: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

24: create resource team */
25:
26: PROCEDURE create_resource_team_post
27: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
28: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
29: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
30: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
31: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 29: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

25:
26: PROCEDURE create_resource_team_post
27: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
28: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
29: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
30: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
31: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 30: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

26: PROCEDURE create_resource_team_post
27: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
28: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
29: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
30: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
31: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 31: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

27: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
28: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
29: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
30: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
31: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: );

Line 32: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

28: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
29: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
30: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
31: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: );
36:

Line 33: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

29: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
30: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
31: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
32: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
33: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: );
36:
37:

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

38: /* Internal Industry Procedure for pre processing in case of
39: update resource team */
40:
41: PROCEDURE update_resource_team_pre
42: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
43: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
44: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
45: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
46: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

Line 43: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

39: update resource team */
40:
41: PROCEDURE update_resource_team_pre
42: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
43: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
44: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
45: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
46: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
47: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 44: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

40:
41: PROCEDURE update_resource_team_pre
42: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
43: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
44: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
45: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
46: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
47: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
48: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 45: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

41: PROCEDURE update_resource_team_pre
42: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
43: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
44: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
45: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
46: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
47: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
48: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
49: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 46: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

42: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
43: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
44: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
45: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
46: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
47: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
48: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
49: X_RETURN_STATUS OUT NOCOPY VARCHAR2
50: );

Line 47: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

43: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
44: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
45: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
46: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
47: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
48: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
49: X_RETURN_STATUS OUT NOCOPY VARCHAR2
50: );
51:

Line 48: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

44: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
45: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
46: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
47: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
48: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
49: X_RETURN_STATUS OUT NOCOPY VARCHAR2
50: );
51:
52:

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

53: /* Internal Industry Procedure for post processing in case of
54: update resource team */
55:
56: PROCEDURE update_resource_team_post
57: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
58: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
59: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
60: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
61: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

Line 58: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

54: update resource team */
55:
56: PROCEDURE update_resource_team_post
57: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
58: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
59: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
60: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
61: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
62: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 59: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

55:
56: PROCEDURE update_resource_team_post
57: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
58: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
59: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
60: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
61: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
62: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
63: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 60: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

56: PROCEDURE update_resource_team_post
57: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
58: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
59: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
60: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
61: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
62: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
63: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 61: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

57: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
58: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
59: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
60: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
61: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
62: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
63: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2
65: );

Line 62: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

58: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
59: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
60: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
61: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
62: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
63: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2
65: );
66:

Line 63: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

59: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
60: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
61: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
62: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
63: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
64: X_RETURN_STATUS OUT NOCOPY VARCHAR2
65: );
66:
67: