The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Repair_Order(
p_Init_Msg_List IN VARCHAR2 := 'F',
p_Commit IN VARCHAR2 := 'F',
p_REPAIR_LINE_ID IN NUMBER,
p_REPAIR_NUMBER IN VARCHAR2,
p_INCIDENT_ID IN NUMBER,
p_INVENTORY_ITEM_ID IN NUMBER,
p_CUSTOMER_PRODUCT_ID IN NUMBER,
p_UNIT_OF_MEASURE IN VARCHAR2,
p_REPAIR_TYPE_ID IN NUMBER,
-- RESOURCE_GROUP Added by Vijay 10/28/2004
p_RESOURCE_GROUP IN NUMBER,
p_RESOURCE_ID IN NUMBER,
p_PROJECT_ID IN NUMBER,
p_TASK_ID IN NUMBER,
p_UNIT_NUMBER IN VARCHAR2, -- rfieldma, prj integration
p_CONTRACT_LINE_ID IN NUMBER,
p_AUTO_PROCESS_RMA IN VARCHAR2,
p_REPAIR_MODE IN VARCHAR2,
p_OBJECT_VERSION_NUMBER IN NUMBER,
p_ITEM_REVISION IN VARCHAR2,
p_INSTANCE_ID IN NUMBER,
p_STATUS IN VARCHAR2,
p_STATUS_REASON_CODE IN VARCHAR2,
p_DATE_CLOSED IN DATE,
p_APPROVAL_REQUIRED_FLAG IN VARCHAR2,
p_APPROVAL_STATUS IN VARCHAR2,
p_SERIAL_NUMBER IN VARCHAR2,
p_PROMISE_DATE IN DATE,
p_ATTRIBUTE_CATEGORY IN VARCHAR2,
p_ATTRIBUTE1 IN VARCHAR2,
p_ATTRIBUTE2 IN VARCHAR2,
p_ATTRIBUTE3 IN VARCHAR2,
p_ATTRIBUTE4 IN VARCHAR2,
p_ATTRIBUTE5 IN VARCHAR2,
p_ATTRIBUTE6 IN VARCHAR2,
p_ATTRIBUTE7 IN VARCHAR2,
p_ATTRIBUTE8 IN VARCHAR2,
p_ATTRIBUTE9 IN VARCHAR2,
p_ATTRIBUTE10 IN VARCHAR2,
p_ATTRIBUTE11 IN VARCHAR2,
p_ATTRIBUTE12 IN VARCHAR2,
p_ATTRIBUTE13 IN VARCHAR2,
p_ATTRIBUTE14 IN VARCHAR2,
p_ATTRIBUTE15 IN VARCHAR2,
-- additional DFF attributes, subhat(bug#7497907).
P_ATTRIBUTE16 IN VARCHAR2 ,
P_ATTRIBUTE17 IN VARCHAR2 ,
P_ATTRIBUTE18 IN VARCHAR2 ,
P_ATTRIBUTE19 IN VARCHAR2 ,
P_ATTRIBUTE20 IN VARCHAR2 ,
P_ATTRIBUTE21 IN VARCHAR2 ,
P_ATTRIBUTE22 IN VARCHAR2 ,
P_ATTRIBUTE23 IN VARCHAR2 ,
P_ATTRIBUTE24 IN VARCHAR2 ,
P_ATTRIBUTE25 IN VARCHAR2 ,
P_ATTRIBUTE26 IN VARCHAR2 ,
P_ATTRIBUTE27 IN VARCHAR2 ,
P_ATTRIBUTE28 IN VARCHAR2 ,
P_ATTRIBUTE29 IN VARCHAR2 ,
P_ATTRIBUTE30 IN VARCHAR2 ,
p_QUANTITY IN NUMBER,
p_QUANTITY_IN_WIP IN NUMBER,
p_QUANTITY_RCVD IN NUMBER,
p_QUANTITY_SHIPPED IN NUMBER,
p_CURRENCY_CODE IN VARCHAR2,
p_DEFAULT_PO_NUM IN VARCHAR2 := null,
p_REPAIR_GROUP_ID IN NUMBER,
p_RO_TXN_STATUS IN VARCHAR2,
p_ORDER_LINE_ID IN NUMBER,
p_ORIGINAL_SOURCE_REFERENCE IN VARCHAR2,
p_ORIGINAL_SOURCE_HEADER_ID IN NUMBER,
p_ORIGINAL_SOURCE_LINE_ID IN NUMBER,
p_PRICE_LIST_HEADER_ID IN NUMBER,
p_PROBLEM_DESCRIPTION IN VARCHAR2, -- swai: bug 4666344
p_RO_PRIORITY_CODE IN VARCHAR2, -- swai: R12
-- g_miss_date means keep field in table handler
-- null means clear field in table handler
p_RESOLVE_BY_DATE IN DATE, -- rfieldma, bug 5355051, defaulted to g_miss_date in spec
p_BULLETIN_CHECK_DATE IN DATE, -- := FND_API.G_MISS_DATE,
p_ESCALATION_CODE IN VARCHAR2, -- := FND_API.G_MISS_CHAR,
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_GRP;
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order before CSD_REPAIRS_PUB.Update_Repair_Order');
CSD_REPAIRS_PUB.Update_Repair_Order
(p_API_version_number => 1.0,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_repair_line_id => p_repair_line_id,
p_Repln_Rec => l_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_GRP;
End Update_Repair_Order;
Procedure Update_Approval_Status(
p_repair_line_id IN NUMBER,
p_new_approval_status IN VARCHAR2,
p_old_approval_status IN VARCHAR2,
p_quantity IN NUMBER,
p_org_contact_id IN NUMBER,
p_reason IN VARCHAR2,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)
IS
-- CONSTANTS --
lc_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.csd_repairs_grp.update_approval_status';
l_api_name CONSTANT VARCHAR2(30) := 'Update_Approval_Status';
SAVEPOINT UPDATE_APPROVAL_STATUS_GRP;
'Calling CSD_REPAIRS_PVT.Update_Repair_Order ');
CSD_REPAIRS_PVT.Update_Repair_Order
(p_API_version_number => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_commit => FND_API.G_FALSE,
p_validation_level => null,
p_repair_line_id => p_repair_line_id,
p_Repln_Rec => l_Repln_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
'Returned from CSD_REPAIRS_PVT.Update_Repair_Order. x_return_status='|| x_return_status);
ROLLBACK TO UPDATE_APPROVAL_STATUS_GRP;
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Approval_Status before api CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call');
p_PROGRAM_UPDATE_DATE => null,
p_CREATED_BY => FND_GLOBAL.USER_ID,
p_CREATION_DATE => sysdate,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_DATE => sysdate,
p_repair_line_id => p_repair_line_id,
p_EVENT_CODE => l_event_code,
p_EVENT_DATE => sysdate,
p_QUANTITY => p_quantity,
p_PARAMN1 => p_org_contact_id,
p_PARAMN2 => l_estimate_total,
p_PARAMN3 => null,
p_PARAMN4 => null,
p_PARAMN5 => null,
p_PARAMN6 => null,
p_PARAMN7 => null,
p_PARAMN8 => null,
p_PARAMN9 => null,
p_PARAMN10 => FND_GLOBAL.USER_ID,
p_PARAMC1 => p_new_approval_status,
p_PARAMC2 => p_old_approval_status,
p_PARAMC3 => p_reason,
p_PARAMC4 => null,
p_PARAMC5 => null ,
p_PARAMC6 => null,
p_PARAMC7 => null,
p_PARAMC8 => null,
p_PARAMC9 => null,
p_PARAMC10 => null,
p_PARAMD1 => null,
p_PARAMD2 => null,
p_PARAMD3 => null,
p_PARAMD4 => null,
p_PARAMD5 => null,
p_PARAMD6 => null,
p_PARAMD7 => null,
p_PARAMD8 => null,
p_PARAMD9 => null,
p_PARAMD10 => null,
p_ATTRIBUTE_CATEGORY => null,
p_ATTRIBUTE1 => null,
p_ATTRIBUTE2 => null,
p_ATTRIBUTE3 => null,
p_ATTRIBUTE4 => null,
p_ATTRIBUTE5 => null,
p_ATTRIBUTE6 => null,
p_ATTRIBUTE7 => null,
p_ATTRIBUTE8 => null,
p_ATTRIBUTE9 => null,
p_ATTRIBUTE10 => null,
p_ATTRIBUTE11 => null,
p_ATTRIBUTE12 =>null,
p_ATTRIBUTE13 => null,
p_ATTRIBUTE14 => null,
p_ATTRIBUTE15 => null,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data
);
ROLLBACK TO UPDATE_APPROVAL_STATUS_GRP;
END Update_Approval_Status;
Procedure Update_Status(
p_repair_line_id IN NUMBER,
p_new_status IN VARCHAR2,
p_old_status IN VARCHAR2,
p_quantity IN NUMBER,
p_reason IN VARCHAR2,
p_status_reason_code IN VARCHAR2,
p_object_version_number IN NUMBER,
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_Status';
SAVEPOINT UPDATE_STATUS_GRP;
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_REPAIRS_PVT.Update_Repair_Order');
CSD_REPAIRS_PVT.Update_Repair_Order
(p_API_version_number => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_commit => FND_API.G_FALSE,
p_validation_level => null,
p_repair_line_id => p_repair_line_id,
p_Repln_Rec => l_Repln_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status after CSD_REPAIRS_PVT.Update_Repair_Order status : '||x_return_status);
ROLLBACK TO UPDATE_STATUS_GRP;
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
p_PROGRAM_UPDATE_DATE => null,
p_CREATED_BY => FND_GLOBAL.USER_ID,
p_CREATION_DATE => sysdate,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_DATE => sysdate,
p_repair_line_id => p_repair_line_id,
p_EVENT_CODE => 'SC',
p_EVENT_DATE => sysdate,
p_QUANTITY => p_quantity,
p_PARAMN1 => null,
p_PARAMN2 => null,
p_PARAMN3 => null,
p_PARAMN4 => null,
p_PARAMN5 => null,
p_PARAMN6 => null,
p_PARAMN7 => null,
p_PARAMN8 => null,
p_PARAMN9 => null,
p_PARAMN10 => FND_GLOBAL.USER_ID,
p_PARAMC1 => p_new_status,
p_PARAMC2 => p_old_status,
p_PARAMC3 => p_reason,
p_PARAMC4 => null,
p_PARAMC5 => null,
p_PARAMC6 => null,
p_PARAMC7 => null,
p_PARAMC8 => null,
p_PARAMC9 => null,
p_PARAMC10 => null,
p_PARAMD1 => null,
p_PARAMD2 => null,
p_PARAMD3 => null,
p_PARAMD4 => null,
p_PARAMD5 => null,
p_PARAMD6 => null,
p_PARAMD7 => null,
p_PARAMD8 => null,
p_PARAMD9 => null,
p_PARAMD10 => null,
p_ATTRIBUTE_CATEGORY => null,
p_ATTRIBUTE1 => null,
p_ATTRIBUTE2 => null,
p_ATTRIBUTE3 => null,
p_ATTRIBUTE4 => null,
p_ATTRIBUTE5 => null,
p_ATTRIBUTE6 => null,
p_ATTRIBUTE7 => null,
p_ATTRIBUTE8 => null,
p_ATTRIBUTE9 => null,
p_ATTRIBUTE10 => null,
p_ATTRIBUTE11 => null,
p_ATTRIBUTE12 =>null,
p_ATTRIBUTE13 => null,
p_ATTRIBUTE14 => null,
p_ATTRIBUTE15 => null,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data
);
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write status : '||x_return_status);
ROLLBACK TO UPDATE_STATUS_GRP;
END Update_Status;
Procedure Update_Group_Approval_Status(
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,
p_repair_group_id IN NUMBER,
p_object_version_number IN OUT NOCOPY NUMBER,
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_Group_Approval_Status';
Select rep.repair_line_id
, rep.approval_status
, rep.quantity
, rep.object_version_number rep_ovn
, est.repair_estimate_id
, est.object_version_number est_ovn
from csd_repairs rep
, csd_repair_estimate est
where rep.repair_group_id = p_repair_group_id
and rep.repair_line_id = est.repair_line_id
and est.estimate_status = 'BID';
SAVEPOINT UPDATE_GRP_APPV_STATUS;
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status convert repairs rec call');
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update repairs call');
CSD_REPAIRS_PVT.Update_Repair_Order
(p_API_version_number => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_commit => FND_API.G_FALSE,
p_validation_level => null,
p_repair_line_id => l_repair_line_id,
p_Repln_Rec => l_rep_ord_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update_Repair_Order :'||x_return_status);
csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO hist call');
p_PROGRAM_UPDATE_DATE => null,
p_CREATED_BY => FND_GLOBAL.USER_ID,
p_CREATION_DATE => sysdate,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_DATE => sysdate,
p_repair_line_id => l_repair_line_id,
p_EVENT_CODE => l_event_code,
p_EVENT_DATE => sysdate,
p_QUANTITY => l_rep_quantity,
p_PARAMN1 => null,
p_PARAMN2 => null,
p_PARAMN3 => null,
p_PARAMN4 => null,
p_PARAMN5 => null,
p_PARAMN6 => null,
p_PARAMN7 => null,
p_PARAMN8 => null,
p_PARAMN9 => null,
p_PARAMN10 => FND_GLOBAL.USER_ID,
p_PARAMC1 => l_approval_status, -- new status
p_PARAMC2 => l_rep_approval_status, -- old status
p_PARAMC3 => 'Repair Group Estimate Approval', -- travi new
p_PARAMC4 => null,
p_PARAMC5 => null ,
p_PARAMC6 => null,
p_PARAMC7 => null,
p_PARAMC8 => null,
p_PARAMC9 => null,
p_PARAMC10 => null,
p_PARAMD1 => null,
p_PARAMD2 => null,
p_PARAMD3 => null,
p_PARAMD4 => null,
p_PARAMD5 => null,
p_PARAMD6 => null,
p_PARAMD7 => null,
p_PARAMD8 => null,
p_PARAMD9 => null,
p_PARAMD10 => null,
p_ATTRIBUTE_CATEGORY => null,
p_ATTRIBUTE1 => null,
p_ATTRIBUTE2 => null,
p_ATTRIBUTE3 => null,
p_ATTRIBUTE4 => null,
p_ATTRIBUTE5 => null,
p_ATTRIBUTE6 => null,
p_ATTRIBUTE7 => null,
p_ATTRIBUTE8 => null,
p_ATTRIBUTE9 => null,
p_ATTRIBUTE10 => null,
p_ATTRIBUTE11 => null,
p_ATTRIBUTE12 =>null,
p_ATTRIBUTE13 => null,
p_ATTRIBUTE14 => null,
p_ATTRIBUTE15 => null,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data
);
csd_gen_utility_pvt.add('Update_Group_Approval_Status Validate_And_Write :'||x_return_status);
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO estimate call');
csd_repair_estimate_pvt.update_repair_estimate
(p_api_version => 1.0,
p_commit => 'F',
p_init_msg_list => 'T',
p_validation_level => fnd_api.g_valid_level_full,
x_estimate_rec => l_rep_est_rec,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status update_repair_estimate :'||x_return_status);
csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');
ROLLBACK TO UPDATE_GRP_APPV_STATUS;
ROLLBACK TO UPDATE_GRP_APPV_STATUS;
ROLLBACK TO UPDATE_GRP_APPV_STATUS;
END Update_Group_Approval_Status;
Procedure Update_Group_Reject_Status(
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,
p_repair_group_id IN NUMBER,
p_object_version_number IN OUT NOCOPY NUMBER,
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_Group_Reject_Status';
Select rep.repair_line_id
, rep.approval_status
, rep.quantity
, rep.object_version_number rep_ovn
, est.repair_estimate_id
, est.object_version_number est_ovn
from csd_repairs rep
, csd_repair_estimate est
where rep.repair_group_id = p_repair_group_id
and rep.repair_line_id = est.repair_line_id;
SAVEPOINT UPDATE_GRP_REJT_STATUS;
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status convert repairs rec call');
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update repairs call');
CSD_REPAIRS_PVT.Update_Repair_Order
(p_API_version_number => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_commit => FND_API.G_FALSE,
p_validation_level => null,
p_repair_line_id => l_repair_line_id,
p_Repln_Rec => l_rep_ord_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update_Repair_Order :'||x_return_status);
csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO hist call');
p_PROGRAM_UPDATE_DATE => null,
p_CREATED_BY => FND_GLOBAL.USER_ID,
p_CREATION_DATE => sysdate,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_DATE => sysdate,
p_repair_line_id => l_repair_line_id,
p_EVENT_CODE => l_event_code,
p_EVENT_DATE => sysdate,
p_QUANTITY => l_rep_quantity,
p_PARAMN1 => null,
p_PARAMN2 => null,
p_PARAMN3 => null,
p_PARAMN4 => null,
p_PARAMN5 => null,
p_PARAMN6 => null,
p_PARAMN7 => null,
p_PARAMN8 => null,
p_PARAMN9 => null,
p_PARAMN10 => FND_GLOBAL.USER_ID,
p_PARAMC1 => l_Reject_status, -- new status
p_PARAMC2 => l_rep_Reject_status, -- old status
p_PARAMC3 => 'Repair Group Estimate Reject', -- travi new
p_PARAMC4 => null,
p_PARAMC5 => null ,
p_PARAMC6 => null,
p_PARAMC7 => null,
p_PARAMC8 => null,
p_PARAMC9 => null,
p_PARAMC10 => null,
p_PARAMD1 => null,
p_PARAMD2 => null,
p_PARAMD3 => null,
p_PARAMD4 => null,
p_PARAMD5 => null,
p_PARAMD6 => null,
p_PARAMD7 => null,
p_PARAMD8 => null,
p_PARAMD9 => null,
p_PARAMD10 => null,
p_ATTRIBUTE_CATEGORY => null,
p_ATTRIBUTE1 => null,
p_ATTRIBUTE2 => null,
p_ATTRIBUTE3 => null,
p_ATTRIBUTE4 => null,
p_ATTRIBUTE5 => null,
p_ATTRIBUTE6 => null,
p_ATTRIBUTE7 => null,
p_ATTRIBUTE8 => null,
p_ATTRIBUTE9 => null,
p_ATTRIBUTE10 => null,
p_ATTRIBUTE11 => null,
p_ATTRIBUTE12 =>null,
p_ATTRIBUTE13 => null,
p_ATTRIBUTE14 => null,
p_ATTRIBUTE15 => null,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data
);
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Validate_And_Write :'||x_return_status);
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO estimate call');
csd_repair_estimate_pvt.update_repair_estimate
(p_api_version => 1.0,
p_commit => 'F',
p_init_msg_list => 'T',
p_validation_level => fnd_api.g_valid_level_full,
x_estimate_rec => l_rep_est_rec,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status update_repair_estimate :'||x_return_status);
csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');
ROLLBACK TO UPDATE_GRP_REJT_STATUS;
ROLLBACK TO UPDATE_GRP_REJT_STATUS;
ROLLBACK TO UPDATE_GRP_REJT_STATUS;
END Update_Group_Reject_Status;