1 PACKAGE CSL_CS_COUNTER_VALS_ACC_PKG AUTHID CURRENT_USER AS
2 /* $Header: cslcvacs.pls 115.5 2002/11/08 14:02:56 asiegers ship $ */
3
4 FUNCTION Replicate_Record
5 ( p_counter_value_id IN NUMBER
6 )
7 RETURN BOOLEAN;
8 /***
9 Function that checks if counter value record should be replicated.
10 Returns TRUE if it should
11 ***/
12
13 FUNCTION Post_Insert_Parent
14 ( p_counter_id IN NUMBER
15 ,p_resource_id IN NUMBER
16 )
17 RETURN BOOLEAN;
18 /***
19 Public function that gets called when an assignment needs to be inserted into ACC table.
20 Returns TRUE when record already was or has been inserted into ACC table.
21 ***/
22
23 FUNCTION Pre_Delete_Parent
24 ( p_counter_id IN NUMBER
25 ,p_resource_id IN NUMBER
26 ) RETURN BOOLEAN;
27 /***
28 DO NOTHING. Counter value will never be deleted.
29 ***/
30
31 PROCEDURE PRE_INSERT_COUNTER_VALUE ( x_return_status OUT NOCOPY varchar2);
32 /* Called before counter value Insert */
33
34 PROCEDURE POST_INSERT_COUNTER_VALUE ( P_Api_Version_Number IN NUMBER
35 , P_Init_Msg_List IN VARCHAR2
36 , P_Commit IN VARCHAR2
37 , p_validation_level IN NUMBER
38 , p_COUNTER_GRP_LOG_ID IN NUMBER
39 , X_Return_Status OUT NOCOPY VARCHAR2
40 , X_Msg_Count OUT NOCOPY NUMBER
41 , X_Msg_Data OUT NOCOPY VARCHAR2 );
42 /* Called after counter value Insert */
43
44 PROCEDURE PRE_UPDATE_COUNTER_VALUE ( x_return_status OUT NOCOPY varchar2);
45 /* Called before counter value Update */
46
47 PROCEDURE POST_UPDATE_COUNTER_VALUE ( P_Api_Version_Number IN NUMBER
48 , P_Init_Msg_List IN VARCHAR2
49 , P_Commit IN VARCHAR2
50 , p_validation_level IN NUMBER
51 , p_COUNTER_GRP_LOG_ID IN NUMBER
52 , p_object_version_number IN NUMBER
53 , X_Return_Status OUT NOCOPY VARCHAR2
54 , X_Msg_Count OUT NOCOPY NUMBER
55 , X_Msg_Data OUT NOCOPY VARCHAR2 );
56 /* Called after counter value Update */
57
58 PROCEDURE PRE_DELETE_COUNTER_VALUE ( x_return_status OUT NOCOPY varchar2);
59 /* Called before counter value Update */
60
61 PROCEDURE POST_DELETE_COUNTER_VALUE (
62 p_counter_value_id in NUMBER
63 , x_return_status OUT NOCOPY varchar2);
64 /* Called after counter value Update */
65
66
67
68 PROCEDURE PRE_INSERT_COUNTER_PROP_VAL ( x_return_status OUT NOCOPY varchar2);
69 /* Called before counter property value Insert */
70
71 PROCEDURE POST_INSERT_COUNTER_PROP_VAL ( P_Api_Version_Number IN NUMBER
72 , P_Init_Msg_List IN VARCHAR2
73 , P_Commit IN VARCHAR2
74 , p_validation_level IN NUMBER
75 , p_COUNTER_GRP_LOG_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 /* Called after counter property value Insert */
81
82 PROCEDURE PRE_UPDATE_COUNTER_PROP_VAL ( x_return_status OUT NOCOPY varchar2);
83 /* Called before counter property value Update */
84
85 PROCEDURE POST_UPDATE_COUNTER_PROP_VAL ( P_Api_Version_Number IN NUMBER
86 , P_Init_Msg_List IN VARCHAR2
87 , P_Commit IN VARCHAR2
88 , p_validation_level IN NUMBER
89 , p_COUNTER_GRP_LOG_ID IN NUMBER
90 , p_object_version_number IN NUMBER
91 , X_Return_Status OUT NOCOPY VARCHAR2
92 , X_Msg_Count OUT NOCOPY NUMBER
93 , X_Msg_Data OUT NOCOPY VARCHAR2 );
94 /* Called after counter property value Update */
95
96 PROCEDURE PRE_DELETE_COUNTER_PROP_VAL ( x_return_status OUT NOCOPY varchar2);
97 /* Called before counter property value Update */
98
99 PROCEDURE POST_DELETE_COUNTER_PROP_VAL (
100 p_counter_prop_val_id in NUMBER
101 , x_return_status OUT NOCOPY varchar2);
102 /* Called after counter property value Update */
103
104 END CSL_CS_COUNTER_VALS_ACC_PKG;