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.QP_QP_FORM_PRICE_LIST dependencies on QP_PRICE_LIST_UTIL

Line 241: l_PRICE_LIST_val_rec := QP_Price_List_Util.Get_Values

237: -- Load display out parameters if any
238: oe_debug_Pub.add('msg count 2 : ' || x_msg_count);
239: oe_debug_Pub.add('msg data 2 : ' || x_msg_data);
240:
241: l_PRICE_LIST_val_rec := QP_Price_List_Util.Get_Values
242: ( p_PRICE_LIST_rec => l_x_PRICE_LIST_rec
243: );
244: x_automatic := l_PRICE_LIST_val_rec.automatic;
245: x_currency := l_PRICE_LIST_val_rec.currency;

Line 452: IF p_attr_id = QP_Price_List_Util.G_AUTOMATIC THEN

448: );
449:
450: l_old_PRICE_LIST_rec := l_PRICE_LIST_rec;
451:
452: IF p_attr_id = QP_Price_List_Util.G_AUTOMATIC THEN
453: l_PRICE_LIST_rec.automatic_flag := p_attr_value;
454: ELSIF p_attr_id = QP_Price_List_Util.G_COMMENTS THEN
455: l_PRICE_LIST_rec.comments := p_attr_value;
456: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY THEN

Line 454: ELSIF p_attr_id = QP_Price_List_Util.G_COMMENTS THEN

450: l_old_PRICE_LIST_rec := l_PRICE_LIST_rec;
451:
452: IF p_attr_id = QP_Price_List_Util.G_AUTOMATIC THEN
453: l_PRICE_LIST_rec.automatic_flag := p_attr_value;
454: ELSIF p_attr_id = QP_Price_List_Util.G_COMMENTS THEN
455: l_PRICE_LIST_rec.comments := p_attr_value;
456: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY THEN
457: l_PRICE_LIST_rec.currency_code := p_attr_value;
458: ELSIF p_attr_id = QP_Price_List_Util.G_DISCOUNT_LINES THEN

Line 456: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY THEN

452: IF p_attr_id = QP_Price_List_Util.G_AUTOMATIC THEN
453: l_PRICE_LIST_rec.automatic_flag := p_attr_value;
454: ELSIF p_attr_id = QP_Price_List_Util.G_COMMENTS THEN
455: l_PRICE_LIST_rec.comments := p_attr_value;
456: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY THEN
457: l_PRICE_LIST_rec.currency_code := p_attr_value;
458: ELSIF p_attr_id = QP_Price_List_Util.G_DISCOUNT_LINES THEN
459: l_PRICE_LIST_rec.discount_lines_flag := p_attr_value;
460: ELSIF p_attr_id = QP_Price_List_Util.G_END_DATE_ACTIVE THEN

Line 458: ELSIF p_attr_id = QP_Price_List_Util.G_DISCOUNT_LINES THEN

454: ELSIF p_attr_id = QP_Price_List_Util.G_COMMENTS THEN
455: l_PRICE_LIST_rec.comments := p_attr_value;
456: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY THEN
457: l_PRICE_LIST_rec.currency_code := p_attr_value;
458: ELSIF p_attr_id = QP_Price_List_Util.G_DISCOUNT_LINES THEN
459: l_PRICE_LIST_rec.discount_lines_flag := p_attr_value;
460: ELSIF p_attr_id = QP_Price_List_Util.G_END_DATE_ACTIVE THEN
461: l_PRICE_LIST_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
462: ELSIF p_attr_id = QP_Price_List_Util.G_FREIGHT_TERMS THEN

Line 460: ELSIF p_attr_id = QP_Price_List_Util.G_END_DATE_ACTIVE THEN

456: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY THEN
457: l_PRICE_LIST_rec.currency_code := p_attr_value;
458: ELSIF p_attr_id = QP_Price_List_Util.G_DISCOUNT_LINES THEN
459: l_PRICE_LIST_rec.discount_lines_flag := p_attr_value;
460: ELSIF p_attr_id = QP_Price_List_Util.G_END_DATE_ACTIVE THEN
461: l_PRICE_LIST_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
462: ELSIF p_attr_id = QP_Price_List_Util.G_FREIGHT_TERMS THEN
463: l_PRICE_LIST_rec.freight_terms_code := p_attr_value;
464: ELSIF p_attr_id = QP_Price_List_Util.G_GSA_INDICATOR THEN

Line 462: ELSIF p_attr_id = QP_Price_List_Util.G_FREIGHT_TERMS THEN

458: ELSIF p_attr_id = QP_Price_List_Util.G_DISCOUNT_LINES THEN
459: l_PRICE_LIST_rec.discount_lines_flag := p_attr_value;
460: ELSIF p_attr_id = QP_Price_List_Util.G_END_DATE_ACTIVE THEN
461: l_PRICE_LIST_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
462: ELSIF p_attr_id = QP_Price_List_Util.G_FREIGHT_TERMS THEN
463: l_PRICE_LIST_rec.freight_terms_code := p_attr_value;
464: ELSIF p_attr_id = QP_Price_List_Util.G_GSA_INDICATOR THEN
465: l_PRICE_LIST_rec.gsa_indicator := p_attr_value;
466: ELSIF p_attr_id = QP_Price_List_Util.G_NAME THEN

Line 464: ELSIF p_attr_id = QP_Price_List_Util.G_GSA_INDICATOR THEN

460: ELSIF p_attr_id = QP_Price_List_Util.G_END_DATE_ACTIVE THEN
461: l_PRICE_LIST_rec.end_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
462: ELSIF p_attr_id = QP_Price_List_Util.G_FREIGHT_TERMS THEN
463: l_PRICE_LIST_rec.freight_terms_code := p_attr_value;
464: ELSIF p_attr_id = QP_Price_List_Util.G_GSA_INDICATOR THEN
465: l_PRICE_LIST_rec.gsa_indicator := p_attr_value;
466: ELSIF p_attr_id = QP_Price_List_Util.G_NAME THEN
467: l_PRICE_LIST_rec.name := p_attr_value;
468: ELSIF p_attr_id = QP_Price_List_Util.G_DESCRIPTION THEN

Line 466: ELSIF p_attr_id = QP_Price_List_Util.G_NAME THEN

462: ELSIF p_attr_id = QP_Price_List_Util.G_FREIGHT_TERMS THEN
463: l_PRICE_LIST_rec.freight_terms_code := p_attr_value;
464: ELSIF p_attr_id = QP_Price_List_Util.G_GSA_INDICATOR THEN
465: l_PRICE_LIST_rec.gsa_indicator := p_attr_value;
466: ELSIF p_attr_id = QP_Price_List_Util.G_NAME THEN
467: l_PRICE_LIST_rec.name := p_attr_value;
468: ELSIF p_attr_id = QP_Price_List_Util.G_DESCRIPTION THEN
469: l_PRICE_LIST_rec.description := p_attr_value;
470: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_HEADER THEN

Line 468: ELSIF p_attr_id = QP_Price_List_Util.G_DESCRIPTION THEN

464: ELSIF p_attr_id = QP_Price_List_Util.G_GSA_INDICATOR THEN
465: l_PRICE_LIST_rec.gsa_indicator := p_attr_value;
466: ELSIF p_attr_id = QP_Price_List_Util.G_NAME THEN
467: l_PRICE_LIST_rec.name := p_attr_value;
468: ELSIF p_attr_id = QP_Price_List_Util.G_DESCRIPTION THEN
469: l_PRICE_LIST_rec.description := p_attr_value;
470: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_HEADER THEN
471: l_PRICE_LIST_rec.list_header_id := TO_NUMBER(p_attr_value);
472: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_TYPE THEN

Line 470: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_HEADER THEN

466: ELSIF p_attr_id = QP_Price_List_Util.G_NAME THEN
467: l_PRICE_LIST_rec.name := p_attr_value;
468: ELSIF p_attr_id = QP_Price_List_Util.G_DESCRIPTION THEN
469: l_PRICE_LIST_rec.description := p_attr_value;
470: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_HEADER THEN
471: l_PRICE_LIST_rec.list_header_id := TO_NUMBER(p_attr_value);
472: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_TYPE THEN
473: l_PRICE_LIST_rec.list_type_code := p_attr_value;
474: ELSIF p_attr_id = QP_Price_List_Util.G_VERSION_NO THEN

Line 472: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_TYPE THEN

468: ELSIF p_attr_id = QP_Price_List_Util.G_DESCRIPTION THEN
469: l_PRICE_LIST_rec.description := p_attr_value;
470: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_HEADER THEN
471: l_PRICE_LIST_rec.list_header_id := TO_NUMBER(p_attr_value);
472: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_TYPE THEN
473: l_PRICE_LIST_rec.list_type_code := p_attr_value;
474: ELSIF p_attr_id = QP_Price_List_Util.G_VERSION_NO THEN
475: l_PRICE_LIST_rec.version_no := p_attr_value;
476: ELSIF p_attr_id = QP_Price_List_Util.G_PRORATE THEN

Line 474: ELSIF p_attr_id = QP_Price_List_Util.G_VERSION_NO THEN

470: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_HEADER THEN
471: l_PRICE_LIST_rec.list_header_id := TO_NUMBER(p_attr_value);
472: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_TYPE THEN
473: l_PRICE_LIST_rec.list_type_code := p_attr_value;
474: ELSIF p_attr_id = QP_Price_List_Util.G_VERSION_NO THEN
475: l_PRICE_LIST_rec.version_no := p_attr_value;
476: ELSIF p_attr_id = QP_Price_List_Util.G_PRORATE THEN
477: l_PRICE_LIST_rec.prorate_flag := p_attr_value;
478: ELSIF p_attr_id = QP_Price_List_Util.G_ROUNDING_FACTOR THEN

Line 476: ELSIF p_attr_id = QP_Price_List_Util.G_PRORATE THEN

472: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_TYPE THEN
473: l_PRICE_LIST_rec.list_type_code := p_attr_value;
474: ELSIF p_attr_id = QP_Price_List_Util.G_VERSION_NO THEN
475: l_PRICE_LIST_rec.version_no := p_attr_value;
476: ELSIF p_attr_id = QP_Price_List_Util.G_PRORATE THEN
477: l_PRICE_LIST_rec.prorate_flag := p_attr_value;
478: ELSIF p_attr_id = QP_Price_List_Util.G_ROUNDING_FACTOR THEN
479: l_PRICE_LIST_rec.rounding_factor := TO_NUMBER(p_attr_value);
480: ELSIF p_attr_id = QP_Price_List_Util.G_SHIP_METHOD THEN

Line 478: ELSIF p_attr_id = QP_Price_List_Util.G_ROUNDING_FACTOR THEN

474: ELSIF p_attr_id = QP_Price_List_Util.G_VERSION_NO THEN
475: l_PRICE_LIST_rec.version_no := p_attr_value;
476: ELSIF p_attr_id = QP_Price_List_Util.G_PRORATE THEN
477: l_PRICE_LIST_rec.prorate_flag := p_attr_value;
478: ELSIF p_attr_id = QP_Price_List_Util.G_ROUNDING_FACTOR THEN
479: l_PRICE_LIST_rec.rounding_factor := TO_NUMBER(p_attr_value);
480: ELSIF p_attr_id = QP_Price_List_Util.G_SHIP_METHOD THEN
481: l_PRICE_LIST_rec.ship_method_code := p_attr_value;
482: ELSIF p_attr_id = QP_Price_List_Util.G_START_DATE_ACTIVE THEN

Line 480: ELSIF p_attr_id = QP_Price_List_Util.G_SHIP_METHOD THEN

476: ELSIF p_attr_id = QP_Price_List_Util.G_PRORATE THEN
477: l_PRICE_LIST_rec.prorate_flag := p_attr_value;
478: ELSIF p_attr_id = QP_Price_List_Util.G_ROUNDING_FACTOR THEN
479: l_PRICE_LIST_rec.rounding_factor := TO_NUMBER(p_attr_value);
480: ELSIF p_attr_id = QP_Price_List_Util.G_SHIP_METHOD THEN
481: l_PRICE_LIST_rec.ship_method_code := p_attr_value;
482: ELSIF p_attr_id = QP_Price_List_Util.G_START_DATE_ACTIVE THEN
483: l_PRICE_LIST_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: ELSIF p_attr_id = QP_Price_List_Util.G_TERMS THEN

Line 482: ELSIF p_attr_id = QP_Price_List_Util.G_START_DATE_ACTIVE THEN

478: ELSIF p_attr_id = QP_Price_List_Util.G_ROUNDING_FACTOR THEN
479: l_PRICE_LIST_rec.rounding_factor := TO_NUMBER(p_attr_value);
480: ELSIF p_attr_id = QP_Price_List_Util.G_SHIP_METHOD THEN
481: l_PRICE_LIST_rec.ship_method_code := p_attr_value;
482: ELSIF p_attr_id = QP_Price_List_Util.G_START_DATE_ACTIVE THEN
483: l_PRICE_LIST_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: ELSIF p_attr_id = QP_Price_List_Util.G_TERMS THEN
485: l_PRICE_LIST_rec.terms_id := TO_NUMBER(p_attr_value);
486: --added active_flag

Line 484: ELSIF p_attr_id = QP_Price_List_Util.G_TERMS THEN

480: ELSIF p_attr_id = QP_Price_List_Util.G_SHIP_METHOD THEN
481: l_PRICE_LIST_rec.ship_method_code := p_attr_value;
482: ELSIF p_attr_id = QP_Price_List_Util.G_START_DATE_ACTIVE THEN
483: l_PRICE_LIST_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: ELSIF p_attr_id = QP_Price_List_Util.G_TERMS THEN
485: l_PRICE_LIST_rec.terms_id := TO_NUMBER(p_attr_value);
486: --added active_flag
487: ELSIF p_attr_id = QP_Price_List_Util.G_ACTIVE_FLAG THEN
488: l_PRICE_LIST_rec.active_flag := p_attr_value;

Line 487: ELSIF p_attr_id = QP_Price_List_Util.G_ACTIVE_FLAG THEN

483: l_PRICE_LIST_rec.start_date_active := TO_DATE(p_attr_value,'DD/MM/YYYY');
484: ELSIF p_attr_id = QP_Price_List_Util.G_TERMS THEN
485: l_PRICE_LIST_rec.terms_id := TO_NUMBER(p_attr_value);
486: --added active_flag
487: ELSIF p_attr_id = QP_Price_List_Util.G_ACTIVE_FLAG THEN
488: l_PRICE_LIST_rec.active_flag := p_attr_value;
489: --mkarya for bug 1944882 - added mobile download
490: ELSIF p_attr_id = QP_Price_List_Util.G_MOBILE_DOWNLOAD THEN
491: l_PRICE_LIST_rec.mobile_download := p_attr_value;

Line 490: ELSIF p_attr_id = QP_Price_List_Util.G_MOBILE_DOWNLOAD THEN

486: --added active_flag
487: ELSIF p_attr_id = QP_Price_List_Util.G_ACTIVE_FLAG THEN
488: l_PRICE_LIST_rec.active_flag := p_attr_value;
489: --mkarya for bug 1944882 - added mobile download
490: ELSIF p_attr_id = QP_Price_List_Util.G_MOBILE_DOWNLOAD THEN
491: l_PRICE_LIST_rec.mobile_download := p_attr_value;
492: --Multi-Currency SunilPandey
493: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY_HEADER THEN
494: l_PRICE_LIST_rec.CURRENCY_HEADER_ID := TO_NUMBER(p_attr_value);

Line 493: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY_HEADER THEN

489: --mkarya for bug 1944882 - added mobile download
490: ELSIF p_attr_id = QP_Price_List_Util.G_MOBILE_DOWNLOAD THEN
491: l_PRICE_LIST_rec.mobile_download := p_attr_value;
492: --Multi-Currency SunilPandey
493: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY_HEADER THEN
494: l_PRICE_LIST_rec.CURRENCY_HEADER_ID := TO_NUMBER(p_attr_value);
495: --Attribute Manager Giri
496: ELSIF p_attr_id = QP_Price_List_Util.G_PTE THEN
497: l_PRICE_LIST_rec.PTE_CODE := p_attr_value; --Blanket Agreement

Line 496: ELSIF p_attr_id = QP_Price_List_Util.G_PTE THEN

492: --Multi-Currency SunilPandey
493: ELSIF p_attr_id = QP_Price_List_Util.G_CURRENCY_HEADER THEN
494: l_PRICE_LIST_rec.CURRENCY_HEADER_ID := TO_NUMBER(p_attr_value);
495: --Attribute Manager Giri
496: ELSIF p_attr_id = QP_Price_List_Util.G_PTE THEN
497: l_PRICE_LIST_rec.PTE_CODE := p_attr_value; --Blanket Agreement
498: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_SOURCE THEN
499: l_PRICE_LIST_rec.list_source_code := p_attr_value;
500: ELSIF p_attr_id = QP_Price_List_Util.ORIG_SYSTEM_HEADER_REF THEN

Line 498: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_SOURCE THEN

494: l_PRICE_LIST_rec.CURRENCY_HEADER_ID := TO_NUMBER(p_attr_value);
495: --Attribute Manager Giri
496: ELSIF p_attr_id = QP_Price_List_Util.G_PTE THEN
497: l_PRICE_LIST_rec.PTE_CODE := p_attr_value; --Blanket Agreement
498: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_SOURCE THEN
499: l_PRICE_LIST_rec.list_source_code := p_attr_value;
500: ELSIF p_attr_id = QP_Price_List_Util.ORIG_SYSTEM_HEADER_REF THEN
501: l_PRICE_LIST_rec.orig_system_header_ref:= p_attr_value;
502: -- added global_flag for Pricing Security

Line 500: ELSIF p_attr_id = QP_Price_List_Util.ORIG_SYSTEM_HEADER_REF THEN

496: ELSIF p_attr_id = QP_Price_List_Util.G_PTE THEN
497: l_PRICE_LIST_rec.PTE_CODE := p_attr_value; --Blanket Agreement
498: ELSIF p_attr_id = QP_Price_List_Util.G_LIST_SOURCE THEN
499: l_PRICE_LIST_rec.list_source_code := p_attr_value;
500: ELSIF p_attr_id = QP_Price_List_Util.ORIG_SYSTEM_HEADER_REF THEN
501: l_PRICE_LIST_rec.orig_system_header_ref:= p_attr_value;
502: -- added global_flag for Pricing Security
503: ELSIF p_attr_id = QP_Price_List_Util.G_GLOBAL_FLAG THEN
504: l_PRICE_LIST_rec.global_flag:= p_attr_value;

Line 503: ELSIF p_attr_id = QP_Price_List_Util.G_GLOBAL_FLAG THEN

499: l_PRICE_LIST_rec.list_source_code := p_attr_value;
500: ELSIF p_attr_id = QP_Price_List_Util.ORIG_SYSTEM_HEADER_REF THEN
501: l_PRICE_LIST_rec.orig_system_header_ref:= p_attr_value;
502: -- added global_flag for Pricing Security
503: ELSIF p_attr_id = QP_Price_List_Util.G_GLOBAL_FLAG THEN
504: l_PRICE_LIST_rec.global_flag:= p_attr_value;
505: ELSIF p_attr_id = QP_Price_List_Util.G_SOURCE_SYSTEM_CODE THEN
506: l_PRICE_LIST_rec.source_system_code := p_attr_value;
507: ELSIF p_attr_id = QP_Price_List_Util.G_SHAREABLE_FLAG THEN

Line 505: ELSIF p_attr_id = QP_Price_List_Util.G_SOURCE_SYSTEM_CODE THEN

501: l_PRICE_LIST_rec.orig_system_header_ref:= p_attr_value;
502: -- added global_flag for Pricing Security
503: ELSIF p_attr_id = QP_Price_List_Util.G_GLOBAL_FLAG THEN
504: l_PRICE_LIST_rec.global_flag:= p_attr_value;
505: ELSIF p_attr_id = QP_Price_List_Util.G_SOURCE_SYSTEM_CODE THEN
506: l_PRICE_LIST_rec.source_system_code := p_attr_value;
507: ELSIF p_attr_id = QP_Price_List_Util.G_SHAREABLE_FLAG THEN
508: l_PRICE_LIST_rec.shareable_flag := p_attr_value;
509: ELSIF p_attr_id = QP_Price_List_Util.G_SOLD_TO_ORG_ID THEN

Line 507: ELSIF p_attr_id = QP_Price_List_Util.G_SHAREABLE_FLAG THEN

503: ELSIF p_attr_id = QP_Price_List_Util.G_GLOBAL_FLAG THEN
504: l_PRICE_LIST_rec.global_flag:= p_attr_value;
505: ELSIF p_attr_id = QP_Price_List_Util.G_SOURCE_SYSTEM_CODE THEN
506: l_PRICE_LIST_rec.source_system_code := p_attr_value;
507: ELSIF p_attr_id = QP_Price_List_Util.G_SHAREABLE_FLAG THEN
508: l_PRICE_LIST_rec.shareable_flag := p_attr_value;
509: ELSIF p_attr_id = QP_Price_List_Util.G_SOLD_TO_ORG_ID THEN
510: l_PRICE_LIST_rec.sold_to_org_id := p_attr_value;
511: ELSIF p_attr_id = QP_Price_List_Util.G_LOCKED_FROM_LIST_HEADER THEN

Line 509: ELSIF p_attr_id = QP_Price_List_Util.G_SOLD_TO_ORG_ID THEN

505: ELSIF p_attr_id = QP_Price_List_Util.G_SOURCE_SYSTEM_CODE THEN
506: l_PRICE_LIST_rec.source_system_code := p_attr_value;
507: ELSIF p_attr_id = QP_Price_List_Util.G_SHAREABLE_FLAG THEN
508: l_PRICE_LIST_rec.shareable_flag := p_attr_value;
509: ELSIF p_attr_id = QP_Price_List_Util.G_SOLD_TO_ORG_ID THEN
510: l_PRICE_LIST_rec.sold_to_org_id := p_attr_value;
511: ELSIF p_attr_id = QP_Price_List_Util.G_LOCKED_FROM_LIST_HEADER THEN
512: l_PRICE_LIST_rec.locked_from_list_header_id := TO_NUMBER(p_attr_value);
513: --added for MOAC

Line 511: ELSIF p_attr_id = QP_Price_List_Util.G_LOCKED_FROM_LIST_HEADER THEN

507: ELSIF p_attr_id = QP_Price_List_Util.G_SHAREABLE_FLAG THEN
508: l_PRICE_LIST_rec.shareable_flag := p_attr_value;
509: ELSIF p_attr_id = QP_Price_List_Util.G_SOLD_TO_ORG_ID THEN
510: l_PRICE_LIST_rec.sold_to_org_id := p_attr_value;
511: ELSIF p_attr_id = QP_Price_List_Util.G_LOCKED_FROM_LIST_HEADER THEN
512: l_PRICE_LIST_rec.locked_from_list_header_id := TO_NUMBER(p_attr_value);
513: --added for MOAC
514: ELSIF p_attr_id = QP_Price_List_Util.G_ORG_ID THEN
515: l_PRICE_LIST_rec.org_id := p_attr_value;

Line 514: ELSIF p_attr_id = QP_Price_List_Util.G_ORG_ID THEN

510: l_PRICE_LIST_rec.sold_to_org_id := p_attr_value;
511: ELSIF p_attr_id = QP_Price_List_Util.G_LOCKED_FROM_LIST_HEADER THEN
512: l_PRICE_LIST_rec.locked_from_list_header_id := TO_NUMBER(p_attr_value);
513: --added for MOAC
514: ELSIF p_attr_id = QP_Price_List_Util.G_ORG_ID THEN
515: l_PRICE_LIST_rec.org_id := p_attr_value;
516: ELSIF p_attr_id = QP_Price_List_Util.G_ATTRIBUTE1
517: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE10
518: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE11

Line 516: ELSIF p_attr_id = QP_Price_List_Util.G_ATTRIBUTE1

512: l_PRICE_LIST_rec.locked_from_list_header_id := TO_NUMBER(p_attr_value);
513: --added for MOAC
514: ELSIF p_attr_id = QP_Price_List_Util.G_ORG_ID THEN
515: l_PRICE_LIST_rec.org_id := p_attr_value;
516: ELSIF p_attr_id = QP_Price_List_Util.G_ATTRIBUTE1
517: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE10
518: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE11
519: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE12
520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13

Line 517: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE10

513: --added for MOAC
514: ELSIF p_attr_id = QP_Price_List_Util.G_ORG_ID THEN
515: l_PRICE_LIST_rec.org_id := p_attr_value;
516: ELSIF p_attr_id = QP_Price_List_Util.G_ATTRIBUTE1
517: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE10
518: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE11
519: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE12
520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13
521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14

Line 518: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE11

514: ELSIF p_attr_id = QP_Price_List_Util.G_ORG_ID THEN
515: l_PRICE_LIST_rec.org_id := p_attr_value;
516: ELSIF p_attr_id = QP_Price_List_Util.G_ATTRIBUTE1
517: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE10
518: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE11
519: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE12
520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13
521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14
522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15

Line 519: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE12

515: l_PRICE_LIST_rec.org_id := p_attr_value;
516: ELSIF p_attr_id = QP_Price_List_Util.G_ATTRIBUTE1
517: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE10
518: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE11
519: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE12
520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13
521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14
522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15
523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2

Line 520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13

516: ELSIF p_attr_id = QP_Price_List_Util.G_ATTRIBUTE1
517: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE10
518: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE11
519: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE12
520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13
521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14
522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15
523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2
524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3

Line 521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14

517: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE10
518: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE11
519: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE12
520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13
521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14
522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15
523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2
524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3
525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4

Line 522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15

518: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE11
519: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE12
520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13
521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14
522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15
523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2
524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3
525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4
526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5

Line 523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2

519: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE12
520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13
521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14
522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15
523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2
524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3
525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4
526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5
527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6

Line 524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3

520: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE13
521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14
522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15
523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2
524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3
525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4
526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5
527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6
528: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE7

Line 525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4

521: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE14
522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15
523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2
524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3
525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4
526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5
527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6
528: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE7
529: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE8

Line 526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5

522: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE15
523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2
524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3
525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4
526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5
527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6
528: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE7
529: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE8
530: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE9

Line 527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6

523: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE2
524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3
525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4
526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5
527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6
528: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE7
529: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE8
530: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE9
531: OR p_attr_id = QP_Price_List_Util.G_CONTEXT

Line 528: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE7

524: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE3
525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4
526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5
527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6
528: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE7
529: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE8
530: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE9
531: OR p_attr_id = QP_Price_List_Util.G_CONTEXT
532: THEN

Line 529: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE8

525: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE4
526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5
527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6
528: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE7
529: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE8
530: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE9
531: OR p_attr_id = QP_Price_List_Util.G_CONTEXT
532: THEN
533:

Line 530: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE9

526: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE5
527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6
528: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE7
529: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE8
530: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE9
531: OR p_attr_id = QP_Price_List_Util.G_CONTEXT
532: THEN
533:
534: l_PRICE_LIST_rec.attribute1 := p_attribute1;

Line 531: OR p_attr_id = QP_Price_List_Util.G_CONTEXT

527: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE6
528: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE7
529: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE8
530: OR p_attr_id = QP_Price_List_Util.G_ATTRIBUTE9
531: OR p_attr_id = QP_Price_List_Util.G_CONTEXT
532: THEN
533:
534: l_PRICE_LIST_rec.attribute1 := p_attribute1;
535: l_PRICE_LIST_rec.attribute10 := p_attribute10;

Line 663: l_PRICE_LIST_val_rec := QP_Price_List_Util.Get_Values

659: x_org_id := FND_API.G_MISS_NUM;
660:
661: -- Load display out parameters if any
662:
663: l_PRICE_LIST_val_rec := QP_Price_List_Util.Get_Values
664: ( p_PRICE_LIST_rec => l_x_PRICE_LIST_rec
665: , p_old_PRICE_LIST_rec => l_PRICE_LIST_rec
666: );
667:

Line 1785: g_PRICE_LIST_rec := QP_Price_List_Util.Query_Row

1781: THEN
1782:
1783: -- Query row from DB
1784:
1785: g_PRICE_LIST_rec := QP_Price_List_Util.Query_Row
1786: ( p_list_header_id => p_list_header_id
1787: );
1788:
1789: g_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;