eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.WIP_TRANSACTION_PUB

Source


1 PACKAGE WIP_Transaction_PUB AUTHID CURRENT_USER AS
2 /* $Header: WIPPTXNS.pls 120.0.12010000.2 2010/03/10 09:47:59 hliew ship $ */
3 
4 --  Wiptransaction record type
5 
6 TYPE Wiptransaction_Rec_Type IS RECORD
7 (   dummy                         VARCHAR2(1)
8 ,   return_status                 VARCHAR2(1)
9 ,   db_flag                       VARCHAR2(1)
10 ,   action                        VARCHAR2(30)
11 );
12 
13 TYPE Wiptransaction_Tbl_Type IS TABLE OF Wiptransaction_Rec_Type
14     INDEX BY BINARY_INTEGER;
15 
16 --  Wiptransaction value record type
17 
18 TYPE Wiptransaction_Val_Rec_Type IS RECORD
19 (   null_element NUMBER := NULL
20 );
21 
22 TYPE Wiptransaction_Val_Tbl_Type IS TABLE OF Wiptransaction_Val_Rec_Type
23     INDEX BY BINARY_INTEGER;
24 
25 --  Variables representing missing records and tables
26 
27 G_MISS_WIPTRANSACTION_REC     Wiptransaction_Rec_Type;
28 G_MISS_WIPTRANSACTION_VAL_REC Wiptransaction_Val_Rec_Type;
29 G_MISS_WIPTRANSACTION_TBL     Wiptransaction_Tbl_Type;
30 G_MISS_WIPTRANSACTION_VAL_TBL Wiptransaction_Val_Tbl_Type;
31 
32 
33 --  Resource record type ;  also used for OSP
34 
35 TYPE Res_Rec_Type IS RECORD
36 (   acct_period_id                NUMBER
37 ,   activity_id                   NUMBER
38 ,   activity_name                 VARCHAR2(10)
39 ,   actual_resource_rate          NUMBER
40 ,   attribute1                    VARCHAR2(150)
41 ,   attribute10                   VARCHAR2(150)
42 ,   attribute11                   VARCHAR2(150)
43 ,   attribute12                   VARCHAR2(150)
44 ,   attribute13                   VARCHAR2(150)
45 ,   attribute14                   VARCHAR2(150)
46 ,   attribute15                   VARCHAR2(150)
47 ,   attribute2                    VARCHAR2(150)
48 ,   attribute3                    VARCHAR2(150)
49 ,   attribute4                    VARCHAR2(150)
50 ,   attribute5                    VARCHAR2(150)
51 ,   attribute6                    VARCHAR2(150)
52 ,   attribute7                    VARCHAR2(150)
53 ,   attribute8                    VARCHAR2(150)
54 ,   attribute9                    VARCHAR2(150)
55 ,   attribute_category            VARCHAR2(30)
56 ,   autocharge_type               NUMBER
57 ,   basis_type                    NUMBER
58 ,   completion_transaction_id     NUMBER
59 ,   created_by                    NUMBER
60 ,   created_by_name               VARCHAR2(100)
61 ,   creation_date                 DATE
62 ,   currency_actual_rsc_rate      NUMBER
63 ,   currency_code                 VARCHAR2(15)
64 ,   currency_conversion_date      DATE
65 ,   currency_conversion_rate      NUMBER
66 ,   currency_conversion_type      VARCHAR2(10)
67 ,   department_code               VARCHAR2(10)
68 ,   department_id                 NUMBER
69 ,   employee_id                   NUMBER
70 ,   employee_num                  VARCHAR2(30)
71 ,   entity_type                   NUMBER
72 ,   group_id                      NUMBER
73 ,   last_updated_by               NUMBER
74 ,   last_updated_by_name          VARCHAR2(100)
75 ,   last_update_date              DATE
76 ,   last_update_login             NUMBER
77 ,   line_code                     VARCHAR2(10)
78 ,   line_id                       NUMBER
79 ,   move_transaction_id           NUMBER
80 ,   operation_seq_num             NUMBER
81 ,   organization_code             VARCHAR2(3)
82 ,   organization_id               NUMBER
83 ,   po_header_id                  NUMBER
84 ,   po_line_id                    NUMBER
85 ,   primary_item_id               NUMBER
86 ,   primary_quantity              NUMBER
87 ,   primary_uom                   VARCHAR2(3)
88 ,   primary_uom_class             VARCHAR2(10)
89 ,   process_phase                 NUMBER
90 ,   process_status                NUMBER
91 ,   program_application_id        NUMBER
92 ,   program_id                    NUMBER
93 ,   program_update_date           DATE
94 ,   project_id                    NUMBER
95 ,   rcv_transaction_id            NUMBER
96 ,   reason_id                     NUMBER
97 ,   reason_name                   VARCHAR2(30)
98 ,   receiving_account_id          NUMBER
99 ,   reference                     VARCHAR2(240)
100 ,   repetitive_schedule_id        NUMBER
101 ,   request_id                    NUMBER
102 ,   resource_code                 VARCHAR2(10)
103 ,   resource_id                   NUMBER
104 ,   resource_seq_num              NUMBER
105 ,   resource_type                 NUMBER
106 ,   source_code                   VARCHAR2(30)
107 ,   source_line_id                NUMBER
108 ,   standard_rate_flag            NUMBER
109 ,   task_id                       NUMBER
110 ,   transaction_date              DATE
111 ,   transaction_id                NUMBER
112 ,   transaction_quantity          NUMBER
113 ,   transaction_type              NUMBER
114 ,   transaction_uom               VARCHAR2(3)
115 ,   usage_rate_or_amount          NUMBER
116 ,   wip_entity_id                 NUMBER
117 ,   wip_entity_name               VARCHAR2(240)
118 ,   return_status                 VARCHAR2(1)
119 ,   db_flag                       VARCHAR2(1)
120 ,   action                        VARCHAR2(30)
121 ,   WIPTransaction_index          NUMBER
122 ,   encumbrance_type_id           NUMBER  --Fix bug 9356683, for costing encumbrance project
123 ,   encumbrance_amount            NUMBER  --Fix bug 9356683
124 ,   encumbrance_quantity          NUMBER  --Fix bug 9356683
125 ,   encumbrance_ccid              NUMBER  --Fix bug 9356683
126 );
127 
128 
129 --Possible OSP actions. These are "in addition to" or "entity specific modification of" the actions in WIP_Globals package.
130 
131 G_ACT_OSP_RECEIVE                  CONSTANT VARCHAR2(50) :=  'RECEIVE';
132 
133 -- the following 4 constants are the transaction followed by the parent transaction
134 G_ACT_OSP_RET_TO_RCV               CONSTANT VARCHAR2(50) :=  'RETURN TO RECEIVINGDELIVER';
135 G_ACT_OSP_RET_TO_VEND              CONSTANT VARCHAR2(50) :=  'RETURN TO VENDORDELIVER';
136 G_ACT_OSP_CORRECT_TO_VEND          CONSTANT VARCHAR2(50) :=  'CORRECTRETURN TO VENDOR';
137 G_ACT_OSP_CORRECT_TO_RCV           CONSTANT VARCHAR2(50) :=  'CORRECTRETURN TO RECEIVING';
138 G_ACT_OSP_CORRECT_RECEIVE          CONSTANT VARCHAR2(50) :=  'CORRECTRECEIVE';
139 G_ACT_OSP_DELIVER                  CONSTANT VARCHAR2(50) :=  'DELIVER';
140 
141 TYPE Res_Tbl_Type IS TABLE OF Res_Rec_Type
142     INDEX BY BINARY_INTEGER;
143 
144 --  Res value record type
145 
146 TYPE Res_Val_Rec_Type IS RECORD
147 (   acct_period                   VARCHAR2(240)
148 ,   activity                      VARCHAR2(240)
149 ,   completion_transaction        VARCHAR2(240)
150 ,   currency                      VARCHAR2(240)
151 ,   department                    VARCHAR2(240)
152 ,   employee                      VARCHAR2(240)
153 ,   group_name                    VARCHAR2(240)
154 ,   line                          VARCHAR2(240)
155 ,   move_transaction              VARCHAR2(240)
156 ,   organization                  VARCHAR2(240)
157 ,   po_header                     VARCHAR2(240)
158 ,   po_line                       VARCHAR2(240)
159 ,   primary_item                  VARCHAR2(240)
160 ,   project                       VARCHAR2(240)
161 ,   rcv_transaction               VARCHAR2(240)
162 ,   reason                        VARCHAR2(240)
163 ,   receiving_account             VARCHAR2(240)
164 ,   repetitive_schedule           VARCHAR2(240)
165 ,   resource_name                 VARCHAR2(240)
166 ,   source                        VARCHAR2(240)
167 ,   source_line                   VARCHAR2(240)
168 ,   standard_rate                 VARCHAR2(240)
169 ,   task                          VARCHAR2(240)
170 ,   transaction                   VARCHAR2(240)
171 ,   wip_entity                    VARCHAR2(240)
172 );
173 
174 TYPE Res_Val_Tbl_Type IS TABLE OF Res_Val_Rec_Type
175     INDEX BY BINARY_INTEGER;
176 
177 --  Variables representing missing records and tables
178 
179 G_MISS_RES_REC                Res_Rec_Type;
180 G_MISS_RES_VAL_REC            Res_Val_Rec_Type;
181 G_MISS_RES_TBL                Res_Tbl_Type;
182 G_MISS_RES_VAL_TBL            Res_Val_Tbl_Type;
183 
184 
185 --  Shopfloormove record type
186 
187 TYPE Shopfloormove_Rec_Type IS RECORD
188 (   acct_period_id                NUMBER
189 ,   attribute1                    VARCHAR2(150)
190 ,   attribute10                   VARCHAR2(150)
191 ,   attribute11                   VARCHAR2(150)
192 ,   attribute12                   VARCHAR2(150)
193 ,   attribute13                   VARCHAR2(150)
194 ,   attribute14                   VARCHAR2(150)
195 ,   attribute15                   VARCHAR2(150)
196 ,   attribute2                    VARCHAR2(150)
197 ,   attribute3                    VARCHAR2(150)
198 ,   attribute4                    VARCHAR2(150)
199 ,   attribute5                    VARCHAR2(150)
200 ,   attribute6                    VARCHAR2(150)
201 ,   attribute7                    VARCHAR2(150)
202 ,   attribute8                    VARCHAR2(150)
203 ,   attribute9                    VARCHAR2(150)
204 ,   attribute_category            VARCHAR2(30)
205 ,   created_by                    NUMBER
206 ,   created_by_name               VARCHAR2(100)
207 ,   creation_date                 DATE
208 ,   entity_type                   NUMBER
209 ,   fm_department_code            VARCHAR2(10)
210 ,   fm_department_id              NUMBER
211 ,   fm_intraop_step_type          NUMBER
212 ,   fm_operation_code             VARCHAR2(4)
213 ,   fm_operation_seq_num          NUMBER
214 ,   group_id                      NUMBER
215 ,   kanban_card_id                NUMBER
216 ,   last_updated_by               NUMBER
217 ,   last_updated_by_name          VARCHAR2(100)
218 ,   last_update_date              DATE
219 ,   last_update_login             NUMBER
220 ,   line_code                     VARCHAR2(10)
221 ,   line_id                       NUMBER
222 ,   organization_code             VARCHAR2(3)
223 ,   organization_id               NUMBER
224 ,   overcpl_primary_qty           NUMBER
225 ,   overcpl_transaction_id        NUMBER
226 ,   overcpl_transaction_qty       NUMBER
227 ,   primary_item_id               NUMBER
228 ,   primary_quantity              NUMBER
229 ,   primary_uom                   VARCHAR2(3)
230 ,   process_phase                 NUMBER
231 ,   process_status                NUMBER
232 ,   program_application_id        NUMBER
233 ,   program_id                    NUMBER
234 ,   program_update_date           DATE
235 ,   qa_collection_id              NUMBER
236 ,   reason_id                     NUMBER
237 ,   reason_name                   VARCHAR2(30)
238 ,   reference                     VARCHAR2(240)
239 ,   repetitive_schedule_id        NUMBER
240 ,   request_id                    NUMBER
241 ,   scrap_account_id              NUMBER
242 ,   source_code                   VARCHAR2(30)
243 ,   source_line_id                NUMBER
244 ,   to_department_code            VARCHAR2(10)
245 ,   to_department_id              NUMBER
246 ,   to_intraop_step_type          NUMBER
247 ,   to_operation_code             VARCHAR2(4)
248 ,   to_operation_seq_num          NUMBER
249 ,   transaction_date              DATE
250 ,   transaction_id                NUMBER
251 ,   transaction_quantity          NUMBER
252 ,   transaction_type              NUMBER
253 ,   transaction_uom               VARCHAR2(3)
254 ,   wip_entity_id                 NUMBER
255 ,   wip_entity_name               VARCHAR2(240)
256 ,   return_status                 VARCHAR2(1)
257 ,   db_flag                       VARCHAR2(1)
258 ,   action                        VARCHAR2(30)
259 ,   WIPTransaction_index          NUMBER
260 );
261 
262 TYPE Shopfloormove_Tbl_Type IS TABLE OF Shopfloormove_Rec_Type
263     INDEX BY BINARY_INTEGER;
264 
265 --  Shopfloormove value record type
266 
267 TYPE Shopfloormove_Val_Rec_Type IS RECORD
268 (   acct_period                   VARCHAR2(240)
269 ,   fm_department                 VARCHAR2(240)
270 ,   fm_operation                  VARCHAR2(240)
271 ,   group_name                    VARCHAR2(240)
272 ,   kanban_card                   VARCHAR2(240)
273 ,   kanban                        VARCHAR2(240)
274 ,   line                          VARCHAR2(240)
275 ,   organization                  VARCHAR2(240)
276 ,   overcompletion                VARCHAR2(240)
277 ,   overcpl_transaction           VARCHAR2(240)
278 ,   primary_item                  VARCHAR2(240)
279 ,   qa_collection                 VARCHAR2(240)
280 ,   reason                        VARCHAR2(240)
281 ,   repetitive_schedule           VARCHAR2(240)
282 ,   scrap_account                 VARCHAR2(240)
283 ,   source                        VARCHAR2(240)
284 ,   source_line                   VARCHAR2(240)
285 ,   to_department                 VARCHAR2(240)
286 ,   to_operation                  VARCHAR2(240)
287 ,   transaction                   VARCHAR2(240)
288 ,   transaction_link              VARCHAR2(240)
289 ,   wip_entity                    VARCHAR2(240)
290 );
291 
292 TYPE Shopfloormove_Val_Tbl_Type IS TABLE OF Shopfloormove_Val_Rec_Type
293     INDEX BY BINARY_INTEGER;
294 
295 --  Variables representing missing records and tables
296 
297 G_MISS_SHOPFLOORMOVE_REC      Shopfloormove_Rec_Type;
298 G_MISS_SHOPFLOORMOVE_VAL_REC  Shopfloormove_Val_Rec_Type;
299 G_MISS_SHOPFLOORMOVE_TBL      Shopfloormove_Tbl_Type;
300 G_MISS_SHOPFLOORMOVE_VAL_TBL  Shopfloormove_Val_Tbl_Type;
301 
302 -- The following records are used for defaulting procedures
303 TYPE Rcv_Txn_Type Is RECORD
304 (
305     comments                   VARCHAR2(240)
306 ,   creation_date              DATE
307 ,   created_by                 NUMBER
308 ,   currency_code              VARCHAR2(15)
309 ,   currency_conversion_date   DATE
310 ,   currency_conversion_rate   NUMBER
311 ,   currency_conversion_type   VARCHAR2(10)
312 ,   item_id		       NUMBER
313 ,   last_update_date           DATE
314 ,   last_update_login          NUMBER
315 ,   last_updated_by            NUMBER
316 ,   organization_id            NUMBER
317 ,   primary_unit_of_measure    VARCHAR2(25)
318 ,   po_header_id               NUMBER
319 ,   po_line_id                 NUMBER
320 ,   po_unit_price              NUMBER
321 ,   quantity 	               NUMBER
322 ,   unit_of_measure	       VARCHAR2(25)
323 ,   reason_id                  NUMBER
324 ,   source_doc_quantity	       NUMBER
325 ,   source_doc_unit_of_measure VARCHAR2(25)
326 ,   transaction_date           DATE
327 ,   wip_line_id                NUMBER
328 ,   wip_entity_id              NUMBER
329 ,   wip_operation_seq_num      NUMBER
330 ,   wip_repetitive_schedule_id NUMBER
331 ,   wip_resource_seq_num       NUMBER
332 );
333 
334 TYPE WIP_Op_Res_Type Is RECORD
335 (   activity_id             NUMBER
336 ,   autocharge_type         NUMBER
337 ,   basis_type              NUMBER
338 ,   resource_id             NUMBER
339 ,   std_rate_flag           NUMBER
340 ,   usage_rate_or_amount    NUMBER
341 ,   uom_code                VARCHAR2(3)
342 );
343 
344 TYPE PO_Dist_Type Is RECORD
345 (  project_id 		NUMBER
346 ,  task_id 		NUMBER
347 ,  nonrecoverable_tax	NUMBER
348 ,  primary_quantity_ordered	NUMBER
349 );
350 
351 TYPE BOM_Resource_Type Is RECORD
352 (  resource_code 	VARCHAR2(10)
353 ,  resource_type 	NUMBER
354 );
355 
356 TYPE OSP_Move_Details_Type IS RECORD
357 (
358   transaction_type	NUMBER
359 , primary_quantity	NUMBER
360 , transaction_quantity	NUMBER
361 , fm_operation_seq_num	NUMBER
362 , fm_intraop_step_type	NUMBER
363 , fm_department_id	NUMBER
364 , to_operation_seq_num	NUMBER
365 , to_intraop_step_type	NUMBER
366 , to_department_id	NUMBER
367 , move_direction	NUMBER
368 );
369 
370 G_MISS_RCV_TXN_REC      Rcv_Txn_Type;
371 G_MISS_WIP_OP_RES_REC   WIP_Op_Res_Type;
372 G_MISS_PO_DIST_REC      PO_Dist_Type;
373 G_MISS_BOM_RES_REC      BOM_Resource_Type;
374 G_MISS_OSP_MOVE_DET_REC OSP_Move_Details_Type;
375 
376 
377 --  Start of Comments
378 --  API name    Get_Transaction
379 --  Type        Public
380 --  Function
381 --
382 --  Pre-reqs
383 --
384 --  Parameters
385 --
386 --  Version     Current version = 1.0
387 --              Initial version = 1.0
388 --
389 --  Notes
390 --
391 --  End of Comments
392 
393 PROCEDURE Get_Transaction
394 (   p_api_version_number            IN  NUMBER
395 ,   p_init_msg_list                 IN  VARCHAR2 := NULL
396 ,   p_return_values                 IN  VARCHAR2 := NULL
397 ,   x_return_status                 OUT NOCOPY VARCHAR2
398 ,   x_msg_count                     OUT NOCOPY NUMBER
399 ,   x_msg_data                      OUT NOCOPY VARCHAR2
400 ,   p_dummy                         IN  VARCHAR2
401 ,   x_WIPTransaction_tbl            OUT NOCOPY Wiptransaction_Tbl_Type
402 ,   x_WIPTransaction_val_tbl        OUT NOCOPY Wiptransaction_Val_Tbl_Type
403 ,   x_Res_tbl                       OUT NOCOPY Res_Tbl_Type
404 ,   x_Res_val_tbl                   OUT NOCOPY Res_Val_Tbl_Type
405 ,   x_ShopFloorMove_tbl             OUT NOCOPY Shopfloormove_Tbl_Type
406 ,   x_ShopFloorMove_val_tbl         OUT NOCOPY Shopfloormove_Val_Tbl_Type
407 );
408 
409 END WIP_Transaction_PUB;