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 115.16 2002/12/05 23:25:44 seli 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 );
123 
124 
125 --Possible OSP actions. These are "in addition to" or "entity specific modification of" the actions in WIP_Globals package.
126 
127 G_ACT_OSP_RECEIVE                  CONSTANT VARCHAR2(50) :=  'RECEIVE';
128 
129 -- the following 4 constants are the transaction followed by the parent transaction
130 G_ACT_OSP_RET_TO_RCV               CONSTANT VARCHAR2(50) :=  'RETURN TO RECEIVINGDELIVER';
131 G_ACT_OSP_RET_TO_VEND              CONSTANT VARCHAR2(50) :=  'RETURN TO VENDORDELIVER';
132 G_ACT_OSP_CORRECT_TO_VEND          CONSTANT VARCHAR2(50) :=  'CORRECTRETURN TO VENDOR';
133 G_ACT_OSP_CORRECT_TO_RCV           CONSTANT VARCHAR2(50) :=  'CORRECTRETURN TO RECEIVING';
134 G_ACT_OSP_CORRECT_RECEIVE          CONSTANT VARCHAR2(50) :=  'CORRECTRECEIVE';
135 G_ACT_OSP_DELIVER                  CONSTANT VARCHAR2(50) :=  'DELIVER';
136 
137 TYPE Res_Tbl_Type IS TABLE OF Res_Rec_Type
138     INDEX BY BINARY_INTEGER;
139 
140 --  Res value record type
141 
142 TYPE Res_Val_Rec_Type IS RECORD
143 (   acct_period                   VARCHAR2(240)
144 ,   activity                      VARCHAR2(240)
145 ,   completion_transaction        VARCHAR2(240)
146 ,   currency                      VARCHAR2(240)
147 ,   department                    VARCHAR2(240)
148 ,   employee                      VARCHAR2(240)
149 ,   group_name                    VARCHAR2(240)
150 ,   line                          VARCHAR2(240)
151 ,   move_transaction              VARCHAR2(240)
152 ,   organization                  VARCHAR2(240)
153 ,   po_header                     VARCHAR2(240)
154 ,   po_line                       VARCHAR2(240)
155 ,   primary_item                  VARCHAR2(240)
156 ,   project                       VARCHAR2(240)
157 ,   rcv_transaction               VARCHAR2(240)
158 ,   reason                        VARCHAR2(240)
159 ,   receiving_account             VARCHAR2(240)
160 ,   repetitive_schedule           VARCHAR2(240)
161 ,   resource_name                 VARCHAR2(240)
162 ,   source                        VARCHAR2(240)
163 ,   source_line                   VARCHAR2(240)
164 ,   standard_rate                 VARCHAR2(240)
165 ,   task                          VARCHAR2(240)
166 ,   transaction                   VARCHAR2(240)
167 ,   wip_entity                    VARCHAR2(240)
168 );
169 
170 TYPE Res_Val_Tbl_Type IS TABLE OF Res_Val_Rec_Type
171     INDEX BY BINARY_INTEGER;
172 
173 --  Variables representing missing records and tables
174 
175 G_MISS_RES_REC                Res_Rec_Type;
176 G_MISS_RES_VAL_REC            Res_Val_Rec_Type;
177 G_MISS_RES_TBL                Res_Tbl_Type;
178 G_MISS_RES_VAL_TBL            Res_Val_Tbl_Type;
179 
180 
181 --  Shopfloormove record type
182 
183 TYPE Shopfloormove_Rec_Type IS RECORD
184 (   acct_period_id                NUMBER
185 ,   attribute1                    VARCHAR2(150)
186 ,   attribute10                   VARCHAR2(150)
187 ,   attribute11                   VARCHAR2(150)
188 ,   attribute12                   VARCHAR2(150)
189 ,   attribute13                   VARCHAR2(150)
190 ,   attribute14                   VARCHAR2(150)
191 ,   attribute15                   VARCHAR2(150)
192 ,   attribute2                    VARCHAR2(150)
193 ,   attribute3                    VARCHAR2(150)
194 ,   attribute4                    VARCHAR2(150)
195 ,   attribute5                    VARCHAR2(150)
196 ,   attribute6                    VARCHAR2(150)
197 ,   attribute7                    VARCHAR2(150)
198 ,   attribute8                    VARCHAR2(150)
199 ,   attribute9                    VARCHAR2(150)
200 ,   attribute_category            VARCHAR2(30)
201 ,   created_by                    NUMBER
202 ,   created_by_name               VARCHAR2(100)
203 ,   creation_date                 DATE
204 ,   entity_type                   NUMBER
205 ,   fm_department_code            VARCHAR2(10)
206 ,   fm_department_id              NUMBER
207 ,   fm_intraop_step_type          NUMBER
208 ,   fm_operation_code             VARCHAR2(4)
209 ,   fm_operation_seq_num          NUMBER
210 ,   group_id                      NUMBER
211 ,   kanban_card_id                NUMBER
212 ,   last_updated_by               NUMBER
213 ,   last_updated_by_name          VARCHAR2(100)
214 ,   last_update_date              DATE
215 ,   last_update_login             NUMBER
216 ,   line_code                     VARCHAR2(10)
217 ,   line_id                       NUMBER
218 ,   organization_code             VARCHAR2(3)
219 ,   organization_id               NUMBER
220 ,   overcpl_primary_qty           NUMBER
221 ,   overcpl_transaction_id        NUMBER
222 ,   overcpl_transaction_qty       NUMBER
223 ,   primary_item_id               NUMBER
224 ,   primary_quantity              NUMBER
225 ,   primary_uom                   VARCHAR2(3)
226 ,   process_phase                 NUMBER
227 ,   process_status                NUMBER
228 ,   program_application_id        NUMBER
229 ,   program_id                    NUMBER
230 ,   program_update_date           DATE
231 ,   qa_collection_id              NUMBER
232 ,   reason_id                     NUMBER
233 ,   reason_name                   VARCHAR2(30)
234 ,   reference                     VARCHAR2(240)
235 ,   repetitive_schedule_id        NUMBER
236 ,   request_id                    NUMBER
237 ,   scrap_account_id              NUMBER
238 ,   source_code                   VARCHAR2(30)
239 ,   source_line_id                NUMBER
240 ,   to_department_code            VARCHAR2(10)
241 ,   to_department_id              NUMBER
242 ,   to_intraop_step_type          NUMBER
243 ,   to_operation_code             VARCHAR2(4)
244 ,   to_operation_seq_num          NUMBER
245 ,   transaction_date              DATE
246 ,   transaction_id                NUMBER
247 ,   transaction_quantity          NUMBER
248 ,   transaction_type              NUMBER
249 ,   transaction_uom               VARCHAR2(3)
250 ,   wip_entity_id                 NUMBER
251 ,   wip_entity_name               VARCHAR2(240)
252 ,   return_status                 VARCHAR2(1)
253 ,   db_flag                       VARCHAR2(1)
254 ,   action                        VARCHAR2(30)
255 ,   WIPTransaction_index          NUMBER
256 );
257 
258 TYPE Shopfloormove_Tbl_Type IS TABLE OF Shopfloormove_Rec_Type
259     INDEX BY BINARY_INTEGER;
260 
261 --  Shopfloormove value record type
262 
263 TYPE Shopfloormove_Val_Rec_Type IS RECORD
264 (   acct_period                   VARCHAR2(240)
265 ,   fm_department                 VARCHAR2(240)
266 ,   fm_operation                  VARCHAR2(240)
267 ,   group_name                    VARCHAR2(240)
268 ,   kanban_card                   VARCHAR2(240)
269 ,   kanban                        VARCHAR2(240)
270 ,   line                          VARCHAR2(240)
271 ,   organization                  VARCHAR2(240)
272 ,   overcompletion                VARCHAR2(240)
273 ,   overcpl_transaction           VARCHAR2(240)
274 ,   primary_item                  VARCHAR2(240)
275 ,   qa_collection                 VARCHAR2(240)
276 ,   reason                        VARCHAR2(240)
277 ,   repetitive_schedule           VARCHAR2(240)
278 ,   scrap_account                 VARCHAR2(240)
279 ,   source                        VARCHAR2(240)
280 ,   source_line                   VARCHAR2(240)
281 ,   to_department                 VARCHAR2(240)
282 ,   to_operation                  VARCHAR2(240)
283 ,   transaction                   VARCHAR2(240)
284 ,   transaction_link              VARCHAR2(240)
285 ,   wip_entity                    VARCHAR2(240)
286 );
287 
288 TYPE Shopfloormove_Val_Tbl_Type IS TABLE OF Shopfloormove_Val_Rec_Type
289     INDEX BY BINARY_INTEGER;
290 
291 --  Variables representing missing records and tables
292 
293 G_MISS_SHOPFLOORMOVE_REC      Shopfloormove_Rec_Type;
294 G_MISS_SHOPFLOORMOVE_VAL_REC  Shopfloormove_Val_Rec_Type;
295 G_MISS_SHOPFLOORMOVE_TBL      Shopfloormove_Tbl_Type;
296 G_MISS_SHOPFLOORMOVE_VAL_TBL  Shopfloormove_Val_Tbl_Type;
297 
298 -- The following records are used for defaulting procedures
299 TYPE Rcv_Txn_Type Is RECORD
300 (
301     comments                   VARCHAR2(240)
302 ,   creation_date              DATE
303 ,   created_by                 NUMBER
304 ,   currency_code              VARCHAR2(15)
305 ,   currency_conversion_date   DATE
306 ,   currency_conversion_rate   NUMBER
307 ,   currency_conversion_type   VARCHAR2(10)
308 ,   item_id		       NUMBER
309 ,   last_update_date           DATE
310 ,   last_update_login          NUMBER
311 ,   last_updated_by            NUMBER
312 ,   organization_id            NUMBER
313 ,   primary_unit_of_measure    VARCHAR2(25)
314 ,   po_header_id               NUMBER
315 ,   po_line_id                 NUMBER
316 ,   po_unit_price              NUMBER
317 ,   quantity 	               NUMBER
318 ,   unit_of_measure	       VARCHAR2(25)
319 ,   reason_id                  NUMBER
320 ,   source_doc_quantity	       NUMBER
321 ,   source_doc_unit_of_measure VARCHAR2(25)
322 ,   transaction_date           DATE
323 ,   wip_line_id                NUMBER
324 ,   wip_entity_id              NUMBER
325 ,   wip_operation_seq_num      NUMBER
326 ,   wip_repetitive_schedule_id NUMBER
327 ,   wip_resource_seq_num       NUMBER
328 );
329 
330 TYPE WIP_Op_Res_Type Is RECORD
331 (   activity_id             NUMBER
332 ,   autocharge_type         NUMBER
333 ,   basis_type              NUMBER
334 ,   resource_id             NUMBER
335 ,   std_rate_flag           NUMBER
336 ,   usage_rate_or_amount    NUMBER
337 ,   uom_code                VARCHAR2(3)
338 );
339 
340 TYPE PO_Dist_Type Is RECORD
341 (  project_id 		NUMBER
342 ,  task_id 		NUMBER
343 ,  nonrecoverable_tax	NUMBER
344 ,  primary_quantity_ordered	NUMBER
345 );
346 
347 TYPE BOM_Resource_Type Is RECORD
348 (  resource_code 	VARCHAR2(10)
349 ,  resource_type 	NUMBER
350 );
351 
352 TYPE OSP_Move_Details_Type IS RECORD
353 (
354   transaction_type	NUMBER
355 , primary_quantity	NUMBER
356 , transaction_quantity	NUMBER
357 , fm_operation_seq_num	NUMBER
358 , fm_intraop_step_type	NUMBER
359 , fm_department_id	NUMBER
360 , to_operation_seq_num	NUMBER
361 , to_intraop_step_type	NUMBER
362 , to_department_id	NUMBER
363 , move_direction	NUMBER
364 );
365 
366 G_MISS_RCV_TXN_REC      Rcv_Txn_Type;
367 G_MISS_WIP_OP_RES_REC   WIP_Op_Res_Type;
368 G_MISS_PO_DIST_REC      PO_Dist_Type;
369 G_MISS_BOM_RES_REC      BOM_Resource_Type;
370 G_MISS_OSP_MOVE_DET_REC OSP_Move_Details_Type;
371 
372 
373 --  Start of Comments
374 --  API name    Get_Transaction
375 --  Type        Public
376 --  Function
377 --
378 --  Pre-reqs
379 --
380 --  Parameters
381 --
382 --  Version     Current version = 1.0
383 --              Initial version = 1.0
384 --
385 --  Notes
386 --
387 --  End of Comments
388 
389 PROCEDURE Get_Transaction
390 (   p_api_version_number            IN  NUMBER
391 ,   p_init_msg_list                 IN  VARCHAR2 := NULL
392 ,   p_return_values                 IN  VARCHAR2 := NULL
393 ,   x_return_status                 OUT NOCOPY VARCHAR2
394 ,   x_msg_count                     OUT NOCOPY NUMBER
398 ,   x_WIPTransaction_val_tbl        OUT NOCOPY Wiptransaction_Val_Tbl_Type
395 ,   x_msg_data                      OUT NOCOPY VARCHAR2
396 ,   p_dummy                         IN  VARCHAR2
397 ,   x_WIPTransaction_tbl            OUT NOCOPY Wiptransaction_Tbl_Type
399 ,   x_Res_tbl                       OUT NOCOPY Res_Tbl_Type
400 ,   x_Res_val_tbl                   OUT NOCOPY Res_Val_Tbl_Type
401 ,   x_ShopFloorMove_tbl             OUT NOCOPY Shopfloormove_Tbl_Type
402 ,   x_ShopFloorMove_val_tbl         OUT NOCOPY Shopfloormove_Val_Tbl_Type
403 );
404 
405 END WIP_Transaction_PUB;