APPS.QP_DEFAULT_FORMULA_LINES SQL Statements

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

Line: 57

    SELECT QP_PRICE_FORMULA_LINES_S.nextval
    INTO   l_price_formula_line_id
    FROM   dual;

Line: 558

    IF g_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_FORMULA_LINES_rec.last_updated_by := NULL;

Line: 564

    IF g_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_FORMULA_LINES_rec.last_update_date := NULL;

Line: 570

    IF g_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_FORMULA_LINES_rec.last_update_login := NULL;

Line: 597

    OR  g_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_FORMULA_LINES_rec.numeric_constant = FND_API.G_MISS_NUM
    OR  g_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM
    OR  g_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM
    OR  g_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR
    OR  g_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM
    OR  g_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM
    OR  g_FORMULA_LINES_rec.pricing_attribute = FND_API.G_MISS_CHAR
    OR  g_FORMULA_LINES_rec.pricing_attribute_context = FND_API.G_MISS_CHAR
    OR  g_FORMULA_LINES_rec.start_date_active = FND_API.G_MISS_DATE
    OR  g_FORMULA_LINES_rec.step_number = FND_API.G_MISS_NUM
    OR  g_FORMULA_LINES_rec.reqd_flag = FND_API.G_MISS_CHAR
    THEN

        QP_Default_Formula_Lines.Attributes
        (   p_FORMULA_LINES_rec           => g_FORMULA_LINES_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_FORMULA_LINES_rec           => x_FORMULA_LINES_rec
        );