APPS.QP_DEFAULT_FORMULA SQL Statements

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

Line: 57

    SELECT QP_PRICE_FORMULAS_B_S.nextval
    INTO   l_price_formula_id
    FROM   dual;

Line: 359

    IF g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_FORMULA_rec.last_updated_by := NULL;

Line: 365

    IF g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_FORMULA_rec.last_update_date := NULL;

Line: 371

    IF g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_FORMULA_rec.last_update_login := NULL;

Line: 400

    OR  g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_FORMULA_rec.name = FND_API.G_MISS_CHAR
    OR  g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM
    OR  g_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE
    THEN

        QP_Default_Formula.Attributes
        (   p_FORMULA_rec                 => g_FORMULA_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_FORMULA_rec                 => x_FORMULA_rec
        );