1 PACKAGE jtf_rs_resource_team_vuhk AUTHID CURRENT_USER AS
2 /* $Header: jtfrsits.pls 120.0 2005/05/11 08:20:21 appldev ship $ */
3
4 /*****************************************************************************************
5 This is the Vertical Industry User Hook API.
6 The Vertical Industry can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
9 /* Vertical 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,
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 /* Vertical Industry 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,
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 /* Vertical Industry 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,
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 /* Vertical Industry 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,
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 END jtf_rs_resource_team_vuhk;