1 PACKAGE CST_XLA_PVT AUTHID CURRENT_USER AS
2 /* $Header: CSTVXLAS.pls 120.7.12010000.2 2010/02/18 01:21:33 ipineda 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 | PRIVATE FUNCTION |
68 | blueprint_SLA_hook_wrap |
69 | |
70 | DESCRIPTION |
71 | This is a wrapper call to blueprint_sla_hook when this is being |
72 | called from one of the bulk insert statements since the function |
73 | blueprint_sla_hook has out parameters, this wrapper should not |
74 | be modified or customized |
75 | |
76 | PARAMETERS: |
77 | INPUT: |
78 | -p_wrap_txn_id Transaction ID |
79 | -p_wrap_tb_source String identifying the source table of the |
80 | transaction that is calling the hook, the two |
81 | possible values are: |
82 | "MMT" for transaction belonging to table |
83 | MTL_MATERIAL_TRANSACTIONS |
84 | "WT" for transactions belonging to table |
85 | WIP_TRANSACTIONS |
86 | CALLED FROM |
87 | CST_XLA_PVT.CreateBulk_WIPXLAEvent |
88 | CST_XLA.PVT.Create_WIPUpdateXLAEvent |
89 | CST_XLA.Create_CostUpdateXLAEvent |
90 | |
91 | RETURN VALUES |
92 | integer 1 Create SLA events in blue print org for this txn |
93 | -1 Error in the hook |
94 | 0 or any other number |
95 | Do not create SLA events in blue print org for this |
96 | transaction (Default) |
97 | HISTORY |
98 | 04-Jan-2010 Ivan Pineda Created |
99 *----------------------------------------------------------------------------*/
100 FUNCTION blueprint_sla_hook_wrap(p_wrap_txn_id NUMBER,
101 p_wrap_tb_source VARCHAR2)
102 RETURN integer;
103
104 --------------------------------------------------------------------------------------
105 -- API name : Create_RCVXLAEvent
106 -- Type : Private
107 -- Function : To seed accounting event in SLA by calling an SLA API with
108 -- required parameters
109 -- Pre-reqs :
110 -- Parameters :
111 -- IN : p_api_version IN NUMBER
112 -- p_init_msg_list IN VARCHAR2
113 -- p_commit IN VARCHAR2
114 -- p_validation_level IN NUMBER
115 -- p_trx_info IN t_xla_rcv_trx_info
116 --
117 --
118 -- OUT : x_return_status OUT VARCHAR2(1)
119 -- x_msg_count OUT NUMBER
120 -- x_msg_data OUT VARCHAR2(2000)
121 -- Version :
122 -- Initial version 1.0
123 -- Notes : The API is called from the Receiving Transactions Processor
124 -- (RCVVACCB.pls)
125 --
126 -- End of comments
127 -------------------------------------------------------------------------------------
128 PROCEDURE Create_RCVXLAEvent (
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2,
131 p_commit IN VARCHAR2,
132 p_validation_level IN NUMBER,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136
137 p_trx_info IN t_xla_rcv_trx_info
138
139 );
140
141 --------------------------------------------------------------------------------------
142 -- API name : Create_INVXLAEvent
143 -- Type : Private
144 -- Function : To seed accounting event in SLA by calling an SLA API with
145 -- required parameters
146 -- Pre-reqs :
147 -- Parameters :
148 -- IN : p_api_version IN NUMBER
149 -- p_init_msg_list IN VARCHAR2
150 -- p_commit IN VARCHAR2
151 -- p_validation_level IN NUMBER
152 -- p_trx_info IN t_xla_inv_trx_info
153 --
154 --
155 -- OUT : x_return_status OUT VARCHAR2(1)
156 -- x_msg_count OUT NUMBER
157 -- x_msg_data OUT VARCHAR2(2000)
158 -- Version :
159 -- Initial version 1.0
160 -- Notes : The API is called from Cost Processors (Std - inltcp.lpc,
161 -- Avg - CSTACINB.pls, FIFO/LIFO - CSTLCINB.pls)
162 -- End of comments
163 -------------------------------------------------------------------------------------
164 PROCEDURE Create_INVXLAEvent (
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2,
167 p_commit IN VARCHAR2,
168 p_validation_level IN NUMBER,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172
173 p_trx_info IN t_xla_inv_trx_info
174
175 );
176
177 --------------------------------------------------------------------------------------
178 -- API name : Create_WIPXLAEvent
179 -- Type : Private
180 -- Function : To seed accounting event in SLA by calling an SLA API with
181 -- required parameters
182 -- Pre-reqs :
183 -- Parameters :
184 -- IN : p_api_version IN NUMBER
185 -- p_init_msg_list IN VARCHAR2
186 -- p_commit IN VARCHAR2
187 -- p_validation_level IN NUMBER
188 -- p_trx_info IN t_xla_wip_trx_info
189 --
190 --
191 -- OUT : x_return_status OUT VARCHAR2(1)
192 -- x_msg_count OUT NUMBER
193 -- x_msg_data OUT VARCHAR2(2000)
194 -- Version :
195 -- Initial version 1.0
196 -- Notes :
197 -- End of comments
198 -------------------------------------------------------------------------------------
199 PROCEDURE Create_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_trx_info IN t_xla_wip_trx_info
209
210 );
211
212 --------------------------------------------------------------------------------------
213 -- API name : CreateBulk_WIPXLAEvent
214 -- Type : Private
215 -- Function : To create WIP accounting events in bulk for a
216 -- WIP transaction group and Organization
217 -- Pre-reqs :
218 -- Parameters :
219 -- IN : p_api_version IN NUMBER
220 -- p_init_msg_list IN VARCHAR2
221 -- p_commit IN VARCHAR2
222 -- p_validation_level IN NUMBER
223 -- p_wcti_group_id IN NUMBER
224 -- p_organization_id IN NUMBER
225 --
226 -- OUT : x_return_status OUT VARCHAR2(1)
227 -- x_msg_count OUT NUMBER
228 -- x_msg_data OUT VARCHAR2(2000)
229 -- Version :
230 -- Initial version 1.0
231 -- Notes :
232 -- The API takes a WCTI group_id and creates events
233 -- for all the transactions within that group
234 -- Called from cmlwrx.lpc, cmlwsx.lpc
235 -- End of comments
236 --------------------------------------------------------------------------------------
237 PROCEDURE CreateBulk_WIPXLAEvent (
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2,
240 p_commit IN VARCHAR2,
241 p_validation_level IN NUMBER,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245
246 p_wcti_group_id IN NUMBER,
247 p_organization_id IN NUMBER );
248
249
250 --------------------------------------------------------------------------------------
251 -- API name : Create_CostUpdateXLAEvent
252 -- Type : Private
253 -- Function : To create Standard Cost Update accounting events in bulk
254 -- Pre-reqs :
255 -- Parameters :
256 -- IN : p_api_version IN NUMBER
257 -- p_init_msg_list IN VARCHAR2
258 -- p_commit IN VARCHAR2
259 -- p_validation_level IN NUMBER
260 -- p_update_id IN NUMBER
261 -- p_organization_id IN NUMBER
262 --
263 -- OUT : x_return_status OUT VARCHAR2(1)
264 -- x_msg_count OUT NUMBER
265 -- x_msg_data OUT VARCHAR2(2000)
266 -- Version :
267 -- Initial version 1.0
268 -- Notes :
269 -- The API takes a Standard Cost Update ID and organization_id
270 -- and creates all events associated with it.
271 -- Called from cmlicu.lpc
272 -- End of comments
273 --------------------------------------------------------------------------------------
274 PROCEDURE Create_CostUpdateXLAEvent (
275 p_api_version IN NUMBER,
276 p_init_msg_list IN VARCHAR2,
277 p_commit IN VARCHAR2,
278 p_validation_level IN NUMBER,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
285 --------------------------------------------------------------------------------------
282
283 p_update_id IN NUMBER,
284 p_organization_id IN NUMBER );
286 -- API name : Create_WIPUpdateXLAEvent
287 -- Type : Private
288 -- Function : To create WIP Cost Update accounting events in bulk
289 -- Pre-reqs :
290 -- Parameters :
291 -- IN : p_api_version IN NUMBER
292 -- p_init_msg_list IN VARCHAR2
293 -- p_commit IN VARCHAR2
294 -- p_validation_level IN NUMBER
295 -- p_update_id IN NUMBER
296 -- p_organization_id IN NUMBER
297 --
298 -- OUT : x_return_status OUT VARCHAR2(1)
299 -- x_msg_count OUT NUMBER
300 -- x_msg_data OUT VARCHAR2(2000)
301 -- Version :
302 -- Initial version 1.0
303 -- Notes :
304 -- The API takes a WIP Cost Update ID and organization_id
305 -- and creates all events associated with it.
306 -- Called from cmlwcu.lpc
307 -- End of comments
308 --------------------------------------------------------------------------------------
309 PROCEDURE Create_WIPUpdateXLAEvent (
310 p_api_version IN NUMBER,
311 p_init_msg_list IN VARCHAR2,
312 p_commit IN VARCHAR2,
313 p_validation_level IN NUMBER,
314 x_return_status OUT NOCOPY VARCHAR2,
315 x_msg_count OUT NOCOPY NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2,
317
318 p_update_id IN NUMBER,
319 p_organization_id IN NUMBER );
320
321 ------------------------
322 -- CST Security Policy
323 ------------------------
324 FUNCTION standard_policy
325 (p_obj_schema IN VARCHAR2
326 ,p_obj_name IN VARCHAR2)
327 RETURN VARCHAR2;
328
329 FUNCTION MO_POLICY
330 (p_obj_schema IN VARCHAR2
331 ,p_obj_name IN VARCHAR2)
332 RETURN VARCHAR2;
333
334 FUNCTION INV_ORG_POLICY
335 (p_obj_schema IN VARCHAR2
336 ,p_obj_name IN VARCHAR2)
337 RETURN VARCHAR2;
338
339
340 END CST_XLA_PVT;