1 PACKAGE CSL_CS_COUNTERS_ACC_PKG AUTHID CURRENT_USER AS
2 /* $Header: cslctacs.pls 115.6 2002/11/08 14:03:00 asiegers ship $ */
3
4 /***
5 Function that checks if a counter group record should be replicated. Returns TRUE if it should
6 ***/
7 FUNCTION Replicate_Record
8 ( p_counter_group_id NUMBER
9 )
10 RETURN BOOLEAN;
11
12 /***
13 Public function that gets called when a customer product needs to be inserted into ACC table.
14 Returns TRUE when record already was or has been inserted into ACC table.
15 ***/
16 FUNCTION Post_Insert_Parent
17 ( p_item_instance_id IN NUMBER
18 ,p_resource_id IN NUMBER
19 )
20 RETURN BOOLEAN;
21
22 /***
23 Public procedure that gets called after a customer product needs to be deleted from ACC table.
24 ***/
25 FUNCTION Pre_Delete_Parent
26 ( p_item_instance_id IN NUMBER
27 ,p_resource_id IN NUMBER
28 ) RETURN BOOLEAN;
29
30 /* Called before counter group Insert */
31 PROCEDURE PRE_INSERT_COUNTER_GROUP ( x_return_status out NOCOPY varchar2);
32
33 /* Called after counter group Insert */
34 PROCEDURE POST_INSERT_COUNTER_GROUP ( p_api_version IN NUMBER
35 , P_Init_Msg_List IN VARCHAR2
36 , P_Commit IN VARCHAR2
37 , X_Return_Status OUT NOCOPY VARCHAR2
38 , X_Msg_Count OUT NOCOPY NUMBER
39 , X_Msg_Data OUT NOCOPY VARCHAR2
40 , p_source_object_cd IN VARCHAR2
41 , p_source_object_id IN NUMBER
42 , x_ctr_grp_id IN NUMBER
43 , x_object_version_number OUT NOCOPY NUMBER);
44
45
46 /* Called before counter group Update */
47 PROCEDURE PRE_UPDATE_COUNTER_GROUP ( x_return_status out NOCOPY varchar2);
48
49 /* Called after counter group Update */
50 PROCEDURE POST_UPDATE_COUNTER_GROUP( P_Api_Version IN NUMBER
51 , P_Init_Msg_List IN VARCHAR2
52 , P_Commit IN VARCHAR2
53 , X_Return_Status OUT NOCOPY VARCHAR2
54 , X_Msg_Count OUT NOCOPY NUMBER
55 , X_Msg_Data OUT NOCOPY VARCHAR2
56 , p_ctr_grp_id IN NUMBER
57 , p_object_version_number IN NUMBER
58 , p_cascade_upd_to_instances IN VARCHAR2
59 , x_object_version_number OUT NOCOPY NUMBER );
60
61
62 /* Called before counter group Delete */
63 PROCEDURE PRE_DELETE_COUNTER_GROUP ( x_return_status out NOCOPY varchar2);
64
65 /* Called after counter group Delete */
66 PROCEDURE POST_DELETE_COUNTER_GROUP (p_counter_group_id IN NUMBER
67 , x_return_status out NOCOPY varchar2);
68
69
70 /* Called before counter Insert */
71 PROCEDURE PRE_INSERT_COUNTER ( x_return_status out NOCOPY varchar2);
72
73 /* Called after counter Insert */
74 PROCEDURE POST_INSERT_COUNTER ( p_api_version IN NUMBER
75 , P_Init_Msg_List IN VARCHAR2
76 , P_Commit IN VARCHAR2
77 , X_Return_Status OUT NOCOPY VARCHAR2
78 , X_Msg_Count OUT NOCOPY NUMBER
79 , X_Msg_Data OUT NOCOPY VARCHAR2
80 , x_ctr_id IN NUMBER
81 , x_object_version_number OUT NOCOPY NUMBER);
82
83
84 /* Called before counter Update */
85 PROCEDURE PRE_UPDATE_COUNTER ( x_return_status out NOCOPY varchar2);
86
87 /* Called after counter Update */
88 PROCEDURE POST_UPDATE_COUNTER ( P_Api_Version IN NUMBER
89 , P_Init_Msg_List IN VARCHAR2
90 , P_Commit IN VARCHAR2
91 , X_Return_Status OUT NOCOPY VARCHAR2
92 , X_Msg_Count OUT NOCOPY NUMBER
93 , X_Msg_Data OUT NOCOPY VARCHAR2
94 , p_ctr_id IN NUMBER
95 , p_object_version_number IN NUMBER
96 , p_cascade_upd_to_instances IN VARCHAR2
97 , x_object_version_number OUT NOCOPY NUMBER );
98
99
100 /* Called before counter Delete */
101 PROCEDURE PRE_DELETE_COUNTER ( P_Api_Version IN NUMBER
102 , P_Init_Msg_List IN VARCHAR2
103 , P_Commit IN VARCHAR2
104 , X_Return_Status OUT NOCOPY VARCHAR2
105 , X_Msg_Count OUT NOCOPY NUMBER
106 , X_Msg_Data OUT NOCOPY VARCHAR2
107 , p_ctr_id IN NUMBER );
108
109 /* Called after counter Delete */
110 PROCEDURE POST_DELETE_COUNTER ( p_counter_id IN NUMBER
111 , x_return_status out NOCOPY varchar2);
112
113
114 /* Called before counter property Insert */
115 PROCEDURE PRE_INSERT_COUNTER_PROPERTY (x_return_status out NOCOPY varchar2);
116
117 /* Called after counter property Insert */
118 PROCEDURE POST_INSERT_COUNTER_PROPERTY ( P_Api_Version IN NUMBER
119 , P_Init_Msg_List IN VARCHAR2
120 , P_Commit IN VARCHAR2
121 , X_Return_Status OUT NOCOPY VARCHAR2
122 , X_Msg_Count OUT NOCOPY NUMBER
123 , X_Msg_Data OUT NOCOPY VARCHAR2
124 , x_ctr_prop_id IN NUMBER
125 , x_object_version_number OUT NOCOPY NUMBER );
126
127
128 /* Called before counter property Update */
129 PROCEDURE PRE_UPDATE_COUNTER_PROPERTY ( x_return_status out NOCOPY varchar2);
130
131 /* Called after counter property Update */
132 PROCEDURE POST_UPDATE_COUNTER_PROPERTY ( P_Api_Version IN NUMBER
133 , P_Init_Msg_List IN VARCHAR2
134 , P_Commit IN VARCHAR2
135 , X_Return_Status OUT NOCOPY VARCHAR2
136 , X_Msg_Count OUT NOCOPY NUMBER
137 , X_Msg_Data OUT NOCOPY VARCHAR2
138 , p_ctr_prop_id IN NUMBER
139 , p_object_version_number IN NUMBER
140 , p_cascade_upd_to_instances IN VARCHAR2
141 , x_object_version_number OUT NOCOPY NUMBER );
142
143
144 /* Called before counter property Delete */
145 PROCEDURE PRE_DELETE_COUNTER_PROPERTY ( P_Api_Version IN NUMBER
146 , P_Init_Msg_List IN VARCHAR2
147 , P_Commit IN VARCHAR2
148 , X_Return_Status OUT NOCOPY VARCHAR2
149 , X_Msg_Count OUT NOCOPY NUMBER
150 , X_Msg_Data OUT NOCOPY VARCHAR2
151 , p_ctr_prop_id IN NUMBER );
152
153
154 /* Called after counter property Delete */
155 PROCEDURE POST_DELETE_COUNTER_PROPERTY ( p_counter_prop_id IN NUMBER
156 ,x_return_status out NOCOPY varchar2);
157
158
159 END CSL_CS_COUNTERS_ACC_PKG;