APPS.MRP_VALIDATE SQL Statements

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

Line: 20

    FND_API.g_attr_tbl.DELETE;

Line: 65

    FND_API.g_attr_tbl(I).name     := 'last_updated_by';

Line: 67

    FND_API.g_attr_tbl(I).name     := 'last_update_date';

Line: 69

    FND_API.g_attr_tbl(I).name     := 'last_update_login';

Line: 101

    FND_API.g_attr_tbl(I).name     := 'program_update_date';

Line: 411

    SELECT  'VALID'
    INTO     l_dummy
    FROM     DUAL
    WHERE    p_build_sequence > 0;

Line: 747

    SELECT  'VALID'
    INTO     l_dummy
    FROM     FND_COMMON_LOOKUPS
    WHERE    LOOKUP_CODE = p_demand_class
    AND      LOOKUP_TYPE = 'DEMAND_CLASS'
    AND      ENABLED_FLAG = 'Y'
    AND      SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND
                             NVL(END_DATE_ACTIVE,SYSDATE);

Line: 983

FUNCTION Last_Updated_By ( p_last_updated_by IN NUMBER )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 989

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

Line: 1010

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_updated_by');

Line: 1023

            ,   'Last_Updated_By'
            );

Line: 1029

END Last_Updated_By;

Line: 1031

FUNCTION Last_Update_Date ( p_last_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 1037

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

Line: 1058

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_date');

Line: 1071

            ,   'Last_Update_Date'
            );

Line: 1077

END Last_Update_Date;

Line: 1079

FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 1085

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

Line: 1106

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_login');

Line: 1119

            ,   'Last_Update_Login'
            );

Line: 1125

END Last_Update_Login;

Line: 1331

    SELECT  'VALID'
    INTO     l_dummy
    FROM     DUAL
    WHERE    p_mps_net_quantity >= 0;

Line: 1427

    SELECT  'VALID'
    INTO     l_dummy
    FROM     mtl_parameters
    WHERE    ORGANIZATION_ID = p_organization_id;

Line: 1667

    SELECT  'VALID'
    INTO     l_dummy
    FROM     DUAL
    WHERE    p_planned_quantity >= 0;

Line: 1847

FUNCTION Program_Update_Date ( p_program_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 1853

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

Line: 1874

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','program_update_date');

Line: 1887

            ,   'Program_Update_Date'
            );

Line: 1893

END Program_Update_Date;

Line: 1907

    SELECT  'VALID'
    INTO     l_dummy
    FROM     MTL_PROJECT_V
    WHERE    PROJECT_ID = p_project_id;

Line: 1955

    SELECT  'VALID'
    INTO     l_dummy
    FROM     DUAL
    WHERE    p_quantity_completed >= 0;

Line: 2291

    SELECT  'VALID'
    INTO     l_dummy
    FROM     DUAL
    WHERE    p_scheduled_flag in (1,2,3);

Line: 2678

    SELECT  'VALID'
    INTO     l_dummy
    FROM    DUAL
    WHERE    EXISTS (
    SELECT UNIT_NUMBER FROM pjm_unit_numbers_lov_v
    WHERE UNIT_NUMBER = p_end_item_unit_number);