9: /* Customer 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: );
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:
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:
23: /* Customer 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,
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,
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,
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
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: );
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:
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:
38: /* Customer 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,
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,
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,
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
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: );
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:
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:
53: /* Customer 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,
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,
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,
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
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: );
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:
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:
68:
69: /* Customer/Vertical Industry Function before Message Generation */
70:
71: FUNCTION ok_to_generate_msg
72: (P_TEAM_ID IN JTF_RS_TEAMS_VL.TEAM_ID%TYPE,
73: X_RETURN_STATUS OUT NOCOPY VARCHAR2
74: ) RETURN BOOLEAN;
75:
76: