The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT OZF_OFFER_ADJUSTMENT_LINES_s.NEXTVAL
FROM dual;
SELECT 1
FROM OZF_OFFER_ADJUSTMENT_LINES
WHERE OFFER_ADJUSTMENT_LINE_ID = l_id;
OZF_OFFER_ADJUSTMENT_LINES_PKG.Insert_Row(
px_offer_adjustment_line_id => l_offer_adjustment_line_id,
p_offer_adjustment_id => p_offer_back_create_rec.offer_adjustment_id,
p_list_line_id => p_offer_back_create_rec.list_line_id,
p_arithmetic_operator => p_offer_back_create_rec.arithmetic_operator,
p_original_discount => p_offer_back_create_rec.original_discount,
p_modified_discount => p_offer_back_create_rec.modified_discount,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
px_object_version_number => l_object_version_number,
p_security_group_id => p_offer_back_create_rec.security_group_id);
PROCEDURE Update_Offer_Back(
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,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_offer_back_create_rec IN offer_back_create_rec_type,
x_object_version_number OUT NOCOPY NUMBER
)
IS
CURSOR c_get_offer_back_create(offer_adjustment_line_id NUMBER) IS
SELECT *
FROM OZF_OFFER_ADJUSTMENT_LINES
WHERE offer_adjustment_line_id = p_offer_back_create_rec.offer_adjustment_line_id;
L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Offer_Back';
SAVEPOINT UPDATE_Offer_Back_PVT;
OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
p_token_name => 'INFO',
p_token_value => 'Offer_Back_Create') ;
p_token_value => 'Last_Update_Date') ;
p_validation_mode => JTF_PLSQL_API.g_update,
p_offer_back_create_rec => p_offer_back_create_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
OZF_UTILITY_PVT.debug_message('Invoking Update Table Handler: ' );
OZF_OFFER_ADJUSTMENT_LINES_PKG.Update_Row(
p_offer_adjustment_line_id => p_offer_back_create_rec.offer_adjustment_line_id,
p_offer_adjustment_id => p_offer_back_create_rec.offer_adjustment_id,
p_list_line_id => p_offer_back_create_rec.list_line_id,
p_arithmetic_operator => p_offer_back_create_rec.arithmetic_operator,
p_original_discount => p_offer_back_create_rec.original_discount,
p_modified_discount => p_offer_back_create_rec.modified_discount,
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
p_object_version_number => p_offer_back_create_rec.object_version_number,
p_security_group_id => p_offer_back_create_rec.security_group_id);
OZF_UTILITY_PVT.debug_message('Aftyer Invoking Update Table Handler: ' );
ROLLBACK TO UPDATE_Offer_Back_PVT;
ROLLBACK TO UPDATE_Offer_Back_PVT;
ROLLBACK TO UPDATE_Offer_Back_PVT;
End Update_Offer_Back;
PROCEDURE Delete_Offer_Back(
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,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_offer_adjustment_line_id IN NUMBER,
p_object_version_number IN NUMBER
)
IS
L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Offer_Back';
SAVEPOINT DELETE_Offer_Back_Create_PVT;
OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
OZF_OFFER_ADJUSTMENT_LINES_PKG.Delete_Row(
p_OFFER_ADJUSTMENT_LINE_ID => p_OFFER_ADJUSTMENT_LINE_ID);
ROLLBACK TO DELETE_Offer_Back_PVT;
ROLLBACK TO DELETE_Offer_Back_PVT;
ROLLBACK TO DELETE_Offer_Back_PVT;
End Delete_Offer_Back;
SELECT OFFER_ADJUSTMENT_LINE_ID
FROM OZF_OFFER_ADJUSTMENT_LINES
WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID
AND object_version_number = p_object_version
FOR UPDATE NOWAIT;
SELECT *
FROM ozf_offer_adjustment_lines
WHERE offer_adjustment_line_id = p_offer_back_create_rec.offer_adjustment_line_id;
IF p_offer_back_create_rec.last_update_date = FND_API.g_miss_date THEN
x_complete_rec.last_update_date := l_offer_back_create_rec.last_update_date;
IF p_offer_back_create_rec.last_updated_by = FND_API.g_miss_num THEN
x_complete_rec.last_updated_by := l_offer_back_create_rec.last_updated_by;
IF p_offer_back_create_rec.last_update_login = FND_API.g_miss_num THEN
x_complete_rec.last_update_login := l_offer_back_create_rec.last_update_login;