[Home] [Help]
PACKAGE: APPS.AHL_RM_OPERATION_PVT
Source
1 PACKAGE AHL_RM_OPERATION_PVT AS
2 /* $Header: AHLVOPES.pls 120.0.12010000.2 2008/11/23 14:25:14 bachandr 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 DESCRIPTION VARCHAR2(2000),
31 REMARKS VARCHAR2(2000),
32 REVISION_NOTES VARCHAR2(2000),
33 CONCATENATED_SEGMENTS AHL_OPERATIONS_V.CONCATENATED_SEGMENTS%TYPE,
34 SEGMENT1 VARCHAR2(30),
35 SEGMENT2 VARCHAR2(30),
36 SEGMENT3 VARCHAR2(30),
37 SEGMENT4 VARCHAR2(30),
38 SEGMENT5 VARCHAR2(30),
39 SEGMENT6 VARCHAR2(30),
40 SEGMENT7 VARCHAR2(30),
41 SEGMENT8 VARCHAR2(30),
42 SEGMENT9 VARCHAR2(30),
43 SEGMENT10 VARCHAR2(30),
44 SEGMENT11 VARCHAR2(30),
45 SEGMENT12 VARCHAR2(30),
46 SEGMENT13 VARCHAR2(30),
47 SEGMENT14 VARCHAR2(30),
48 SEGMENT15 VARCHAR2(30),
49 ATTRIBUTE_CATEGORY VARCHAR2(30),
50 ATTRIBUTE1 VARCHAR2(150),
51 ATTRIBUTE2 VARCHAR2(150),
52 ATTRIBUTE3 VARCHAR2(150),
53 ATTRIBUTE4 VARCHAR2(150),
54 ATTRIBUTE5 VARCHAR2(150),
55 ATTRIBUTE6 VARCHAR2(150),
56 ATTRIBUTE7 VARCHAR2(150),
57 ATTRIBUTE8 VARCHAR2(150),
58 ATTRIBUTE9 VARCHAR2(150),
59 ATTRIBUTE10 VARCHAR2(150),
60 ATTRIBUTE11 VARCHAR2(150),
61 ATTRIBUTE12 VARCHAR2(150),
62 ATTRIBUTE13 VARCHAR2(150),
63 ATTRIBUTE14 VARCHAR2(150),
64 ATTRIBUTE15 VARCHAR2(150),
65 DML_OPERATION VARCHAR2(1)
66 );
67
68 -- Start of Comments
69 -- Procedure name : process_operation
70 -- Type : Private
71 -- Pre-reqs :
72 -- Function :
73 -- Parameters :
74 --
75 -- Standard IN Parameters :
76 -- p_api_version NUMBER Required
77 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
78 -- p_commit VARCHAR2 Default FND_API.G_FALSE
79 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
80 -- p_default VARCHAR2 Default FND_API.G_TRUE
81 -- p_module_type VARCHAR2 Default NULL
82 --
83 -- Standard OUT Parameters :
84 -- x_return_status VARCHAR2 Required
85 -- x_msg_count NUMBER Required
86 -- x_msg_data VARCHAR2 Required
87 --
88 -- process_operation IN parameters:
89 -- None
90 --
91 -- process_operation IN OUT parameters:
92 -- p_x_operation_rec operation_rec_type Required
93 --
94 -- process_operation OUT parameters:
95 -- None
96 --
97 -- Version:
98 -- Current version 1.0
99 --
100 -- End of Comments
101
102 PROCEDURE process_operation
103 (
104 p_api_version IN NUMBER := 1.0,
105 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
106 p_commit IN VARCHAR2 := FND_API.G_FALSE,
107 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108 p_default IN VARCHAR2 := FND_API.G_FALSE,
109 p_module_type IN VARCHAR2 := NULL,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_x_operation_rec IN OUT NOCOPY operation_rec_type
114 );
115
116 -- Start of Comments
117 -- Procedure name : delete_operation
118 -- Type : Private
119 -- Pre-reqs :
120 -- Function :
121 -- Parameters :
122 --
123 -- Standard IN Parameters :
124 -- p_api_version NUMBER Required
125 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
126 -- p_commit VARCHAR2 Default FND_API.G_FALSE
127 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
128 -- p_default VARCHAR2 Default FND_API.G_TRUE
129 -- p_module_type VARCHAR2 Default NULL
130 --
131 -- Standard OUT Parameters :
132 -- x_return_status VARCHAR2 Required
133 -- x_msg_count NUMBER Required
134 -- x_msg_data VARCHAR2 Required
135 --
136 -- delete_operation IN parameters:
137 -- p_operation_id NUMBER Required
138 -- p_object_version_number NUMBER Required
139 --
140 -- delete_operation IN OUT parameters:
141 -- None
142 --
143 -- delete_operation OUT parameters:
144 -- None
145 --
146 -- Version:
147 -- Current version 1.0
148 --
149 -- End of Comments
150
151 PROCEDURE delete_operation
152 (
153 p_api_version IN NUMBER := 1.0,
154 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
155 p_commit IN VARCHAR2 := FND_API.G_FALSE,
156 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157 p_default IN VARCHAR2 := FND_API.G_FALSE,
158 p_module_type IN VARCHAR2 := NULL,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_operation_id IN NUMBER,
163 p_object_version_number IN NUMBER
164 );
165
166 -- Start of Comments
167 -- Procedure name : create_oper_revision
168 -- Type : Private
169 -- Pre-reqs :
170 -- Function :
171 -- Parameters :
172 --
173 -- Standard IN Parameters :
174 -- p_api_version NUMBER Required
175 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
176 -- p_commit VARCHAR2 Default FND_API.G_FALSE
177 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
178 -- p_default VARCHAR2 Default FND_API.G_TRUE
179 -- p_module_type VARCHAR2 Default NULL
180 --
181 -- Standard OUT Parameters :
182 -- x_return_status VARCHAR2 Required
183 -- x_msg_count NUMBER Required
184 -- x_msg_data VARCHAR2 Required
185 --
186 -- create_oper_revision IN parameters:
187 -- p_operation_id NUMBER Required
188 -- p_object_version_number NUMBER Required
189 --
190 -- create_oper_revision IN OUT parameters:
191 -- None
192 --
193 -- create_oper_revision OUT parameters:
194 -- x_operation_id NUMBER Required
195 --
196 -- Version:
197 -- Current version 1.0
198 --
199 -- End of Comments
200
201 PROCEDURE create_oper_revision
202 (
203 p_api_version IN NUMBER := 1.0,
204 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
205 p_commit IN VARCHAR2 := FND_API.G_FALSE,
206 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207 p_default IN VARCHAR2 := FND_API.G_FALSE,
208 p_module_type IN VARCHAR2 := NULL,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_operation_id IN NUMBER,
213 p_object_version_number IN NUMBER,
214 x_operation_id OUT NOCOPY NUMBER
215 );
216
217 END AHL_RM_OPERATION_PVT;