1 PACKAGE jtf_rs_resource_values_cuhk AUTHID CURRENT_USER AS
2 /* $Header: jtfrsccs.pls 120.0 2005/05/11 08:19:36 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 create resource values */
10
11 PROCEDURE create_rs_resource_values_pre (
12 p_resource_id IN NUMBER,
13 p_resource_param_id IN NUMBER,
14 p_value IN VARCHAR2,
15 p_value_type IN VARCHAR2,
16 X_Return_Status OUT NOCOPY VARCHAR2,
17 X_Msg_Count OUT NOCOPY NUMBER,
18 X_Msg_Data OUT NOCOPY VARCHAR2
19 );
20
21 /* Customer Procedure for post processing in case of create resource values */
22
23 PROCEDURE create_rs_resource_values_post (
24 p_resource_id IN NUMBER,
25 p_resource_param_id IN NUMBER,
26 p_value IN VARCHAR2,
27 p_value_type IN VARCHAR2,
28 X_Return_Status OUT NOCOPY VARCHAR2,
29 X_Msg_Count OUT NOCOPY NUMBER,
30 X_Msg_Data OUT NOCOPY VARCHAR2,
31 P_resource_param_value_id IN NUMBER
32 );
33
34 /* Customer Procedure for pre processing in case of update resource values */
35
36 PROCEDURE update_rs_resource_values_pre (
37 p_resource_param_value_id IN NUMBER,
38 p_value IN VARCHAR2,
39 X_Return_Status OUT NOCOPY VARCHAR2,
40 X_Msg_Count OUT NOCOPY NUMBER,
41 X_Msg_Data OUT NOCOPY VARCHAR2
42 );
43
44 /* Customer Procedure for post processing in case of update resource values */
45
46 PROCEDURE update_rs_resource_values_post (
47 p_resource_param_value_id IN NUMBER,
48 p_value IN VARCHAR2,
49 X_Return_Status OUT NOCOPY VARCHAR2,
50 X_Msg_Count OUT NOCOPY NUMBER,
51 X_Msg_Data OUT NOCOPY VARCHAR2
52 );
53
54 /* Customer Procedure for pre processing in case of delete resource values */
55
56 PROCEDURE delete_rs_resource_values_pre (
57 p_resource_param_value_id IN NUMBER,
58 X_Return_Status OUT NOCOPY VARCHAR2,
59 X_Msg_Count OUT NOCOPY NUMBER,
60 X_Msg_Data OUT NOCOPY VARCHAR2
61 );
62
63 /* Customer Procedure for post processing in case of delete resource values */
64
65 PROCEDURE delete_rs_resource_values_post (
66 p_resource_param_value_id IN NUMBER,
67 X_Return_Status OUT NOCOPY VARCHAR2,
68 X_Msg_Count OUT NOCOPY NUMBER,
69 X_Msg_Data OUT NOCOPY VARCHAR2
70 );
71
72 /* Customer Procedure for pre processing in case of delete all resource values */
73
74 PROCEDURE delete_all_rs_values_pre (
75 p_resource_id IN NUMBER,
76 X_Return_Status OUT NOCOPY VARCHAR2,
77 X_Msg_Count OUT NOCOPY NUMBER,
78 X_Msg_Data OUT NOCOPY VARCHAR2
79 );
80
81 /* Customer Procedure for post processing in case of delete all resource values */
82
83 PROCEDURE delete_all_rs_values_post (
84 p_resource_id IN NUMBER,
85 X_Return_Status OUT NOCOPY VARCHAR2,
86 X_Msg_Count OUT NOCOPY NUMBER,
87 X_Msg_Data OUT NOCOPY VARCHAR2
88 );
89
90 /* Customer/Vertical Industry Function before Message Generation */
91
92 FUNCTION ok_to_generate_msg (
93 P_RESOURCE_PARAM_VALUE_ID IN JTF_RS_RESOURCE_VALUES.RESOURCE_PARAM_VALUE_ID%TYPE,
94 X_RETURN_STATUS OUT NOCOPY VARCHAR2
95 )RETURN BOOLEAN;
96
97 END jtf_rs_resource_values_cuhk;
[Home] [Help]