The following lines contain the word 'select', 'insert', 'update' or 'delete':
P_LAST_UPDATE_DATE IN DATE,
P_CREATED_BY IN NUMBER,
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_LOGIN IN NUMBER,
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,
P_ATTRIBUTE_CATEGORY IN VARCHAR2,
P_OBJECT_VERSION_NUMBER IN NUMBER ,
x_csc_plan_lines_rec OUT NOCOPY CSC_PLAN_LINES_REC_TYPE)
IS
BEGIN
x_csc_plan_lines_rec.LINE_ID := P_LINE_ID;
x_csc_plan_lines_rec.LAST_UPDATE_DATE := P_LAST_UPDATE_DATE ;
x_csc_plan_lines_rec.LAST_UPDATED_BY := P_LAST_UPDATED_BY ;
x_csc_plan_lines_rec.LAST_UPDATE_LOGIN := P_LAST_UPDATE_LOGIN ;
P_LAST_UPDATE_DATE IN DATE,
P_CREATED_BY IN NUMBER,
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_LOGIN IN NUMBER,
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,
P_ATTRIBUTE_CATEGORY IN VARCHAR2,
P_OBJECT_VERSION_NUMBER IN NUMBER,
X_LINE_ID OUT NOCOPY NUMBER,
X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_csc_plan_lines_rec CSC_PLAN_LINES_REC_TYPE;
P_LAST_UPDATE_DATE => p_last_update_date,
P_CREATED_BY => p_created_by,
P_LAST_UPDATED_BY => p_last_updated_by,
P_LAST_UPDATE_LOGIN => p_last_update_login,
P_ATTRIBUTE1 => p_attribute1,
P_ATTRIBUTE2 => p_attribute2,
P_ATTRIBUTE3 => p_attribute3,
P_ATTRIBUTE4 => p_attribute4,
P_ATTRIBUTE5 => p_attribute5,
P_ATTRIBUTE6 => p_attribute6,
P_ATTRIBUTE7 => p_attribute7,
P_ATTRIBUTE8 => p_attribute8,
P_ATTRIBUTE9 => p_attribute9,
P_ATTRIBUTE10 => p_attribute10,
P_ATTRIBUTE11 => p_attribute11,
P_ATTRIBUTE12 => p_attribute12,
P_ATTRIBUTE13 => p_attribute13,
P_ATTRIBUTE14 => p_attribute14,
P_ATTRIBUTE15 => p_attribute15,
P_ATTRIBUTE_CATEGORY => p_attribute_category,
P_OBJECT_VERSION_NUMBER => p_object_version_number,
x_csc_plan_lines_rec => l_csc_plan_lines_rec);
CSC_PLAN_LINES_PKG.Insert_Row(
px_LINE_ID => x_LINE_ID,
p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
p_CREATION_DATE => SYSDATE,
p_LAST_UPDATE_DATE => SYSDATE,
p_CREATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
PROCEDURE Update_plan_lines(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
p_validation_level IN NUMBER,
P_LINE_ID IN NUMBER,
P_PLAN_ID IN NUMBER,
P_CONDITION_ID IN NUMBER,
P_CREATION_DATE IN DATE,
P_LAST_UPDATE_DATE IN DATE,
P_CREATED_BY IN NUMBER,
P_LAST_UPDATED_BY IN NUMBER,
P_LAST_UPDATE_LOGIN IN NUMBER,
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,
P_ATTRIBUTE_CATEGORY IN VARCHAR2,
P_OBJECT_VERSION_NUMBER IN NUMBER,
X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2)
IS
l_csc_plan_lines_rec CSC_PLAN_LINES_REC_TYPE;
P_LAST_UPDATE_DATE => p_last_update_date,
P_CREATED_BY => p_created_by,
P_LAST_UPDATED_BY => p_last_updated_by,
P_LAST_UPDATE_LOGIN => p_last_update_login,
P_ATTRIBUTE1 => p_attribute1,
P_ATTRIBUTE2 => p_attribute2,
P_ATTRIBUTE3 => p_attribute3,
P_ATTRIBUTE4 => p_attribute4,
P_ATTRIBUTE5 => p_attribute5,
P_ATTRIBUTE6 => p_attribute6,
P_ATTRIBUTE7 => p_attribute7,
P_ATTRIBUTE8 => p_attribute8,
P_ATTRIBUTE9 => p_attribute9,
P_ATTRIBUTE10 => p_attribute10,
P_ATTRIBUTE11 => p_attribute11,
P_ATTRIBUTE12 => p_attribute12,
P_ATTRIBUTE13 => p_attribute13,
P_ATTRIBUTE14 => p_attribute14,
P_ATTRIBUTE15 => p_attribute15,
P_ATTRIBUTE_CATEGORY => p_attribute_category,
P_OBJECT_VERSION_NUMBER => p_object_version_number,
x_csc_plan_lines_rec => l_csc_plan_lines_rec);
Update_plan_lines(
P_Api_Version_Number => p_api_version_number,
P_Init_Msg_List => p_init_msg_list,
P_Commit => p_commit,
P_Validation_level => p_validation_level,
P_CSC_PLAN_LINES_Rec => l_csc_plan_lines_rec,
X_OBJECT_VERSION_NUMBER => x_object_version_number,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data );
END update_plan_lines; /* end of overloaded update */
PROCEDURE Update_plan_lines(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
p_validation_level IN NUMBER,
P_CSC_PLAN_LINES_Rec IN CSC_PLAN_LINES_Rec_Type,
X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
Cursor C_Get_plan_lines(C_LINE_ID Number) IS
Select rowid, LINE_ID, PLAN_ID,
CONDITION_ID, LAST_UPDATE_DATE, CREATION_DATE,
LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN,
ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6,
ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9,
ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
ATTRIBUTE_CATEGORY,OBJECT_VERSION_NUMBER
From CSC_PLAN_LINES
where line_id = c_line_id
For Update NOWAIT;
l_api_name CONSTANT VARCHAR2(30) := 'Update_plan_lines';
SAVEPOINT UPDATE_PLAN_LINES_PVT;
l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_DATE,
l_ref_CSC_PLAN_LINES_rec.CREATION_DATE,
l_ref_CSC_PLAN_LINES_rec.LAST_UPDATED_BY,
l_ref_CSC_PLAN_LINES_rec.CREATED_BY,
l_ref_CSC_PLAN_LINES_rec.LAST_UPDATE_LOGIN,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE1,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE2,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE3,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE4,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE5,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE6,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE7,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE8,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE9,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE10,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE11,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE12,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE13,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE14,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE15,
l_ref_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
l_ref_CSC_PLAN_LINES_rec.OBJECT_VERSION_NUMBER;
FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
P_CSC_PLAN_LINES_Rec => P_CSC_PLAN_LINES_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
CSC_PLAN_LINES_PKG.Update_Row(
p_LINE_ID => p_CSC_PLAN_LINES_rec.LINE_ID,
p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
p_CREATION_DATE => SYSDATE,
p_LAST_UPDATE_DATE => SYSDATE,
p_CREATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
p_ATTRIBUTE1 => p_CSC_PLAN_LINES_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_CSC_PLAN_LINES_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_CSC_PLAN_LINES_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_CSC_PLAN_LINES_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_CSC_PLAN_LINES_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_CSC_PLAN_LINES_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_CSC_PLAN_LINES_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_CSC_PLAN_LINES_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_CSC_PLAN_LINES_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_CSC_PLAN_LINES_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_CSC_PLAN_LINES_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_CSC_PLAN_LINES_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_CSC_PLAN_LINES_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_CSC_PLAN_LINES_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_CSC_PLAN_LINES_rec.ATTRIBUTE15,
p_ATTRIBUTE_CATEGORY => p_CSC_PLAN_LINES_rec.ATTRIBUTE_CATEGORY,
x_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER);
End Update_plan_lines;
PROCEDURE Delete_plan_lines(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
P_PLAN_ID IN NUMBER,
P_LINE_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_plan_lines';
SAVEPOINT DELETE_PLAN_LINES_PVT;
CSC_PLAN_LINES_PKG.Delete_Row(
p_PLAN_ID => P_PLAN_ID,
p_LINE_ID => P_LINE_ID);
End Delete_plan_lines;
select line_id
from CSC_PLAN_LINES
where line_id = p_line_id;
IF( p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE ) THEN
if ( p_line_id is NULL or p_line_id = FND_API.G_MISS_NUM ) then
fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
select plan_id
from csc_plan_headers_b
where plan_id = p_plan_id;
select id
from okc_condition_headers_b
where id = p_condition_id;
select 1
from csc_plan_lines
where plan_id = p_plan_id
and condition_id = p_condition_id;
if ( (p_validation_mode <> CSC_CORE_UTILS_PVT.G_UPDATE) AND (c2%FOUND) ) then
fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_OBJECT_VERSION_NUMBER <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;