[Home] [Help]
PACKAGE: APPS.AHL_RM_OPERATION_PVT
Source
1 PACKAGE AHL_RM_OPERATION_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVOPES.pls 120.2.12020000.2 2012/12/07 01:18:49 sareepar ship $ */
3
4 TYPE operation_rec_type IS RECORD
5 (
6 OPERATION_ID NUMBER,
7 OBJECT_VERSION_NUMBER NUMBER,
8 LAST_UPDATE_DATE DATE,
9 LAST_UPDATED_BY NUMBER(15),
10 CREATION_DATE DATE,
11 CREATED_BY NUMBER(15),
12 LAST_UPDATE_LOGIN NUMBER(15),
13 STANDARD_OPERATION_FLAG VARCHAR2(1),
14 REVISION_NUMBER VARCHAR2(30),
15 REVISION_STATUS_CODE VARCHAR2(30),
16 REVISION_STATUS VARCHAR2(80),
17 ACTIVE_START_DATE DATE,
18 ACTIVE_END_DATE DATE,
19 QA_INSPECTION_TYPE VARCHAR2(150),
20 QA_INSPECTION_TYPE_DESC VARCHAR2(150),
21 OPERATION_TYPE_CODE VARCHAR2(30),
22 OPERATION_TYPE VARCHAR2(80),
23 PROCESS_CODE VARCHAR2(30),
24 PROCESS VARCHAR2(80),
25 --bachandr Enigma Phase I changes -- start
26 MODEL_CODE VARCHAR2(30),
27 MODEL_MEANING VARCHAR2(80),
28 ENIGMA_OP_ID VARCHAR2 (80),
29 --bachandr Enigma Phase I changes -- end
30 --pekambar Enigma Phase II changes -- start
31 ENIGMATYPE_CODE VARCHAR2(30),
32 ENIGMATYPE_MEANING VARCHAR2(80),
33 ENIGMA_DOC_ID VARCHAR2(80),
34 --pekambar Enigma Phase II changes -- end
35 DESCRIPTION VARCHAR2(2000),
36 REMARKS VARCHAR2(2000),
37 REVISION_NOTES VARCHAR2(2000),
38 CONCATENATED_SEGMENTS AHL_OPERATIONS_V.CONCATENATED_SEGMENTS%TYPE,
39 SEGMENT1 VARCHAR2(30),
40 SEGMENT2 VARCHAR2(30),
41 SEGMENT3 VARCHAR2(30),
42 SEGMENT4 VARCHAR2(30),
43 SEGMENT5 VARCHAR2(30),
44 SEGMENT6 VARCHAR2(30),
45 SEGMENT7 VARCHAR2(30),
46 SEGMENT8 VARCHAR2(30),
47 SEGMENT9 VARCHAR2(30),
48 SEGMENT10 VARCHAR2(30),
49 SEGMENT11 VARCHAR2(30),
50 SEGMENT12 VARCHAR2(30),
51 SEGMENT13 VARCHAR2(30),
52 SEGMENT14 VARCHAR2(30),
53 SEGMENT15 VARCHAR2(30),
54 ATTRIBUTE_CATEGORY VARCHAR2(30),
55 ATTRIBUTE1 VARCHAR2(150),
56 ATTRIBUTE2 VARCHAR2(150),
57 ATTRIBUTE3 VARCHAR2(150),
58 ATTRIBUTE4 VARCHAR2(150),
59 ATTRIBUTE5 VARCHAR2(150),
60 ATTRIBUTE6 VARCHAR2(150),
61 ATTRIBUTE7 VARCHAR2(150),
62 ATTRIBUTE8 VARCHAR2(150),
63 ATTRIBUTE9 VARCHAR2(150),
64 ATTRIBUTE10 VARCHAR2(150),
65 ATTRIBUTE11 VARCHAR2(150),
66 ATTRIBUTE12 VARCHAR2(150),
67 ATTRIBUTE13 VARCHAR2(150),
68 ATTRIBUTE14 VARCHAR2(150),
69 ATTRIBUTE15 VARCHAR2(150),
70 DML_OPERATION VARCHAR2(1)
71 );
72
73 -- Start of Comments
74 -- Procedure name : process_operation
75 -- Type : Private
76 -- Pre-reqs :
77 -- Function :
78 -- Parameters :
79 --
80 -- Standard IN Parameters :
81 -- p_api_version NUMBER Required
82 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
83 -- p_commit VARCHAR2 Default FND_API.G_FALSE
84 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
85 -- p_default VARCHAR2 Default FND_API.G_TRUE
86 -- p_module_type VARCHAR2 Default NULL
87 --
88 -- Standard OUT Parameters :
89 -- x_return_status VARCHAR2 Required
90 -- x_msg_count NUMBER Required
91 -- x_msg_data VARCHAR2 Required
92 --
93 -- process_operation IN parameters:
94 -- None
95 --
96 -- process_operation IN OUT parameters:
97 -- p_x_operation_rec operation_rec_type Required
98 --
99 -- process_operation OUT parameters:
100 -- None
101 --
102 -- Version:
103 -- Current version 1.0
104 --
105 -- End of Comments
106
107 PROCEDURE process_operation
108 (
109 p_api_version IN NUMBER := 1.0,
110 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
111 p_commit IN VARCHAR2 := FND_API.G_FALSE,
112 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113 p_default IN VARCHAR2 := FND_API.G_FALSE,
114 p_module_type IN VARCHAR2 := NULL,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_x_operation_rec IN OUT NOCOPY operation_rec_type
119 );
120
121 -- Start of Comments
122 -- Procedure name : delete_operation
123 -- Type : Private
124 -- Pre-reqs :
125 -- Function :
126 -- Parameters :
127 --
128 -- Standard IN Parameters :
129 -- p_api_version NUMBER Required
130 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
131 -- p_commit VARCHAR2 Default FND_API.G_FALSE
132 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
133 -- p_default VARCHAR2 Default FND_API.G_TRUE
134 -- p_module_type VARCHAR2 Default NULL
135 --
136 -- Standard OUT Parameters :
137 -- x_return_status VARCHAR2 Required
138 -- x_msg_count NUMBER Required
139 -- x_msg_data VARCHAR2 Required
140 --
141 -- delete_operation IN parameters:
142 -- p_operation_id NUMBER Required
143 -- p_object_version_number NUMBER Required
144 --
145 -- delete_operation IN OUT parameters:
146 -- None
147 --
148 -- delete_operation OUT parameters:
149 -- None
150 --
151 -- Version:
152 -- Current version 1.0
153 --
154 -- End of Comments
155
156 PROCEDURE delete_operation
157 (
158 p_api_version IN NUMBER := 1.0,
159 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
160 p_commit IN VARCHAR2 := FND_API.G_FALSE,
161 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162 p_default IN VARCHAR2 := FND_API.G_FALSE,
163 p_module_type IN VARCHAR2 := NULL,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_operation_id IN NUMBER,
168 p_object_version_number IN NUMBER
169 );
170
171 -- Start of Comments
172 -- Procedure name : create_oper_revision
173 -- Type : Private
174 -- Pre-reqs :
175 -- Function :
176 -- Parameters :
177 --
178 -- Standard IN Parameters :
179 -- p_api_version NUMBER Required
180 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
181 -- p_commit VARCHAR2 Default FND_API.G_FALSE
182 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
183 -- p_default VARCHAR2 Default FND_API.G_TRUE
184 -- p_module_type VARCHAR2 Default NULL
185 --
186 -- Standard OUT Parameters :
187 -- x_return_status VARCHAR2 Required
188 -- x_msg_count NUMBER Required
189 -- x_msg_data VARCHAR2 Required
190 --
191 -- create_oper_revision IN parameters:
192 -- p_operation_id NUMBER Required
193 -- p_object_version_number NUMBER Required
194 --
195 -- create_oper_revision IN OUT parameters:
196 -- None
197 --
198 -- create_oper_revision OUT parameters:
199 -- x_operation_id NUMBER Required
200 --
201 -- Version:
202 -- Current version 1.0
203 --
204 -- End of Comments
205
206 PROCEDURE create_oper_revision
207 (
208 p_api_version IN NUMBER := 1.0,
209 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
210 p_commit IN VARCHAR2 := FND_API.G_FALSE,
211 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212 p_default IN VARCHAR2 := FND_API.G_FALSE,
213 p_module_type IN VARCHAR2 := NULL,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_operation_id IN NUMBER,
218 p_object_version_number IN NUMBER,
219 x_operation_id OUT NOCOPY NUMBER
220 );
221
222 END AHL_RM_OPERATION_PVT;