1 PACKAGE jtf_rs_resource_team_cuhk AUTHID CURRENT_USER AS
2 /* $Header: jtfrscts.pls 120.0 2005/05/11 08:19:44 appldev ship $ */
3
4 /*****************************************************************************************
5 This is the Customer User Hook API.
6 The Customers can add customization procedures here for Pre and Post Processing.
7 ******************************************************************************************/
8
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,
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,
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,
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,
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
77
78 END jtf_rs_resource_team_cuhk;