DBA Data[Home] [Help]

APPS.OE_DEFAULT_PRICE_BREAK SQL Statements

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

Line: 453

    IF g_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_Price_Break_rec.last_updated_by := NULL;
Line: 459

    IF g_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_Price_Break_rec.last_update_date := NULL;
Line: 465

    IF g_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_Price_Break_rec.last_update_login := NULL;
Line: 483

    IF g_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_Price_Break_rec.program_update_date := NULL;
Line: 518

    OR  g_Price_Break_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_Price_Break_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_Price_Break_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_Price_Break_rec.method_type_code = FND_API.G_MISS_CHAR
    OR  g_Price_Break_rec.percent = FND_API.G_MISS_NUM
    OR  g_Price_Break_rec.price = FND_API.G_MISS_NUM
    OR  g_Price_Break_rec.price_break_high = FND_API.G_MISS_NUM
    OR  g_Price_Break_rec.price_break_low = FND_API.G_MISS_NUM
    OR  g_Price_Break_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_Price_Break_rec.program_id = FND_API.G_MISS_NUM
    OR  g_Price_Break_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_Price_Break_rec.request_id = FND_API.G_MISS_NUM
    OR  g_Price_Break_rec.start_date_active = FND_API.G_MISS_DATE
    OR  g_Price_Break_rec.unit_code = FND_API.G_MISS_CHAR
    THEN

        OE_Default_Price_Break.Attributes
        (   p_Price_Break_rec             => g_Price_Break_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_Price_Break_rec             => x_Price_Break_rec
        );