[Home] [Help]
PACKAGE: APPS.EAM_MAT_REQ_UTILITY_PVT
Source
1 PACKAGE EAM_MAT_REQ_UTILITY_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVMRUS.pls 115.2 2003/06/11 06:20:41 agaurav ship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVMRUS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_MAT_REQ_UTILITY_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 12-JUN-2002 Kenichi Nagumo Initial Creation
21 ***************************************************************************/
22
23 PROCEDURE Query_Row
24 ( p_wip_entity_id IN NUMBER
25 , p_organization_id IN NUMBER
26 , p_operation_seq_num IN NUMBER
27 , p_inventory_item_id IN NUMBER
28 , x_eam_mat_req_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
29 , x_Return_status OUT NOCOPY VARCHAR2
30 );
31
32 PROCEDURE Insert_Row
33 ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
34 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
35 , x_return_Status OUT NOCOPY VARCHAR2
36 );
37
38 PROCEDURE Update_Row
39 ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
40 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
41 , x_return_Status OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE Delete_Row
45 ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
46 , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
47 , x_return_Status OUT NOCOPY VARCHAR2
48 );
49
50 PROCEDURE Perform_Writes
51 ( p_eam_mat_req_rec IN EAM_PROCESS_WO_PUB.eam_mat_req_rec_type
52 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
53 , x_return_status OUT NOCOPY VARCHAR2
54 );
55
56 FUNCTION NUM_OF_ROW
57 ( p_wip_entity_id NUMBER
58 , p_organization_id NUMBER
59 , p_operation_seq_num NUMBER
60 ) RETURN BOOLEAN ;
61
62
63 END EAM_MAT_REQ_UTILITY_PVT;