APPS.CSD_WF_PROCESS_PVT dependencies on CSD_REPAIRS

Line 41: csd_repairs ro

37: ro.serial_number,
38: sr.item,
39: decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
40: from csd_incidents_v sr,
41: csd_repairs ro
42: where ro.incident_id = sr.incident_id
43: and ro.repair_line_id = p_repair_line_id;
44:
45: -- cursor to see if a role exist for the SR contact.

Line 50: csd_repairs ro

46: Cursor get_wf_role (p_repair_line_id in number) is
47: Select wr.name
48: from wf_roles wr,
49: cs_incidents_v sr,
50: csd_repairs ro
51: where ro.repair_line_id = p_repair_line_id
52: and ro.incident_id = sr.incident_id
53: and wr.orig_system_id = sr.contact_party_id
54: and wr.orig_system = 'HZ_PARTY'

Line 191: csd_repairs_v ro

187: ro.item,
188: ro.flow_status,
189: decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
190: from csd_incidents_v sr,
191: csd_repairs_v ro
192: where ro.incident_id = sr.incident_id
193: and ro.repair_line_id = p_repair_line_id;
194:
195: -- cursor to see if a role exists for the SR contact.

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 341: csd_repairs_v ro,

337: ro.flow_status, ro.item,
338: cjr.source_first_name, cjr.source_last_name
339: From wf_roles wr,
340: csd_incidents_v sr,
341: csd_repairs_v ro,
342: CS_JTF_RS_RESOURCE_EXTNS_SEC cjr
343: Where ro.repair_line_id = p_repair_line_id
344: and ro.incident_id = sr.incident_id
345: and wr.orig_system_id = cjr.source_id

Line 429: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;

425: -- local variable declaration
426: l_return_status Varchar2(1);
427: l_msg_count Number;
428: l_msg_data Varchar2(2000);
429: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
430: l_repln_rec_clear CSD_REPAIRS_PUB.REPLN_Rec_Type;
431: l_repair_line_id Number;
432: l_repair_number Varchar2(30);
433: l_int_party_rec csd_bulk_receive_util.bulk_receive_rec;

Line 430: l_repln_rec_clear CSD_REPAIRS_PUB.REPLN_Rec_Type;

426: l_return_status Varchar2(1);
427: l_msg_count Number;
428: l_msg_data Varchar2(2000);
429: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
430: l_repln_rec_clear CSD_REPAIRS_PUB.REPLN_Rec_Type;
431: l_repair_line_id Number;
432: l_repair_number Varchar2(30);
433: l_int_party_rec csd_bulk_receive_util.bulk_receive_rec;
434: l_notes_tbl cs_servicerequest_pub.notes_table;

Line 711: csd_repairs_pvt.Create_Repair_Order(

707:
708: l_repair_line_id := null;
709: l_repair_number := null;
710:
711: csd_repairs_pvt.Create_Repair_Order(
712: P_Api_Version_Number => 1.0,
713: P_Init_Msg_List => Fnd_Api.G_TRUE,
714: P_Commit => Fnd_Api.G_FALSE,
715: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 830: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'Calling csd_repairs_util.create_repair_warranty for order line id '||l_order_line_id);

826: END IF;
827: l_order_line_id := to_number(itemkey);
828: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
829: THEN
830: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'Calling csd_repairs_util.create_repair_warranty for order line id '||l_order_line_id);
831: END IF;
832: csd_repairs_util.create_repair_warranty
833: (p_api_version_number => 1.0,
834: p_init_msg_list => fnd_api.g_true,

Line 832: csd_repairs_util.create_repair_warranty

828: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
829: THEN
830: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'Calling csd_repairs_util.create_repair_warranty for order line id '||l_order_line_id);
831: END IF;
832: csd_repairs_util.create_repair_warranty
833: (p_api_version_number => 1.0,
834: p_init_msg_list => fnd_api.g_true,
835: p_commit => fnd_api.g_false,
836: x_return_status => x_return_status,

Line 845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'Return from csd_repairs_util.create_repair_warranty. The return status is '||x_return_status);

841: );
842:
843: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
844: THEN
845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, lc_mod_name, 'Return from csd_repairs_util.create_repair_warranty. The return status is '||x_return_status);
846: END IF;
847:
848: IF x_return_status = fnd_api.g_ret_sts_success
849: THEN