APPS.QP_DEFAULT_LIMITS SQL Statements

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

Line: 50

    SELECT qp_limits_s.nextval
    INTO   l_limit_id
    FROM   dual;

Line: 765

    IF g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_LIMITS_rec.last_updated_by := NULL;

Line: 771

    IF g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_LIMITS_rec.last_update_date := NULL;

Line: 777

    IF g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_LIMITS_rec.last_update_login := NULL;

Line: 795

    IF g_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_LIMITS_rec.program_update_date := NULL;

Line: 829

    OR  g_LIMITS_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_LIMITS_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_LIMITS_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_LIMITS_rec.limit_exceed_action_code = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.limit_id = FND_API.G_MISS_NUM
    OR  g_LIMITS_rec.limit_level_code = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.limit_number = FND_API.G_MISS_NUM
    OR  g_LIMITS_rec.list_header_id = FND_API.G_MISS_NUM
    OR  g_LIMITS_rec.list_line_id = FND_API.G_MISS_NUM
    OR  g_LIMITS_rec.multival_attr1_type = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.multival_attr1_context = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.multival_attribute1 = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.multival_attr1_datatype = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.multival_attr2_type = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.multival_attr2_context = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.multival_attribute2 = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.multival_attr2_datatype = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.organization_flag = FND_API.G_MISS_CHAR
    OR  g_LIMITS_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_LIMITS_rec.program_id = FND_API.G_MISS_NUM
    OR  g_LIMITS_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_LIMITS_rec.request_id = FND_API.G_MISS_NUM
    THEN

        QP_Default_Limits.Attributes
        (   p_LIMITS_rec                  => g_LIMITS_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_LIMITS_rec                  => x_LIMITS_rec
        );