DBA Data[Home] [Help]

APPS.OE_OE_FORM_CONTRACT dependencies on OE_CONTRACT_UTIL

Line 212: l_Contract_val_rec := OE_Contract_Util.Get_Values

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;

Line 383: IF p_attr_id = OE_Contract_Util.G_AGREEMENT THEN

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

Line 385: ELSIF p_attr_id = OE_Contract_Util.G_DISCOUNT 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

Line 387: ELSIF p_attr_id = OE_Contract_Util.G_LAST_UPDATED_BY 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

Line 389: ELSIF p_attr_id = OE_Contract_Util.G_PRICE_LIST 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

Line 391: ELSIF p_attr_id = OE_Contract_Util.G_PRICING_CONTRACT THEN

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

Line 393: ELSIF p_attr_id = OE_Contract_Util.G_ATTRIBUTE1

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

Line 394: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE10

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

Line 395: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE11

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

Line 396: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE12

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

Line 397: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE13

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

Line 398: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE14

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

Line 399: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE15

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

Line 400: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE2

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

Line 401: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE3

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

Line 402: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE4

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

Line 403: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE5

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

Line 404: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE6

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

Line 405: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE7

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

Line 406: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE8

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:

Line 407: OR p_attr_id = OE_Contract_Util.G_ATTRIBUTE9

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;

Line 408: OR p_attr_id = OE_Contract_Util.G_CONTEXT

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;

Line 511: l_Contract_val_rec := OE_Contract_Util.Get_Values

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:

Line 1464: g_Contract_rec := OE_Contract_Util.Query_Row

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;