1 PACKAGE jtf_rs_resource_group_cuhk AS
2 /* $Header: jtfrscgs.pls 120.0 2005/05/11 08:19:38 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 group */
11
12 PROCEDURE create_resource_group_pre
13 (P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
14 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
15 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
16 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
17 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
18 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
19 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
20 X_RETURN_STATUS OUT NOCOPY VARCHAR2
21 );
22
23
24 /* Customer Procedure for post processing in case of
25 create resource group */
26
27 PROCEDURE create_resource_group_post
28 (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
29 P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
30 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
31 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
32 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
33 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
34 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
35 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
36 X_RETURN_STATUS OUT NOCOPY VARCHAR2
37 );
38
39
40 /* Customer Procedure for pre processing in case of
41 update resource group */
42
43 PROCEDURE update_resource_group_pre
44 (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
45 P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
46 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
47 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
48 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
49 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
50 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
51 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
52 X_RETURN_STATUS OUT NOCOPY VARCHAR2
53 );
54
55
56 /* Customer Procedure for post processing in case of
57 update resource group */
58
59 PROCEDURE update_resource_group_post
60 (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
61 P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
62 P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE,
63 P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE,
64 P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE,
65 P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
66 P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE,
67 P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE,
68 X_RETURN_STATUS OUT NOCOPY VARCHAR2
69 );
70
71
72
73 /* Customer/Vertical Industry Function before Message Generation */
74
75 FUNCTION ok_to_generate_msg
76 (P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
77 X_RETURN_STATUS OUT NOCOPY VARCHAR2
78 ) RETURN BOOLEAN;
79
80
81
82 END jtf_rs_resource_group_cuhk;
[Home] [Help]