APPS.OE_DEFAULT_PRICE_LIST_LINE SQL Statements

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

Line: 85

    select qp_list_lines_s.nextval into l_price_list_line_id
    from dual;

Line: 1521

    IF g_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_PRICE_LIST_LINE_rec.last_updated_by := NULL;

Line: 1527

    IF g_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_PRICE_LIST_LINE_rec.last_update_date := NULL;

Line: 1533

    IF g_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_PRICE_LIST_LINE_rec.last_update_login := NULL;

Line: 1551

    IF g_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_PRICE_LIST_LINE_rec.program_update_date := NULL;

Line: 1587

    OR  g_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_LINE_rec.unit_code = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_LINE_rec.list_line_type_code = FND_API.G_MISS_CHAR
    THEN

        OE_Default_Price_List_Line.Attributes
        (   p_PRICE_LIST_LINE_rec         => g_PRICE_LIST_LINE_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_PRICE_LIST_LINE_rec         => x_PRICE_LIST_LINE_rec
        );