1 PACKAGE EAM_WO_QUA_UTILITY_PVT AS
2 /* $Header: EAMVWQUS.pls 120.1 2005/08/25 08:38:43 mmaduska noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVWQUS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_WO_QUA_UTILITY_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 14-FEB-2005 mmaduska Initial Creation
21 ***************************************************************************/
22
23 /*
24 * The procedure is getting called when user passes quality records
25 * during work order completion and operation completion
26 * The procedure does the actual data base operations depending on the record passed
27 */
28
29 PROCEDURE Perform_Writes
30 (
31 p_eam_request_rec IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
34 );
35
36 /*
37 * The procedure is getting called when user passes quality records
38 * during work order completion and operation completion
39 * The procedure enters the data into quality table QA_RESULTS
40 */
41
42 PROCEDURE insert_row
43 (
44 p_collection_id IN NUMBER
45 , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
46 , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
49 );
50
51 END EAM_WO_QUA_UTILITY_PVT;