1 PACKAGE CST_XLA_PVT AS
2 /* $Header: CSTVXLAS.pls 120.7.12010000.1 2008/07/24 17:26:19 appldev ship $ */
3 TYPE t_cst_inv_event_info IS RECORD
4 (
5 TRANSACTION_ID NUMBER,
6 ORGANIZATION_ID NUMBER,
7 TXN_SRC_TYPE_ID NUMBER,
8 EVENT_TYPE_CODE VARCHAR2(30)
9 );
10 TYPE t_cst_inv_events IS TABLE OF t_cst_inv_event_info INDEX BY BINARY_INTEGER;
11
12 --------------------------------------------------
13 -- Type to store Inventory Transaction information
14 -- to generate an SLA event
15 --------------------------------------------------
16 TYPE t_xla_inv_trx_info IS RECORD
17 (
18 TRANSACTION_DATE DATE,
19 TRANSACTION_ID NUMBER,
20 TXN_TYPE_ID NUMBER,
21 TXN_SRC_TYPE_ID NUMBER,
22 TXN_ACTION_ID NUMBER,
23 FOB_POINT NUMBER,
24 ATTRIBUTE VARCHAR2(30),
25 TXN_ORGANIZATION_ID NUMBER,
26 TXFR_ORGANIZATION_ID NUMBER,
27 TP VARCHAR2(1),
28 ENCUMBRANCE_FLAG VARCHAR2(1),
29 PRIMARY_QUANTITY NUMBER
30 );
31
32 --------------------------------------------------
33 -- Type to store Receiving Transaction information
34 -- to generate an SLA event
35 --------------------------------------------------
36
37 TYPE t_xla_rcv_trx_info IS RECORD
38 (
39 TRANSACTION_DATE DATE,
40 TRANSACTION_ID NUMBER,
41 ACCT_EVENT_ID NUMBER,
42 ACCT_EVENT_TYPE_ID NUMBER,
43 ATTRIBUTE VARCHAR2(25),
44 INV_ORGANIZATION_ID NUMBER,
45 OPERATING_UNIT NUMBER,
46 LEDGER_ID NUMBER,
47 ENCUMBRANCE_FLAG VARCHAR2(1),
48 TRANSACTION_NUMBER VARCHAR2(240)
49 );
50
51 --------------------------------------------
52 -- Type to store WIP Transaction information
53 -- to generate an SLA event
54 --------------------------------------------
55 TYPE t_xla_wip_trx_info IS RECORD
56 (
57 TRANSACTION_DATE DATE,
58 TRANSACTION_ID NUMBER,
59 TXN_TYPE_ID NUMBER,
60 WIP_RESOURCE_ID NUMBER,
61 WIP_BASIS_TYPE_ID NUMBER,
62 ATTRIBUTE VARCHAR2(30),
63 INV_ORGANIZATION_ID NUMBER
64 );
65
66 --------------------------------------------------------------------------------------
67 -- API name : Create_RCVXLAEvent
68 -- Type : Private
69 -- Function : To seed accounting event in SLA by calling an SLA API with
70 -- required parameters
71 -- Pre-reqs :
72 -- Parameters :
73 -- IN : p_api_version IN NUMBER
74 -- p_init_msg_list IN VARCHAR2
75 -- p_commit IN VARCHAR2
76 -- p_validation_level IN NUMBER
77 -- p_trx_info IN t_xla_rcv_trx_info
78 --
79 --
80 -- OUT : x_return_status OUT VARCHAR2(1)
81 -- x_msg_count OUT NUMBER
82 -- x_msg_data OUT VARCHAR2(2000)
83 -- Version :
84 -- Initial version 1.0
85 -- Notes : The API is called from the Receiving Transactions Processor
86 -- (RCVVACCB.pls)
87 --
88 -- End of comments
89 -------------------------------------------------------------------------------------
90 PROCEDURE Create_RCVXLAEvent (
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2,
93 p_commit IN VARCHAR2,
94 p_validation_level IN NUMBER,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98
99 p_trx_info IN t_xla_rcv_trx_info
100
101 );
102
103 --------------------------------------------------------------------------------------
104 -- API name : Create_INVXLAEvent
105 -- Type : Private
106 -- Function : To seed accounting event in SLA by calling an SLA API with
107 -- required parameters
108 -- Pre-reqs :
109 -- Parameters :
110 -- IN : p_api_version IN NUMBER
111 -- p_init_msg_list IN VARCHAR2
112 -- p_commit IN VARCHAR2
113 -- p_validation_level IN NUMBER
114 -- p_trx_info IN t_xla_inv_trx_info
115 --
116 --
117 -- OUT : x_return_status OUT VARCHAR2(1)
118 -- x_msg_count OUT NUMBER
119 -- x_msg_data OUT VARCHAR2(2000)
120 -- Version :
121 -- Initial version 1.0
122 -- Notes : The API is called from Cost Processors (Std - inltcp.lpc,
123 -- Avg - CSTACINB.pls, FIFO/LIFO - CSTLCINB.pls)
124 -- End of comments
125 -------------------------------------------------------------------------------------
126 PROCEDURE Create_INVXLAEvent (
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2,
129 p_commit IN VARCHAR2,
130 p_validation_level IN NUMBER,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134
135 p_trx_info IN t_xla_inv_trx_info
136
137 );
138
139 --------------------------------------------------------------------------------------
140 -- API name : Create_WIPXLAEvent
141 -- Type : Private
142 -- Function : To seed accounting event in SLA by calling an SLA API with
143 -- required parameters
144 -- Pre-reqs :
145 -- Parameters :
146 -- IN : p_api_version IN NUMBER
147 -- p_init_msg_list IN VARCHAR2
148 -- p_commit IN VARCHAR2
149 -- p_validation_level IN NUMBER
150 -- p_trx_info IN t_xla_wip_trx_info
151 --
152 --
153 -- OUT : x_return_status OUT VARCHAR2(1)
154 -- x_msg_count OUT NUMBER
155 -- x_msg_data OUT VARCHAR2(2000)
156 -- Version :
157 -- Initial version 1.0
158 -- Notes :
159 -- End of comments
160 -------------------------------------------------------------------------------------
161 PROCEDURE Create_WIPXLAEvent (
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2,
164 p_commit IN VARCHAR2,
165 p_validation_level IN NUMBER,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169
170 p_trx_info IN t_xla_wip_trx_info
171
172 );
173
174 --------------------------------------------------------------------------------------
175 -- API name : CreateBulk_WIPXLAEvent
176 -- Type : Private
177 -- Function : To create WIP accounting events in bulk for a
178 -- WIP transaction group and Organization
179 -- Pre-reqs :
180 -- Parameters :
181 -- IN : p_api_version IN NUMBER
182 -- p_init_msg_list IN VARCHAR2
183 -- p_commit IN VARCHAR2
184 -- p_validation_level IN NUMBER
185 -- p_wcti_group_id IN NUMBER
186 -- p_organization_id IN NUMBER
187 --
188 -- OUT : x_return_status OUT VARCHAR2(1)
189 -- x_msg_count OUT NUMBER
190 -- x_msg_data OUT VARCHAR2(2000)
191 -- Version :
192 -- Initial version 1.0
193 -- Notes :
194 -- The API takes a WCTI group_id and creates events
195 -- for all the transactions within that group
196 -- Called from cmlwrx.lpc, cmlwsx.lpc
197 -- End of comments
198 --------------------------------------------------------------------------------------
199 PROCEDURE CreateBulk_WIPXLAEvent (
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2,
202 p_commit IN VARCHAR2,
203 p_validation_level IN NUMBER,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207
208 p_wcti_group_id IN NUMBER,
209 p_organization_id IN NUMBER );
210
211
212 --------------------------------------------------------------------------------------
213 -- API name : Create_CostUpdateXLAEvent
214 -- Type : Private
215 -- Function : To create Standard Cost Update accounting events in bulk
216 -- Pre-reqs :
217 -- Parameters :
218 -- IN : p_api_version IN NUMBER
219 -- p_init_msg_list IN VARCHAR2
220 -- p_commit IN VARCHAR2
221 -- p_validation_level IN NUMBER
222 -- p_update_id IN NUMBER
223 -- p_organization_id IN NUMBER
224 --
225 -- OUT : x_return_status OUT VARCHAR2(1)
226 -- x_msg_count OUT NUMBER
227 -- x_msg_data OUT VARCHAR2(2000)
228 -- Version :
229 -- Initial version 1.0
230 -- Notes :
231 -- The API takes a Standard Cost Update ID and organization_id
232 -- and creates all events associated with it.
233 -- Called from cmlicu.lpc
234 -- End of comments
235 --------------------------------------------------------------------------------------
236 PROCEDURE Create_CostUpdateXLAEvent (
237 p_api_version IN NUMBER,
238 p_init_msg_list IN VARCHAR2,
239 p_commit IN VARCHAR2,
240 p_validation_level IN NUMBER,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244
245 p_update_id IN NUMBER,
246 p_organization_id IN NUMBER );
247 --------------------------------------------------------------------------------------
248 -- API name : Create_WIPUpdateXLAEvent
249 -- Type : Private
250 -- Function : To create WIP Cost Update accounting events in bulk
251 -- Pre-reqs :
252 -- Parameters :
253 -- IN : p_api_version IN NUMBER
254 -- p_init_msg_list IN VARCHAR2
255 -- p_commit IN VARCHAR2
256 -- p_validation_level IN NUMBER
257 -- p_update_id IN NUMBER
258 -- p_organization_id IN NUMBER
259 --
260 -- OUT : x_return_status OUT VARCHAR2(1)
261 -- x_msg_count OUT NUMBER
262 -- x_msg_data OUT VARCHAR2(2000)
263 -- Version :
264 -- Initial version 1.0
265 -- Notes :
266 -- The API takes a WIP Cost Update ID and organization_id
267 -- and creates all events associated with it.
268 -- Called from cmlwcu.lpc
269 -- End of comments
270 --------------------------------------------------------------------------------------
271 PROCEDURE Create_WIPUpdateXLAEvent (
272 p_api_version IN NUMBER,
273 p_init_msg_list IN VARCHAR2,
274 p_commit IN VARCHAR2,
275 p_validation_level IN NUMBER,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279
280 p_update_id IN NUMBER,
281 p_organization_id IN NUMBER );
282
283 ------------------------
284 -- CST Security Policy
285 ------------------------
286 FUNCTION standard_policy
287 (p_obj_schema IN VARCHAR2
288 ,p_obj_name IN VARCHAR2)
289 RETURN VARCHAR2;
290
291 FUNCTION MO_POLICY
292 (p_obj_schema IN VARCHAR2
293 ,p_obj_name IN VARCHAR2)
294 RETURN VARCHAR2;
295
296 FUNCTION INV_ORG_POLICY
297 (p_obj_schema IN VARCHAR2
298 ,p_obj_name IN VARCHAR2)
299 RETURN VARCHAR2;
300
301
302 END CST_XLA_PVT;