1 PACKAGE CSD_REPAIRS_GRP as
2 /* $Header: csdgdras.pls 120.6.12010000.2 2008/11/06 07:24:32 subhat ship $ */
3 --
4 -- Package name : CSD_REPAIRS_GRP
5 -- Purpose : This package contains routines called by Repairs Form. The procedures convert the
6 -- parameters into REPLN_REC_TYPE and call the Private APIs.
7 -- History :
8 -- Version Date Name Description
9 -- 115.0 12/28/99 pkdas Created.
10 -- 115.1 01/18/00 pkdas
11 -- 115.2 02/21/00 pkdas Changed the name of the procedure Insert_From_Form
12 -- to Create_Repairs and Update_From_Form to Update_Repairs.
13 -- Added p_REPAIR_LINE_ID and p_REPAIR_NUMBER as IN
14 -- parameters in the Create_Repairs procedure.
15 -- Added standard OUT parameter in the Create_Repairs
16 -- and Update_Repairs procedures. Added default values
17 -- to the parameters.
18 -- 115.3 02/29/00 pkdas Changed the procedure name
19 -- Create_Repairs -> Create_Repair_Order
20 -- Update_Repairs -> Update_Repair_Order
21 -- 115.4 11/30/01 travi Added Auto_Process_Rma, Object_Version_Number and Repair_Mode columns
22 -- 115.5 01/04/02 travi Added Object_Version_Number to update_approval_status
23 -- and update_status procedures
24 -- 115.6 01/14/02 travi Added Item_Revision
25 -- 115.7 05/16/02 travi Added Update_Group_Approval_Status and Update_Group_Reject_Status procedures
26 -- 115.28 08/06/02 saupadhy Default input parameters for procedures were made consistent in package specifica
27 -- -tion and body. To fix bug 2497692
28
29 --
30 --
31 -- NOTE :
32 --
33
34
35 PROCEDURE Create_Repair_Order(
36 p_Init_Msg_List IN VARCHAR2 := 'F',
37 p_Commit IN VARCHAR2 := 'F',
38 p_REPAIR_LINE_ID IN NUMBER,
39 p_REPAIR_NUMBER IN VARCHAR2,
40 p_INCIDENT_ID IN NUMBER,
41 p_INVENTORY_ITEM_ID IN NUMBER,
42 p_CUSTOMER_PRODUCT_ID IN NUMBER,
43 p_UNIT_OF_MEASURE IN VARCHAR2,
44 p_REPAIR_TYPE_ID IN NUMBER,
45 -- RESOURCE_GROUP Added by Vijay 10/28/2004
46 p_RESOURCE_GROUP IN NUMBER,
47 p_RESOURCE_ID IN NUMBER,
48 p_PROJECT_ID IN NUMBER,
49 p_TASK_ID IN NUMBER,
50 p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, prj intergration
51 p_CONTRACT_LINE_ID IN NUMBER,
52 p_AUTO_PROCESS_RMA IN VARCHAR2,
53 p_REPAIR_MODE IN VARCHAR2,
54 p_OBJECT_VERSION_NUMBER IN NUMBER,
55 p_ITEM_REVISION IN VARCHAR2,
56 p_INSTANCE_ID IN NUMBER,
57 p_STATUS IN VARCHAR2 := 'O',
58 p_STATUS_REASON_CODE IN VARCHAR2,
59 p_DATE_CLOSED IN DATE,
60 p_APPROVAL_REQUIRED_FLAG IN VARCHAR2,
61 p_APPROVAL_STATUS IN VARCHAR2,
62 p_SERIAL_NUMBER IN VARCHAR2,
63 p_PROMISE_DATE IN DATE,
64 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
65 p_ATTRIBUTE1 IN VARCHAR2,
66 p_ATTRIBUTE2 IN VARCHAR2,
67 p_ATTRIBUTE3 IN VARCHAR2,
68 p_ATTRIBUTE4 IN VARCHAR2,
69 p_ATTRIBUTE5 IN VARCHAR2,
70 p_ATTRIBUTE6 IN VARCHAR2,
71 p_ATTRIBUTE7 IN VARCHAR2,
72 p_ATTRIBUTE8 IN VARCHAR2,
73 p_ATTRIBUTE9 IN VARCHAR2,
74 p_ATTRIBUTE10 IN VARCHAR2,
75 p_ATTRIBUTE11 IN VARCHAR2,
76 p_ATTRIBUTE12 IN VARCHAR2,
77 p_ATTRIBUTE13 IN VARCHAR2,
78 p_ATTRIBUTE14 IN VARCHAR2,
79 p_ATTRIBUTE15 IN VARCHAR2,
80 -- additional DFF attributes, subhat(bug#7497907).
81 P_ATTRIBUTE16 IN VARCHAR2 ,
82 P_ATTRIBUTE17 IN VARCHAR2 ,
83 P_ATTRIBUTE18 IN VARCHAR2 ,
84 P_ATTRIBUTE19 IN VARCHAR2 ,
85 P_ATTRIBUTE20 IN VARCHAR2 ,
86 P_ATTRIBUTE21 IN VARCHAR2 ,
87 P_ATTRIBUTE22 IN VARCHAR2 ,
88 P_ATTRIBUTE23 IN VARCHAR2 ,
89 P_ATTRIBUTE24 IN VARCHAR2 ,
90 P_ATTRIBUTE25 IN VARCHAR2 ,
91 P_ATTRIBUTE26 IN VARCHAR2 ,
92 P_ATTRIBUTE27 IN VARCHAR2 ,
93 P_ATTRIBUTE28 IN VARCHAR2 ,
94 P_ATTRIBUTE29 IN VARCHAR2 ,
95 P_ATTRIBUTE30 IN VARCHAR2 ,
96 p_QUANTITY IN NUMBER := 1,
97 p_QUANTITY_IN_WIP IN NUMBER,
98 p_QUANTITY_RCVD IN NUMBER,
99 p_QUANTITY_SHIPPED IN NUMBER,
100 p_CURRENCY_CODE IN VARCHAR2,
101 p_DEFAULT_PO_NUM IN VARCHAR2 := null,
102 p_REPAIR_GROUP_ID IN NUMBER,
103 p_RO_TXN_STATUS IN VARCHAR2,
104 p_ORDER_LINE_ID IN NUMBER,
105 p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2,
106 p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER,
107 p_ORIGINAL_SOURCE_LINE_ID IN NUMBER,
108 p_PRICE_LIST_HEADER_ID IN NUMBER,
109 p_INVENTORY_ORG_ID IN NUMBER,
110 p_PROBLEM_DESCRIPTION IN VARCHAR2 := null, -- swai: bug 4666344
111 p_RO_PRIORITY_CODE IN VARCHAR2 := null, -- swai: R12
112 -- G_MISS_DATE means default resolve_by_date during RO creation
113 -- null means do not default resolve_by_date during RO creation
114 p_RESOLVE_BY_DATE IN DATE := FND_API.G_MISS_DATE, -- rfieldma, bug 5355051
115 p_BULLETIN_CHECK_DATE IN DATE := FND_API.G_MISS_DATE,
116 p_ESCALATION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 x_repair_line_id OUT NOCOPY NUMBER,
118 x_repair_number OUT NOCOPY VARCHAR2,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2
122 );
123
124
125 PROCEDURE Update_Repair_Order(
126 p_Init_Msg_List IN VARCHAR2 := 'F',
127 p_Commit IN VARCHAR2 := 'F',
128 p_REPAIR_LINE_ID IN NUMBER,
129 p_REPAIR_NUMBER IN VARCHAR2,
130 p_INCIDENT_ID IN NUMBER,
131 p_INVENTORY_ITEM_ID IN NUMBER,
132 p_CUSTOMER_PRODUCT_ID IN NUMBER,
133 p_UNIT_OF_MEASURE IN VARCHAR2,
134 p_REPAIR_TYPE_ID IN NUMBER,
135 -- RESOURCE_GROUP Added by Vijay 10/28/2004
136 p_RESOURCE_GROUP IN NUMBER,
137 p_RESOURCE_ID IN NUMBER,
138 p_PROJECT_ID IN NUMBER,
139 p_TASK_ID IN NUMBER,
140 p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, prj intergration
141 p_CONTRACT_LINE_ID IN NUMBER,
142 p_AUTO_PROCESS_RMA IN VARCHAR2,
143 p_REPAIR_MODE IN VARCHAR2,
144 p_OBJECT_VERSION_NUMBER IN NUMBER,
145 p_ITEM_REVISION IN VARCHAR2,
146 p_INSTANCE_ID IN NUMBER,
147 p_STATUS IN VARCHAR2,
148 p_STATUS_REASON_CODE IN VARCHAR2,
149 p_DATE_CLOSED IN DATE,
150 p_APPROVAL_REQUIRED_FLAG IN VARCHAR2,
151 p_APPROVAL_STATUS IN VARCHAR2,
152 p_SERIAL_NUMBER IN VARCHAR2,
153 p_PROMISE_DATE IN DATE,
154 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
155 p_ATTRIBUTE1 IN VARCHAR2,
156 p_ATTRIBUTE2 IN VARCHAR2,
157 p_ATTRIBUTE3 IN VARCHAR2,
158 p_ATTRIBUTE4 IN VARCHAR2,
159 p_ATTRIBUTE5 IN VARCHAR2,
160 p_ATTRIBUTE6 IN VARCHAR2,
161 p_ATTRIBUTE7 IN VARCHAR2,
162 p_ATTRIBUTE8 IN VARCHAR2,
163 p_ATTRIBUTE9 IN VARCHAR2,
164 p_ATTRIBUTE10 IN VARCHAR2,
165 p_ATTRIBUTE11 IN VARCHAR2,
166 p_ATTRIBUTE12 IN VARCHAR2,
167 p_ATTRIBUTE13 IN VARCHAR2,
168 p_ATTRIBUTE14 IN VARCHAR2,
169 p_ATTRIBUTE15 IN VARCHAR2,
170 -- additional DFF attributes, subhat(bug#7497907).
171 P_ATTRIBUTE16 IN VARCHAR2 ,
172 P_ATTRIBUTE17 IN VARCHAR2 ,
173 P_ATTRIBUTE18 IN VARCHAR2 ,
174 P_ATTRIBUTE19 IN VARCHAR2 ,
175 P_ATTRIBUTE20 IN VARCHAR2 ,
176 P_ATTRIBUTE21 IN VARCHAR2 ,
177 P_ATTRIBUTE22 IN VARCHAR2 ,
178 P_ATTRIBUTE23 IN VARCHAR2 ,
179 P_ATTRIBUTE24 IN VARCHAR2 ,
180 P_ATTRIBUTE25 IN VARCHAR2 ,
181 P_ATTRIBUTE26 IN VARCHAR2 ,
182 P_ATTRIBUTE27 IN VARCHAR2 ,
183 P_ATTRIBUTE28 IN VARCHAR2 ,
184 P_ATTRIBUTE29 IN VARCHAR2 ,
185 P_ATTRIBUTE30 IN VARCHAR2 ,
186 p_QUANTITY IN NUMBER,
187 p_QUANTITY_IN_WIP IN NUMBER,
188 p_QUANTITY_RCVD IN NUMBER,
189 p_QUANTITY_SHIPPED IN NUMBER,
190 p_CURRENCY_CODE IN VARCHAR2,
191 p_DEFAULT_PO_NUM IN VARCHAR2 := null,
192 p_REPAIR_GROUP_ID IN NUMBER,
193 p_RO_TXN_STATUS IN VARCHAR2,
194 p_ORDER_LINE_ID IN NUMBER,
195 p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2,
196 p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER,
197 p_ORIGINAL_SOURCE_LINE_ID IN NUMBER,
198 p_PRICE_LIST_HEADER_ID IN NUMBER,
199 p_PROBLEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR, -- swai: bug 4666344
200 p_RO_PRIORITY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR, -- swai: R12
201 -- g_miss_date means keep field in table handler
202 -- null clear field in table handler
203 p_RESOLVE_BY_DATE IN DATE := FND_API.G_MISS_DATE, -- rfieldma, bug 5355051
204 p_BULLETIN_CHECK_DATE IN DATE := FND_API.G_MISS_DATE,
205 p_ESCALATION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2
209 );
210
211 Procedure Update_Approval_Status(
212 p_repair_line_id IN NUMBER,
213 p_new_approval_status IN VARCHAR2,
214 p_old_approval_status IN VARCHAR2,
215 p_quantity IN NUMBER,
216 p_org_contact_id IN NUMBER,
217 p_reason IN VARCHAR2,
218 p_object_version_number IN OUT NOCOPY NUMBER,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2
222 );
223
224
225 Procedure Update_Status(
226 p_repair_line_id IN NUMBER,
227 p_new_status IN VARCHAR2,
228 p_old_status IN VARCHAR2,
229 p_quantity IN NUMBER,
230 p_reason IN VARCHAR2,
231 p_status_reason_code IN VARCHAR2,
232 p_object_version_number IN NUMBER,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2
236 );
237
238 Procedure Update_Group_Approval_Status(
239 p_api_version IN NUMBER,
240 p_commit IN VARCHAR2 := fnd_api.g_false,
241 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
242 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
243 p_repair_group_id IN NUMBER,
244 p_object_version_number IN OUT NOCOPY NUMBER,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2
248 );
249
250 Procedure Update_Group_Reject_Status(
251 p_api_version IN NUMBER,
252 p_commit IN VARCHAR2 := fnd_api.g_false,
253 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
254 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
255 p_repair_group_id IN NUMBER,
256 p_object_version_number IN OUT NOCOPY NUMBER,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2
260 );
261
262 --
263 --
264 End CSD_REPAIRS_GRP;