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,
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,
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
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
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:
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
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,
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,
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,
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
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
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:
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
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,
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,
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,
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
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
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:
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
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,
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,
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,
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
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
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:
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