The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_REPAIR_LINE_ID IN NUMBER,
P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2) IS
--
l_api_name CONSTANT VARCHAR2(30) := 'Update_Repair_Order';
SAVEPOINT UPDATE_REPAIR_ORDER_PUB;
CSD_repairs_PVT.Update_Repair_Order(P_Api_Version_Number => 1.0,
P_Init_Msg_List => p_init_msg_list,
P_Commit => p_commit,
P_Validation_Level => p_validation_level,
p_REPAIR_LINE_ID => p_repair_line_id,
P_REPLN_Rec => p_REPLN_Rec,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
ROLLBACK TO UPDATE_REPAIR_ORDER_PUB;
End Update_Repair_Order;
PROCEDURE Update_Repair_Type (
p_api_version IN NUMBER,
p_commit IN VARCHAR2 := fnd_api.g_false,
p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_repair_type_rec IN CSD_REPAIRS_PUB.Repair_Type_Rec_Type,
x_object_version_number OUT NOCOPY NUMBER
) IS
--
l_api_name CONSTANT VARCHAR2(30) := 'Update_Repair_Type';
SAVEPOINT UPDATE_REPAIR_TYPE_PUB;
CSD_REPAIRS_PVT.UPDATE_REPAIR_TYPE(P_Api_Version => p_api_version,
p_commit => CSD_PROCESS_UTIL.g_false,
p_init_msg_list => CSD_PROCESS_UTIL.g_false,
p_validation_level => p_validation_level,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_repair_line_id => p_repair_type_rec.repair_line_id,
p_from_repair_type_id => p_repair_type_rec.from_repair_type_id,
p_to_repair_type_id => p_repair_type_rec.to_repair_type_id,
p_common_flow_status_id => p_repair_type_rec.common_flow_status_id,
p_reason_code => p_repair_type_rec.reason_code,
p_object_version_number => p_repair_type_rec.object_version_number,
x_object_version_number => x_object_version_number
);
ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
'EXC_ERROR[' || x_msg_data || ']');
ROLLBACK TO UPDATE_REPAIR_TYPE_PUB;
'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
'EXC_UNEXP_ERROR[' || x_msg_data || ']');
Rollback TO UPDATE_REPAIR_TYPE_PUB;
'csd.plsql.CSD_REPAIRS_PUB.Update_Repair_Type',
'SQL MEssage[' || SQLERRM || ']');
End Update_Repair_Type;
* Update Repair Order Status
* @param P_Api_Version api version number
* @param P_Commit to decide whether to commit the transaction or not, default to false
* @param P_Init_Msg_List initial the message stack, default to false
* @param X_Return_Status return status
* @param X_Msg_Count return message count
* @param X_Msg_Data return message data
* @param P_Repair_status_rec repair status attributes record.
* @param P_status_upd_control_rec repair status record control flags.
* @param X_OBJECT_VERSION_NUMBER
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Update Repair Order Status
*/
PROCEDURE Update_Ro_Status(P_Api_Version IN NUMBER,
P_Commit IN VARCHAR2,
P_Init_Msg_List IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
P_REPAIR_STATUS_Rec IN REPAIR_STATUS_REC_TYPE,
P_STATUS_UPD_CONTROL_REC IN STATUS_UPD_CONTROL_REC_TYPE,
X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER) IS
--
l_api_name CONSTANT VARCHAR2(30) := 'Update_Ro_Status';
SAVEPOINT UPDATE_RO_STATUS_PUB;
CSD_REPAIRS_PVT.UPDATE_RO_STATUS(P_Api_Version => p_api_version,
P_Commit => p_commit,
P_Init_Msg_List => p_init_msg_list,
P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data,
P_REPAIR_STATUS_REC => p_repair_status_rec,
P_STATUS_CONTROL_REC => p_status_upd_control_rec,
X_OBJECT_VERSION_NUMBER => x_object_Version_number);
ROLLBACK TO UPDATE_RO_STATUS_PUB;
ROLLBACK TO UPDATE_RO_STATUS_PUB;
'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
'EXC_ERROR[' || x_msg_data || ']');
ROLLBACK TO UPDATE_RO_STATUS_PUB;
'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
'EXC_UNEXP_ERROR[' || x_msg_data || ']');
Rollback TO UPDATE_RO_STATUS_PUB;
'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
'SQL MEssage[' || SQLERRM || ']');
End Update_ro_status;