APPS.OE_DEFAULT_AGREEMENT SQL Statements

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

Line: 40

    select oe_agreements_s.nextval into l_Agreement_Id
    from dual;

Line: 1088

    IF g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_Agreement_rec.last_updated_by := NULL;

Line: 1094

    IF g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_Agreement_rec.last_update_date := NULL;

Line: 1100

    IF g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_Agreement_rec.last_update_login := NULL;

Line: 1139

    OR  g_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_Agreement_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_Agreement_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_Agreement_rec.name = FND_API.G_MISS_CHAR
    OR  g_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR
    OR  g_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR
    OR  g_Agreement_rec.price_list_id = FND_API.G_MISS_NUM
    OR  g_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR
    OR  g_Agreement_rec.revision = FND_API.G_MISS_CHAR
    OR  g_Agreement_rec.revision_date = FND_API.G_MISS_DATE
    OR  g_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR
    OR  g_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM
    OR  g_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR
    OR  g_Agreement_rec.signature_date = FND_API.G_MISS_DATE
    OR  g_Agreement_rec.start_date_active = FND_API.G_MISS_DATE
    OR  g_Agreement_rec.term_id = FND_API.G_MISS_NUM
    --begin code  added by rchellam for OKC
    OR  g_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR
    OR  g_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM
    --end code  added by rchellam for OKC
    THEN

        OE_Default_Agreement.Attributes
        (   p_Agreement_rec               => g_Agreement_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_Agreement_rec               => x_Agreement_rec
        );