APPS.CSD_OM_INTERFACE_PVT dependencies on CSD_REPAIRS

Line 224: l_rep_line_tbl CSD_REPAIRS_PUB.REPLN_TBL_Type;

220:
221: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
222: l_notes_table CS_ServiceRequest_PUB.notes_table;
223: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
224: l_rep_line_tbl CSD_REPAIRS_PUB.REPLN_TBL_Type;
225: l_inc_type_id NUMBER;
226: l_inc_status_id NUMBER;
227: l_inc_severity_id NUMBER;
228: l_inc_urgency_id NUMBER;

Line 321: ( select 'X' from csd_repairs cra

317: AND rcv.organization_id = haou.organization_id
318: AND rcv.organization_id = p_inv_org_id
319: AND rcv.subinventory = p_sub_inv
320: AND not exists
321: ( select 'X' from csd_repairs cra
322: where cra.original_source_line_id = oel.line_id
323: and cra.original_source_header_id = oel.header_id)
324: AND not exists
325: ( select 'x' from cs_estimate_details ced

Line 537: from csd_repairs cra

533: -- for every order line
534: Begin
535: Select incident_id
536: into l_incident_id
537: from csd_repairs cra
538: where cra.original_source_header_id = c1.rma_header_id
539: -- and cra.original_source_line_id = c1.line_id
540: and rownum = 1;
541: l_skip_sr_flag := TRUE;

Line 851: Debug( 'Calling CSD_REPAIRS_PVT.Create_Repair_Order',l_mod_name,1);

847: Savepoint create_ro;
848:
849: l_REPAIR_line_id := NULL;
850:
851: Debug( 'Calling CSD_REPAIRS_PVT.Create_Repair_Order',l_mod_name,1);
852: CSD_REPAIRS_PVT.Create_Repair_Order
853: ( P_Api_Version_Number => 1.0,
854: P_Init_Msg_List => FND_API.G_TRUE,
855: P_Commit => FND_API.G_FALSE,

Line 852: CSD_REPAIRS_PVT.Create_Repair_Order

848:
849: l_REPAIR_line_id := NULL;
850:
851: Debug( 'Calling CSD_REPAIRS_PVT.Create_Repair_Order',l_mod_name,1);
852: CSD_REPAIRS_PVT.Create_Repair_Order
853: ( P_Api_Version_Number => 1.0,
854: P_Init_Msg_List => FND_API.G_TRUE,
855: P_Commit => FND_API.G_FALSE,
856: p_validation_level => fnd_api.g_valid_level_full,