9: /* Internal Industry 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: ) IS
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: ) IS
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: ) IS
18:
19: BEGIN
26: /* Internal Industry Procedure for post processing in case of
27: create resource team members */
28:
29: PROCEDURE create_team_members_post
30: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
31: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
32: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
33: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
27: create resource team members */
28:
29: PROCEDURE create_team_members_post
30: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
31: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
32: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
33: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: ) IS
28:
29: PROCEDURE create_team_members_post
30: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
31: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
32: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
33: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: ) IS
36:
29: PROCEDURE create_team_members_post
30: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
31: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
32: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
33: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
34: X_RETURN_STATUS OUT NOCOPY VARCHAR2
35: ) IS
36:
37: BEGIN
44: /* Internal Industry Procedure for pre processing in case of
45: update resource team members */
46:
47: PROCEDURE update_team_members_pre
48: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
49: X_RETURN_STATUS OUT NOCOPY VARCHAR2
50: ) IS
51:
52: BEGIN
57: /* Internal Industry Procedure for post processing in case of
58: update resource team members */
59:
60: PROCEDURE update_team_members_post
61: (P_TEAM_MEMBER_ID IN JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE,
62: X_RETURN_STATUS OUT NOCOPY VARCHAR2
63: ) IS
64:
65: BEGIN
70: /* Internal Industry Procedure for pre processing in case of
71: delete resource team members */
72:
73: PROCEDURE delete_team_members_pre
74: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
75: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
76: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
77: X_RETURN_STATUS OUT NOCOPY VARCHAR2
78: ) IS
71: delete resource team members */
72:
73: PROCEDURE delete_team_members_pre
74: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
75: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
76: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
77: X_RETURN_STATUS OUT NOCOPY VARCHAR2
78: ) IS
79:
72:
73: PROCEDURE delete_team_members_pre
74: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
75: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
76: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
77: X_RETURN_STATUS OUT NOCOPY VARCHAR2
78: ) IS
79:
80: BEGIN
87: /* Internal Industry Procedure for post processing in case of
88: delete resource team members */
89:
90: PROCEDURE delete_team_members_post
91: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
92: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
93: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2
95: ) IS
88: delete resource team members */
89:
90: PROCEDURE delete_team_members_post
91: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
92: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
93: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2
95: ) IS
96:
89:
90: PROCEDURE delete_team_members_post
91: (P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
92: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
93: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2
95: ) IS
96:
97: BEGIN