9: /* Customer Procedure for pre processing in case of
10: create resource team members */
11:
12: PROCEDURE create_team_members_pre
13: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
14: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
15: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
16: X_RETURN_STATUS OUT NOCOPY VARCHAR2
17: );
10: create resource team members */
11:
12: PROCEDURE create_team_members_pre
13: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
14: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
15: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
16: X_RETURN_STATUS OUT NOCOPY VARCHAR2
17: );
18:
11:
12: PROCEDURE create_team_members_pre
13: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
14: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
15: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
16: X_RETURN_STATUS OUT NOCOPY VARCHAR2
17: );
18:
19:
20: /* Customer Procedure for post processing in case of
21: create resource team members */
22:
23: PROCEDURE create_team_members_post
24: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
25: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
26: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
27: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2
21: create resource team members */
22:
23: PROCEDURE create_team_members_post
24: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
25: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
26: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
27: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2
29: );
22:
23: PROCEDURE create_team_members_post
24: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
25: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
26: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
27: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2
29: );
30:
23: PROCEDURE create_team_members_post
24: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
25: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
26: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
27: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2
29: );
30:
31:
32: /* Customer Procedure for pre processing in case of
33: update resource team members */
34:
35: PROCEDURE update_team_members_pre
36: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
37: X_RETURN_STATUS OUT NOCOPY VARCHAR2
38: );
39:
40:
41: /* Customer Procedure for post processing in case of
42: update resource team members */
43:
44: PROCEDURE update_team_members_post
45: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2
47: );
48:
49: /* Customer Procedure for pre processing in case of
49: /* Customer Procedure for pre processing in case of
50: delete resource team members */
51:
52: PROCEDURE delete_team_members_pre
53: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
54: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
55: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
56: X_RETURN_STATUS OUT NOCOPY VARCHAR2
57: );
50: delete resource team members */
51:
52: PROCEDURE delete_team_members_pre
53: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
54: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
55: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
56: X_RETURN_STATUS OUT NOCOPY VARCHAR2
57: );
58:
51:
52: PROCEDURE delete_team_members_pre
53: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
54: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
55: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
56: X_RETURN_STATUS OUT NOCOPY VARCHAR2
57: );
58:
59:
60: /* Customer Procedure for post processing in case of
61: delete resource team members */
62:
63: PROCEDURE delete_team_members_post
64: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
65: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
66: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
67: X_RETURN_STATUS OUT NOCOPY VARCHAR2
68: );
61: delete resource team members */
62:
63: PROCEDURE delete_team_members_post
64: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
65: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
66: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
67: X_RETURN_STATUS OUT NOCOPY VARCHAR2
68: );
69:
62:
63: PROCEDURE delete_team_members_post
64: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
65: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
66: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
67: X_RETURN_STATUS OUT NOCOPY VARCHAR2
68: );
69:
70:
71:
72: /* Customer/Vertical Industry Function before Message Generation */
73:
74: FUNCTION ok_to_generate_msg
75: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
76: X_RETURN_STATUS OUT NOCOPY VARCHAR2
77: ) RETURN BOOLEAN;
78:
79: