The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_updated_by,p_old_Agreement_rec.last_updated_by)
THEN
NULL;
IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_date,p_old_Agreement_rec.last_update_date)
THEN
NULL;
IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_login,p_old_Agreement_rec.last_update_login)
THEN
NULL;
ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
NULL;
ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
NULL;
ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
NULL;
IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_updated_by,p_old_Agreement_rec.last_updated_by)
THEN
NULL;
IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_date,p_old_Agreement_rec.last_update_date)
THEN
NULL;
IF NOT OE_GLOBALS.Equal(p_Agreement_rec.last_update_login,p_old_Agreement_rec.last_update_login)
THEN
NULL;
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;
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;
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;
IF l_Agreement_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_Agreement_rec.last_updated_by := NULL;
IF l_Agreement_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_Agreement_rec.last_update_date := NULL;
IF l_Agreement_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_Agreement_rec.last_update_login := NULL;
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');
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
);
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
;
oe_debug_pub.add('Exiting OE_Agreement_Util.Update_Row');
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
)
IS
x_row_id VARCHAR2(240);
oe_debug_pub.add('Entering OE_Agreement_Util.Insert_Row');
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
);
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
);
oe_debug_pub.add('Entering OE_Agreement_Util.Insert_Row');
, 'Insert_Row'
);
END Insert_Row;
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;
SELECT list_line_id
FROM QP_LIST_LINES
WHERE LIST_HEADER_ID = p_Price_List_id;
oe_debug_pub.add('Entering OE_Agreement_Util.Delete_Row');
If (p_Agreement_Delete_Flag) Then
oe_debug_pub.add('p_Agreement_Delete_Flag :');
If (p_Agreement_Lines_Delete_Flag) Then
oe_debug_pub.add('p_Agreement_Lines_Delete_Flag :');
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;
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;
Deletes the Price List Header
oe_debug_pub.add(' OE_Agreement_Util: Deleting price list for the Agreement');
QP_Price_List_Util.Delete_Row( l_Price_List_id );
/* 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;
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;
OE_AGREEMENTS_PKG.DELETE_ROW( p_agreement_id );
oe_debug_pub.add('Did not delete agreement');
FND_MESSAGE.SET_NAME('QP','QP_AGREEMENT_DELETE');
oe_debug_pub.add('Exiting OE_Agreement_Util.Delete_Row');
, 'Delete_Row'
);
END Delete_Row;
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
)
;
l_Agreement_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
l_Agreement_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
l_Agreement_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
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
);
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;
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;
FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');