[Home] [Help]
PACKAGE: APPS.AHL_RM_ROUTE_PVT
Source
1 PACKAGE AHL_RM_ROUTE_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVROMS.pls 120.4.12020000.2 2012/12/07 13:43:25 sareepar ship $ */
3
4 TYPE route_rec_type IS RECORD
5 (
6 ROUTE_ID NUMBER,
7 OBJECT_VERSION_NUMBER NUMBER,
8 ROUTE_NO VARCHAR2(30),
9 TITLE VARCHAR2(240),
10 ROUTE_TYPE_CODE VARCHAR2(30),
11 ROUTE_TYPE VARCHAR2(80),
12 --bachandr Enigma Phase I changes -- start
13 MODEL_CODE VARCHAR2(30),
14 MODEL_MEANING VARCHAR2(80),
15 ENIGMA_DOC_ID VARCHAR2(80),
16 ENIGMA_ROUTE_ID VARCHAR2(80),
17 ENIGMA_PUBLISH_DATE DATE,
18 FILE_ID NUMBER,
19 --bachandr Enigma Phase I changes -- end
20 --snarkhed Enigma Phase II changes --start
21 ENIGMA_SOURCE_CODE VARCHAR2(30),
22 ENIGMA_SOURCE_MEANING VARCHAR2(80),
23 JOB_CARD_LYT_CODE VARCHAR2(30),
24 JOB_CARD_LYT_MEANING VARCHAR2(80),
25 --snarkhed Enigma Phase II changes --end
26 PROCESS_CODE VARCHAR2(30),
27 PROCESS VARCHAR2(80),
28 PRODUCT_TYPE_CODE VARCHAR2(30),
29 PRODUCT_TYPE VARCHAR2(80),
30 OPERATOR_PARTY_ID NUMBER,
31 OPERATOR_NAME VARCHAR2(360),
32 ZONE_CODE VARCHAR2(30),
33 ZONE VARCHAR2(80),
34 SUB_ZONE_CODE VARCHAR2(30),
35 SUB_ZONE VARCHAR2(80),
36 SERVICE_ITEM_ID NUMBER,
37 SERVICE_ITEM_ORG_ID NUMBER,
38 SERVICE_ITEM_NUMBER VARCHAR2(40),
39 ACCOUNTING_CLASS_CODE VARCHAR2(10),
40 ACCOUNTING_CLASS_ORG_ID NUMBER,
41 ACCOUNTING_CLASS VARCHAR2(240),
42 TASK_TEMPLATE_GROUP_ID NUMBER,
43 TASK_TEMPLATE_GROUP VARCHAR2(80),
44 QA_INSPECTION_TYPE VARCHAR2(150),
45 QA_INSPECTION_TYPE_DESC VARCHAR2(150),
46 TIME_SPAN NUMBER,
47 ACTIVE_START_DATE DATE,
48 ACTIVE_END_DATE DATE,
49 REVISION_NUMBER NUMBER,
50 REVISION_STATUS_CODE VARCHAR2(30),
51 REVISION_STATUS VARCHAR2(80),
52 --pdoki Bug 6504159 Begin.
53 UNIT_RECEIPT_UPDATE_FLAG VARCHAR2(1),
54 UNIT_RECEIPT_UPDATE VARCHAR2(80),
55 --pdoki Bug 6504159 End.
56 --MANESING::Supplier Warranty, 25-Aug-2010, added variables for warranty template id and name
57 WARRANTY_TEMPLATE_ID NUMBER,
58 WARRANTY_TEMPLATE_NAME VARCHAR2(150),
59 --MANESING::VWP Enhancements, 18-Jan-2011, added variables for Duplicate and Return to supply flags
60 DUPLICATE_FLAG VARCHAR2(1),
61 RETURN_TO_SUPPLY_FLAG VARCHAR2(1),
62 REMARKS VARCHAR2(2000),
63 REVISION_NOTES VARCHAR2(2000),
64 SEGMENT1 VARCHAR2(30),
65 SEGMENT2 VARCHAR2(30),
66 SEGMENT3 VARCHAR2(30),
67 SEGMENT4 VARCHAR2(30),
68 SEGMENT5 VARCHAR2(30),
69 SEGMENT6 VARCHAR2(30),
70 SEGMENT7 VARCHAR2(30),
71 SEGMENT8 VARCHAR2(30),
72 SEGMENT9 VARCHAR2(30),
73 SEGMENT10 VARCHAR2(30),
74 SEGMENT11 VARCHAR2(30),
75 SEGMENT12 VARCHAR2(30),
76 SEGMENT13 VARCHAR2(30),
77 SEGMENT14 VARCHAR2(30),
78 SEGMENT15 VARCHAR2(30),
79 ATTRIBUTE_CATEGORY VARCHAR2(30),
80 ATTRIBUTE1 VARCHAR2(150),
81 ATTRIBUTE2 VARCHAR2(150),
82 ATTRIBUTE3 VARCHAR2(150),
83 ATTRIBUTE4 VARCHAR2(150),
84 ATTRIBUTE5 VARCHAR2(150),
85 ATTRIBUTE6 VARCHAR2(150),
86 ATTRIBUTE7 VARCHAR2(150),
87 ATTRIBUTE8 VARCHAR2(150),
88 ATTRIBUTE9 VARCHAR2(150),
89 ATTRIBUTE10 VARCHAR2(150),
90 ATTRIBUTE11 VARCHAR2(150),
91 ATTRIBUTE12 VARCHAR2(150),
92 ATTRIBUTE13 VARCHAR2(150),
93 ATTRIBUTE14 VARCHAR2(150),
94 ATTRIBUTE15 VARCHAR2(150),
95 LAST_UPDATE_DATE DATE,
96 LAST_UPDATED_BY NUMBER(15),
97 CREATION_DATE DATE,
98 CREATED_BY NUMBER(15),
99 LAST_UPDATE_LOGIN NUMBER(15),
100 DML_OPERATION VARCHAR2(1)
101 );
102
103 -- Start of Comments
104 -- Procedure name : process_route
105 -- Type : Private
106 -- Pre-reqs :
107 -- Function :
108 -- Parameters :
109 --
110 -- Standard IN Parameters :
111 -- p_api_version NUMBER Required
112 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
113 -- p_commit VARCHAR2 Default FND_API.G_FALSE
114 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
115 -- p_default VARCHAR2 Default FND_API.G_TRUE
116 -- p_module_type VARCHAR2 Default NULL
117 --
118 -- Standard OUT Parameters :
119 -- x_return_status VARCHAR2 Required
120 -- x_msg_count NUMBER Required
121 -- x_msg_data VARCHAR2 Required
122 --
123 -- process_route IN parameters:
124 -- None.
125 --
126 -- process_route IN OUT parameters:
127 -- p_x_route_rec route_rec_type Required
128 --
129 -- process_route OUT parameters:
130 -- None.
131 --
132 --
133 -- Version :
134 -- Current version 1.0
135 --
136 -- End of Comments
137
138 PROCEDURE process_route
139 (
140 p_api_version IN NUMBER := '1.0',
141 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
142 p_commit IN VARCHAR2 := FND_API.G_FALSE,
143 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144 p_default IN VARCHAR2 := FND_API.G_FALSE,
145 p_module_type IN VARCHAR2 := NULL,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_x_route_rec IN OUT NOCOPY route_rec_type
150 );
151
152 -- Start of Comments
153 -- Procedure name : delete_route
154 -- Type : Private
155 -- Pre-reqs :
156 -- Function :
157 -- Parameters :
158 --
159 -- Standard IN Parameters :
160 -- p_api_version NUMBER Required
161 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
162 -- p_commit VARCHAR2 Default FND_API.G_FALSE
163 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
164 -- p_default VARCHAR2 Default FND_API.G_TRUE
165 -- p_module_type VARCHAR2 Default NULL
166 --
167 -- Standard OUT Parameters :
168 -- x_return_status VARCHAR2 Required
169 -- x_msg_count NUMBER Required
170 -- x_msg_data VARCHAR2 Required
171 --
172 -- delete_route IN parameters:
173 -- p_route_id NUMBER Required
174 -- p_object_version_number NUMBER Required
175 --
176 -- delete_route IN OUT parameters:
177 -- None.
178 --
179 -- delete_route OUT parameters:
180 -- None.
181 --
182 --
183 -- Version :
184 -- Current version 1.0
185 --
186 -- End of Comments
187
188 PROCEDURE delete_route
189 (
190 p_api_version IN NUMBER := '1.0',
191 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
192 p_commit IN VARCHAR2 := FND_API.G_FALSE,
193 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194 p_default IN VARCHAR2 := FND_API.G_FALSE,
195 p_module_type IN VARCHAR2 := NULL,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_route_id IN NUMBER,
200 p_object_version_number IN NUMBER
201 );
202
203 -- Start of Comments
204 -- Procedure name : create_route_revision
205 -- Type : Private
206 -- Pre-reqs :
207 -- Function :
208 -- Parameters :
209 --
210 -- Standard IN Parameters :
211 -- p_api_version NUMBER Required
212 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
213 -- p_commit VARCHAR2 Default FND_API.G_FALSE
214 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
215 -- p_default VARCHAR2 Default FND_API.G_TRUE
216 -- p_module_type VARCHAR2 Default NULL
217 --
218 -- Standard OUT Parameters :
219 -- x_return_status VARCHAR2 Required
220 -- x_msg_count NUMBER Required
221 -- x_msg_data VARCHAR2 Required
222 --
223 -- create_route_revision IN parameters:
224 -- p_route_id NUMBER Required
225 -- p_object_version_number NUMBER Required
226 --
227 -- create_route_revision IN OUT parameters:
228 -- None.
229 --
230 -- create_route_revision OUT parameters:
231 -- x_route_id NUMBER Required
232 --
233 --
234 -- Version :
235 -- Current version 1.0
236 --
237 -- End of Comments
238
239 PROCEDURE create_route_revision
240 (
241 p_api_version IN NUMBER := '1.0',
242 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
243 p_commit IN VARCHAR2 := FND_API.G_FALSE,
244 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245 p_default IN VARCHAR2 := FND_API.G_FALSE,
246 p_module_type IN VARCHAR2 := NULL,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250 p_route_id IN NUMBER,
251 p_object_version_number IN NUMBER,
252 x_route_id OUT NOCOPY NUMBER
253 );
254
255 END AHL_RM_ROUTE_PVT;