APPS.OE_DEFAULT_CONTRACT SQL Statements

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

Line: 22

    select oe_agreements_s.nextval into l_Agreement_Id
    from dual;

Line: 54

    select oe_discounts_s.nextval
    into l_Discount_Id
    from dual;

Line: 66

FUNCTION Get_Last_Updated_By
RETURN NUMBER
IS
BEGIN

    RETURN NULL;

Line: 73

END Get_Last_Updated_By;

Line: 92

    select oe_pricing_contracts_s.nextval into l_Pricing_Contract_Id
    from dual;

Line: 250

    IF g_Contract_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_Contract_rec.last_updated_by := Get_Last_Updated_By;

Line: 254

        IF g_Contract_rec.last_updated_by IS NOT NULL THEN

            IF OE_Validate_Attr.Last_Updated_By(g_Contract_rec.last_updated_by)
            THEN
                OE_Contract_Util.Clear_Dependent_Attr
                (   p_attr_id                     => OE_Contract_Util.G_LAST_UPDATED_BY
                ,   p_Contract_rec                => g_Contract_rec
                ,   x_Contract_rec                => g_Contract_rec
                );

Line: 264

                g_Contract_rec.last_updated_by := NULL;

Line: 347

    IF g_Contract_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_Contract_rec.last_update_date := NULL;

Line: 353

    IF g_Contract_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_Contract_rec.last_update_login := NULL;

Line: 381

    OR  g_Contract_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_Contract_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_Contract_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_Contract_rec.price_list_id = FND_API.G_MISS_NUM
    OR  g_Contract_rec.pricing_contract_id = FND_API.G_MISS_NUM
    THEN

        OE_Default_Contract.Attributes
        (   p_Contract_rec                => g_Contract_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_Contract_rec                => x_Contract_rec
        );