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: ) IS

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: ) IS
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: ) IS
21:
22: BEGIN

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

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

Line 34: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

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

Line 35: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

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

Line 36: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

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

Line 37: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

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

Line 38: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

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

Line 39: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

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

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

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

Line 55: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

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

Line 56: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

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

Line 57: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

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

Line 58: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

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

Line 59: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

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

Line 60: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

56: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
57: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
58: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
59: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
60: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
61: X_RETURN_STATUS OUT NOCOPY VARCHAR2
62: ) IS
63:
64: BEGIN

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

71: /* Internal Industry Procedure for post processing in case of
72: update resource team */
73:
74: PROCEDURE update_resource_team_post
75: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
76: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
77: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
78: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
79: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

Line 76: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,

72: update resource team */
73:
74: PROCEDURE update_resource_team_post
75: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
76: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
77: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
78: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
79: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
80: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

Line 77: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,

73:
74: PROCEDURE update_resource_team_post
75: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
76: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
77: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
78: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
79: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
80: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
81: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

Line 78: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,

74: PROCEDURE update_resource_team_post
75: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
76: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
77: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
78: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
79: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
80: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
81: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
82: X_RETURN_STATUS OUT NOCOPY VARCHAR2

Line 79: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,

75: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
76: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
77: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
78: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
79: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
80: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
81: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
82: X_RETURN_STATUS OUT NOCOPY VARCHAR2
83: ) IS

Line 80: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,

76: P_TEAM_NAME IN JTF_RS_TEAMS_VL.TEAM_NAME%TYPE,
77: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
78: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
79: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
80: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
81: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
82: X_RETURN_STATUS OUT NOCOPY VARCHAR2
83: ) IS
84:

Line 81: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,

77: P_TEAM_DESC IN JTF_RS_TEAMS_VL.TEAM_DESC%TYPE,
78: P_EXCLUSIVE_FLAG IN JTF_RS_TEAMS_VL.EXCLUSIVE_FLAG%TYPE,
79: P_EMAIL_ADDRESS IN JTF_RS_TEAMS_VL.EMAIL_ADDRESS%TYPE,
80: P_START_DATE_ACTIVE IN JTF_RS_TEAMS_VL.START_DATE_ACTIVE%TYPE,
81: P_END_DATE_ACTIVE IN JTF_RS_TEAMS_VL.END_DATE_ACTIVE%TYPE,
82: X_RETURN_STATUS OUT NOCOPY VARCHAR2
83: ) IS
84:
85: BEGIN