[Home] [Help]
PACKAGE: APPS.EAM_PROCESS_PERMIT_PUB
Source
1 PACKAGE EAM_PROCESS_PERMIT_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPWPTS.pls 120.1 2010/10/11 23:54:50 mashah noship $ */
3
4 /***************************************************************************
5 --
6 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
7 -- All rights reserved.
8 --
9 -- FILENAME: EAMPWPTS.pls
10 --
11 -- DESCRIPTION: Spec of package EAM_PROCESS_PERMIT_PUB
12 --
13 -- NOTES
14 --
15 -- HISTORY
16 --
17 -- 25-JAN-2009 Madhuri Shah Initial Creation
18 ***************************************************************************/
19
20 -- g_debug_flag VARCHAR2(1) := 'N';
21
22 Type eam_wp_header_rec_type is record
23 (
24 HEADER_ID NUMBER :=NULL,
25 BATCH_ID NUMBER :=NULL,
26 ROW_ID NUMBER :=NULL,
27 TRANSACTION_TYPE NUMBER :=NULL,
28 PERMIT_ID NUMBER :=NULL,
29 PERMIT_NAME VARCHAR2(240) :=NULL,
30 PERMIT_TYPE NUMBER :=NULL,
31 DESCRIPTION VARCHAR2(240) :=NULL,
32 ORGANIZATION_ID NUMBER :=NULL,
33 STATUS_TYPE NUMBER :=NULL, --lookup
34 VALID_FROM DATE :=NULL,
35 VALID_TO DATE :=NULL,
36 PENDING_FLAG VARCHAR2(1) :=NULL,
37 COMPLETION_DATE DATE :=NULL,
38 USER_DEFINED_STATUS_ID NUMBER :=NULL,
39 ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL,
40 ATTRIBUTE1 VARCHAR2(240) :=NULL,
41 ATTRIBUTE2 VARCHAR2(240) :=NULL,
42 ATTRIBUTE3 VARCHAR2(240) :=NULL,
43 ATTRIBUTE4 VARCHAR2(240) :=NULL,
44 ATTRIBUTE5 VARCHAR2(240) :=NULL,
45 ATTRIBUTE6 VARCHAR2(240) :=NULL,
46 ATTRIBUTE7 VARCHAR2(240) :=NULL,
47 ATTRIBUTE8 VARCHAR2(240) :=NULL,
48 ATTRIBUTE9 VARCHAR2(240) :=NULL,
49 ATTRIBUTE10 VARCHAR2(240) :=NULL,
50 ATTRIBUTE11 VARCHAR2(240) :=NULL,
51 ATTRIBUTE12 VARCHAR2(240) :=NULL,
52 ATTRIBUTE13 VARCHAR2(240) :=NULL,
53 ATTRIBUTE14 VARCHAR2(240) :=NULL,
54 ATTRIBUTE15 VARCHAR2(240) :=NULL,
55 ATTRIBUTE16 VARCHAR2(240) :=NULL,
56 ATTRIBUTE17 VARCHAR2(240) :=NULL,
57 ATTRIBUTE18 VARCHAR2(240) :=NULL,
58 ATTRIBUTE19 VARCHAR2(240) :=NULL,
59 ATTRIBUTE20 VARCHAR2(240) :=NULL,
60 ATTRIBUTE21 VARCHAR2(240) :=NULL,
61 ATTRIBUTE22 VARCHAR2(240) :=NULL,
62 ATTRIBUTE23 VARCHAR2(240) :=NULL,
63 ATTRIBUTE24 VARCHAR2(240) :=NULL,
64 ATTRIBUTE25 VARCHAR2(240) :=NULL,
65 ATTRIBUTE26 VARCHAR2(240) :=NULL,
66 ATTRIBUTE27 VARCHAR2(240) :=NULL,
67 ATTRIBUTE28 VARCHAR2(240) :=NULL,
68 ATTRIBUTE29 VARCHAR2(240) :=NULL,
69 ATTRIBUTE30 VARCHAR2(240) :=NULL,
70 APPROVED_BY NUMBER :=NULL,
71 CREATED_BY NUMBER :=NULL,
72 CREATION_DATE DATE :=NULL,
73 USER_ID NUMBER :=NULL,
74 RESPONSIBILITY_ID NUMBER :=NULL
75 );
76
77 Type eam_wp_association_rec_type is record
78 (
79 HEADER_ID NUMBER :=NULL,
80 BATCH_ID NUMBER :=NULL,
81 ROW_ID NUMBER :=NULL,
82 TRANSACTION_TYPE NUMBER :=NULL,
83 SAFETY_ASSOCIATION_ID NUMBER :=NULL,
84 SOURCE_ID NUMBER :=NULL, -- wip_entity_id
85 TARGET_REF_ID NUMBER :=NULL,
86 ASSOCIATION_TYPE NUMBER :=NULL,
87 ATTRIBUTE_CATEGORY VARCHAR2(30) :=NULL,
88 ATTRIBUTE1 VARCHAR2(240) :=NULL,
89 ATTRIBUTE2 VARCHAR2(240) :=NULL,
90 ATTRIBUTE3 VARCHAR2(240) :=NULL,
91 ATTRIBUTE4 VARCHAR2(240) :=NULL,
92 ATTRIBUTE5 VARCHAR2(240) :=NULL,
93 ATTRIBUTE6 VARCHAR2(240) :=NULL,
94 ATTRIBUTE7 VARCHAR2(240) :=NULL,
95 ATTRIBUTE8 VARCHAR2(240) :=NULL,
96 ATTRIBUTE9 VARCHAR2(240) :=NULL,
97 ATTRIBUTE10 VARCHAR2(240) :=NULL,
98 ATTRIBUTE11 VARCHAR2(240) :=NULL,
99 ATTRIBUTE12 VARCHAR2(240) :=NULL,
100 ATTRIBUTE13 VARCHAR2(240) :=NULL,
101 ATTRIBUTE14 VARCHAR2(240) :=NULL,
102 ATTRIBUTE15 VARCHAR2(240) :=NULL,
103 ATTRIBUTE16 VARCHAR2(240) :=NULL,
104 ATTRIBUTE17 VARCHAR2(240) :=NULL,
105 ATTRIBUTE18 VARCHAR2(240) :=NULL,
106 ATTRIBUTE19 VARCHAR2(240) :=NULL,
107 ATTRIBUTE20 VARCHAR2(240) :=NULL,
108 ATTRIBUTE21 VARCHAR2(240) :=NULL,
109 ATTRIBUTE22 VARCHAR2(240) :=NULL,
110 ATTRIBUTE23 VARCHAR2(240) :=NULL,
111 ATTRIBUTE24 VARCHAR2(240) :=NULL,
112 ATTRIBUTE25 VARCHAR2(240) :=NULL,
113 ATTRIBUTE26 VARCHAR2(240) :=NULL,
114 ATTRIBUTE27 VARCHAR2(240) :=NULL,
115 ATTRIBUTE28 VARCHAR2(240) :=NULL,
116 ATTRIBUTE29 VARCHAR2(240) :=NULL,
117 ATTRIBUTE30 VARCHAR2(240) :=NULL,
118 CREATED_BY NUMBER :=NULL,
119 CREATION_DATE DATE :=NULL
120 );
121
122
123 Type eam_wp_tbl_type is table of eam_wp_header_rec_type
124 INDEX BY BINARY_INTEGER;
125
126 Type eam_wp_association_tbl_type is table of eam_wp_association_rec_type
127 INDEX BY BINARY_INTEGER;
128
129
130
131 /**************************************************************************
132 * Procedure: PROCESS_WORK_PERMIT
133 * Purpose: Procedure to process work permit record.
134 * This procedure will call private the procedure PROCESS_WORK_PERMIT
135 * in the EAM_PROCES_PERMIT_PVT API.
136 ***************************************************************************/
137
138
139 PROCEDURE PROCESS_WORK_PERMIT
140 ( p_bo_identifier IN VARCHAR2 := 'EAM'
141 , p_api_version_number IN NUMBER := 1.0
142 , p_init_msg_list IN BOOLEAN := FALSE
143 , p_commit IN VARCHAR2 := 'N'
144 , p_work_permit_header_rec IN EAM_PROCESS_PERMIT_PUB.eam_wp_header_rec_type
145 , p_permit_wo_association_tbl IN EAM_PROCESS_PERMIT_PUB.eam_wp_association_tbl_type
146 , p_debug IN VARCHAR2 := 'N'
147 , p_output_dir IN VARCHAR2 := NULL
148 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
149 , p_debug_file_mode IN VARCHAR2 := 'w'
150 , x_permit_id OUT NOCOPY NUMBER
151 , x_return_status OUT NOCOPY VARCHAR2
152 , x_msg_count OUT NOCOPY NUMBER
153 );
154
155
156 /**************************************************************************
157 * Procedure: COPY_WORK_PERMIT
158 * Purpose: Procedure to copy work permit record.
159 * This procedure will call private the procedure PROCESS_WORK_PERMIT
160 * in the EAM_PROCES_PERMIT_PVT API.
161 ***************************************************************************/
162
163 PROCEDURE COPY_WORK_PERMIT(
164 p_bo_identifier IN VARCHAR2 := 'EAM'
165 , p_api_version_number IN NUMBER := 1.0
166 , p_init_msg_list IN BOOLEAN := FALSE
167 , p_commit IN VARCHAR2 := 'N'
168 , p_debug IN VARCHAR2 := 'N'
169 , p_output_dir IN VARCHAR2 := NULL
170 , p_debug_filename IN VARCHAR2 := 'EAM_SAFETY_DEBUG.log'
171 , p_debug_file_mode IN VARCHAR2 := 'w'
172 , p_org_id IN NUMBER
173 , px_permit_id IN OUT NOCOPY NUMBER
174 , x_return_status OUT NOCOPY VARCHAR2
175 , x_msg_count OUT NOCOPY NUMBER
176 );
177
178 END EAM_PROCESS_PERMIT_PUB;
179