APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on CSD_REPAIRS

Line 192: csd_repairs_v ro

188: ro.serial_number,
189: ro.item,
190: decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
191: FROM csd_incidents_v sr,
192: csd_repairs_v ro
193: WHERE ro.incident_id = sr.incident_id
194: AND ro.repair_line_id = p_repair_line_id;
195:
196: CURSOR get_wf_role (p_repair_line_id IN NUMBER) IS

Line 200: csd_repairs ro

196: CURSOR get_wf_role (p_repair_line_id IN NUMBER) IS
197: Select wr.name
198: from wf_roles wr,
199: cs_incidents_v sr,
200: csd_repairs ro
201: where ro.repair_line_id = p_repair_line_id
202: and ro.incident_id = sr.incident_id
203: and wr.orig_system_id = sr.contact_party_id
204: and wr.orig_system = 'HZ_PARTY'

Line 275: CSD_REPAIRS_GRP.Create_Repair_Order

271: 'calling create repair order public API');
272: END IF;
273: -- API call to create the repair orders.
274:
275: CSD_REPAIRS_GRP.Create_Repair_Order
276: (p_init_msg_list => 'T',
277: p_commit => 'F',
278: p_repair_line_id =>null,
279: p_repair_number => null,