The following lines contain the word 'select', 'insert', 'update' or 'delete':
CSP_REQUIREMENT_LINES_PKG.Insert_Row(
px_REQUIREMENT_LINE_ID => l_requirement_line_rec.requirement_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_REQUIREMENT_HEADER_ID => l_Requirement_Line_rec.REQUIREMENT_HEADER_ID,
p_INVENTORY_ITEM_ID => l_Requirement_Line_rec.INVENTORY_ITEM_ID,
p_UOM_CODE => l_Requirement_Line_rec.UOM_CODE,
p_REQUIRED_QUANTITY => l_Requirement_Line_rec.REQUIRED_QUANTITY,
p_SHIP_COMPLETE_FLAG => l_Requirement_Line_rec.SHIP_COMPLETE_FLAG,
p_LIKELIHOOD => l_Requirement_Line_rec.LIKELIHOOD,
p_REVISION => l_Requirement_Line_rec.REVISION,
p_SOURCE_ORGANIZATION_ID => l_Requirement_Line_rec.SOURCE_ORGANIZATION_ID,
p_SOURCE_SUBINVENTORY => l_Requirement_Line_rec.SOURCE_SUBINVENTORY,
p_ORDERED_QUANTITY => l_Requirement_Line_rec.ORDERED_QUANTITY,
p_ORDER_LINE_ID => l_Requirement_Line_rec.ORDER_LINE_ID,
p_RESERVATION_ID => l_Requirement_Line_rec.RESERVATION_ID,
p_ORDER_BY_DATE => l_Requirement_Line_rec.ORDER_BY_DATE,
p_ATTRIBUTE_CATEGORY => l_Requirement_Line_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_Requirement_Line_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_Requirement_Line_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_Requirement_Line_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_Requirement_Line_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_Requirement_Line_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_Requirement_Line_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_Requirement_Line_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_Requirement_Line_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_Requirement_Line_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_Requirement_Line_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_Requirement_Line_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_Requirement_Line_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_Requirement_Line_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_Requirement_Line_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_Requirement_Line_rec.ATTRIBUTE15,
p_ARRIVAL_DATE => l_Requirement_line_rec.ARRIVAL_DATE,
p_ITEM_SCRATCHPAD => l_requirement_line_rec.item_scratchpad,
p_SHIPPING_METHOD_CODE => l_requirement_line_rec.shipping_method_code,
p_LOCAL_RESERVATION_ID => l_requirement_line_rec.LOCAL_RESERVATION_ID,
p_SOURCED_FROM => l_requirement_line_rec.SOURCED_FROM
);
PROCEDURE Update_requirement_lines(
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_Requirement_Line_Tbl IN Requirement_Line_Tbl_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
/*
Cursor C_Get_requirement_lines(REQUIREMENT_LINE_ID Number) IS
Select rowid,
REQUIREMENT_LINE_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
REQUIREMENT_HEADER_ID,
INVENTORY_ITEM_ID,
UOM_CODE,
REQUIRED_QUANTITY,
SHIP_COMPLETE_FLAG,
LIKELIHOOD,
REVISION,
SOURCE_ORGANIZATION_ID,
SOURCE_SUBINVENTORY,
ORDERED_QUANTITY,
ORDER_LINE_ID,
RESERVATION_ID,
ORDER_BY_DATE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
From CSP_REQUIREMENT_LINES
-- Hint: Developer need to provide Where clause
For Update NOWAIT;
l_api_name CONSTANT VARCHAR2(30) := 'Update_requirement_lines';
SAVEPOINT UPDATE_Requirement_Lines_PUB;
l_ref_Requirement_Lines_rec.LAST_UPDATED_BY,
l_ref_Requirement_Lines_rec.LAST_UPDATE_DATE,
l_ref_Requirement_Lines_rec.LAST_UPDATE_LOGIN,
l_ref_Requirement_Lines_rec.REQUIREMENT_HEADER_ID,
l_ref_Requirement_Lines_rec.INVENTORY_ITEM_ID,
l_ref_Requirement_Lines_rec.UOM_CODE,
l_ref_Requirement_Lines_rec.REQUIRED_QUANTITY,
l_ref_Requirement_Lines_rec.SHIP_COMPLETE_FLAG,
l_ref_Requirement_Lines_rec.LIKELIHOOD,
l_ref_Requirement_Lines_rec.REVISION,
l_ref_Requirement_Lines_rec.SOURCE_ORGANIZATION_ID,
l_ref_Requirement_Lines_rec.SOURCE_SUBINVENTORY,
l_ref_Requirement_Lines_rec.ORDERED_QUANTITY,
l_ref_Requirement_Lines_rec.ORDER_LINE_ID,
l_ref_Requirement_Lines_rec.RESERVATION_ID,
l_ref_Requirement_Lines_rec.ORDER_BY_DATE,
l_ref_Requirement_Lines_rec.ATTRIBUTE_CATEGORY,
l_ref_Requirement_Lines_rec.ATTRIBUTE1,
l_ref_Requirement_Lines_rec.ATTRIBUTE2,
l_ref_Requirement_Lines_rec.ATTRIBUTE3,
l_ref_Requirement_Lines_rec.ATTRIBUTE4,
l_ref_Requirement_Lines_rec.ATTRIBUTE5,
l_ref_Requirement_Lines_rec.ATTRIBUTE6,
l_ref_Requirement_Lines_rec.ATTRIBUTE7,
l_ref_Requirement_Lines_rec.ATTRIBUTE8,
l_ref_Requirement_Lines_rec.ATTRIBUTE9,
l_ref_Requirement_Lines_rec.ATTRIBUTE10,
l_ref_Requirement_Lines_rec.ATTRIBUTE11,
l_ref_Requirement_Lines_rec.ATTRIBUTE12,
l_ref_Requirement_Lines_rec.ATTRIBUTE13,
l_ref_Requirement_Lines_rec.ATTRIBUTE14,
l_ref_Requirement_Lines_rec.ATTRIBUTE15,
If ( C_Get_requirement_lines%NOTFOUND) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
If (l_tar_Requirement_Lines_rec.last_update_date is NULL or
l_tar_Requirement_Lines_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_Requirement_Lines_rec.last_update_date <> l_ref_Requirement_Lines_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 => AS_UTILITY_PVT.G_UPDATE,
p_requirement_line_rec => p_requirement_line_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
CSP_REQUIREMENT_LINES_PKG.Update_Row(
p_REQUIREMENT_LINE_ID => l_requirement_line_rec.REQUIREMENT_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_REQUIREMENT_HEADER_ID => l_requirement_line_rec.REQUIREMENT_HEADER_ID,
p_INVENTORY_ITEM_ID => l_requirement_line_rec.INVENTORY_ITEM_ID,
p_UOM_CODE => l_requirement_line_rec.UOM_CODE,
p_REQUIRED_QUANTITY => l_requirement_line_rec.REQUIRED_QUANTITY,
p_SHIP_COMPLETE_FLAG => l_requirement_line_rec.SHIP_COMPLETE_FLAG,
p_LIKELIHOOD => l_requirement_line_rec.LIKELIHOOD,
p_REVISION => l_requirement_line_rec.REVISION,
p_SOURCE_ORGANIZATION_ID => l_requirement_line_rec.SOURCE_ORGANIZATION_ID,
p_SOURCE_SUBINVENTORY => l_requirement_line_rec.SOURCE_SUBINVENTORY,
p_ORDERED_QUANTITY => l_requirement_line_rec.ORDERED_QUANTITY,
p_ORDER_LINE_ID => l_requirement_line_rec.ORDER_LINE_ID,
p_RESERVATION_ID => l_requirement_line_rec.RESERVATION_ID,
p_ORDER_BY_DATE => l_requirement_line_rec.ORDER_BY_DATE,
p_ATTRIBUTE_CATEGORY => l_requirement_line_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_requirement_line_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_requirement_line_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_requirement_line_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_requirement_line_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_requirement_line_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_requirement_line_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_requirement_line_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_requirement_line_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_requirement_line_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_requirement_line_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_requirement_line_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_requirement_line_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_requirement_line_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_requirement_line_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_requirement_line_rec.ATTRIBUTE15,
p_ARRIVAL_DATE => l_requirement_line_rec.arrival_date,
p_ITEM_SCRATCHPAD => l_requirement_line_rec.item_scratchpad,
p_SHIPPING_METHOD_CODE => l_requirement_line_rec.shipping_method_code,
p_LOCAL_RESERVATION_ID => l_requirement_line_rec.LOCAL_RESERVATION_ID,
p_SOURCED_FROM => l_requirement_line_rec.SOURCED_FROM
);
Rollback to UPDATE_Requirement_Lines_PUB;
End Update_requirement_lines;
PROCEDURE Delete_requirement_lines(
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_requirement_line_tbl IN Requirement_Line_Tbl_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_requirement_lines';
SAVEPOINT DELETE_Requirement_Lines_PUB;
CSP_REQUIREMENT_LINES_PKG.Delete_Row(
p_REQUIREMENT_LINE_ID => l_requirement_line_rec.REQUIREMENT_LINE_ID);
Rollback to DELETE_Requirement_Lines_PUB;
End Delete_requirement_lines;
PROCEDURE Gen_Select(
x_select_cl OUT NOCOPY VARCHAR2
)
IS
BEGIN
-- Debug Message
AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');
x_select_cl := 'Select ' ||
'CSP_REQUIREMENT_LINES.REQUIREMENT_LINE_ID,' ||
'CSP_REQUIREMENT_LINES.CREATED_BY,' ||
'CSP_REQUIREMENT_LINES.CREATION_DATE,' ||
'CSP_REQUIREMENT_LINES.LAST_UPDATED_BY,' ||
'CSP_REQUIREMENT_LINES.LAST_UPDATE_DATE,' ||
'CSP_REQUIREMENT_LINES.LAST_UPDATE_LOGIN,' ||
'CSP_REQUIREMENT_LINES.REQUIREMENT_HEADER_ID,' ||
'CSP_REQUIREMENT_LINES.INVENTORY_ITEM_ID,' ||
'CSP_REQUIREMENT_LINES.UOM_CODE,' ||
'CSP_REQUIREMENT_LINES.REQUIRED_QUANTITY,' ||
'CSP_REQUIREMENT_LINES.SHIP_COMPLETE_FLAG,' ||
'CSP_REQUIREMENT_LINES.LIKELIHOOD,' ||
'CSP_REQUIREMENT_LINES.REVISION,' ||
'CSP_REQUIREMENT_LINES.SOURCE_ORGANIZATION_ID,' ||
'CSP_REQUIREMENT_LINES.SOURCE_SUBINVENTORY,' ||
'CSP_REQUIREMENT_LINES.ORDERED_QUANTITY,' ||
'CSP_REQUIREMENT_LINES.ORDER_LINE_ID,' ||
'CSP_REQUIREMENT_LINES.RESERVATION_ID,' ||
'CSP_REQUIREMENT_LINES.ORDER_BY_DATE,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE_CATEGORY,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE1,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE2,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE3,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE4,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE5,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE6,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE7,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE8,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE9,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE10,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE11,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE12,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE13,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE14,' ||
'CSP_REQUIREMENT_LINES.ATTRIBUTE15,' ||
'from CSP_REQUIREMENT_LINES';
AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, '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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REQUIREMENT_LINE_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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REQUIREMENT_HEADER_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 = AS_UTILITY_PVT.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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_REQUIRED_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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SHIP_COMPLETE_FLAG <> 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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_LIKELIHOOD <> 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 = AS_UTILITY_PVT.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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SOURCE_ORGANIZATION_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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SOURCE_SUBINVENTORY <> 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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ORDERED_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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ORDER_LINE_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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_RESERVATION_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 = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ORDER_BY_DATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;