DBA Data[Home] [Help]

APPS.OE_AGREEMENT_UTIL SQL Statements

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

Line: 176

        IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_updated_by,p_old_Agreement_rec.last_updated_by)
        THEN
            NULL;
Line: 181

        IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_date,p_old_Agreement_rec.last_update_date)
        THEN
            NULL;
Line: 186

        IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_login,p_old_Agreement_rec.last_update_login)
        THEN
            NULL;
Line: 332

    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        NULL;
Line: 334

    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        NULL;
Line: 336

    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        NULL;
Line: 546

    IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_updated_by,p_old_Agreement_rec.last_updated_by)
    THEN
        NULL;
Line: 551

    IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_date,p_old_Agreement_rec.last_update_date)
    THEN
        NULL;
Line: 556

    IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_login,p_old_Agreement_rec.last_update_login)
    THEN
        NULL;
Line: 775

    IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_Agreement_rec.last_updated_by := p_old_Agreement_rec.last_updated_by;
Line: 779

    IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_Agreement_rec.last_update_date := p_old_Agreement_rec.last_update_date;
Line: 783

    IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_Agreement_rec.last_update_login := p_old_Agreement_rec.last_update_login;
Line: 987

    IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_Agreement_rec.last_updated_by := NULL;
Line: 991

    IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_Agreement_rec.last_update_date := NULL;
Line: 995

    IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_Agreement_rec.last_update_login := NULL;
Line: 1074

PROCEDURE Update_Row
(   p_Agreement_rec                 IN  OE_Pricing_Cont_PUB.Agreement_Rec_Type
)
IS
BEGIN

    oe_debug_pub.add('Entering OE_Agreement_Util.Update_Row');
Line: 1082

  IF QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
                                 p_instance_type => QP_Security.G_AGREEMENT_OBJECT,
                                 p_instance_pk1  => p_Agreement_rec.price_list_id) <> 'F' THEN

    OE_AGREEMENTS_PKG.UPDATE_ROW (
           	p_Agreement_rec.agreement_id
		 ,	p_Agreement_rec.tp_attribute2
		 ,	p_Agreement_rec.tp_attribute3
		 ,	p_Agreement_rec.tp_attribute4
		 ,	p_Agreement_rec.tp_attribute5
		 ,	p_Agreement_rec.tp_attribute6
		 ,	p_Agreement_rec.tp_attribute7
		 ,	p_Agreement_rec.tp_attribute8
		 ,	p_Agreement_rec.tp_attribute9
		 ,	p_Agreement_rec.tp_attribute10
		 ,	p_Agreement_rec.tp_attribute11
		 ,	p_Agreement_rec.tp_attribute12
		 ,	p_Agreement_rec.tp_attribute13
		 ,	p_Agreement_rec.tp_attribute14
		 ,	p_Agreement_rec.tp_attribute15
		 ,	p_Agreement_rec.tp_attribute_category
		 ,	p_Agreement_rec.agreement_type_code
		 ,	p_Agreement_rec.price_list_id
		 ,	p_Agreement_rec.term_id
		 ,	p_agreement_rec.override_irule_flag
		 ,	p_Agreement_rec.override_arule_flag
		 ,	p_Agreement_rec.signature_date
		 ,	p_Agreement_rec.agreement_num
		 ,	p_Agreement_rec.tp_attribute1
		 ,	p_Agreement_rec.attribute12
		 ,	p_Agreement_rec.attribute13
		 ,	p_Agreement_rec.attribute14
		 ,	p_Agreement_rec.attribute15
		 ,	p_Agreement_rec.attribute11
		 ,	p_Agreement_rec.attribute9
		 ,	p_Agreement_rec.attribute10
		 ,	p_Agreement_rec.revision
		 ,	p_Agreement_rec.revision_date
		 ,	p_Agreement_rec.revision_reason_code
		 ,	p_Agreement_rec.freight_terms_code
		 ,	p_Agreement_rec.ship_method_code
		 ,	p_Agreement_rec.invoicing_rule_id
		 ,	p_Agreement_rec.accounting_rule_id
		 ,	p_Agreement_rec.sold_to_org_id
		 ,	p_Agreement_rec.purchase_order_num
		 ,	p_Agreement_rec.invoice_contact_id
		 ,	p_Agreement_rec.agreement_contact_id
		 ,	p_Agreement_rec.invoice_to_org_id
		 ,	p_Agreement_rec.salesrep_id
		 ,	p_Agreement_rec.start_date_active
		 ,	p_Agreement_rec.end_date_active
		 ,	p_Agreement_rec.comments
		 ,	p_Agreement_rec.context
		 ,	p_Agreement_rec.attribute1
		 ,	p_Agreement_rec.attribute2
		 ,	p_Agreement_rec.attribute3
		 ,	p_Agreement_rec.attribute4
		 ,	p_Agreement_rec.attribute5
		 ,	p_Agreement_rec.attribute6
		 ,	p_Agreement_rec.attribute7
		 ,	p_Agreement_rec.attribute8
		 ,	p_Agreement_rec.name
		 ,	p_Agreement_rec.last_update_date
		 ,	p_Agreement_rec.last_updated_by
		 ,	p_Agreement_rec.last_update_login
		 ,	p_Agreement_rec.agreement_source_code --added by
		 ,	p_Agreement_rec.orig_system_agr_id --rchellam for OKC
     ,	p_Agreement_rec.invoice_to_customer_id -- Added for bug#4029589
    );
Line: 1162

    UPDATE  OE_AGREEMENTS
    SET     ACCOUNTING_RULE_ID             = p_Agreement_rec.accounting_rule_id
    ,       AGREEMENT_CONTACT_ID           = p_Agreement_rec.agreement_contact_id
    ,       AGREEMENT_ID                   = p_Agreement_rec.agreement_id
    ,       AGREEMENT_NUM                  = p_Agreement_rec.agreement_num
    ,       AGREEMENT_TYPE_CODE            = p_Agreement_rec.agreement_type_code
    ,       ATTRIBUTE1                     = p_Agreement_rec.attribute1
    ,       ATTRIBUTE10                    = p_Agreement_rec.attribute10
    ,       ATTRIBUTE11                    = p_Agreement_rec.attribute11
    ,       ATTRIBUTE12                    = p_Agreement_rec.attribute12
    ,       ATTRIBUTE13                    = p_Agreement_rec.attribute13
    ,       ATTRIBUTE14                    = p_Agreement_rec.attribute14
    ,       ATTRIBUTE15                    = p_Agreement_rec.attribute15
    ,       ATTRIBUTE2                     = p_Agreement_rec.attribute2
    ,       ATTRIBUTE3                     = p_Agreement_rec.attribute3
    ,       ATTRIBUTE4                     = p_Agreement_rec.attribute4
    ,       ATTRIBUTE5                     = p_Agreement_rec.attribute5
    ,       ATTRIBUTE6                     = p_Agreement_rec.attribute6
    ,       ATTRIBUTE7                     = p_Agreement_rec.attribute7
    ,       ATTRIBUTE8                     = p_Agreement_rec.attribute8
    ,       ATTRIBUTE9                     = p_Agreement_rec.attribute9
    ,       CONTEXT                        = p_Agreement_rec.context
    ,       CREATED_BY                     = p_Agreement_rec.created_by
    ,       CREATION_DATE                  = p_Agreement_rec.creation_date
    ,       SOLD_TO_ORG_ID                    = p_Agreement_rec.sold_to_org_id
    ,       END_DATE_ACTIVE                = p_Agreement_rec.end_date_active
    ,       FREIGHT_TERMS_CODE             = p_Agreement_rec.freight_terms_code
    ,       INVOICE_CONTACT_ID             = p_Agreement_rec.invoice_contact_id
    ,       invoice_to_org_id         = p_Agreement_rec.invoice_to_org_id
    ,       INVOICING_RULE_ID              = p_Agreement_rec.invoicing_rule_id
    ,       LAST_UPDATED_BY                = p_Agreement_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_Agreement_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_Agreement_rec.last_update_login
    ,       NAME                           = p_Agreement_rec.name
    ,       OVERRIDE_ARULE_FLAG            = p_Agreement_rec.override_arule_flag
    ,       OVERRIDE_IRULE_FLAG            = p_Agreement_rec.override_irule_flag
    ,       PRICE_LIST_ID                  = p_Agreement_rec.price_list_id
    ,       PURCHASE_ORDER_NUM             = p_Agreement_rec.purchase_order_num
    ,       REVISION                       = p_Agreement_rec.revision
    ,       REVISION_DATE                  = p_Agreement_rec.revision_date
    ,       REVISION_REASON_CODE           = p_Agreement_rec.revision_reason_code
    ,       SALESREP_ID                    = p_Agreement_rec.salesrep_id
    ,       SHIP_METHOD_CODE               = p_Agreement_rec.ship_method_code
    ,       SIGNATURE_DATE                 = p_Agreement_rec.signature_date
    ,       START_DATE_ACTIVE              = p_Agreement_rec.start_date_active
    ,       TERM_ID                        = p_Agreement_rec.term_id
    WHERE   AGREEMENT_ID = p_Agreement_rec.agreement_id
    ;
Line: 1211

    oe_debug_pub.add('Exiting OE_Agreement_Util.Update_Row');
Line: 1221

            ,   'Update_Row'
            );
Line: 1227

END Update_Row;
Line: 1231

PROCEDURE Insert_Row
(   p_Agreement_rec                 IN  OE_Pricing_Cont_PUB.Agreement_Rec_Type
)
IS
x_row_id VARCHAR2(240);
Line: 1239

    oe_debug_pub.add('Entering OE_Agreement_Util.Insert_Row');
Line: 1242

   OE_AGREEMENTS_PKG.INSERT_ROW ( x_row_id
    ,       p_Agreement_rec.agreement_id
    ,       p_Agreement_rec.tp_attribute2
    ,       p_Agreement_rec.tp_attribute3
    ,       p_Agreement_rec.tp_attribute4
    ,       p_Agreement_rec.tp_attribute5
    ,       p_Agreement_rec.tp_attribute6
    ,       p_Agreement_rec.tp_attribute7
    ,       p_Agreement_rec.tp_attribute8
    ,       p_Agreement_rec.tp_attribute9
    ,       p_Agreement_rec.tp_attribute10
    ,       p_Agreement_rec.tp_attribute11
    ,       p_Agreement_rec.tp_attribute12
    ,       p_Agreement_rec.tp_attribute13
    ,       p_Agreement_rec.tp_attribute14
    ,       p_Agreement_rec.tp_attribute15
    ,       p_Agreement_rec.tp_attribute_category
    ,       p_Agreement_rec.agreement_type_code
    ,       p_Agreement_rec.price_list_id
    ,       p_Agreement_rec.term_id
    ,       p_Agreement_rec.override_irule_flag
    ,       p_Agreement_rec.override_arule_flag
    ,       p_Agreement_rec.signature_date
    ,       p_Agreement_rec.agreement_num
    ,       p_Agreement_rec.tp_attribute1
    ,       p_Agreement_rec.attribute12
    ,       p_Agreement_rec.attribute13
    ,       p_Agreement_rec.attribute14
    ,       p_Agreement_rec.attribute15
    ,       p_Agreement_rec.attribute11
    ,       p_Agreement_rec.attribute9
    ,       p_Agreement_rec.attribute10
    ,       p_Agreement_rec.revision
    ,       p_Agreement_rec.revision_date
    ,       p_Agreement_rec.revision_reason_code
    ,       p_Agreement_rec.freight_terms_code
    ,       p_Agreement_rec.ship_method_code
    ,       p_Agreement_rec.invoicing_rule_id
    ,	    p_Agreement_rec.accounting_rule_id
    ,       p_Agreement_rec.sold_to_org_id
    ,       p_Agreement_rec.purchase_order_num
    ,       p_Agreement_rec.invoice_contact_id
    ,       p_Agreement_rec.agreement_contact_id
    ,       p_Agreement_rec.invoice_to_org_id
    ,       p_Agreement_rec.salesrep_id
    ,       p_Agreement_rec.start_date_active
    ,       p_Agreement_rec.end_date_active
    ,       p_Agreement_rec.comments
    ,       p_Agreement_rec.context
    ,       p_Agreement_rec.attribute1
    ,       p_Agreement_rec.attribute2
    ,       p_Agreement_rec.attribute3
    ,       p_Agreement_rec.attribute4
    ,       p_Agreement_rec.attribute5
    ,       p_Agreement_rec.attribute6
    ,       p_Agreement_rec.attribute7
    ,       p_Agreement_rec.attribute8
    ,       p_Agreement_rec.name
    ,       p_Agreement_rec.creation_date
    ,       p_Agreement_rec.created_by
    ,       p_Agreement_rec.last_update_date
    ,       p_Agreement_rec.last_updated_by
    ,       p_Agreement_rec.last_update_login
    ,       p_Agreement_rec.agreement_source_code --added by rchellam for OKC
    ,       p_Agreement_rec.orig_system_agr_id --added by rchellam for OKC
    ,	    p_Agreement_rec.invoice_to_customer_id -- Added for bug#4029589
    );
Line: 1313

    INSERT  INTO OE_AGREEMENTS
    (       ACCOUNTING_RULE_ID
    ,       AGREEMENT_CONTACT_ID
    ,       AGREEMENT_ID
    ,       AGREEMENT_NUM
    ,       AGREEMENT_TYPE_CODE
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       SOLD_TO_ORG_ID
    ,       END_DATE_ACTIVE
    ,       FREIGHT_TERMS_CODE
    ,       INVOICE_CONTACT_ID
    ,       invoice_to_org_id
    ,       INVOICING_RULE_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       NAME
    ,       OVERRIDE_ARULE_FLAG
    ,       OVERRIDE_IRULE_FLAG
    ,       PRICE_LIST_ID
    ,       PURCHASE_ORDER_NUM
    ,       REVISION
    ,       REVISION_DATE
    ,       REVISION_REASON_CODE
    ,       SALESREP_ID
    ,       SHIP_METHOD_CODE
    ,       SIGNATURE_DATE
    ,       START_DATE_ACTIVE
    ,       TERM_ID
    )
    VALUES
    (       p_Agreement_rec.accounting_rule_id
    ,       p_Agreement_rec.agreement_contact_id
    ,       p_Agreement_rec.agreement_id
    ,       p_Agreement_rec.agreement_num
    ,       p_Agreement_rec.agreement_type_code
    ,       p_Agreement_rec.attribute1
    ,       p_Agreement_rec.attribute10
    ,       p_Agreement_rec.attribute11
    ,       p_Agreement_rec.attribute12
    ,       p_Agreement_rec.attribute13
    ,       p_Agreement_rec.attribute14
    ,       p_Agreement_rec.attribute15
    ,       p_Agreement_rec.attribute2
    ,       p_Agreement_rec.attribute3
    ,       p_Agreement_rec.attribute4
    ,       p_Agreement_rec.attribute5
    ,       p_Agreement_rec.attribute6
    ,       p_Agreement_rec.attribute7
    ,       p_Agreement_rec.attribute8
    ,       p_Agreement_rec.attribute9
    ,       p_Agreement_rec.context
    ,       p_Agreement_rec.created_by
    ,       p_Agreement_rec.creation_date
    ,       p_Agreement_rec.sold_to_org_id
    ,       p_Agreement_rec.end_date_active
    ,       p_Agreement_rec.freight_terms_code
    ,       p_Agreement_rec.invoice_contact_id
    ,       p_Agreement_rec.invoice_to_org_id
    ,       p_Agreement_rec.invoicing_rule_id
    ,       p_Agreement_rec.last_updated_by
    ,       p_Agreement_rec.last_update_date
    ,       p_Agreement_rec.last_update_login
    ,       p_Agreement_rec.name
    ,       p_Agreement_rec.override_arule_flag
    ,       p_Agreement_rec.override_irule_flag
    ,       p_Agreement_rec.price_list_id
    ,       p_Agreement_rec.purchase_order_num
    ,       p_Agreement_rec.revision
    ,       p_Agreement_rec.revision_date
    ,       p_Agreement_rec.revision_reason_code
    ,       p_Agreement_rec.salesrep_id
    ,       p_Agreement_rec.ship_method_code
    ,       p_Agreement_rec.signature_date
    ,       p_Agreement_rec.start_date_active
    ,       p_Agreement_rec.term_id
    );
Line: 1409

    oe_debug_pub.add('Entering OE_Agreement_Util.Insert_Row');
Line: 1419

            ,   'Insert_Row'
            );
Line: 1425

END Insert_Row;
Line: 1429

PROCEDURE Delete_Row
(
    x_return_status                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_agreement_id                  IN  NUMBER
,   p_Price_List_Exists_Flag        IN  BOOLEAN
,   p_Agreement_Delete_Flag         IN BOOLEAN
,   p_Agreement_Lines_Delete_Flag         IN BOOLEAN
)
IS
  l_Price_List_id NUMBER;
Line: 1441

		SELECT list_line_id
		FROM QP_LIST_LINES
		WHERE LIST_HEADER_ID = p_Price_List_id;
Line: 1448

    oe_debug_pub.add('Entering OE_Agreement_Util.Delete_Row');
Line: 1454

    If (p_Agreement_Delete_Flag) Then
    oe_debug_pub.add('p_Agreement_Delete_Flag :');
Line: 1460

     If (p_Agreement_Lines_Delete_Flag) Then
     oe_debug_pub.add('p_Agreement_Lines_Delete_Flag :');
Line: 1466

   SELECT price_list_id, q.list_type_code into
        l_Price_List_id, l_list_type_code
        from oe_agreements_b, qp_list_headers q
        where agreement_id = p_agreement_id And
              price_list_id = q.list_header_id;
Line: 1479

 	 If this flag is TRUE then Delete Price List

     SELECT price_list_id into
	l_Price_List_id
	from oe_agreements_b
	where agreement_id = p_agreement_id;
Line: 1488

	 Deletes the Price List Header

		 oe_debug_pub.add(' OE_Agreement_Util: Deleting price list for the Agreement');
Line: 1491

     	QP_Price_List_Util.Delete_Row( l_Price_List_id );
Line: 1494

	/* Delete from qp_qualifiers table */
/* This code has been moved so that qualifier should be deleted only
  if Agreement is deleted. Bug 2321498

		DELETE FROM QP_QUALIFIERS
		where list_header_id = l_Price_List_id
		and qualifier_attr_value = p_agreement_id;
Line: 1510

	if  ( p_Agreement_Delete_Flag  ) and
	    ( p_Agreement_Lines_Delete_Flag) then

               -- Bug 2321498: delete qualifier
                     Begin
                           If l_list_type_code = 'AGR' Then
                              DELETE FROM QP_QUALIFIERS
                            where list_header_id = l_Price_List_id
                            and qualifier_attr_value = p_agreement_id;
Line: 1527

   			OE_AGREEMENTS_PKG.DELETE_ROW( p_agreement_id );
Line: 1530

		oe_debug_pub.add('Did not delete agreement');
Line: 1533

		FND_MESSAGE.SET_NAME('QP','QP_AGREEMENT_DELETE');
Line: 1543

    oe_debug_pub.add('Exiting OE_Agreement_Util.Delete_Row');
Line: 1556

            ,   'Delete_Row'
            );
Line: 1562

END Delete_Row;
Line: 1597

    SELECT  ACCOUNTING_RULE_ID
    ,       AGREEMENT_CONTACT_ID
    ,       AGREEMENT_ID
    ,       AGREEMENT_NUM
    ,       AGREEMENT_TYPE_CODE
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       sold_to_org_id
    ,       END_DATE_ACTIVE
    ,       FREIGHT_TERMS_CODE
    ,       INVOICE_CONTACT_ID
    ,       invoice_to_org_id
    ,       INVOICING_RULE_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       NAME
    ,       OVERRIDE_ARULE_FLAG
    ,       OVERRIDE_IRULE_FLAG
    ,       PRICE_LIST_ID
    ,       PURCHASE_ORDER_NUM
    ,       REVISION
    ,       REVISION_DATE
    ,       REVISION_REASON_CODE
    ,       SALESREP_ID
    ,       SHIP_METHOD_CODE
    ,       SIGNATURE_DATE
    ,       START_DATE_ACTIVE
    ,       TERM_ID
    ,       AGREEMENT_SOURCE_CODE
    ,       ORIG_SYSTEM_AGR_ID
    ,       INVOICE_TO_CUSTOMER_ID -- Added for bug#4029589
    FROM    OE_AGREEMENTS
    WHERE ( AGREEMENT_ID = p_agreement_id
    )
    ;
Line: 1708

        l_Agreement_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
Line: 1709

        l_Agreement_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
Line: 1710

        l_Agreement_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
Line: 1788

    OE_AGREEMENTS_PKG.UPDATE_ROW (
           	p_Agreement_rec.agreement_id
		 ,	p_Agreement_rec.tp_attribute2
		 ,	p_Agreement_rec.tp_attribute3
		 ,	p_Agreement_rec.tp_attribute4
		 ,	p_Agreement_rec.tp_attribute5
		 ,	p_Agreement_rec.tp_attribute6
		 ,	p_Agreement_rec.tp_attribute7
		 ,	p_Agreement_rec.tp_attribute8
		 ,	p_Agreement_rec.tp_attribute9
		 ,	p_Agreement_rec.tp_attribute10
		 ,	p_Agreement_rec.tp_attribute11
		 ,	p_Agreement_rec.tp_attribute12
		 ,	p_Agreement_rec.tp_attribute13
		 ,	p_Agreement_rec.tp_attribute14
		 ,	p_Agreement_rec.tp_attribute15
		 ,	p_Agreement_rec.tp_attribute_category
		 ,	p_Agreement_rec.agreement_type_code
		 ,	p_Agreement_rec.price_list_id
		 ,	p_Agreement_rec.term_id
		 ,	p_agreement_rec.override_irule_flag
		 ,	p_Agreement_rec.override_arule_flag
		 ,	p_Agreement_rec.signature_date
		 ,	p_Agreement_rec.agreement_num
		 ,	p_Agreement_rec.tp_attribute1
		 ,	p_Agreement_rec.attribute12
		 ,	p_Agreement_rec.attribute13
		 ,	p_Agreement_rec.attribute14
		 ,	p_Agreement_rec.attribute15
		 ,	p_Agreement_rec.attribute11
		 ,	p_Agreement_rec.attribute9
		 ,	p_Agreement_rec.attribute10
		 ,	p_Agreement_rec.revision
		 ,	p_Agreement_rec.revision_date
		 ,	p_Agreement_rec.revision_reason_code
		 ,	p_Agreement_rec.freight_terms_code
		 ,	p_Agreement_rec.ship_method_code
		 ,	p_Agreement_rec.invoicing_rule_id
		 ,	p_Agreement_rec.accounting_rule_id
		 ,	p_Agreement_rec.sold_to_org_id
		 ,	p_Agreement_rec.purchase_order_num
		 ,	p_Agreement_rec.invoice_contact_id
		 ,	p_Agreement_rec.agreement_contact_id
		 ,	p_Agreement_rec.invoice_to_org_id
		 ,	p_Agreement_rec.salesrep_id
		 ,	p_Agreement_rec.start_date_active
		 ,	p_Agreement_rec.end_date_active
		 ,	p_Agreement_rec.comments
		 ,	p_Agreement_rec.context
		 ,	p_Agreement_rec.attribute1
		 ,	p_Agreement_rec.attribute2
		 ,	p_Agreement_rec.attribute3
		 ,	p_Agreement_rec.attribute4
		 ,	p_Agreement_rec.attribute5
		 ,	p_Agreement_rec.attribute6
		 ,	p_Agreement_rec.attribute7
		 ,	p_Agreement_rec.attribute8
		 ,	p_Agreement_rec.name
		 ,	p_Agreement_rec.last_update_date
		 ,	p_Agreement_rec.last_updated_by
		 ,	p_Agreement_rec.last_update_login
		 ,	p_Agreement_rec.agreement_source_code --added by
		 ,	p_Agreement_rec.orig_system_agr_id --rchellam for OKC
		 ,	p_Agreement_rec.invoice_to_customer_id -- Added for bug#4029589
    );
Line: 1856

    SELECT  ACCOUNTING_RULE_ID
    ,       AGREEMENT_CONTACT_ID
    ,       AGREEMENT_ID
    ,       AGREEMENT_NUM
    ,       AGREEMENT_TYPE_CODE
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       sold_to_org_id
    ,       END_DATE_ACTIVE
    ,       FREIGHT_TERMS_CODE
    ,       INVOICE_CONTACT_ID
    ,       invoice_to_org_id
    ,       INVOICING_RULE_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       NAME
    ,       OVERRIDE_ARULE_FLAG
    ,       OVERRIDE_IRULE_FLAG
    ,       PRICE_LIST_ID
    ,       PURCHASE_ORDER_NUM
    ,       REVISION
    ,       REVISION_DATE
    ,       REVISION_REASON_CODE
    ,       SALESREP_ID
    ,       SHIP_METHOD_CODE
    ,       SIGNATURE_DATE
    ,       START_DATE_ACTIVE
    ,       TERM_ID
    INTO    l_Agreement_rec.accounting_rule_id
    ,       l_Agreement_rec.agreement_contact_id
    ,       l_Agreement_rec.agreement_id
    ,       l_Agreement_rec.agreement_num
    ,       l_Agreement_rec.agreement_type_code
    ,       l_Agreement_rec.attribute1
    ,       l_Agreement_rec.attribute10
    ,       l_Agreement_rec.attribute11
    ,       l_Agreement_rec.attribute12
    ,       l_Agreement_rec.attribute13
    ,       l_Agreement_rec.attribute14
    ,       l_Agreement_rec.attribute15
    ,       l_Agreement_rec.attribute2
    ,       l_Agreement_rec.attribute3
    ,       l_Agreement_rec.attribute4
    ,       l_Agreement_rec.attribute5
    ,       l_Agreement_rec.attribute6
    ,       l_Agreement_rec.attribute7
    ,       l_Agreement_rec.attribute8
    ,       l_Agreement_rec.attribute9
    ,       l_Agreement_rec.context
    ,       l_Agreement_rec.created_by
    ,       l_Agreement_rec.creation_date
    ,       l_Agreement_rec.sold_to_org_id
    ,       l_Agreement_rec.end_date_active
    ,       l_Agreement_rec.freight_terms_code
    ,       l_Agreement_rec.invoice_contact_id
    ,       l_Agreement_rec.invoice_to_org_id
    ,       l_Agreement_rec.invoicing_rule_id
    ,       l_Agreement_rec.last_updated_by
    ,       l_Agreement_rec.last_update_date
    ,       l_Agreement_rec.last_update_login
    ,       l_Agreement_rec.name
    ,       l_Agreement_rec.override_arule_flag
    ,       l_Agreement_rec.override_irule_flag
    ,       l_Agreement_rec.price_list_id
    ,       l_Agreement_rec.purchase_order_num
    ,       l_Agreement_rec.revision
    ,       l_Agreement_rec.revision_date
    ,       l_Agreement_rec.revision_reason_code
    ,       l_Agreement_rec.salesrep_id
    ,       l_Agreement_rec.ship_method_code
    ,       l_Agreement_rec.signature_date
    ,       l_Agreement_rec.start_date_active
    ,       l_Agreement_rec.term_id
    FROM    OE_AGREEMENTS
    WHERE   AGREEMENT_ID = p_Agreement_rec.agreement_id
        FOR UPDATE NOWAIT;
Line: 2097

    AND (   (l_Agreement_rec.last_updated_by =
             p_Agreement_rec.last_updated_by) OR
            ((p_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM) OR
            (   (l_Agreement_rec.last_updated_by IS NULL) AND
                (p_Agreement_rec.last_updated_by IS NULL))))
    AND (   (l_Agreement_rec.last_update_date =
             p_Agreement_rec.last_update_date) OR
            ((p_Agreement_rec.last_update_date = FND_API.G_MISS_DATE) OR
            (   (l_Agreement_rec.last_update_date IS NULL) AND
                (p_Agreement_rec.last_update_date IS NULL))))
    AND (   (l_Agreement_rec.last_update_login =
             p_Agreement_rec.last_update_login) OR
            ((p_Agreement_rec.last_update_login = FND_API.G_MISS_NUM) OR
            (   (l_Agreement_rec.last_update_login IS NULL) AND
                (p_Agreement_rec.last_update_login IS NULL))))
    AND (   (l_Agreement_rec.name =
             p_Agreement_rec.name) OR
            ((p_Agreement_rec.name = FND_API.G_MISS_CHAR) OR
            (   (l_Agreement_rec.name IS NULL) AND
                (p_Agreement_rec.name IS NULL))))
    AND (   (l_Agreement_rec.override_arule_flag =
             p_Agreement_rec.override_arule_flag) OR
            ((p_Agreement_rec.override_arule_flag = FND_API.G_MISS_CHAR) OR
            (   (l_Agreement_rec.override_arule_flag IS NULL) AND
                (p_Agreement_rec.override_arule_flag IS NULL))))
    AND (   (l_Agreement_rec.override_irule_flag =
             p_Agreement_rec.override_irule_flag) OR
            ((p_Agreement_rec.override_irule_flag = FND_API.G_MISS_CHAR) OR
            (   (l_Agreement_rec.override_irule_flag IS NULL) AND
                (p_Agreement_rec.override_irule_flag IS NULL))))
    AND (   (l_Agreement_rec.price_list_id =
             p_Agreement_rec.price_list_id) OR
            ((p_Agreement_rec.price_list_id = FND_API.G_MISS_NUM) OR
            (   (l_Agreement_rec.price_list_id IS NULL) AND
                (p_Agreement_rec.price_list_id IS NULL))))
    AND (   (l_Agreement_rec.purchase_order_num =
             p_Agreement_rec.purchase_order_num) OR
            ((p_Agreement_rec.purchase_order_num = FND_API.G_MISS_CHAR) OR
            (   (l_Agreement_rec.purchase_order_num IS NULL) AND
                (p_Agreement_rec.purchase_order_num IS NULL))))
    AND (   (l_Agreement_rec.revision =
             p_Agreement_rec.revision) OR
            ((p_Agreement_rec.revision = FND_API.G_MISS_CHAR) OR
            (   (l_Agreement_rec.revision IS NULL) AND
                (p_Agreement_rec.revision IS NULL))))
    AND (   (l_Agreement_rec.revision_date =
             p_Agreement_rec.revision_date) OR
            ((p_Agreement_rec.revision_date = FND_API.G_MISS_DATE) OR
            (   (l_Agreement_rec.revision_date IS NULL) AND
                (p_Agreement_rec.revision_date IS NULL))))
    AND (   (l_Agreement_rec.revision_reason_code =
             p_Agreement_rec.revision_reason_code) OR
            ((p_Agreement_rec.revision_reason_code = FND_API.G_MISS_CHAR) OR
            (   (l_Agreement_rec.revision_reason_code IS NULL) AND
                (p_Agreement_rec.revision_reason_code IS NULL))))
    AND (   (l_Agreement_rec.salesrep_id =
             p_Agreement_rec.salesrep_id) OR
            ((p_Agreement_rec.salesrep_id = FND_API.G_MISS_NUM) OR
            (   (l_Agreement_rec.salesrep_id IS NULL) AND
                (p_Agreement_rec.salesrep_id IS NULL))))
    AND (   (l_Agreement_rec.ship_method_code =
             p_Agreement_rec.ship_method_code) OR
            ((p_Agreement_rec.ship_method_code = FND_API.G_MISS_CHAR) OR
            (   (l_Agreement_rec.ship_method_code IS NULL) AND
                (p_Agreement_rec.ship_method_code IS NULL))))
    AND (   (l_Agreement_rec.signature_date =
             p_Agreement_rec.signature_date) OR
            ((p_Agreement_rec.signature_date = FND_API.G_MISS_DATE) OR
            (   (l_Agreement_rec.signature_date IS NULL) AND
                (p_Agreement_rec.signature_date IS NULL))))
    AND (   (l_Agreement_rec.start_date_active =
             p_Agreement_rec.start_date_active) OR
            ((p_Agreement_rec.start_date_active = FND_API.G_MISS_DATE) OR
            (   (l_Agreement_rec.start_date_active IS NULL) AND
                (p_Agreement_rec.start_date_active IS NULL))))
    AND (   (l_Agreement_rec.term_id =
             p_Agreement_rec.term_id) OR
            ((p_Agreement_rec.term_id = FND_API.G_MISS_NUM) OR
            (   (l_Agreement_rec.term_id IS NULL) AND
                (p_Agreement_rec.term_id IS NULL))))
    --Begin code added by rchellam for OKC
    AND (   (l_Agreement_rec.agreement_source_code =
             p_Agreement_rec.agreement_source_code) OR
            ((p_Agreement_rec.agreement_source_code = FND_API.G_MISS_CHAR) OR
            (   (l_Agreement_rec.agreement_source_code IS NULL) AND
                (p_Agreement_rec.agreement_source_code IS NULL))))
    AND (   (l_Agreement_rec.orig_system_agr_id =
             p_Agreement_rec.orig_system_agr_id) OR
            ((p_Agreement_rec.orig_system_agr_id = FND_API.G_MISS_NUM) OR
            (   (l_Agreement_rec.orig_system_agr_id IS NULL) AND
                (p_Agreement_rec.orig_system_agr_id IS NULL))))
    --End code added by rchellam for OKC
        -- Added for bug#4029589
    AND (   (l_Agreement_rec.invoice_to_customer_id =
             p_Agreement_rec.invoice_to_customer_id) OR
            ((p_Agreement_rec.invoice_to_customer_id = FND_API.G_MISS_NUM) OR
            (   (l_Agreement_rec.invoice_to_customer_id IS NULL) AND
                (p_Agreement_rec.invoice_to_customer_id IS NULL))))
    THEN

        --  Row has not changed. Set out parameter.

        x_Agreement_rec                := l_Agreement_rec;
Line: 2235

            FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');