77: /*--------------------------------------------------*/
78: Function Get_Document_Status
79: (
80: p_document_type in VARCHAR2,
81: p_status_code in VARCHAR2 := fnd_api.g_miss_char,
82: p_status_id in NUMBER := fnd_api.g_miss_num
83: ) RETURN VARCHAR2;
84:
85: /*--------------------------------------------------*/
78: Function Get_Document_Status
79: (
80: p_document_type in VARCHAR2,
81: p_status_code in VARCHAR2 := fnd_api.g_miss_char,
82: p_status_id in NUMBER := fnd_api.g_miss_num
83: ) RETURN VARCHAR2;
84:
85: /*--------------------------------------------------*/
86: /* procedure name: Get_Document_Status */
89: /* either a document_id or */
90: /* document_code */
91: /*--------------------------------------------------*/
92: Procedure Get_Document_Status(p_document_type in VARCHAR2,
93: p_status_code in VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_status_id in NUMBER := FND_API.G_MISS_NUM,
95: x_status_name out NOCOPY VARCHAR2,
96: p_api_version IN NUMBER,
97: p_commit IN VARCHAR2,
90: /* document_code */
91: /*--------------------------------------------------*/
92: Procedure Get_Document_Status(p_document_type in VARCHAR2,
93: p_status_code in VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_status_id in NUMBER := FND_API.G_MISS_NUM,
95: x_status_name out NOCOPY VARCHAR2,
96: p_api_version IN NUMBER,
97: p_commit IN VARCHAR2,
98: p_init_msg_list IN VARCHAR2,
114: p_validation_level IN NUMBER,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
128:
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
128:
129:
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
128:
129:
130: /*--------------------------------------------------*/
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
128:
129:
130: /*--------------------------------------------------*/
131: /* procedure name: Refresh_SR */
139: p_validation_level IN NUMBER,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
153:
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
153:
154: /*--------------------------------------------------*/
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
153:
154: /*--------------------------------------------------*/
155: /* procedure name: Refresh_SR_Task */
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
153:
154: /*--------------------------------------------------*/
155: /* procedure name: Refresh_SR_Task */
156: /* description : procedure to load or update */
164: p_validation_level IN NUMBER,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
178:
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
178:
179: /*--------------------------------------------------*/
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
178:
179: /*--------------------------------------------------*/
180: /* procedure name: Refresh_Purchase_Req */
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
178:
179: /*--------------------------------------------------*/
180: /* procedure name: Refresh_Purchase_Req */
181: /* description : procedure to load or update */
189: p_validation_level IN NUMBER,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
203:
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
203:
204: /*--------------------------------------------------*/
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
203:
204: /*--------------------------------------------------*/
205: /* procedure name: Refresh_Internal_Req */
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
203:
204: /*--------------------------------------------------*/
205: /* procedure name: Refresh_Internal_Req */
206: /* description : procedure to load or update */
214: p_validation_level IN NUMBER,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
228:
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
228:
229: /*--------------------------------------------------*/
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
228:
229: /*--------------------------------------------------*/
230: /* procedure name: Refresh_Int_Sales_Order */
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
228:
229: /*--------------------------------------------------*/
230: /* procedure name: Refresh_Int_Sales_Order */
231: /* description : procedure to load or update */
239: p_validation_level IN NUMBER,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
253:
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
253:
254: /*--------------------------------------------------*/
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
253:
254: /*--------------------------------------------------*/
255: /* procedure name: Refresh_RMA */
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
253:
254: /*--------------------------------------------------*/
255: /* procedure name: Refresh_RMA */
256: /* description : procedure to load or update */
264: p_validation_level IN NUMBER,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
278:
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
278:
279: /*--------------------------------------------------*/
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
278:
279: /*--------------------------------------------------*/
280: /* procedure name: Refresh_RMA_Third_Party */
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
278:
279: /*--------------------------------------------------*/
280: /* procedure name: Refresh_RMA_Third_Party */
281: /* description : procedure to load or update */
289: p_validation_level IN NUMBER,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
303:
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
303:
304: /*--------------------------------------------------*/
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
303:
304: /*--------------------------------------------------*/
305: /* procedure name: Refresh_Ship */
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
303:
304: /*--------------------------------------------------*/
305: /* procedure name: Refresh_Ship */
306: /* description : procedure to load or update */
314: p_validation_level IN NUMBER,
315: x_return_status OUT NOCOPY VARCHAR2,
316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
315: x_return_status OUT NOCOPY VARCHAR2,
316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
328:
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
328:
329: /*--------------------------------------------------*/
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
328:
329: /*--------------------------------------------------*/
330: /* procedure name: Refresh_Ship_Third_Party */
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
328:
329: /*--------------------------------------------------*/
330: /* procedure name: Refresh_Ship_Third_Party */
331: /* description : procedure to load or update */
339: p_validation_level IN NUMBER,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
353:
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
353:
354: /*--------------------------------------------------*/
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
353:
354: /*--------------------------------------------------*/
355: /* procedure name: Refresh_Delivery */
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
353:
354: /*--------------------------------------------------*/
355: /* procedure name: Refresh_Delivery */
356: /* description : procedure to load or update */
364: p_validation_level IN NUMBER,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
378:
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
378:
379: /*--------------------------------------------------------------------------*/
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
378:
379: /*--------------------------------------------------------------------------*/
380: /* procedure name: Refresh */
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
378:
379: /*--------------------------------------------------------------------------*/
380: /* procedure name: Refresh */
381: /* description : procedure to load or update */
415: x_return_status OUT NOCOPY VARCHAR2,
416: x_msg_count OUT NOCOPY NUMBER,
417: x_msg_data OUT NOCOPY VARCHAR2,
418: p_so_orchestration_key_tbl IN so_orchestration_key_tbl_type,
419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
416: x_msg_count OUT NOCOPY NUMBER,
417: x_msg_data OUT NOCOPY VARCHAR2,
418: p_so_orchestration_key_tbl IN so_orchestration_key_tbl_type,
419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
417: x_msg_data OUT NOCOPY VARCHAR2,
418: p_so_orchestration_key_tbl IN so_orchestration_key_tbl_type,
419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
418: p_so_orchestration_key_tbl IN so_orchestration_key_tbl_type,
419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
429:
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
429:
430: /*--------------------------------------------------------------------------*/
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
429:
430: /*--------------------------------------------------------------------------*/
431: /* procedure name: Soo_Bi_Driver_Main */
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
429:
430: /*--------------------------------------------------------------------------*/
431: /* procedure name: Soo_Bi_Driver_Main */
432: /* description : main procedure of */
459: /*--------------------------------------------------------------------------*/
460:
461: PROCEDURE Soo_Driver_Main (errbuf OUT NOCOPY VARCHAR2,
462: retcode OUT NOCOPY VARCHAR2,
463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
460:
461: PROCEDURE Soo_Driver_Main (errbuf OUT NOCOPY VARCHAR2,
462: retcode OUT NOCOPY VARCHAR2,
463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
461: PROCEDURE Soo_Driver_Main (errbuf OUT NOCOPY VARCHAR2,
462: retcode OUT NOCOPY VARCHAR2,
463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
462: retcode OUT NOCOPY VARCHAR2,
463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
473:
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
473:
474: END CSD_SOO_PVT;
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
473:
474: END CSD_SOO_PVT;
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
473:
474: END CSD_SOO_PVT;