[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT customer_id,
account_id
FROM cs_incidents_all_b
WHERE incident_id = p_incident_id;
select count(*)
into l_act_count
from csd_repair_actuals
where repair_line_id = px_CSD_ACTUAL_LINES_REC.repair_line_id;
lx_csd_actuals_rec.LAST_UPDATED_BY := NULL;
lx_csd_actuals_rec.LAST_UPDATE_DATE := NULL;
lx_csd_actuals_rec.LAST_UPDATE_LOGIN := NULL;
select repair_actual_id
into l_act_hdr
from csd_repair_actuals
where repair_line_id = px_CSD_ACTUAL_LINES_REC.repair_line_id;
FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');
FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'LAST_UPDATED_BY = '|| FND_GLOBAL.USER_ID);
CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID
,p_REPAIR_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
,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_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
,p_ITEM_COST => px_CSD_ACTUAL_LINES_REC.ITEM_COST
,p_JUSTIFICATION_NOTES => px_CSD_ACTUAL_LINES_REC.JUSTIFICATION_NOTES
,p_RESOURCE_ID => px_CSD_ACTUAL_LINES_REC.RESOURCE_ID
,p_OVERRIDE_CHARGE_FLAG => px_CSD_ACTUAL_LINES_REC.OVERRIDE_CHARGE_FLAG
,p_ACTUAL_SOURCE_CODE => px_CSD_ACTUAL_LINES_REC.ACTUAL_SOURCE_CODE
,p_ACTUAL_SOURCE_ID => px_CSD_ACTUAL_LINES_REC.ACTUAL_SOURCE_ID
,p_WARRANTY_CLAIM_FLAG => px_CSD_ACTUAL_LINES_REC.WARRANTY_CLAIM_FLAG
,p_WARRANTY_NUMBER => px_CSD_ACTUAL_LINES_REC.WARRANTY_NUMBER
,p_WARRANTY_STATUS_CODE => px_CSD_ACTUAL_LINES_REC.WARRANTY_STATUS_CODE
,p_REPLACED_ITEM_ID => px_CSD_ACTUAL_LINES_REC.REPLACED_ITEM_ID
,p_ATTRIBUTE_CATEGORY => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE_CATEGORY
,p_ATTRIBUTE1 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE1
,p_ATTRIBUTE2 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE2
,p_ATTRIBUTE3 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE3
,p_ATTRIBUTE4 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE4
,p_ATTRIBUTE5 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE5
,p_ATTRIBUTE6 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE6
,p_ATTRIBUTE7 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE7
,p_ATTRIBUTE8 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE8
,p_ATTRIBUTE9 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE9
,p_ATTRIBUTE10 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE10
,p_ATTRIBUTE11 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE11
,p_ATTRIBUTE12 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE12
,p_ATTRIBUTE13 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE13
,p_ATTRIBUTE14 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE14
,p_ATTRIBUTE15 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE15
,p_LOCATOR_ID => px_CSD_ACTUAL_LINES_REC.LOCATOR_ID
,p_LOC_SEGMENT1 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT1
,p_LOC_SEGMENT2 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT2
,p_LOC_SEGMENT3 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT3
,p_LOC_SEGMENT4 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT4
,p_LOC_SEGMENT5 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT5
,p_LOC_SEGMENT6 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT6
,p_LOC_SEGMENT7 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT7
,p_LOC_SEGMENT8 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT8
,p_LOC_SEGMENT9 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT9
,p_LOC_SEGMENT10 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT10
,p_LOC_SEGMENT11 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT11
,p_LOC_SEGMENT12 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT12
,p_LOC_SEGMENT13 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT13
,p_LOC_SEGMENT14 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT14
,p_LOC_SEGMENT15 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT15
,p_LOC_SEGMENT16 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT16
,p_LOC_SEGMENT17 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT17
,p_LOC_SEGMENT18 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT18
,p_LOC_SEGMENT19 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT19
,p_LOC_SEGMENT20 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT20);
FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Returned from CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');
FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');
FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'LAST_UPDATED_BY = '|| FND_GLOBAL.USER_ID);
CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID
,p_REPAIR_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
,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_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
,p_ITEM_COST => px_CSD_ACTUAL_LINES_REC.ITEM_COST
,p_JUSTIFICATION_NOTES => px_CSD_ACTUAL_LINES_REC.JUSTIFICATION_NOTES
,p_RESOURCE_ID => px_CSD_ACTUAL_LINES_REC.RESOURCE_ID
,p_OVERRIDE_CHARGE_FLAG => px_CSD_ACTUAL_LINES_REC.OVERRIDE_CHARGE_FLAG
,p_ACTUAL_SOURCE_CODE => px_CSD_ACTUAL_LINES_REC.ACTUAL_SOURCE_CODE
,p_ACTUAL_SOURCE_ID => px_CSD_ACTUAL_LINES_REC.ACTUAL_SOURCE_ID
,p_WARRANTY_CLAIM_FLAG => px_CSD_ACTUAL_LINES_REC.WARRANTY_CLAIM_FLAG
,p_WARRANTY_NUMBER => px_CSD_ACTUAL_LINES_REC.WARRANTY_NUMBER
,p_WARRANTY_STATUS_CODE => px_CSD_ACTUAL_LINES_REC.WARRANTY_STATUS_CODE
,p_REPLACED_ITEM_ID => px_CSD_ACTUAL_LINES_REC.REPLACED_ITEM_ID
,p_ATTRIBUTE_CATEGORY => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE_CATEGORY
,p_ATTRIBUTE1 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE1
,p_ATTRIBUTE2 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE2
,p_ATTRIBUTE3 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE3
,p_ATTRIBUTE4 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE4
,p_ATTRIBUTE5 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE5
,p_ATTRIBUTE6 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE6
,p_ATTRIBUTE7 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE7
,p_ATTRIBUTE8 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE8
,p_ATTRIBUTE9 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE9
,p_ATTRIBUTE10 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE10
,p_ATTRIBUTE11 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE11
,p_ATTRIBUTE12 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE12
,p_ATTRIBUTE13 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE13
,p_ATTRIBUTE14 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE14
,p_ATTRIBUTE15 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE15
,p_LOCATOR_ID => px_CSD_ACTUAL_LINES_REC.LOCATOR_ID
,p_LOC_SEGMENT1 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT1
,p_LOC_SEGMENT2 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT2
,p_LOC_SEGMENT3 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT3
,p_LOC_SEGMENT4 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT4
,p_LOC_SEGMENT5 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT5
,p_LOC_SEGMENT6 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT6
,p_LOC_SEGMENT7 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT7
,p_LOC_SEGMENT8 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT8
,p_LOC_SEGMENT9 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT9
,p_LOC_SEGMENT10 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT10
,p_LOC_SEGMENT11 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT11
,p_LOC_SEGMENT12 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT12
,p_LOC_SEGMENT13 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT13
,p_LOC_SEGMENT14 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT14
,p_LOC_SEGMENT15 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT15
,p_LOC_SEGMENT16 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT16
,p_LOC_SEGMENT17 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT17
,p_LOC_SEGMENT18 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT18
,p_LOC_SEGMENT19 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT19
,p_LOC_SEGMENT20 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT20);
FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
SELECT currency_code
INTO l_curr_code
FROM oe_price_lists
WHERE price_list_id = px_CHARGES_REC.price_list_id;
FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Insert_Row');
CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
px_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID
,p_REPAIR_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
,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_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
,p_ITEM_COST => px_CSD_ACTUAL_LINES_REC.ITEM_COST
,p_JUSTIFICATION_NOTES => px_CSD_ACTUAL_LINES_REC.JUSTIFICATION_NOTES
,p_RESOURCE_ID => px_CSD_ACTUAL_LINES_REC.RESOURCE_ID
,p_OVERRIDE_CHARGE_FLAG => px_CSD_ACTUAL_LINES_REC.OVERRIDE_CHARGE_FLAG
,p_ACTUAL_SOURCE_CODE => px_CSD_ACTUAL_LINES_REC.ACTUAL_SOURCE_CODE
,p_ACTUAL_SOURCE_ID => px_CSD_ACTUAL_LINES_REC.ACTUAL_SOURCE_ID
,p_WARRANTY_CLAIM_FLAG => px_CSD_ACTUAL_LINES_REC.WARRANTY_CLAIM_FLAG
,p_WARRANTY_NUMBER => px_CSD_ACTUAL_LINES_REC.WARRANTY_NUMBER
,p_WARRANTY_STATUS_CODE => px_CSD_ACTUAL_LINES_REC.WARRANTY_STATUS_CODE
,p_REPLACED_ITEM_ID => px_CSD_ACTUAL_LINES_REC.REPLACED_ITEM_ID
,p_ATTRIBUTE_CATEGORY => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE_CATEGORY
,p_ATTRIBUTE1 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE1
,p_ATTRIBUTE2 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE2
,p_ATTRIBUTE3 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE3
,p_ATTRIBUTE4 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE4
,p_ATTRIBUTE5 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE5
,p_ATTRIBUTE6 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE6
,p_ATTRIBUTE7 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE7
,p_ATTRIBUTE8 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE8
,p_ATTRIBUTE9 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE9
,p_ATTRIBUTE10 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE10
,p_ATTRIBUTE11 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE11
,p_ATTRIBUTE12 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE12
,p_ATTRIBUTE13 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE13
,p_ATTRIBUTE14 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE14
,p_ATTRIBUTE15 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE15
,p_LOCATOR_ID => px_CSD_ACTUAL_LINES_REC.LOCATOR_ID
,p_LOC_SEGMENT1 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT1
,p_LOC_SEGMENT2 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT2
,p_LOC_SEGMENT3 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT3
,p_LOC_SEGMENT4 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT4
,p_LOC_SEGMENT5 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT5
,p_LOC_SEGMENT6 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT6
,p_LOC_SEGMENT7 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT7
,p_LOC_SEGMENT8 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT8
,p_LOC_SEGMENT9 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT9
,p_LOC_SEGMENT10 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT10
,p_LOC_SEGMENT11 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT11
,p_LOC_SEGMENT12 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT12
,p_LOC_SEGMENT13 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT13
,p_LOC_SEGMENT14 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT14
,p_LOC_SEGMENT15 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT15
,p_LOC_SEGMENT16 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT16
,p_LOC_SEGMENT17 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT17
,p_LOC_SEGMENT18 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT18
,p_LOC_SEGMENT19 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT19
,p_LOC_SEGMENT20 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT20);
FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
/* procedure name: UPDATE_REPAIR_ACTUAL_LINES */
/* description : procedure used to Update Repair Actuals */
/* */
/* */
/* */
/* Called from : Depot Repair Actuals UI */
/* Input Parm : */
/* p_api_version NUMBER Req Api Version number */
/* p_init_msg_list VARCHAR2 Opt Initialize message stack */
/* p_commit VARCHAR2 Opt Commits in API */
/* p_validation_level NUMBER Opt validation steps */
/* px_CSD_ACTUAL_LINES_REC REC Req Actuals lines Record */
/* px_Charges_Rec REC Req Charges line Record */
/* Output Parm : */
/* x_return_status VARCHAR2 Return status after the call. */
/* x_msg_count NUMBER Number of messages in stack */
/* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
/* Change Hist : */
/* 08/11/03 travikan Initial Creation. */
/* */
/* */
/* */
/*--------------------------------------------------------------------*/
PROCEDURE UPDATE_REPAIR_ACTUAL_LINES(
P_Api_Version IN NUMBER,
P_Commit IN VARCHAR2,
P_Init_Msg_List IN VARCHAR2,
p_validation_level IN NUMBER,
px_CSD_ACTUAL_LINES_REC IN OUT NOCOPY CSD_ACTUAL_LINES_REC_TYPE,
px_Charges_Rec IN OUT NOCOPY CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
-- Variables used in FND Log
l_stat_level number := FND_LOG.LEVEL_STATEMENT;
l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.update_repair_actual_lines';
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REPAIR_ACTUAL_LINES';
SELECT object_version_number
FROM cs_estimate_details
WHERE estimate_detail_id = p_est_det_id;
SELECT a.object_version_number
FROM csd_repair_actual_lines a,
csd_repairs b
WHERE a.repair_line_id = b.repair_line_id
and a.repair_actual_line_id = p_actual_line_id;
SAVEPOINT UPDATE_REPAIR_ACTUAL_LINES;
FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of update_repair_actual_lines');
and nvl(px_csd_actual_lines_rec.UPDATE_ADD_TO_ORDER_FLAG,
CSD_PROCESS_UTIL.G_TRUE) = CSD_PROCESS_UTIL.G_TRUE then
select line_order_category_code
into l_line_order_category_code
from cs_transaction_types_b
where transaction_type_id = px_Charges_Rec.TRANSACTION_TYPE_ID;
Select max(ced.order_header_id)
into l_add_actual_to_id
from cs_estimate_details ced,
oe_order_headers_all ooh,
oe_order_types_v oot
where
ced.estimate_detail_id in
(select estimate_detail_id
from csd_product_transactions
where repair_line_id = px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
union
select estimate_detail_id
from csd_repair_actual_lines
where repair_actual_id=px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID)
and ced.order_header_id is not null
and ooh.open_flag = 'Y'
and nvl(ooh.cancelled_flag,'N') = 'N'
and ooh.header_id = ced.order_header_id
and (ooh.cust_po_number = nvl(px_Charges_Rec.PURCHASE_ORDER_NUM,ooh.cust_po_number)
or ooh.cust_po_number is null)
and ooh.sold_to_org_id = px_Charges_Rec.bill_to_account_id -- swai: bug 6962424
and oot.order_type_id = ooh.order_type_id
and oot.order_category_code in ('MIXED','ORDER')
and ced.interface_to_oe_flag = 'Y';
Select max(ced.order_header_id)
into l_add_actual_to_id
from cs_estimate_details ced,
oe_order_headers_all ooh,
oe_order_types_v oot
where
ced.estimate_detail_id in
(select estimate_detail_id
from csd_product_transactions
where repair_line_id = px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
union
select estimate_detail_id
from csd_repair_actual_lines
where repair_actual_id=px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID)
and ced.order_header_id is not null
and ooh.open_flag = 'Y'
and nvl(ooh.cancelled_flag,'N') = 'N'
and ooh.header_id = ced.order_header_id
and (ooh.cust_po_number = nvl(px_Charges_Rec.PURCHASE_ORDER_NUM,ooh.cust_po_number)
or ooh.cust_po_number is null)
and ooh.sold_to_org_id = px_Charges_Rec.bill_to_account_id -- swai: bug 6962424
and oot.order_type_id = ooh.order_type_id
and oot.order_category_code in ('MIXED','RETURN')
and ced.interface_to_oe_flag = 'Y';
p_action => 'UPDATE',
-- swai: 12.1 service costing uptake bug 6960295
p_cs_cost_flag => l_cs_cost_flag,
x_Charges_Rec => px_charges_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Charges API returned error while calling UPDATE.');
FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_REC_PKG.Update_Row');
CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row(
p_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER
,p_ESTIMATE_DETAIL_ID => px_CSD_ACTUAL_LINES_REC.ESTIMATE_DETAIL_ID
,p_REPAIR_ACTUAL_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_ID
,p_REPAIR_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_LINE_ID
,p_CREATED_BY => FND_API.G_MISS_NUM
,p_CREATION_DATE => FND_API.G_MISS_DATE
,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
,p_LAST_UPDATE_DATE => SYSDATE
,p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID
,p_ITEM_COST => px_CSD_ACTUAL_LINES_REC.ITEM_COST
,p_JUSTIFICATION_NOTES => px_CSD_ACTUAL_LINES_REC.JUSTIFICATION_NOTES
,p_RESOURCE_ID => px_CSD_ACTUAL_LINES_REC.RESOURCE_ID
,p_OVERRIDE_CHARGE_FLAG => px_CSD_ACTUAL_LINES_REC.OVERRIDE_CHARGE_FLAG
,p_ACTUAL_SOURCE_CODE => px_CSD_ACTUAL_LINES_REC.ACTUAL_SOURCE_CODE
,p_ACTUAL_SOURCE_ID => px_CSD_ACTUAL_LINES_REC.ACTUAL_SOURCE_ID
,p_WARRANTY_CLAIM_FLAG => px_CSD_ACTUAL_LINES_REC.WARRANTY_CLAIM_FLAG
,p_WARRANTY_NUMBER => px_CSD_ACTUAL_LINES_REC.WARRANTY_NUMBER
,p_WARRANTY_STATUS_CODE => px_CSD_ACTUAL_LINES_REC.WARRANTY_STATUS_CODE
,p_REPLACED_ITEM_ID => px_CSD_ACTUAL_LINES_REC.REPLACED_ITEM_ID
,p_ATTRIBUTE_CATEGORY => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE_CATEGORY
,p_ATTRIBUTE1 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE1
,p_ATTRIBUTE2 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE2
,p_ATTRIBUTE3 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE3
,p_ATTRIBUTE4 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE4
,p_ATTRIBUTE5 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE5
,p_ATTRIBUTE6 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE6
,p_ATTRIBUTE7 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE7
,p_ATTRIBUTE8 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE8
,p_ATTRIBUTE9 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE9
,p_ATTRIBUTE10 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE10
,p_ATTRIBUTE11 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE11
,p_ATTRIBUTE12 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE12
,p_ATTRIBUTE13 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE13
,p_ATTRIBUTE14 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE14
,p_ATTRIBUTE15 => px_CSD_ACTUAL_LINES_REC.ATTRIBUTE15
,p_LOCATOR_ID => px_CSD_ACTUAL_LINES_REC.LOCATOR_ID
,p_LOC_SEGMENT1 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT1
,p_LOC_SEGMENT2 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT2
,p_LOC_SEGMENT3 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT3
,p_LOC_SEGMENT4 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT4
,p_LOC_SEGMENT5 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT5
,p_LOC_SEGMENT6 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT6
,p_LOC_SEGMENT7 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT7
,p_LOC_SEGMENT8 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT8
,p_LOC_SEGMENT9 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT9
,p_LOC_SEGMENT10 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT10
,p_LOC_SEGMENT11 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT11
,p_LOC_SEGMENT12 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT12
,p_LOC_SEGMENT13 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT13
,p_LOC_SEGMENT14 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT14
,p_LOC_SEGMENT15 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT15
,p_LOC_SEGMENT16 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT16
,p_LOC_SEGMENT17 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT17
,p_LOC_SEGMENT18 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT18
,p_LOC_SEGMENT19 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT19
,p_LOC_SEGMENT20 => px_CSD_ACTUAL_LINES_REC.LOC_SEGMENT20);
FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Update_Row Cal:'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
ROLLBACK TO UPDATE_REPAIR_ACTUAL_LINES;
ROLLBACK TO UPDATE_REPAIR_ACTUAL_LINES;
ROLLBACK TO UPDATE_REPAIR_ACTUAL_LINES;
End UPDATE_REPAIR_ACTUAL_LINES;
/* procedure name: DELETE_REPAIR_ACTUAL_LINES */
/* description : procedure used to Delete Repair Actuals */
/* */
/* */
/* */
/* Called from : Depot Repair Actuals UI */
/* Input Parm : */
/* p_api_version NUMBER Req Api Version number */
/* p_init_msg_list VARCHAR2 Opt Initialize message stack */
/* p_commit VARCHAR2 Opt Commits in API */
/* p_validation_level NUMBER Opt validation steps */
/* px_CSD_ACTUAL_LINES_REC REC Req Actuals lines Record */
/* px_Charges_Rec REC Req Charges line Record */
/* Output Parm : */
/* x_return_status VARCHAR2 Return status after the call. */
/* x_msg_count NUMBER Number of messages in stack */
/* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
/* Change Hist : */
/* 08/11/03 travikan Initial Creation. */
/* */
/* */
/* */
/*--------------------------------------------------------------------*/
PROCEDURE DELETE_REPAIR_ACTUAL_LINES(
P_Api_Version IN NUMBER,
P_Commit IN VARCHAR2,
P_Init_Msg_List IN VARCHAR2,
p_validation_level IN NUMBER,
px_CSD_ACTUAL_LINES_REC IN OUT NOCOPY CSD_ACTUAL_LINES_REC_TYPE,
px_Charges_Rec IN OUT NOCOPY CS_CHARGE_DETAILS_PUB.CHARGES_REC_TYPE,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
-- Variables used in FND Log
l_stat_level number := FND_LOG.LEVEL_STATEMENT;
l_mod_name varchar2(2000) := 'csd.plsql.csd_repair_actual_lines_pvt.delete_repair_actual_lines';
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_REPAIR_ACTUAL_LINES';
SELECT
a.repair_actual_line_id,
a.object_version_number
FROM csd_repair_actual_lines a,
csd_repairs b
WHERE a.repair_line_id = b.repair_line_id
and a.repair_actual_line_id = p_actual_line_id;
SAVEPOINT DELETE_REPAIR_ACTUAL_LINES;
FND_LOG.STRING(Fnd_Log.Level_Statement,l_mod_name,'At the Beginning of delete_repair_actual_lines');
FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call process_estimate_lines to delete charge line');
p_action => 'DELETE',
-- swai: 12.1 service costing uptake bug 6960295
p_cs_cost_flag => l_cs_cost_flag,
x_Charges_Rec => px_charges_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
FND_LOG.STRING(Fnd_Log.Level_Procedure,l_mod_name,'Call to CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row');
CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row(
p_REPAIR_ACTUAL_LINE_ID => px_CSD_ACTUAL_LINES_REC.REPAIR_ACTUAL_LINE_ID
,p_OBJECT_VERSION_NUMBER => px_CSD_ACTUAL_LINES_REC.OBJECT_VERSION_NUMBER);
FND_LOG.STRING(Fnd_Log.Level_Exception,l_mod_name,'Others exception in CSD_REPAIR_ACTUAL_LINES_PKG.Delete_Row Call :'||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1,255));
ROLLBACK TO DELETE_REPAIR_ACTUAL_LINES;
ROLLBACK TO DELETE_REPAIR_ACTUAL_LINES;
ROLLBACK TO DELETE_REPAIR_ACTUAL_LINES;
End DELETE_REPAIR_ACTUAL_LINES;
/* description : procedure used to Delete Repair Actuals */
/* */
/* */
/* */
/* Called from : Depot Repair Actuals UI */
/* Input Parm : */
/* p_api_version NUMBER Req Api Version number */
/* p_init_msg_list VARCHAR2 Opt Initialize message stack */
/* p_commit VARCHAR2 Opt Commits in API */
/* p_validation_level NUMBER Opt validation steps */
/* px_CSD_ACTUAL_LINES_REC REC Req Actuals lines Record */
/* Output Parm : */
/* x_return_status VARCHAR2 Return status after the call. */
/* x_msg_count NUMBER Number of messages in stack */
/* x_msg_data VARCHAR2 Mesg. text if x_msg_count >= 1 */
/* Change Hist : */
/* 08/11/03 travikan Initial Creation. */
/* */
/* */
/* */
/*--------------------------------------------------------------------*/
PROCEDURE LOCK_REPAIR_ACTUAL_LINES(
P_Api_Version IN NUMBER,
P_Commit IN VARCHAR2,
P_Init_Msg_List IN VARCHAR2,
p_validation_level IN NUMBER,
px_CSD_ACTUAL_LINES_REC IN OUT NOCOPY CSD_ACTUAL_LINES_REC_TYPE,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
-- Variables used in FND Log
l_stat_level number := FND_LOG.LEVEL_STATEMENT;