eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_FORM_AGREEMENT dependencies on OE_AGREEMENT_UTIL

Line 241: l_Agreement_val_rec := OE_Agreement_Util.Get_Values

237: -- Added for bug#4029589
238:
239: -- Load display out parameters if any
240:
241: l_Agreement_val_rec := OE_Agreement_Util.Get_Values
242: ( p_Agreement_rec => l_x_Agreement_rec
243: );
244: x_accounting_rule := l_Agreement_val_rec.accounting_rule;
245: x_agreement_contact := l_Agreement_val_rec.agreement_contact;

Line 464: IF p_attr_id = OE_Agreement_Util.G_ACCOUNTING_RULE THEN

460: );
461:
462: l_old_Agreement_rec := l_Agreement_rec;
463:
464: IF p_attr_id = OE_Agreement_Util.G_ACCOUNTING_RULE THEN
465: l_Agreement_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
466: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_CONTACT THEN
467: l_Agreement_rec.agreement_contact_id := TO_NUMBER(p_attr_value);
468: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT THEN

Line 466: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_CONTACT THEN

462: l_old_Agreement_rec := l_Agreement_rec;
463:
464: IF p_attr_id = OE_Agreement_Util.G_ACCOUNTING_RULE THEN
465: l_Agreement_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
466: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_CONTACT THEN
467: l_Agreement_rec.agreement_contact_id := TO_NUMBER(p_attr_value);
468: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT THEN
469: l_Agreement_rec.agreement_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_NUM THEN

Line 468: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT THEN

464: IF p_attr_id = OE_Agreement_Util.G_ACCOUNTING_RULE THEN
465: l_Agreement_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
466: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_CONTACT THEN
467: l_Agreement_rec.agreement_contact_id := TO_NUMBER(p_attr_value);
468: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT THEN
469: l_Agreement_rec.agreement_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_NUM THEN
471: l_Agreement_rec.agreement_num := p_attr_value;
472: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_TYPE THEN

Line 470: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_NUM THEN

466: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_CONTACT THEN
467: l_Agreement_rec.agreement_contact_id := TO_NUMBER(p_attr_value);
468: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT THEN
469: l_Agreement_rec.agreement_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_NUM THEN
471: l_Agreement_rec.agreement_num := p_attr_value;
472: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_TYPE THEN
473: l_Agreement_rec.agreement_type_code := p_attr_value;
474: ELSIF p_attr_id = OE_Agreement_Util.G_CUSTOMER THEN

Line 472: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_TYPE THEN

468: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT THEN
469: l_Agreement_rec.agreement_id := TO_NUMBER(p_attr_value);
470: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_NUM THEN
471: l_Agreement_rec.agreement_num := p_attr_value;
472: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_TYPE THEN
473: l_Agreement_rec.agreement_type_code := p_attr_value;
474: ELSIF p_attr_id = OE_Agreement_Util.G_CUSTOMER THEN
475: /* l_Agreement_rec.customer_id := TO_NUMBER(p_attr_value); */
476: l_Agreement_rec.sold_to_org_id := TO_NUMBER(p_attr_value);

Line 474: ELSIF p_attr_id = OE_Agreement_Util.G_CUSTOMER THEN

470: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_NUM THEN
471: l_Agreement_rec.agreement_num := p_attr_value;
472: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_TYPE THEN
473: l_Agreement_rec.agreement_type_code := p_attr_value;
474: ELSIF p_attr_id = OE_Agreement_Util.G_CUSTOMER THEN
475: /* l_Agreement_rec.customer_id := TO_NUMBER(p_attr_value); */
476: l_Agreement_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
477: ELSIF p_attr_id = OE_Agreement_Util.G_END_DATE_ACTIVE THEN
478: l_Agreement_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');

Line 477: ELSIF p_attr_id = OE_Agreement_Util.G_END_DATE_ACTIVE THEN

473: l_Agreement_rec.agreement_type_code := p_attr_value;
474: ELSIF p_attr_id = OE_Agreement_Util.G_CUSTOMER THEN
475: /* l_Agreement_rec.customer_id := TO_NUMBER(p_attr_value); */
476: l_Agreement_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
477: ELSIF p_attr_id = OE_Agreement_Util.G_END_DATE_ACTIVE THEN
478: l_Agreement_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
479: ELSIF p_attr_id = OE_Agreement_Util.G_FREIGHT_TERMS THEN
480: l_Agreement_rec.freight_terms_code := p_attr_value;
481: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_CONTACT THEN

Line 479: ELSIF p_attr_id = OE_Agreement_Util.G_FREIGHT_TERMS THEN

475: /* l_Agreement_rec.customer_id := TO_NUMBER(p_attr_value); */
476: l_Agreement_rec.sold_to_org_id := TO_NUMBER(p_attr_value);
477: ELSIF p_attr_id = OE_Agreement_Util.G_END_DATE_ACTIVE THEN
478: l_Agreement_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
479: ELSIF p_attr_id = OE_Agreement_Util.G_FREIGHT_TERMS THEN
480: l_Agreement_rec.freight_terms_code := p_attr_value;
481: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_CONTACT THEN
482: l_Agreement_rec.invoice_contact_id := TO_NUMBER(p_attr_value);
483: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_SITE_USE THEN

Line 481: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_CONTACT THEN

477: ELSIF p_attr_id = OE_Agreement_Util.G_END_DATE_ACTIVE THEN
478: l_Agreement_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
479: ELSIF p_attr_id = OE_Agreement_Util.G_FREIGHT_TERMS THEN
480: l_Agreement_rec.freight_terms_code := p_attr_value;
481: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_CONTACT THEN
482: l_Agreement_rec.invoice_contact_id := TO_NUMBER(p_attr_value);
483: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_SITE_USE THEN
484: /* ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_ORG THEN */
485: /* l_Agreement_rec.invoice_to_site_use_id := TO_NUMBER(p_attr_value); */

Line 483: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_SITE_USE THEN

479: ELSIF p_attr_id = OE_Agreement_Util.G_FREIGHT_TERMS THEN
480: l_Agreement_rec.freight_terms_code := p_attr_value;
481: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_CONTACT THEN
482: l_Agreement_rec.invoice_contact_id := TO_NUMBER(p_attr_value);
483: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_SITE_USE THEN
484: /* ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_ORG THEN */
485: /* l_Agreement_rec.invoice_to_site_use_id := TO_NUMBER(p_attr_value); */
486: l_Agreement_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
487: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICING_RULE THEN

Line 484: /* ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_ORG THEN */

480: l_Agreement_rec.freight_terms_code := p_attr_value;
481: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_CONTACT THEN
482: l_Agreement_rec.invoice_contact_id := TO_NUMBER(p_attr_value);
483: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_SITE_USE THEN
484: /* ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_ORG THEN */
485: /* l_Agreement_rec.invoice_to_site_use_id := TO_NUMBER(p_attr_value); */
486: l_Agreement_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
487: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICING_RULE THEN
488: l_Agreement_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);

Line 487: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICING_RULE THEN

483: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_SITE_USE THEN
484: /* ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_ORG THEN */
485: /* l_Agreement_rec.invoice_to_site_use_id := TO_NUMBER(p_attr_value); */
486: l_Agreement_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
487: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICING_RULE THEN
488: l_Agreement_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
489: ELSIF p_attr_id = OE_Agreement_Util.G_NAME THEN
490: l_Agreement_rec.name := p_attr_value;
491: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_ARULE THEN

Line 489: ELSIF p_attr_id = OE_Agreement_Util.G_NAME THEN

485: /* l_Agreement_rec.invoice_to_site_use_id := TO_NUMBER(p_attr_value); */
486: l_Agreement_rec.invoice_to_org_id := TO_NUMBER(p_attr_value);
487: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICING_RULE THEN
488: l_Agreement_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
489: ELSIF p_attr_id = OE_Agreement_Util.G_NAME THEN
490: l_Agreement_rec.name := p_attr_value;
491: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_ARULE THEN
492: l_Agreement_rec.override_arule_flag := p_attr_value;
493: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_IRULE THEN

Line 491: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_ARULE THEN

487: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICING_RULE THEN
488: l_Agreement_rec.invoicing_rule_id := TO_NUMBER(p_attr_value);
489: ELSIF p_attr_id = OE_Agreement_Util.G_NAME THEN
490: l_Agreement_rec.name := p_attr_value;
491: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_ARULE THEN
492: l_Agreement_rec.override_arule_flag := p_attr_value;
493: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_IRULE THEN
494: l_Agreement_rec.override_irule_flag := p_attr_value;
495: ELSIF p_attr_id = OE_Agreement_Util.G_PRICE_LIST THEN

Line 493: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_IRULE THEN

489: ELSIF p_attr_id = OE_Agreement_Util.G_NAME THEN
490: l_Agreement_rec.name := p_attr_value;
491: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_ARULE THEN
492: l_Agreement_rec.override_arule_flag := p_attr_value;
493: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_IRULE THEN
494: l_Agreement_rec.override_irule_flag := p_attr_value;
495: ELSIF p_attr_id = OE_Agreement_Util.G_PRICE_LIST THEN
496: l_Agreement_rec.price_list_id := TO_NUMBER(p_attr_value);
497: ELSIF p_attr_id = OE_Agreement_Util.G_PURCHASE_ORDER_NUM THEN

Line 495: ELSIF p_attr_id = OE_Agreement_Util.G_PRICE_LIST THEN

491: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_ARULE THEN
492: l_Agreement_rec.override_arule_flag := p_attr_value;
493: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_IRULE THEN
494: l_Agreement_rec.override_irule_flag := p_attr_value;
495: ELSIF p_attr_id = OE_Agreement_Util.G_PRICE_LIST THEN
496: l_Agreement_rec.price_list_id := TO_NUMBER(p_attr_value);
497: ELSIF p_attr_id = OE_Agreement_Util.G_PURCHASE_ORDER_NUM THEN
498: l_Agreement_rec.purchase_order_num := p_attr_value;
499: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION THEN

Line 497: ELSIF p_attr_id = OE_Agreement_Util.G_PURCHASE_ORDER_NUM THEN

493: ELSIF p_attr_id = OE_Agreement_Util.G_OVERRIDE_IRULE THEN
494: l_Agreement_rec.override_irule_flag := p_attr_value;
495: ELSIF p_attr_id = OE_Agreement_Util.G_PRICE_LIST THEN
496: l_Agreement_rec.price_list_id := TO_NUMBER(p_attr_value);
497: ELSIF p_attr_id = OE_Agreement_Util.G_PURCHASE_ORDER_NUM THEN
498: l_Agreement_rec.purchase_order_num := p_attr_value;
499: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION THEN
500: l_Agreement_rec.revision := p_attr_value;
501: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_DATE THEN

Line 499: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION THEN

495: ELSIF p_attr_id = OE_Agreement_Util.G_PRICE_LIST THEN
496: l_Agreement_rec.price_list_id := TO_NUMBER(p_attr_value);
497: ELSIF p_attr_id = OE_Agreement_Util.G_PURCHASE_ORDER_NUM THEN
498: l_Agreement_rec.purchase_order_num := p_attr_value;
499: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION THEN
500: l_Agreement_rec.revision := p_attr_value;
501: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_DATE THEN
502: l_Agreement_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
503: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_REASON THEN

Line 501: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_DATE THEN

497: ELSIF p_attr_id = OE_Agreement_Util.G_PURCHASE_ORDER_NUM THEN
498: l_Agreement_rec.purchase_order_num := p_attr_value;
499: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION THEN
500: l_Agreement_rec.revision := p_attr_value;
501: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_DATE THEN
502: l_Agreement_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
503: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_REASON THEN
504: l_Agreement_rec.revision_reason_code := p_attr_value;
505: ELSIF p_attr_id = OE_Agreement_Util.G_SALESREP THEN

Line 503: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_REASON THEN

499: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION THEN
500: l_Agreement_rec.revision := p_attr_value;
501: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_DATE THEN
502: l_Agreement_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
503: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_REASON THEN
504: l_Agreement_rec.revision_reason_code := p_attr_value;
505: ELSIF p_attr_id = OE_Agreement_Util.G_SALESREP THEN
506: l_Agreement_rec.salesrep_id := TO_NUMBER(p_attr_value);
507: ELSIF p_attr_id = OE_Agreement_Util.G_SHIP_METHOD THEN

Line 505: ELSIF p_attr_id = OE_Agreement_Util.G_SALESREP THEN

501: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_DATE THEN
502: l_Agreement_rec.revision_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
503: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_REASON THEN
504: l_Agreement_rec.revision_reason_code := p_attr_value;
505: ELSIF p_attr_id = OE_Agreement_Util.G_SALESREP THEN
506: l_Agreement_rec.salesrep_id := TO_NUMBER(p_attr_value);
507: ELSIF p_attr_id = OE_Agreement_Util.G_SHIP_METHOD THEN
508: l_Agreement_rec.ship_method_code := p_attr_value;
509: ELSIF p_attr_id = OE_Agreement_Util.G_SIGNATURE_DATE THEN

Line 507: ELSIF p_attr_id = OE_Agreement_Util.G_SHIP_METHOD THEN

503: ELSIF p_attr_id = OE_Agreement_Util.G_REVISION_REASON THEN
504: l_Agreement_rec.revision_reason_code := p_attr_value;
505: ELSIF p_attr_id = OE_Agreement_Util.G_SALESREP THEN
506: l_Agreement_rec.salesrep_id := TO_NUMBER(p_attr_value);
507: ELSIF p_attr_id = OE_Agreement_Util.G_SHIP_METHOD THEN
508: l_Agreement_rec.ship_method_code := p_attr_value;
509: ELSIF p_attr_id = OE_Agreement_Util.G_SIGNATURE_DATE THEN
510: l_Agreement_rec.signature_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
511: ELSIF p_attr_id = OE_Agreement_Util.G_START_DATE_ACTIVE THEN

Line 509: ELSIF p_attr_id = OE_Agreement_Util.G_SIGNATURE_DATE THEN

505: ELSIF p_attr_id = OE_Agreement_Util.G_SALESREP THEN
506: l_Agreement_rec.salesrep_id := TO_NUMBER(p_attr_value);
507: ELSIF p_attr_id = OE_Agreement_Util.G_SHIP_METHOD THEN
508: l_Agreement_rec.ship_method_code := p_attr_value;
509: ELSIF p_attr_id = OE_Agreement_Util.G_SIGNATURE_DATE THEN
510: l_Agreement_rec.signature_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
511: ELSIF p_attr_id = OE_Agreement_Util.G_START_DATE_ACTIVE THEN
512: l_Agreement_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
513: ELSIF p_attr_id = OE_Agreement_Util.G_TERM THEN

Line 511: ELSIF p_attr_id = OE_Agreement_Util.G_START_DATE_ACTIVE THEN

507: ELSIF p_attr_id = OE_Agreement_Util.G_SHIP_METHOD THEN
508: l_Agreement_rec.ship_method_code := p_attr_value;
509: ELSIF p_attr_id = OE_Agreement_Util.G_SIGNATURE_DATE THEN
510: l_Agreement_rec.signature_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
511: ELSIF p_attr_id = OE_Agreement_Util.G_START_DATE_ACTIVE THEN
512: l_Agreement_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
513: ELSIF p_attr_id = OE_Agreement_Util.G_TERM THEN
514: l_Agreement_rec.term_id := TO_NUMBER(p_attr_value);
515: --Begin code added by rchellam for OKC

Line 513: ELSIF p_attr_id = OE_Agreement_Util.G_TERM THEN

509: ELSIF p_attr_id = OE_Agreement_Util.G_SIGNATURE_DATE THEN
510: l_Agreement_rec.signature_date := TO_DATE(p_attr_value,'DD/MM/YYYY');
511: ELSIF p_attr_id = OE_Agreement_Util.G_START_DATE_ACTIVE THEN
512: l_Agreement_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
513: ELSIF p_attr_id = OE_Agreement_Util.G_TERM THEN
514: l_Agreement_rec.term_id := TO_NUMBER(p_attr_value);
515: --Begin code added by rchellam for OKC
516: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_SOURCE THEN
517: l_Agreement_rec.agreement_source_code := p_attr_value;

Line 516: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_SOURCE THEN

512: l_Agreement_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
513: ELSIF p_attr_id = OE_Agreement_Util.G_TERM THEN
514: l_Agreement_rec.term_id := TO_NUMBER(p_attr_value);
515: --Begin code added by rchellam for OKC
516: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_SOURCE THEN
517: l_Agreement_rec.agreement_source_code := p_attr_value;
518: ELSIF p_attr_id = OE_Agreement_Util.G_ORIG_SYSTEM_AGR THEN
519: l_Agreement_rec.orig_system_agr_id := TO_NUMBER(p_attr_value);
520: --End code added by rchellam for OKC

Line 518: ELSIF p_attr_id = OE_Agreement_Util.G_ORIG_SYSTEM_AGR THEN

514: l_Agreement_rec.term_id := TO_NUMBER(p_attr_value);
515: --Begin code added by rchellam for OKC
516: ELSIF p_attr_id = OE_Agreement_Util.G_AGREEMENT_SOURCE THEN
517: l_Agreement_rec.agreement_source_code := p_attr_value;
518: ELSIF p_attr_id = OE_Agreement_Util.G_ORIG_SYSTEM_AGR THEN
519: l_Agreement_rec.orig_system_agr_id := TO_NUMBER(p_attr_value);
520: --End code added by rchellam for OKC
521: -- Added for bug#4029589
522: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_CUSTOMER_ID THEN

Line 522: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_CUSTOMER_ID THEN

518: ELSIF p_attr_id = OE_Agreement_Util.G_ORIG_SYSTEM_AGR THEN
519: l_Agreement_rec.orig_system_agr_id := TO_NUMBER(p_attr_value);
520: --End code added by rchellam for OKC
521: -- Added for bug#4029589
522: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_CUSTOMER_ID THEN
523: l_Agreement_rec.invoice_to_customer_id := TO_NUMBER(p_attr_value);
524: ELSIF p_attr_id = OE_Agreement_Util.G_ATTRIBUTE1
525: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE10
526: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE11

Line 524: ELSIF p_attr_id = OE_Agreement_Util.G_ATTRIBUTE1

520: --End code added by rchellam for OKC
521: -- Added for bug#4029589
522: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_CUSTOMER_ID THEN
523: l_Agreement_rec.invoice_to_customer_id := TO_NUMBER(p_attr_value);
524: ELSIF p_attr_id = OE_Agreement_Util.G_ATTRIBUTE1
525: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE10
526: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE11
527: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE12
528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13

Line 525: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE10

521: -- Added for bug#4029589
522: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_CUSTOMER_ID THEN
523: l_Agreement_rec.invoice_to_customer_id := TO_NUMBER(p_attr_value);
524: ELSIF p_attr_id = OE_Agreement_Util.G_ATTRIBUTE1
525: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE10
526: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE11
527: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE12
528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13
529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14

Line 526: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE11

522: ELSIF p_attr_id = OE_Agreement_Util.G_INVOICE_TO_CUSTOMER_ID THEN
523: l_Agreement_rec.invoice_to_customer_id := TO_NUMBER(p_attr_value);
524: ELSIF p_attr_id = OE_Agreement_Util.G_ATTRIBUTE1
525: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE10
526: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE11
527: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE12
528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13
529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14
530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15

Line 527: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE12

523: l_Agreement_rec.invoice_to_customer_id := TO_NUMBER(p_attr_value);
524: ELSIF p_attr_id = OE_Agreement_Util.G_ATTRIBUTE1
525: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE10
526: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE11
527: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE12
528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13
529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14
530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15
531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2

Line 528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13

524: ELSIF p_attr_id = OE_Agreement_Util.G_ATTRIBUTE1
525: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE10
526: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE11
527: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE12
528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13
529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14
530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15
531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2
532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3

Line 529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14

525: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE10
526: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE11
527: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE12
528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13
529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14
530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15
531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2
532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3
533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4

Line 530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15

526: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE11
527: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE12
528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13
529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14
530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15
531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2
532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3
533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4
534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5

Line 531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2

527: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE12
528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13
529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14
530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15
531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2
532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3
533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4
534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5
535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6

Line 532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3

528: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE13
529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14
530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15
531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2
532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3
533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4
534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5
535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6
536: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE7

Line 533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4

529: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE14
530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15
531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2
532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3
533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4
534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5
535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6
536: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE7
537: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE8

Line 534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5

530: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE15
531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2
532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3
533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4
534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5
535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6
536: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE7
537: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE8
538: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE9

Line 535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6

531: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE2
532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3
533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4
534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5
535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6
536: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE7
537: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE8
538: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE9
539: OR p_attr_id = OE_Agreement_Util.G_CONTEXT

Line 536: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE7

532: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE3
533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4
534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5
535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6
536: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE7
537: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE8
538: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE9
539: OR p_attr_id = OE_Agreement_Util.G_CONTEXT
540: THEN

Line 537: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE8

533: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE4
534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5
535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6
536: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE7
537: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE8
538: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE9
539: OR p_attr_id = OE_Agreement_Util.G_CONTEXT
540: THEN
541:

Line 538: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE9

534: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE5
535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6
536: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE7
537: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE8
538: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE9
539: OR p_attr_id = OE_Agreement_Util.G_CONTEXT
540: THEN
541:
542: l_Agreement_rec.attribute1 := p_attribute1;

Line 539: OR p_attr_id = OE_Agreement_Util.G_CONTEXT

535: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE6
536: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE7
537: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE8
538: OR p_attr_id = OE_Agreement_Util.G_ATTRIBUTE9
539: OR p_attr_id = OE_Agreement_Util.G_CONTEXT
540: THEN
541:
542: l_Agreement_rec.attribute1 := p_attribute1;
543: l_Agreement_rec.attribute10 := p_attribute10;

Line 683: l_Agreement_val_rec := OE_Agreement_Util.Get_Values

679: -- Added for bug#4029589
680:
681: -- Load display out parameters if any
682:
683: l_Agreement_val_rec := OE_Agreement_Util.Get_Values
684: ( p_Agreement_rec => l_x_Agreement_rec
685: , p_old_Agreement_rec => l_Agreement_rec
686: );
687:

Line 991: If p_attr_id = OE_Agreement_Util.G_NAME

987:
988:
989: /* Added following code to raise warning message for Bug-2106110 */
990:
991: If p_attr_id = OE_Agreement_Util.G_NAME
992: AND l_old_Agreement_rec.name is not NULL Then
993: If l_old_Agreement_rec.name <> p_attr_value Then
994: FND_MESSAGE.SET_NAME('QP','QP_AGR_NAME_CHG');
995: OE_MSG_PUB.Add;

Line 1767: g_Agreement_rec := OE_Agreement_Util.Query_Row

1763: THEN
1764:
1765: -- Query row from DB
1766:
1767: g_Agreement_rec := OE_Agreement_Util.Query_Row
1768: ( p_agreement_id => p_agreement_id
1769: );
1770:
1771: g_Agreement_rec.db_flag := FND_API.G_TRUE;