APPS.MRP_VALIDATE_ASSIGNMENT_SET SQL Statements

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

Line: 91

PROCEDURE Entity_Delete
(   x_return_status                 OUT NOCOPY VARCHAR2
,   p_Assignment_Set_rec            IN  MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 125

            ,   'Entity_Delete'
            );

Line: 129

END Entity_Delete;

Line: 359

    IF  p_Assignment_Set_rec.Last_Updated_By IS NOT NULL AND
        (   p_Assignment_Set_rec.Last_Updated_By <>
            p_old_Assignment_Set_rec.Last_Updated_By OR
            p_old_Assignment_Set_rec.Last_Updated_By IS NULL )
    THEN
        IF NOT Val_Last_Updated_By(p_Assignment_Set_rec.Last_Updated_By) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 369

    IF  p_Assignment_Set_rec.Last_Update_Date IS NOT NULL AND
        (   p_Assignment_Set_rec.Last_Update_Date <>
            p_old_Assignment_Set_rec.Last_Update_Date OR
            p_old_Assignment_Set_rec.Last_Update_Date IS NULL )
    THEN
        IF NOT Val_Last_Update_Date(p_Assignment_Set_rec.Last_Update_Date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 379

    IF  p_Assignment_Set_rec.Last_Update_Login IS NOT NULL AND
        (   p_Assignment_Set_rec.Last_Update_Login <>
            p_old_Assignment_Set_rec.Last_Update_Login OR
            p_old_Assignment_Set_rec.Last_Update_Login IS NULL )
    THEN
        IF NOT Val_Last_Update_Login(p_Assignment_Set_rec.Last_Update_Login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 409

    IF  p_Assignment_Set_rec.Program_Update_Date IS NOT NULL AND
        (   p_Assignment_Set_rec.Program_Update_Date <>
            p_old_Assignment_Set_rec.Program_Update_Date OR
            p_old_Assignment_Set_rec.Program_Update_Date IS NULL )
    THEN
        IF NOT Val_Program_Update_Date(p_Assignment_Set_rec.Program_Update_Date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 481

        SELECT count(*)
        INTO   l_count
        FROM   MRP_ASSIGNMENT_SETS
        WHERE  assignment_set_name = p_Assignment_Set_Name;

Line: 844

FUNCTION Val_Last_Updated_By
(   p_Last_Updated_By               IN  NUMBER
)   RETURN BOOLEAN
IS
BEGIN

    IF p_Last_Updated_By IS NULL OR
       p_Last_Updated_By = FND_API.G_MISS_NUM
    THEN
        RETURN TRUE;

Line: 858

END Val_Last_Updated_By;

Line: 862

FUNCTION Val_Last_Update_Date
(   p_Last_Update_Date              IN  DATE
)   RETURN BOOLEAN
IS
BEGIN

    IF p_Last_Update_Date IS NULL OR
       p_Last_Update_Date = FND_API.G_MISS_DATE
    THEN
        RETURN TRUE;

Line: 876

END Val_Last_Update_Date;

Line: 880

FUNCTION Val_Last_Update_Login
(   p_Last_Update_Login             IN  NUMBER
)   RETURN BOOLEAN
IS
BEGIN

    IF p_Last_Update_Login IS NULL OR
       p_Last_Update_Login = FND_API.G_MISS_NUM
    THEN
        RETURN TRUE;

Line: 894

END Val_Last_Update_Login;

Line: 934

FUNCTION Val_Program_Update_Date
(   p_Program_Update_Date           IN  DATE
)   RETURN BOOLEAN
IS
BEGIN

    IF p_Program_Update_Date IS NULL OR
       p_Program_Update_Date = FND_API.G_MISS_DATE
    THEN
        RETURN TRUE;

Line: 948

END Val_Program_Update_Date;