APPS.OE_VALIDATE_PRICE_LIST_LINE SQL Statements

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

Line: 200

	    SELECT count(*)
	    into   l_Count
	    from oe_price_list_lines
	    where price_list_id = p_PRICE_LIST_LINE_rec.price_list_id
	    and   unit_code = p_PRICE_LIST_LINE_rec.unit_code
	    and  pricing_attribute1 = p_PRICE_LIST_LINE_rec.pricing_attribute1
	    and  pricing_attribute2 = p_PRICE_LIST_LINE_rec.pricing_attribute2
	    and (
		( p_PRICE_LIST_LINE_rec.start_date_active between
			start_date_active and end_date_active)
		OR
		(p_PRICE_LIST_LINE_rec.end_date_active  between
			start_date_active and end_date_active ));

Line: 329

    IF  p_PRICE_LIST_LINE_rec.last_updated_by IS NOT NULL AND
        (   p_PRICE_LIST_LINE_rec.last_updated_by <>
            p_old_PRICE_LIST_LINE_rec.last_updated_by OR
            p_old_PRICE_LIST_LINE_rec.last_updated_by IS NULL )
    THEN
        IF NOT OE_Validate_Attr.Last_Updated_By(p_PRICE_LIST_LINE_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 339

    IF  p_PRICE_LIST_LINE_rec.last_update_date IS NOT NULL AND
        (   p_PRICE_LIST_LINE_rec.last_update_date <>
            p_old_PRICE_LIST_LINE_rec.last_update_date OR
            p_old_PRICE_LIST_LINE_rec.last_update_date IS NULL )
    THEN
        IF NOT OE_Validate_Attr.Last_Update_Date(p_PRICE_LIST_LINE_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 349

    IF  p_PRICE_LIST_LINE_rec.last_update_login IS NOT NULL AND
        (   p_PRICE_LIST_LINE_rec.last_update_login <>
            p_old_PRICE_LIST_LINE_rec.last_update_login OR
            p_old_PRICE_LIST_LINE_rec.last_update_login IS NULL )
    THEN
        IF NOT OE_Validate_Attr.Last_Update_Login(p_PRICE_LIST_LINE_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 591

    IF  p_PRICE_LIST_LINE_rec.program_update_date IS NOT NULL AND
        (   p_PRICE_LIST_LINE_rec.program_update_date <>
            p_old_PRICE_LIST_LINE_rec.program_update_date OR
            p_old_PRICE_LIST_LINE_rec.program_update_date IS NULL )
    THEN
        IF NOT OE_Validate_Attr.Program_Update_Date(p_PRICE_LIST_LINE_rec.program_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1018

PROCEDURE Entity_Delete
(   x_return_status                 OUT VARCHAR2
,   p_PRICE_LIST_LINE_rec           IN  OE_Price_List_PUB.Price_List_Line_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 1052

            ,   'Entity_Delete'
            );

Line: 1056

END Entity_Delete;