DBA Data[Home] [Help]

PACKAGE: APPS.EAM_WO_COMP_UTILITY_PVT

Source


1 PACKAGE EAM_WO_COMP_UTILITY_PVT AS
2 /* $Header: EAMVWCUS.pls 120.1 2005/10/21 16:51:16 baroy noship $ */
3 /***************************************************************************
4 --
5 --  Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 --  All rights reserved.
7 --
8 --  FILENAME
9 --
10 --      EAMVWCUS.pls
11 --
12 --  DESCRIPTION
13 --
14 --      Spec of package EAM_WO_COMP_UTILITY_PVT
15 --
16 --  NOTES
17 --
18 --  HISTORY
19 --
20 --  14-FEB-2005    mmaduska     Initial Creation
21 ***************************************************************************/
22 
23 PROCEDURE Perform_Writes (
24 	p_eam_wo_comp_rec	IN  EAM_PROCESS_WO_PUB. eam_wo_comp_rec_type
25 	, x_return_status       OUT NOCOPY  VARCHAR2
26 	, x_mesg_token_tbl      OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
27   );
28 
29 PROCEDURE insert_row (
30 	p_eam_wo_comp_rec     IN  EAM_PROCESS_WO_PUB. eam_wo_comp_rec_type
31 	, x_return_status     OUT NOCOPY  VARCHAR2
32 	, x_mesg_token_tbl    OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
33  );
34 
35 PROCEDURE update_row (
36 	  p_eam_wo_comp_rec     IN  EAM_PROCESS_WO_PUB. eam_wo_comp_rec_type
37         , x_return_status       OUT NOCOPY  VARCHAR2
38 	, x_mesg_token_tbl      OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
39 );
40 
41 INVENTORY_ITEM_NULL EAM_WorkOrderTransactions_PUB.Inventory_Item_Tbl_Type;
42 
43 TYPE Lot_Serial_Rec_Type is RECORD
44 (
45 	lot_number		VARCHAR2(80),
46 	serial_number		VARCHAR2(30),
47 	quantity		NUMBER
48 );
49 
50 TYPE Lot_Serial_Tbl_Type is TABLE OF Lot_Serial_Rec_Type INDEX BY BINARY_INTEGER;
51 
52 END EAM_WO_COMP_UTILITY_PVT;