[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;