6795: p_validation_level IN NUMBER,
6796: x_return_status OUT NOCOPY VARCHAR2,
6797: x_msg_count OUT NOCOPY NUMBER,
6798: x_msg_data OUT NOCOPY VARCHAR2,
6799: p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,
6800: x_estimate_hdr_id OUT NOCOPY NUMBER ) IS
6801: l_incident_id NUMBER;
6802: l_tmp_count NUMBER;
6803: l_repln_obj_Ver NUMBER;
6808: l_msg_Data VARCHAR2(2000);
6809: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESTIMATE_HEADER';
6810: l_api_version CONSTANT NUMBER := 1.0;
6811:
6812: l_estimate_hdr_rec Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC;
6813: l_est_hdr_pvt_rec Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC;
6814: BEGIN
6815:
6816: IF (Fnd_Log.level_procedure >= Fnd_Log.g_current_runtime_level)
6992: p_validation_level IN NUMBER,
6993: x_return_status OUT NOCOPY VARCHAR2,
6994: x_msg_count OUT NOCOPY NUMBER,
6995: x_msg_data OUT NOCOPY VARCHAR2,
6996: p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,
6997: x_estimate_line_id OUT NOCOPY NUMBER) IS
6998:
6999: l_tmp_count NUMBER;
7000: l_repair_type_id NUMBER;
7007: l_no_charge_flag VARCHAR2(10);
7008: l_contract_line_id NUMBER;
7009:
7010: l_est_pvt_line_rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_LINE_REC;
7011: l_estimate_line_rec Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC;
7012:
7013: BEGIN
7014:
7015: -- Standard Start of API savepoint
7145: p_validation_level IN NUMBER,
7146: x_return_status OUT NOCOPY VARCHAR2,
7147: x_msg_count OUT NOCOPY NUMBER,
7148: x_msg_data OUT NOCOPY VARCHAR2,
7149: p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,
7150: x_object_version_number OUT NOCOPY NUMBER) IS
7151:
7152: l_return_status VARCHAR2(30);
7153: l_approval_Status VARCHAR2(30);
7156: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATE_HEADER';
7157: l_api_version CONSTANT NUMBER := 1.0;
7158:
7159: l_est_pvt_hdr_Rec CSD_REPAIR_ESTIMATE_PVT.REPAIR_ESTIMATE_REC;
7160: l_estimate_hdr_rec Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC;
7161:
7162: l_est_status_changed BOOLEAN;
7163: l_est_hdr_id NUMBER;
7164:
7420: p_validation_level IN NUMBER,
7421: x_return_status OUT NOCOPY VARCHAR2,
7422: x_msg_count OUT NOCOPY NUMBER,
7423: x_msg_data OUT NOCOPY VARCHAR2,
7424: p_estimate_line_rec IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,
7425: x_object_version_number OUT NOCOPY NUMBER) IS
7426: BEGIN
7427: NULL;
7428: END UPDATE_ESTIMATE_LINE;