The following lines contain the word 'select', 'insert', 'update' or 'delete':
CSP_TASK_PARTS_PKG.Insert_Row(
px_TASK_PART_ID => x_TASK_PART_ID,
p_PRODUCT_TASK_ID => p_TASK_PART_rec.PRODUCT_TASK_ID,
p_INVENTORY_ITEM_ID => p_TASK_PART_rec.INVENTORY_ITEM_ID,
p_MANUAL_QUANTITY => p_TASK_PART_rec.MANUAL_QUANTITY,
p_MANUAL_PERCENTAGE => p_TASK_PART_rec.MANUAL_PERCENTAGE,
p_QUANTITY_USED => p_TASK_PART_rec.QUANTITY_USED,
p_ACTUAL_TIMES_USED => p_TASK_PART_rec.ACTUAL_TIMES_USED,
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_ATTRIBUTE_CATEGORY => p_TASK_PART_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_TASK_PART_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_TASK_PART_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_TASK_PART_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_TASK_PART_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_TASK_PART_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_TASK_PART_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_TASK_PART_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_TASK_PART_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_TASK_PART_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_TASK_PART_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_TASK_PART_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_TASK_PART_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_TASK_PART_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_TASK_PART_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_TASK_PART_rec.ATTRIBUTE15,
p_PRIMARY_UOM_CODE => p_TASK_PART_rec.PRIMARY_UOM_CODE,
p_REVISION => p_TASK_PART_rec.REVISION,
p_START_DATE => p_TASK_PART_rec.START_DATE,
p_END_DATE => p_TASK_PART_rec.END_DATE,
p_ROLLUP_QUANTITY_USED => p_TASK_PART_rec.ROLLUP_QUANTITY_USED,
p_ROLLUP_TIMES_USED => p_TASK_PART_rec.ROLLUP_TIMES_USED,
p_SUBSTITUTE_ITEM => p_TASK_PART_rec.SUBSTITUTE_ITEM );
PROCEDURE Update_task_part(
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_TASK_PART_Rec IN TASK_PART_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
/*
Cursor C_Get_task_part(TASK_PART_ID Number) IS
Select rowid,
TASK_PART_ID,
PRODUCT_TASK_ID,
INVENTORY_ITEM_ID,
MANUAL_QUANTITY,
MANUAL_PERCENTAGE,
QUANTITY_USED,
ACTUAL_TIMES_USED,
CALCULATED_QUANTITY,
PART_PERCENTAGE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRIMARY_UOM_CODE,
REVISION,
START_DATE,
END_DATE
From CSP_TASK_PARTS
-- Hint: Developer need to provide Where clause
For Update NOWAIT;
l_api_name CONSTANT VARCHAR2(30) := 'Update_task_part';
SAVEPOINT UPDATE_TASK_PART_PVT;
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Private API: - Open Cursor to Select');
l_ref_TASK_PART_rec.LAST_UPDATED_BY,
l_ref_TASK_PART_rec.LAST_UPDATE_DATE,
l_ref_TASK_PART_rec.LAST_UPDATE_LOGIN,
l_ref_TASK_PART_rec.ATTRIBUTE_CATEGORY,
l_ref_TASK_PART_rec.ATTRIBUTE1,
l_ref_TASK_PART_rec.ATTRIBUTE2,
l_ref_TASK_PART_rec.ATTRIBUTE3,
l_ref_TASK_PART_rec.ATTRIBUTE4,
l_ref_TASK_PART_rec.ATTRIBUTE5,
l_ref_TASK_PART_rec.ATTRIBUTE6,
l_ref_TASK_PART_rec.ATTRIBUTE7,
l_ref_TASK_PART_rec.ATTRIBUTE8,
l_ref_TASK_PART_rec.ATTRIBUTE9,
l_ref_TASK_PART_rec.ATTRIBUTE10,
l_ref_TASK_PART_rec.ATTRIBUTE11,
l_ref_TASK_PART_rec.ATTRIBUTE12,
l_ref_TASK_PART_rec.ATTRIBUTE13,
l_ref_TASK_PART_rec.ATTRIBUTE14,
l_ref_TASK_PART_rec.ATTRIBUTE15,
l_ref_TASK_PART_rec.PRIMARY_UOM_CODE,
l_ref_TASK_PART_rec.REVISION,
l_ref_TASK_PART_rec.START_DATE,
l_ref_TASK_PART_rec.END_DATE;
FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
If (l_tar_TASK_PART_rec.last_update_date is NULL or
l_tar_TASK_PART_rec.last_update_date = FND_API.G_MISS_Date ) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
If (l_tar_TASK_PART_rec.last_update_date <> l_ref_TASK_PART_rec.last_update_date) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
p_validation_mode => JTF_PLSQL_API.G_UPDATE,
P_TASK_PART_Rec => P_TASK_PART_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Calling update table handler');
CSP_TASK_PARTS_PKG.Update_Row(
p_TASK_PART_ID => p_TASK_PART_rec.TASK_PART_ID,
p_PRODUCT_TASK_ID => p_TASK_PART_rec.PRODUCT_TASK_ID,
p_INVENTORY_ITEM_ID => p_TASK_PART_rec.INVENTORY_ITEM_ID,
p_MANUAL_QUANTITY => p_TASK_PART_rec.MANUAL_QUANTITY,
p_MANUAL_PERCENTAGE => p_TASK_PART_rec.MANUAL_PERCENTAGE,
p_QUANTITY_USED => p_TASK_PART_rec.QUANTITY_USED,
p_ACTUAL_TIMES_USED => p_TASK_PART_rec.ACTUAL_TIMES_USED,
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_ATTRIBUTE_CATEGORY => p_TASK_PART_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_TASK_PART_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_TASK_PART_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_TASK_PART_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_TASK_PART_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_TASK_PART_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_TASK_PART_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_TASK_PART_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_TASK_PART_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_TASK_PART_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_TASK_PART_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_TASK_PART_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_TASK_PART_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_TASK_PART_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_TASK_PART_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_TASK_PART_rec.ATTRIBUTE15,
p_PRIMARY_UOM_CODE => p_TASK_PART_rec.PRIMARY_UOM_CODE,
p_REVISION => p_TASK_PART_rec.REVISION,
p_START_DATE => p_TASK_PART_rec.START_DATE,
p_END_DATE => p_TASK_PART_rec.END_DATE,
p_ROLLUP_QUANTITY_USED => p_TASK_PART_rec.ROLLUP_QUANTITY_USED,
p_ROLLUP_TIMES_USED => p_TASK_PART_rec.ROLLUP_TIMES_USED,
p_SUBSTITUTE_ITEM => p_TASK_PART_rec.SUBSTITUTE_ITEM );
End Update_task_part;
PROCEDURE Delete_task_part(
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_TASK_PART_Rec IN TASK_PART_Rec_Type,
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_task_part';
SAVEPOINT DELETE_TASK_PART_PVT;
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Calling delete table handler');
CSP_TASK_PARTS_PKG.Delete_Row(
p_TASK_PART_ID => p_TASK_PART_rec.TASK_PART_ID);
End Delete_task_part;
PROCEDURE Gen_Select(
x_select_cl OUT NOCOPY VARCHAR2
)
IS
BEGIN
-- Debug Message
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Select Begins');
x_select_cl := 'Select ' ||
'CSP_TASK_PARTS.TASK_PART_ID,' ||
'CSP_TASK_PARTS.PRODUCT_TASK_ID,' ||
'CSP_TASK_PARTS.INVENTORY_ITEM_ID,' ||
'CSP_TASK_PARTS.MANUAL_QUANTITY,' ||
'CSP_TASK_PARTS.MANUAL_PERCENTAGE,' ||
'CSP_TASK_PARTS.QUANTITY_USED,' ||
'CSP_TASK_PARTS.ACTUAL_TIMES_USED,' ||
'CSP_TASK_PARTS.CREATED_BY,' ||
'CSP_TASK_PARTS.CREATION_DATE,' ||
'CSP_TASK_PARTS.LAST_UPDATED_BY,' ||
'CSP_TASK_PARTS.LAST_UPDATE_DATE,' ||
'CSP_TASK_PARTS.LAST_UPDATE_LOGIN,' ||
'CSP_TASK_PARTS.ATTRIBUTE_CATEGORY,' ||
'CSP_TASK_PARTS.ATTRIBUTE1,' ||
'CSP_TASK_PARTS.ATTRIBUTE2,' ||
'CSP_TASK_PARTS.ATTRIBUTE3,' ||
'CSP_TASK_PARTS.ATTRIBUTE4,' ||
'CSP_TASK_PARTS.ATTRIBUTE5,' ||
'CSP_TASK_PARTS.ATTRIBUTE6,' ||
'CSP_TASK_PARTS.ATTRIBUTE7,' ||
'CSP_TASK_PARTS.ATTRIBUTE8,' ||
'CSP_TASK_PARTS.ATTRIBUTE9,' ||
'CSP_TASK_PARTS.ATTRIBUTE10,' ||
'CSP_TASK_PARTS.ATTRIBUTE11,' ||
'CSP_TASK_PARTS.ATTRIBUTE12,' ||
'CSP_TASK_PARTS.ATTRIBUTE13,' ||
'CSP_TASK_PARTS.ATTRIBUTE14,' ||
'CSP_TASK_PARTS.ATTRIBUTE15,' ||
'CSP_TASK_PARTS.PRIMARY_UOM_CODE,' ||
'CSP_TASK_PARTS.REVISION,' ||
'CSP_TASK_PARTS.START_DATE,' ||
'CSP_TASK_PARTS.END_DATE,' ||
'from CSP_TASK_PARTS';
JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Private API: Generate Select Ends');
END Gen_Select;
SELECT INSTR(p_rec_item, '%', 1, 1)
FROM DUAL;
SELECT INSTR(p_rec_item, '_', 1, 1)
FROM DUAL;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TASK_PART_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PRODUCT_TASK_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_INVENTORY_ITEM_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_MANUAL_QUANTITY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_MANUAL_PERCENTAGE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_QUANTITY_USED <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ACTUAL_TIMES_USED <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PRIMARY_UOM_CODE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REVISION <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_START_DATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_END_DATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ROLLUP_QUANTITY_USED <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ROLLUP_TIMES_USED <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SUBSTITUTE_ITEM <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;