APPS.OE_OE_FORM_AGREEMENT SQL Statements

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

Line: 579

        l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;

Line: 1068

,   x_last_update_date              OUT NOCOPY /* file.sql.39 change */ DATE
,   x_last_updated_by               OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_last_update_login             OUT NOCOPY /* file.sql.39 change */ NUMBER
)
IS
l_Agreement_rec               OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line: 1123

        l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;

Line: 1132

    and l_Agreement_rec.operation = oe_globals.G_OPR_UPDATE ) THEN

   select oe_agreements_s.nextval into l_agreement_rec.agreement_id from dual;

Line: 1185

    x_last_update_date             := l_x_Agreement_rec.last_update_date;

Line: 1186

    x_last_updated_by              := l_x_Agreement_rec.last_updated_by;

Line: 1187

    x_last_update_login            := l_x_Agreement_rec.last_update_login;

Line: 1274

PROCEDURE Delete_Row
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_agreement_id                  IN  NUMBER
)
IS
l_Agreement_rec               OE_Pricing_Cont_PUB.Agreement_Rec_Type;

Line: 1322

    l_Agreement_rec.operation := oe_globals.G_OPR_DELETE;

Line: 1399

            ,   'Delete_Row'
            );

Line: 1410

END Delete_Row;

Line: 1574

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_name                          IN  VARCHAR2
,   p_override_arule_flag           IN  VARCHAR2
,   p_override_irule_flag           IN  VARCHAR2
,   p_price_list_id                 IN  NUMBER
,   p_purchase_order_num            IN  VARCHAR2
,   p_revision                      IN  VARCHAR2
,   p_revision_date                 IN  DATE
,   p_revision_reason_code          IN  VARCHAR2
,   p_salesrep_id                   IN  NUMBER
,   p_ship_method_code              IN  VARCHAR2
,   p_signature_date                IN  DATE
,   p_start_date_active             IN  DATE
,   p_term_id                       IN  NUMBER
,   p_agreement_source_code         IN  VARCHAR2
                                         --added by rchellam for OKC
,   p_orig_system_agr_id            IN  NUMBER --added by rchellam for OKC
,   p_invoice_to_customer_id        IN  NUMBER -- Added for bug#4029589
)
IS
l_return_status               VARCHAR2(1);

Line: 1645

    l_Agreement_rec.last_updated_by := p_last_updated_by;

Line: 1646

    l_Agreement_rec.last_update_date := p_last_update_date;

Line: 1647

    l_Agreement_rec.last_update_login := p_last_update_login;