PACKAGE: APPS.EAM_CLEARANCE_VALIDATE_PVT

Source

1 PACKAGE EAM_CLEARANCE_VALIDATE_PVT AUTHID CURRENT_USER AS
2   /* $Header: EAMVCLVS.pls 120.0 2011/03/04 00:42:51 mashah noship $ */
3   /***************************************************************************
4   --
5   --  Copyright (c) 2011 Oracle Corporation, Redwood Shores, CA, USA
6   --  All rights reserved.
7   --
8   --  FILENAME: EAMVCLVS.pls
9   --
10   --  DESCRIPTION: Spec of package EAM_CLEARANCE_VALIDATE_PVT
11   --
12   --  NOTES
13   --
14   --  HISTORY
15   --
16   --
17   ***************************************************************************/
18   -- g_debug_flag            VARCHAR2(1) := 'N';
19 
20 
21 /********************************************************************
22 * Procedure     : Check_Existence
23 * Purpose       : Procedure will query the old work clearance
24                   record and return it in old record variables.
25 *********************************************************************/
26 PROCEDURE CHECK_EXISTENCE
27   (   p_work_clearance_header_rec    IN  EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
28     , x_clearance_header_rec    OUT NOCOPY  EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
29     , x_mesg_token_Tbl     OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
30     , x_return_Status      OUT NOCOPY VARCHAR2
31   );
32 
33 
34 
35 /********************************************************************
36 * Procedure: Check_Attributes
37 * Purpose: Check_Attributes procedure will validate every
38            Revised item attribute in its entirely.
39 *********************************************************************/
40 PROCEDURE CHECK_ATTRIBUTES
41   (   p_work_clearance_header_rec    IN  EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
42     , p_old_clearance_header_rec    IN  EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
43     , x_mesg_token_Tbl     OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
44     , x_return_Status      OUT NOCOPY VARCHAR2
45   );
46 
47 
48 /********************************************************************
49 * Procedure     : Check_Required
50 * Purpose       : Check_Required procedure will check the existence
51                   of mandatory attributes.
52 *********************************************************************/
53 PROCEDURE CHECK_REQUIRED
54  (   p_work_clearance_header_rec    IN  EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
55    , x_mesg_token_Tbl     OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
56    , x_return_Status      OUT NOCOPY VARCHAR2
57   );
58 
59 END EAM_CLEARANCE_VALIDATE_PVT ;
60