APPS.CSD_RECALLS_PVT dependencies on CSD_REPAIRS

Line 396: csd_repairs cr,

392: cr.quantity,
393: msi.concatenated_segments
394: FROM csd_recall_lines crl,
395: csi_item_instances cii,
396: csd_repairs cr,
397: cs_incidents_all_b cs,
398: mtl_system_items_kfv msi
399: WHERE crl.processing_group_id = p_group_id
400: AND crl.instance_id = cii.instance_id

Line 615: l_repln_rec csd_repairs_pub.repln_rec_type;

611: l_create_job_flag BOOLEAN := FALSE;
612: l_index NUMBER;
613: l_service_request_rec csd_process_pvt.service_request_rec := csd_process_util.sr_rec;
614: l_sr_notes_tbl cs_servicerequest_pub.notes_table;
615: l_repln_rec csd_repairs_pub.repln_rec_type;
616: l_create_ro_flag BOOLEAN := FALSE;
617: l_ent_contracts oks_entitlements_pub.get_contop_tbl;
618: l_calc_resptime_flag VARCHAR2(1) := 'Y';
619: l_server_tz_id NUMBER;

Line 899: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repairs_util.get_entitlements for contract info');

895: AND rownum < 2;
896: END IF;
897:
898: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
899: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repairs_util.get_entitlements for contract info');
900: END IF;
901:
902: csd_repairs_util.get_entitlements(
903: p_api_version_number => 1.0,

Line 902: csd_repairs_util.get_entitlements(

898: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
899: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling csd_repairs_util.get_entitlements for contract info');
900: END IF;
901:
902: csd_repairs_util.get_entitlements(
903: p_api_version_number => 1.0,
904: p_init_msg_list => fnd_api.g_false,
905: p_commit => fnd_api.g_false,
906: p_contract_number => null,

Line 986: CSD_REPAIRS_PVT.Create_Repair_Order(

982: -- call create repair order PVT API.
983: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
984: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Calling Create_Repair_Order for creating RO');
985: END IF;
986: CSD_REPAIRS_PVT.Create_Repair_Order(
987: p_api_version_number => 1.0,
988: p_commit => fnd_api.g_false,
989: p_init_msg_list => fnd_api.g_true,
990: p_validation_level => fnd_api.g_valid_level_full,

Line 1376: FROM csd_repairs cr,

1372: AND sr.incident_status_id = cis.incident_status_id
1373: AND cis.status_code <> 'CLOSED'
1374: AND NOT EXISTS
1375: (SELECT 'exists'
1376: FROM csd_repairs cr,
1377: csd_repair_job_xref crj1
1378: WHERE cr.incident_id = crl.incident_id
1379: AND cr.repair_line_id = crj1.repair_line_id
1380: )