APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on CSD_REPAIRS

Line 188: csd_repairs_v ro

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

Line 196: csd_repairs ro

192: CURSOR get_wf_role (p_repair_line_id IN NUMBER) IS
193: SELECT wr.name
194: FROM wf_roles wr,
195: cs_incidents_v sr,
196: csd_repairs ro
197: WHERE ro.repair_line_id = p_repair_line_id
198: AND ro.incident_id = sr.incident_id
199: AND wr.orig_system_id = sr.contact_party_id
200: AND wr.orig_system = 'HZ_PARTY'

Line 264: 'Calling CSD_REPAIRS_UTIL.GET_ENTITLEMENTS to get contracts if any.');

260: fnd_profile.get('SERVER_TIMEZONE_ID', l_server_tz_id);
261:
262: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
263: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
264: 'Calling CSD_REPAIRS_UTIL.GET_ENTITLEMENTS to get contracts if any.');
265: END IF;
266: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(
267: p_api_version_number => 1.0,
268: p_init_msg_list => fnd_api.g_false,

Line 266: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(

262: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
263: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
264: 'Calling CSD_REPAIRS_UTIL.GET_ENTITLEMENTS to get contracts if any.');
265: END IF;
266: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(
267: p_api_version_number => 1.0,
268: p_init_msg_list => fnd_api.g_false,
269: p_commit => fnd_api.g_false,
270: p_contract_number => null,

Line 393: csd_repairs_util.get_contract_resolve_by_date(

389: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
390: Fnd_Log.STRING(Fnd_Log.LEVEL_PROCEDURE, lc_mod_name,
391: 'Deriving resolve by date');
392: END IF;
393: csd_repairs_util.get_contract_resolve_by_date(
394: p_contract_line_id => l_contract_line_id,
395: p_bus_proc_id => l_business_process_id,
396: p_severity_id => l_incident_severity_id,
397: p_request_date => sysdate,

Line 421: CSD_REPAIRS_GRP.Create_Repair_Order

417: 'calling create repair order public API');
418: END IF;
419: -- API call to create the repair orders.
420:
421: CSD_REPAIRS_GRP.Create_Repair_Order
422: (p_init_msg_list => 'T',
423: p_commit => 'F',
424: p_repair_line_id =>null,
425: p_repair_number => null,