[Home] [Help]
PACKAGE: APPS.EAM_PROCESS_CLEARANCE_PVT
Source
1 PACKAGE EAM_PROCESS_CLEARANCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVWCLS.pls 120.0 2011/03/04 01:04:23 mashah noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2011 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME: EAMVWCLS.pls
9 --
10 -- DESCRIPTION: Spec of package EAM_PROCESS_CLEARANCE_PVT
11 --
12 -- NOTES
13 --
14 -- HISTORY
15 --
16 --
17 ***************************************************************************/
18 -- g_debug_flag VARCHAR2(1) := 'N';
19
20 /**************************************************************************
21 * Procedure : PROCESS_WORK_CLEARANCE
22 * Purpose : This will process create/update/delete on work clearance
23 ***************************************************************************/
24 PROCEDURE PROCESS_WORK_CLEARANCE
25 ( p_bo_identifier IN VARCHAR2 := 'EAM'
26 , p_api_version_number IN NUMBER := 1.0
27 , p_init_msg_list IN BOOLEAN := FALSE
28 , p_commit IN VARCHAR2 := 'N'
29 , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
30 , p_clearance_establishment_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
31 , p_clearance_re_estabish_tbl IN EAM_PROCESS_SAFETY_PUB.eam_establishment_tbl_type
32 , p_clearance_workorder_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
33 , p_clearance_permit_asso_tbl IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type
34 , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
35 , x_return_status OUT NOCOPY VARCHAR2
36 , x_msg_count OUT NOCOPY NUMBER
37 , p_debug IN VARCHAR2 := 'N'
38 , p_output_dir IN VARCHAR2 := NULL
39 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
40 , p_debug_file_mode IN VARCHAR2 := 'w'
41 );
42
43
44 /**************************************************************************
45 * Procedure : WORK_CLEARANCE
46 * Purpose : This will process work clearance header
47 ***************************************************************************/
48 PROCEDURE WORK_CLEARANCE
49 ( p_validation_level IN NUMBER
50 , p_work_clearance_id IN NUMBER
51 , p_organization_id IN NUMBER
52 , p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
53 , x_work_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
54 , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.MESG_TOKEN_TBL_TYPE
55 , x_return_status OUT NOCOPY VARCHAR2
56 );
57
58
59 /********************************************************************
60 * Procedure: Raise_Workflow_Events
61 *Purpose: This procedure raises the workflow events for clearance release
62 *********************************************************************/
63 PROCEDURE RAISE_WORKFLOW_EVENTS
64 ( p_api_version IN NUMBER
65 , p_validation_level IN NUMBER
66 , p_eam_wc_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
67 , p_old_eam_wc_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
68 , p_approval_required IN BOOLEAN
69 , p_new_system_status IN NUMBER
70 , p_workflow_name IN VARCHAR2
71 , p_workflow_process IN VARCHAR2
72 , x_mesg_token_tbl IN OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
73 , x_return_status IN OUT NOCOPY VARCHAR2
74 );
75
76 /*********************************************************
77 * Procedure : Validate_Transaction_Type
78 * Purpose : This procedure will check if the transaction type is valid
79 for a particular entity.
80 *********************************************************/
81 PROCEDURE VALIDATE_TRANSACTION_TYPE(
82 p_validation_level IN NUMBER
83 , p_entity IN VARCHAR2
84 , x_return_status OUT NOCOPY VARCHAR2
85 , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
86 );
87
88 /**************************************************************************
89 * Procedure: COPY_WORK_CLEARANCE
90 * Purpose: Procedure to copy work clearance record.
91 *
92 ***************************************************************************/
93
94 PROCEDURE COPY_WORK_CLEARANCE(
95 p_bo_identifier IN VARCHAR2 := 'EAM'
96 , p_api_version_number IN NUMBER := 1.0
97 , p_init_msg_list IN BOOLEAN := FALSE
98 , p_commit IN VARCHAR2 := 'N'
99 , p_debug IN VARCHAR2 := 'N'
100 , p_output_dir IN VARCHAR2 := NULL
101 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
102 , p_debug_file_mode IN VARCHAR2 := 'w'
103 , p_org_id IN NUMBER
104 , px_clearance_id IN OUT NOCOPY NUMBER
105 , x_return_status OUT NOCOPY VARCHAR2
106 , x_msg_count OUT NOCOPY NUMBER
107
108 );
109
110 END EAM_PROCESS_CLEARANCE_PVT;
111