The following lines contain the word 'select', 'insert', 'update' or 'delete':
Cursor c2 is SELECT IEX_COSTS_S.nextval from dual;
IEX_COSTS_PKG.Insert_Row(
x_rowid =>v_rowid,
p_COST_ID => v_COST_ID,
p_CASE_ID => p_costs_rec.CASE_ID,
p_DELINQUENCY_ID => p_costs_rec.DELINQUENCY_ID,
p_COST_TYPE_CODE => p_costs_rec.COST_TYPE_CODE,
p_COST_ITEM_TYPE_CODE => p_costs_rec.COST_ITEM_TYPE_CODE,
p_COST_ITEM_TYPE_DESC => p_costs_rec.COST_ITEM_TYPE_DESC,
p_COST_ITEM_AMOUNT => p_costs_rec.COST_ITEM_AMOUNT,
p_COST_ITEM_CURRENCY_CODE => p_costs_rec.COST_ITEM_CURRENCY_CODE,
p_COST_ITEM_QTY => p_costs_rec.COST_ITEM_QTY,
p_COST_ITEM_DATE => p_costs_rec.COST_ITEM_DATE,
p_FUNCTIONAL_AMOUNT => p_costs_rec.FUNCTIONAL_AMOUNT,
p_EXCHANGE_TYPE => p_costs_rec.EXCHANGE_TYPE,
p_EXCHANGE_RATE => p_costs_rec.EXCHANGE_RATE,
p_EXCHANGE_DATE => p_costs_rec.EXCHANGE_DATE,
p_COST_ITEM_APPROVED => v_COST_ITEM_APPROVED,
p_ACTIVE_FLAG => v_ACTIVE_FLAG,
p_OBJECT_VERSION_NUMBER => v_OBJECT_VERSION_NUMBER,
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_REQUEST_ID => p_costs_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_costs_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_costs_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_costs_rec.PROGRAM_UPDATE_DATE,
p_ATTRIBUTE_CATEGORY => p_costs_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_costs_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_costs_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_costs_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_costs_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_costs_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_costs_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_costs_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_costs_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_costs_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_costs_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_costs_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_costs_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_costs_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_costs_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_costs_rec.ATTRIBUTE15,
p_LAST_UPDATE_LOGIN => p_costs_rec.LAST_UPDATE_LOGIN);
IEX_DEBUG_PUB.LogMessage('Create_costs: ' || 'After Calling IEX_COSTS_PKG.Insert_Row'
||' and cost id => ' ||v_cost_id);
PROCEDURE Update_costs(
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_costs_Rec IN costs_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2,
xo_object_version_number OUT NOCOPY NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COSTS';
IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_COSTS_PVT.update_COSTS ******** ');
SAVEPOINT UPDATE_COSTS_PVT;
IEX_COSTS_PKG.Update_Row(
p_COST_ID => p_costs_rec.COST_ID,
p_CASE_ID => p_costs_rec.CASE_ID,
p_DELINQUENCY_ID => p_costs_rec.DELINQUENCY_ID,
p_COST_TYPE_CODE => p_costs_rec.COST_TYPE_CODE,
p_COST_ITEM_TYPE_CODE => p_costs_rec.COST_ITEM_TYPE_CODE,
p_COST_ITEM_TYPE_DESC => p_costs_rec.COST_ITEM_TYPE_DESC,
p_COST_ITEM_AMOUNT => p_costs_rec.COST_ITEM_AMOUNT,
p_COST_ITEM_CURRENCY_CODE => p_costs_rec.COST_ITEM_CURRENCY_CODE,
p_COST_ITEM_QTY => p_costs_rec.COST_ITEM_QTY,
p_COST_ITEM_DATE => p_costs_rec.COST_ITEM_DATE,
p_FUNCTIONAL_AMOUNT =>p_costs_rec.FUNCTIONAL_AMOUNT,
p_EXCHANGE_TYPE => p_costs_rec.EXCHANGE_TYPE,
p_EXCHANGE_RATE => p_costs_rec.EXCHANGE_RATE,
p_EXCHANGE_DATE => p_costs_rec.EXCHANGE_DATE,
p_COST_ITEM_APPROVED => p_costs_rec.COST_ITEM_APPROVED,
p_ACTIVE_FLAG => p_costs_rec.ACTIVE_FLAG,
p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER +1,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_REQUEST_ID => p_costs_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_costs_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_costs_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_costs_rec.PROGRAM_UPDATE_DATE,
p_ATTRIBUTE_CATEGORY => p_costs_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_costs_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_costs_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_costs_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_costs_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_costs_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_costs_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_costs_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_costs_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_costs_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_costs_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_costs_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_costs_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_costs_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_costs_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_costs_rec.ATTRIBUTE15,
p_LAST_UPDATE_LOGIN => p_costs_rec.LAST_UPDATE_LOGIN);
IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_COSTS_PVT.update_costs ******** ');
End Update_costs;
PROCEDURE Delete_costs(
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_cost_id 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) := 'Delete_costs';
IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_COSTS_PVT.delete_costs ******** ');
SAVEPOINT DELETE_COSTS_PVT;
IEX_COSTS_PKG.Delete_Row(
p_COST_ID => p_COST_ID);
IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_COSTS_PVT.delete_costs ******** ');
End Delete_costs;