208: x_pricing_contract_id := l_x_Contract_rec.pricing_contract_id;
209:
210: -- Load display out parameters if any
211:
212: l_Contract_val_rec := OE_Contract_Util.Get_Values
213: ( p_Contract_rec => l_x_Contract_rec
214: );
215: x_agreement := l_Contract_val_rec.agreement;
216: x_discount := l_Contract_val_rec.discount;
379: );
380:
381: l_old_Contract_rec := l_Contract_rec;
382:
383: IF p_attr_id = OE_Contract_Util.G_AGREEMENT THEN
384: l_Contract_rec.agreement_id := TO_NUMBER(p_attr_value);
385: ELSIF p_attr_id = OE_Contract_Util.G_DISCOUNT THEN
386: l_Contract_rec.discount_id := TO_NUMBER(p_attr_value);
387: ELSIF p_attr_id = OE_Contract_Util.G_LAST_UPDATED_BY THEN
381: l_old_Contract_rec := l_Contract_rec;
382:
383: IF p_attr_id = OE_Contract_Util.G_AGREEMENT THEN
384: l_Contract_rec.agreement_id := TO_NUMBER(p_attr_value);
385: ELSIF p_attr_id = OE_Contract_Util.G_DISCOUNT THEN
386: l_Contract_rec.discount_id := TO_NUMBER(p_attr_value);
387: ELSIF p_attr_id = OE_Contract_Util.G_LAST_UPDATED_BY THEN
388: l_Contract_rec.last_updated_by := TO_NUMBER(p_attr_value);
389: ELSIF p_attr_id = OE_Contract_Util.G_PRICE_LIST THEN
383: IF p_attr_id = OE_Contract_Util.G_AGREEMENT THEN
384: l_Contract_rec.agreement_id := TO_NUMBER(p_attr_value);
385: ELSIF p_attr_id = OE_Contract_Util.G_DISCOUNT THEN
386: l_Contract_rec.discount_id := TO_NUMBER(p_attr_value);
387: ELSIF p_attr_id = OE_Contract_Util.G_LAST_UPDATED_BY THEN
388: l_Contract_rec.last_updated_by := TO_NUMBER(p_attr_value);
389: ELSIF p_attr_id = OE_Contract_Util.G_PRICE_LIST THEN
390: l_Contract_rec.price_list_id := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = OE_Contract_Util.G_PRICING_CONTRACT THEN
385: ELSIF p_attr_id = OE_Contract_Util.G_DISCOUNT THEN
386: l_Contract_rec.discount_id := TO_NUMBER(p_attr_value);
387: ELSIF p_attr_id = OE_Contract_Util.G_LAST_UPDATED_BY THEN
388: l_Contract_rec.last_updated_by := TO_NUMBER(p_attr_value);
389: ELSIF p_attr_id = OE_Contract_Util.G_PRICE_LIST THEN
390: l_Contract_rec.price_list_id := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = OE_Contract_Util.G_PRICING_CONTRACT THEN
392: l_Contract_rec.pricing_contract_id := TO_NUMBER(p_attr_value);
393: ELSIF p_attr_id = OE_Contract_Util.G_ATTRIBUTE1
387: ELSIF p_attr_id = OE_Contract_Util.G_LAST_UPDATED_BY THEN
388: l_Contract_rec.last_updated_by := TO_NUMBER(p_attr_value);
389: ELSIF p_attr_id = OE_Contract_Util.G_PRICE_LIST THEN
390: l_Contract_rec.price_list_id := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = OE_Contract_Util.G_PRICING_CONTRACT THEN
392: l_Contract_rec.pricing_contract_id := TO_NUMBER(p_attr_value);
393: ELSIF p_attr_id = OE_Contract_Util.G_ATTRIBUTE1
394: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE10
395: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE11
389: ELSIF p_attr_id = OE_Contract_Util.G_PRICE_LIST THEN
390: l_Contract_rec.price_list_id := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = OE_Contract_Util.G_PRICING_CONTRACT THEN
392: l_Contract_rec.pricing_contract_id := TO_NUMBER(p_attr_value);
393: ELSIF p_attr_id = OE_Contract_Util.G_ATTRIBUTE1
394: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE10
395: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE11
396: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE12
397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13
390: l_Contract_rec.price_list_id := TO_NUMBER(p_attr_value);
391: ELSIF p_attr_id = OE_Contract_Util.G_PRICING_CONTRACT THEN
392: l_Contract_rec.pricing_contract_id := TO_NUMBER(p_attr_value);
393: ELSIF p_attr_id = OE_Contract_Util.G_ATTRIBUTE1
394: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE10
395: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE11
396: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE12
397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13
398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14
391: ELSIF p_attr_id = OE_Contract_Util.G_PRICING_CONTRACT THEN
392: l_Contract_rec.pricing_contract_id := TO_NUMBER(p_attr_value);
393: ELSIF p_attr_id = OE_Contract_Util.G_ATTRIBUTE1
394: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE10
395: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE11
396: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE12
397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13
398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14
399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15
392: l_Contract_rec.pricing_contract_id := TO_NUMBER(p_attr_value);
393: ELSIF p_attr_id = OE_Contract_Util.G_ATTRIBUTE1
394: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE10
395: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE11
396: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE12
397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13
398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14
399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15
400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2
393: ELSIF p_attr_id = OE_Contract_Util.G_ATTRIBUTE1
394: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE10
395: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE11
396: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE12
397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13
398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14
399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15
400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2
401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3
394: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE10
395: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE11
396: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE12
397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13
398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14
399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15
400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2
401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3
402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4
395: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE11
396: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE12
397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13
398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14
399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15
400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2
401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3
402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4
403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5
396: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE12
397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13
398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14
399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15
400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2
401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3
402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4
403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5
404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6
397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13
398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14
399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15
400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2
401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3
402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4
403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5
404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6
405: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE7
398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14
399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15
400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2
401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3
402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4
403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5
404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6
405: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE7
406: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE8
399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15
400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2
401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3
402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4
403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5
404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6
405: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE7
406: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE8
407: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE9
400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2
401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3
402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4
403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5
404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6
405: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE7
406: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE8
407: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE9
408: OR p_attr_id = OE_Contract_Util.G_CONTEXT
401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3
402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4
403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5
404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6
405: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE7
406: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE8
407: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE9
408: OR p_attr_id = OE_Contract_Util.G_CONTEXT
409: THEN
402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4
403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5
404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6
405: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE7
406: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE8
407: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE9
408: OR p_attr_id = OE_Contract_Util.G_CONTEXT
409: THEN
410:
403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5
404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6
405: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE7
406: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE8
407: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE9
408: OR p_attr_id = OE_Contract_Util.G_CONTEXT
409: THEN
410:
411: l_Contract_rec.attribute1 := p_attribute1;
404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6
405: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE7
406: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE8
407: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE9
408: OR p_attr_id = OE_Contract_Util.G_CONTEXT
409: THEN
410:
411: l_Contract_rec.attribute1 := p_attribute1;
412: l_Contract_rec.attribute10 := p_attribute10;
507: x_price_list := FND_API.G_MISS_CHAR;
508:
509: -- Load display out parameters if any
510:
511: l_Contract_val_rec := OE_Contract_Util.Get_Values
512: ( p_Contract_rec => l_x_Contract_rec
513: , p_old_Contract_rec => l_Contract_rec
514: );
515:
1460: THEN
1461:
1462: -- Query row from DB
1463:
1464: g_Contract_rec := OE_Contract_Util.Query_Row
1465: ( p_pricing_contract_id => p_pricing_contract_id
1466: );
1467:
1468: g_Contract_rec.db_flag := FND_API.G_TRUE;