APPS.QP_DEFAULT_LIMIT_ATTRS SQL Statements

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

Line: 49

    SELECT qp_limit_attributes_s.nextval
    INTO   l_limit_attribute_id
    FROM   dual;

Line: 426

    IF g_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_LIMIT_ATTRS_rec.last_updated_by := NULL;

Line: 432

    IF g_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_LIMIT_ATTRS_rec.last_update_date := NULL;

Line: 438

    IF g_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_LIMIT_ATTRS_rec.last_update_login := NULL;

Line: 456

    IF g_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_LIMIT_ATTRS_rec.program_update_date := NULL;

Line: 489

    OR  g_LIMIT_ATTRS_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_LIMIT_ATTRS_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_LIMIT_ATTRS_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_LIMIT_ATTRS_rec.limit_attribute = FND_API.G_MISS_CHAR
    OR  g_LIMIT_ATTRS_rec.limit_attribute_context = FND_API.G_MISS_CHAR
    OR  g_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM
    OR  g_LIMIT_ATTRS_rec.limit_attribute_type = FND_API.G_MISS_CHAR
    OR  g_LIMIT_ATTRS_rec.limit_attr_datatype = FND_API.G_MISS_CHAR
    OR  g_LIMIT_ATTRS_rec.limit_attr_value = FND_API.G_MISS_CHAR
    OR  g_LIMIT_ATTRS_rec.limit_id = FND_API.G_MISS_NUM
    OR  g_LIMIT_ATTRS_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_LIMIT_ATTRS_rec.program_id = FND_API.G_MISS_NUM
    OR  g_LIMIT_ATTRS_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_LIMIT_ATTRS_rec.request_id = FND_API.G_MISS_NUM
    THEN

        QP_Default_Limit_Attrs.Attributes
        (   p_LIMIT_ATTRS_rec             => g_LIMIT_ATTRS_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_LIMIT_ATTRS_rec             => x_LIMIT_ATTRS_rec
        );