APPS.OE_OE_FORM_CONTRACT SQL Statements

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

Line: 42

      SELECT id_flex_num
      FROM   fnd_id_flex_structures
      WHERE  id_flex_code = X_Id_Flex_Code;

Line: 89

,   x_last_updated_by               OUT NUMBER
,   x_price_list_id                 OUT NUMBER
,   x_pricing_contract_id           OUT NUMBER
,   x_agreement                     OUT VARCHAR2
,   x_discount                      OUT VARCHAR2
,   x_price_list                    OUT VARCHAR2
)
IS
l_Contract_rec                OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line: 206

    x_last_updated_by              := l_x_Contract_rec.last_updated_by;

Line: 330

,   x_last_updated_by               OUT NUMBER
,   x_price_list_id                 OUT NUMBER
,   x_pricing_contract_id           OUT NUMBER
,   x_agreement                     OUT VARCHAR2
,   x_discount                      OUT VARCHAR2
,   x_price_list                    OUT VARCHAR2
)
IS
l_Contract_rec                OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line: 387

    ELSIF p_attr_id = OE_Contract_Util.G_LAST_UPDATED_BY THEN
        l_Contract_rec.last_updated_by := TO_NUMBER(p_attr_value);

Line: 448

        l_Contract_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 502

    x_last_updated_by              := FND_API.G_MISS_NUM;

Line: 628

    IF NOT OE_GLOBALS.Equal(l_x_Contract_rec.last_updated_by,
                            l_Contract_rec.last_updated_by)
    THEN
        x_last_updated_by := l_x_Contract_rec.last_updated_by;

Line: 722

,   x_last_update_date              OUT DATE
,   x_last_updated_by               OUT NUMBER
,   x_last_update_login             OUT NUMBER
)
IS
l_Contract_rec                OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line: 777

        l_Contract_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 784

        select oe_pricing_contracts_s.nextval into l_Contract_rec.pricing_contract_id  from dual;

Line: 825

    x_last_update_date             := l_x_Contract_rec.last_update_date;

Line: 826

    x_last_updated_by              := l_x_Contract_rec.last_updated_by;

Line: 827

    x_last_update_login            := l_x_Contract_rec.last_update_login;

Line: 899

PROCEDURE Delete_Row
(   x_return_status                 OUT VARCHAR2
,   x_msg_count                     OUT NUMBER
,   x_msg_data                      OUT VARCHAR2
,   p_pricing_contract_id           IN  NUMBER
)
IS
l_Contract_rec                OE_Pricing_Cont_PUB.Contract_Rec_Type;

Line: 947

    l_Contract_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 1024

            ,   'Delete_Row'
            );

Line: 1035

END Delete_Row;

Line: 1312

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_price_list_id                 IN  NUMBER
,   p_pricing_contract_id           IN  NUMBER
)
IS
l_return_status               VARCHAR2(1);

Line: 1357

    l_Contract_rec.last_updated_by := p_last_updated_by;

Line: 1358

    l_Contract_rec.last_update_date := p_last_update_date;

Line: 1359

    l_Contract_rec.last_update_login := p_last_update_login;