1 PACKAGE CSD_REPAIRS_GRP AUTHID CURRENT_USER as
2 /* $Header: csdgdras.pls 120.6.12010000.3 2010/05/06 01:29:08 takwong 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 p_RO_WARRANTY_STATUS_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 x_repair_line_id OUT NOCOPY NUMBER,
119 x_repair_number OUT NOCOPY VARCHAR2,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125
126 PROCEDURE Update_Repair_Order(
127 p_Init_Msg_List IN VARCHAR2 := 'F',
128 p_Commit IN VARCHAR2 := 'F',
129 p_REPAIR_LINE_ID IN NUMBER,
130 p_REPAIR_NUMBER IN VARCHAR2,
131 p_INCIDENT_ID IN NUMBER,
132 p_INVENTORY_ITEM_ID IN NUMBER,
133 p_CUSTOMER_PRODUCT_ID IN NUMBER,
134 p_UNIT_OF_MEASURE IN VARCHAR2,
135 p_REPAIR_TYPE_ID IN NUMBER,
136 -- RESOURCE_GROUP Added by Vijay 10/28/2004
137 p_RESOURCE_GROUP IN NUMBER,
138 p_RESOURCE_ID IN NUMBER,
139 p_PROJECT_ID IN NUMBER,
140 p_TASK_ID IN NUMBER,
141 p_UNIT_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR, -- rfieldma, prj intergration
142 p_CONTRACT_LINE_ID IN NUMBER,
143 p_AUTO_PROCESS_RMA IN VARCHAR2,
144 p_REPAIR_MODE IN VARCHAR2,
145 p_OBJECT_VERSION_NUMBER IN NUMBER,
146 p_ITEM_REVISION IN VARCHAR2,
147 p_INSTANCE_ID IN NUMBER,
148 p_STATUS IN VARCHAR2,
149 p_STATUS_REASON_CODE IN VARCHAR2,
150 p_DATE_CLOSED IN DATE,
151 p_APPROVAL_REQUIRED_FLAG IN VARCHAR2,
152 p_APPROVAL_STATUS IN VARCHAR2,
153 p_SERIAL_NUMBER IN VARCHAR2,
154 p_PROMISE_DATE IN DATE,
155 p_ATTRIBUTE_CATEGORY IN VARCHAR2,
156 p_ATTRIBUTE1 IN VARCHAR2,
157 p_ATTRIBUTE2 IN VARCHAR2,
158 p_ATTRIBUTE3 IN VARCHAR2,
159 p_ATTRIBUTE4 IN VARCHAR2,
160 p_ATTRIBUTE5 IN VARCHAR2,
161 p_ATTRIBUTE6 IN VARCHAR2,
162 p_ATTRIBUTE7 IN VARCHAR2,
163 p_ATTRIBUTE8 IN VARCHAR2,
164 p_ATTRIBUTE9 IN VARCHAR2,
165 p_ATTRIBUTE10 IN VARCHAR2,
166 p_ATTRIBUTE11 IN VARCHAR2,
167 p_ATTRIBUTE12 IN VARCHAR2,
168 p_ATTRIBUTE13 IN VARCHAR2,
169 p_ATTRIBUTE14 IN VARCHAR2,
170 p_ATTRIBUTE15 IN VARCHAR2,
171 -- additional DFF attributes, subhat(bug#7497907).
172 P_ATTRIBUTE16 IN VARCHAR2 ,
173 P_ATTRIBUTE17 IN VARCHAR2 ,
174 P_ATTRIBUTE18 IN VARCHAR2 ,
175 P_ATTRIBUTE19 IN VARCHAR2 ,
176 P_ATTRIBUTE20 IN VARCHAR2 ,
177 P_ATTRIBUTE21 IN VARCHAR2 ,
178 P_ATTRIBUTE22 IN VARCHAR2 ,
179 P_ATTRIBUTE23 IN VARCHAR2 ,
180 P_ATTRIBUTE24 IN VARCHAR2 ,
181 P_ATTRIBUTE25 IN VARCHAR2 ,
182 P_ATTRIBUTE26 IN VARCHAR2 ,
183 P_ATTRIBUTE27 IN VARCHAR2 ,
184 P_ATTRIBUTE28 IN VARCHAR2 ,
185 P_ATTRIBUTE29 IN VARCHAR2 ,
186 P_ATTRIBUTE30 IN VARCHAR2 ,
187 p_QUANTITY IN NUMBER,
188 p_QUANTITY_IN_WIP IN NUMBER,
189 p_QUANTITY_RCVD IN NUMBER,
190 p_QUANTITY_SHIPPED IN NUMBER,
191 p_CURRENCY_CODE IN VARCHAR2,
192 p_DEFAULT_PO_NUM IN VARCHAR2 := null,
193 p_REPAIR_GROUP_ID IN NUMBER,
194 p_RO_TXN_STATUS IN VARCHAR2,
195 p_ORDER_LINE_ID IN NUMBER,
196 p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2,
197 p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER,
198 p_ORIGINAL_SOURCE_LINE_ID IN NUMBER,
199 p_PRICE_LIST_HEADER_ID IN NUMBER,
200 p_PROBLEM_DESCRIPTION IN VARCHAR2 := FND_API.G_MISS_CHAR, -- swai: bug 4666344
201 p_RO_PRIORITY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR, -- swai: R12
202 -- g_miss_date means keep field in table handler
203 -- null clear field in table handler
204 p_RESOLVE_BY_DATE IN DATE := FND_API.G_MISS_DATE, -- rfieldma, bug 5355051
205 p_BULLETIN_CHECK_DATE IN DATE := FND_API.G_MISS_DATE,
206 p_ESCALATION_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
207 p_ro_warranty_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2
211 );
212
213 Procedure Update_Approval_Status(
214 p_repair_line_id IN NUMBER,
215 p_new_approval_status IN VARCHAR2,
216 p_old_approval_status IN VARCHAR2,
217 p_quantity IN NUMBER,
218 p_org_contact_id IN NUMBER,
219 p_reason IN VARCHAR2,
220 p_object_version_number IN OUT NOCOPY NUMBER,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2
224 );
225
226
227 Procedure Update_Status(
228 p_repair_line_id IN NUMBER,
229 p_new_status IN VARCHAR2,
230 p_old_status IN VARCHAR2,
231 p_quantity IN NUMBER,
232 p_reason IN VARCHAR2,
233 p_status_reason_code IN VARCHAR2,
234 p_object_version_number IN NUMBER,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2
238 );
239
240 Procedure Update_Group_Approval_Status(
241 p_api_version IN NUMBER,
242 p_commit IN VARCHAR2 := fnd_api.g_false,
243 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
244 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
245 p_repair_group_id IN NUMBER,
246 p_object_version_number IN OUT NOCOPY NUMBER,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2
250 );
251
252 Procedure Update_Group_Reject_Status(
253 p_api_version IN NUMBER,
254 p_commit IN VARCHAR2 := fnd_api.g_false,
255 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
256 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
257 p_repair_group_id IN NUMBER,
258 p_object_version_number IN OUT NOCOPY NUMBER,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2
262 );
263
264 --
265 --
266 End CSD_REPAIRS_GRP;
[Home] [Help]