DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE_PATTR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 168

    IF  p_Line_Price_Attr_rec.last_updated_by IS NOT NULL AND
        (   p_Line_Price_Attr_rec.last_updated_by <>
            p_old_Line_Price_Attr_rec.last_updated_by OR
            p_old_Line_Price_Attr_rec.last_updated_by IS NULL )
    THEN
        IF NOT OE_Validate_adj.Last_Updated_By(p_Line_Price_Attr_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;
Line: 178

    IF  p_Line_Price_Attr_rec.last_update_date IS NOT NULL AND
        (   p_Line_Price_Attr_rec.last_update_date <>
            p_old_Line_Price_Attr_rec.last_update_date OR
            p_old_Line_Price_Attr_rec.last_update_date IS NULL )
    THEN
        IF NOT OE_Validate_adj.Last_Update_Date(p_Line_Price_Attr_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;
Line: 188

    IF  p_Line_Price_Attr_rec.last_update_login IS NOT NULL AND
        (   p_Line_Price_Attr_rec.last_update_login <>
            p_old_Line_Price_Attr_rec.last_update_login OR
            p_old_Line_Price_Attr_rec.last_update_login IS NULL )
    THEN
        IF NOT OE_Validate_adj.Last_Update_Login(p_Line_Price_Attr_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;
Line: 238

    IF  p_Line_Price_Attr_rec.program_update_date IS NOT NULL AND
        (   p_Line_Price_Attr_rec.program_update_date <>
            p_old_Line_Price_Attr_rec.program_update_date OR
            p_old_Line_Price_Attr_rec.program_update_date IS NULL )
    THEN
        IF NOT OE_Validate_adj.Program_Update_Date(p_Line_Price_Attr_rec.program_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;
Line: 821

	   FND_MESSAGE.SET_NAME('ONT','ONT_OTA_UPDATE_NOT_ALLOWED');
Line: 1993

PROCEDURE Entity_Delete
( x_return_status OUT NOCOPY VARCHAR2

,   p_Line_Price_Attr_rec        IN  OE_Order_PUB.Line_Price_Att_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
Line: 2011

	 FND_MESSAGE.SET_NAME('ONT','ONT_OTA_DELETE_NOT_ALLOWED');
Line: 2036

            ,   'Entity_Delete'
            );
Line: 2040

END Entity_Delete;