APPS.OE_DEFAULT_PRICE_LIST SQL Statements

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

Line: 76

    select qp_list_headers_b_s.nextval into l_price_list_id
    from dual;

Line: 534

    IF g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_PRICE_LIST_rec.last_updated_by := NULL;

Line: 540

    IF g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_PRICE_LIST_rec.last_update_date := NULL;

Line: 546

    IF g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_PRICE_LIST_rec.last_update_login := NULL;

Line: 564

    IF g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_PRICE_LIST_rec.program_update_date := NULL;

Line: 601

    OR  g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
    OR  g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
    OR  g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
    OR  g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
    THEN

        OE_Default_Price_List.Attributes
        (   p_PRICE_LIST_rec              => g_PRICE_LIST_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_PRICE_LIST_rec              => x_PRICE_LIST_rec
        );