[Home] [Help]
PACKAGE: APPS.EAM_PROCESS_PERMIT_PVT
Source
1 PACKAGE EAM_PROCESS_PERMIT_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVWPTS.pls 120.2 2011/03/04 21:22:02 mashah noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2009 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME: EAMVWPTS.pls
9 --
10 -- DESCRIPTION: Spec of package EAM_PROCESS_PERMIT_PVT
11 --
12 -- NOTES
13 --
14 -- HISTORY
15 --
16 -- 25-JAN-2009 Madhuri Shah Initial Creation
17 ***************************************************************************/
18
19 PROCEDURE VALIDATE_TRANSACTION_TYPE(
20 p_validation_level IN NUMBER
21 , p_entity IN VARCHAR2
22 , x_return_status OUT NOCOPY VARCHAR2
23 , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
24 );
25
26 /************************************************************
27 * Procedure : PROCESS_WORK_PERMIT
28 * Purpose : This will process create/update/delete on work permit
29 ************************************************************/
30 PROCEDURE PROCESS_WORK_PERMIT
31 ( p_bo_identifier IN VARCHAR2 := 'EAM'
32 , p_api_version_number IN NUMBER := 1.0
33 , p_init_msg_list IN BOOLEAN := FALSE
34 , p_commit IN VARCHAR2 := 'N'
35 , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
36 , p_permit_wo_association_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
37 , p_permit_clearance_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
38 , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
39 , x_return_status OUT NOCOPY VARCHAR2
40 , x_msg_count OUT NOCOPY NUMBER
41 , p_debug IN VARCHAR2 := 'N'
42 , p_output_dir IN VARCHAR2 := NULL
43 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
44 , p_debug_file_mode IN VARCHAR2 := 'w'
45 );
46
47 /************************************************************
48 * Procedure : WORK_PERMIT
49 * Purpose : This will process work permit header
50 ************************************************************/
51 PROCEDURE WORK_PERMIT
52 (
53 p_validation_level IN NUMBER
54 , p_work_permit_id IN NUMBER :=NULL
55 , p_organization_id IN NUMBER :=NULL
56 , p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
57 , x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
58 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
59 , x_return_status OUT NOCOPY VARCHAR2
60 );
61
62 /********************************************************************
63 * Procedure: Raise_Workflow_Events
64 * Purpose: This procedure raises the workflow events for work permit release
65 *********************************************************************/
66 PROCEDURE RAISE_WORKFLOW_EVENTS
67 ( p_api_version IN NUMBER
68 , p_validation_level IN NUMBER
69 , p_eam_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
70 , p_old_eam_wp_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
71 , p_approval_required IN BOOLEAN
72 , p_new_system_status IN NUMBER
73 , p_workflow_name IN VARCHAR2
74 , p_workflow_process IN VARCHAR2
75 , x_mesg_token_tbl IN OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
76 , x_return_status IN OUT NOCOPY VARCHAR2
77 );
78
79 /**************************************************************************
80 * Procedure: COPY_WORK_PERMIT
81 * Purpose: Procedure to copy work permit record.
82 * This procedure will be called from the public API
83 ***************************************************************************/
84
85 PROCEDURE COPY_WORK_PERMIT(
86 p_bo_identifier IN VARCHAR2 := 'EAM'
87 , p_api_version_number IN NUMBER := 1.0
88 , p_init_msg_list IN BOOLEAN := FALSE
89 , p_commit IN VARCHAR2 := 'N'
90 , p_debug IN VARCHAR2 := 'N'
91 , p_output_dir IN VARCHAR2 := NULL
92 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
93 , p_debug_file_mode IN VARCHAR2 := 'w'
94 , p_org_id IN NUMBER
95 , px_permit_id IN OUT NOCOPY NUMBER
96 , x_return_status OUT NOCOPY VARCHAR2
97 , x_msg_count OUT NOCOPY NUMBER
98
99 );
100
101 END EAM_PROCESS_PERMIT_PVT;
102