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_INT_LOADER_PUB dependencies on FND_API

Line 415: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;

411:
412: END IF;
413:
414: IF (l_operation = 'C') AND (l_list_type_code = 'PRL') THEN
415: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;
416: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
417:
418: IF (gpr_price_list_rec.automatic_flag IS NULL) THEN
419: gpr_price_list_rec.automatic_flag:= 'Y';

Line 423: gpr_modifier_list_rec.list_header_id := FND_API.G_MISS_NUM;

419: gpr_price_list_rec.automatic_flag:= 'Y';
420: END IF;
421:
422: ELSIF (l_operation = 'C') AND (l_list_type_code = 'SLT') THEN
423: gpr_modifier_list_rec.list_header_id := FND_API.G_MISS_NUM;
424: gpr_modifier_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
425:
426: IF (gpr_modifier_list_rec.automatic_flag IS NULL) THEN
427: gpr_modifier_list_rec.automatic_flag:= 'Y';

Line 456: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;

452: gpr_qualifiers_val_tbl(i).qualifier_attr_value_desc,
453: gpr_qualifiers_tbl(i).qualifier_grouping_no;
454: EXIT WHEN l_qualifiers%NOTFOUND;
455:
456: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;
457: gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
458:
459: IF (l_operation = 'C') THEN
460:

Line 457: gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;

453: gpr_qualifiers_tbl(i).qualifier_grouping_no;
454: EXIT WHEN l_qualifiers%NOTFOUND;
455:
456: gpr_qualifiers_tbl(i).qualifier_attribute := FND_API.G_MISS_CHAR;
457: gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
458:
459: IF (l_operation = 'C') THEN
460:
461: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;

Line 461: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;

457: gpr_qualifiers_tbl(i).qualifier_attr_value := FND_API.G_MISS_CHAR;
458:
459: IF (l_operation = 'C') THEN
460:
461: gpr_qualifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
462: gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
463:
464: IF (gpr_qualifiers_tbl(i).excluder_flag IS NULL) THEN
465: IF (l_list_type_code = 'PRL') THEN

Line 466: gpr_qualifiers_tbl(i).excluder_flag:= FND_API.G_MISS_CHAR;

462: gpr_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
463:
464: IF (gpr_qualifiers_tbl(i).excluder_flag IS NULL) THEN
465: IF (l_list_type_code = 'PRL') THEN
466: gpr_qualifiers_tbl(i).excluder_flag:= FND_API.G_MISS_CHAR;
467: ELSIF (l_list_type_code = 'SLT') THEN
468: gpr_qualifiers_tbl(i).excluder_flag:= 'N';
469: END IF;
470: END IF;

Line 473: gpr_qualifiers_tbl(i).qualifier_grouping_no:= FND_API.G_MISS_NUM;

469: END IF;
470: END IF;
471:
472: IF (gpr_qualifiers_tbl(i).qualifier_grouping_no IS NULL) THEN
473: gpr_qualifiers_tbl(i).qualifier_grouping_no:= FND_API.G_MISS_NUM;
474: END IF;
475:
476: /*
477: -- region to id conversion

Line 544: gpr_price_list_line_tbl(i).list_header_id := FND_API.G_MISS_NUM;

540: gpr_price_list_line_tbl(i).price_break_header_index;
541: EXIT WHEN l_lines%NOTFOUND;
542:
543: IF (l_operation = 'C') THEN
544: gpr_price_list_line_tbl(i).list_header_id := FND_API.G_MISS_NUM;
545: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
546: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
547: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
548: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;

Line 545: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;

541: EXIT WHEN l_lines%NOTFOUND;
542:
543: IF (l_operation = 'C') THEN
544: gpr_price_list_line_tbl(i).list_header_id := FND_API.G_MISS_NUM;
545: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
546: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
547: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
548: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
549: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;

Line 546: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;

542:
543: IF (l_operation = 'C') THEN
544: gpr_price_list_line_tbl(i).list_header_id := FND_API.G_MISS_NUM;
545: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
546: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
547: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
548: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
549: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
550: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

Line 547: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;

543: IF (l_operation = 'C') THEN
544: gpr_price_list_line_tbl(i).list_header_id := FND_API.G_MISS_NUM;
545: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
546: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
547: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
548: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
549: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
550: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
551:

Line 548: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;

544: gpr_price_list_line_tbl(i).list_header_id := FND_API.G_MISS_NUM;
545: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
546: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
547: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
548: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
549: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
550: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
551:
552: IF (gpr_price_list_line_tbl(i).automatic_flag IS NULL) THEN

Line 549: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;

545: gpr_price_list_line_tbl(i).list_line_id := FND_API.G_MISS_NUM;
546: gpr_price_list_line_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
547: gpr_price_list_line_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
548: gpr_price_list_line_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
549: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
550: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
551:
552: IF (gpr_price_list_line_tbl(i).automatic_flag IS NULL) THEN
553: gpr_price_list_line_tbl(i).automatic_flag := FND_API.G_MISS_CHAR;

Line 553: gpr_price_list_line_tbl(i).automatic_flag := FND_API.G_MISS_CHAR;

549: gpr_price_list_line_tbl(i).rltd_modifier_group_no := FND_API.G_MISS_NUM;
550: gpr_price_list_line_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
551:
552: IF (gpr_price_list_line_tbl(i).automatic_flag IS NULL) THEN
553: gpr_price_list_line_tbl(i).automatic_flag := FND_API.G_MISS_CHAR;
554: END IF;
555:
556: IF (gpr_price_list_line_tbl(i).modifier_level_code IS NULL) THEN
557: gpr_price_list_line_tbl(i).modifier_level_code := FND_API.G_MISS_CHAR;

Line 557: gpr_price_list_line_tbl(i).modifier_level_code := FND_API.G_MISS_CHAR;

553: gpr_price_list_line_tbl(i).automatic_flag := FND_API.G_MISS_CHAR;
554: END IF;
555:
556: IF (gpr_price_list_line_tbl(i).modifier_level_code IS NULL) THEN
557: gpr_price_list_line_tbl(i).modifier_level_code := FND_API.G_MISS_CHAR;
558: END IF;
559: END IF;
560:
561: -- dbms_output.put_line('*** List Line ***');

Line 608: gpr_modifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;

604: gpr_modifiers_tbl(i).modifier_parent_index;
605: EXIT WHEN l_mod_lines%NOTFOUND;
606:
607: IF (l_operation = 'C') THEN
608: gpr_modifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
609: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
610: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
611: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
612: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;

Line 609: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;

605: EXIT WHEN l_mod_lines%NOTFOUND;
606:
607: IF (l_operation = 'C') THEN
608: gpr_modifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
609: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
610: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
611: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
612: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
613: gpr_modifiers_tbl(i).rltd_modifier_grp_no := FND_API.G_MISS_NUM;

Line 610: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;

606:
607: IF (l_operation = 'C') THEN
608: gpr_modifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
609: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
610: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
611: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
612: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
613: gpr_modifiers_tbl(i).rltd_modifier_grp_no := FND_API.G_MISS_NUM;
614: gpr_modifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

Line 611: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;

607: IF (l_operation = 'C') THEN
608: gpr_modifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
609: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
610: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
611: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
612: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
613: gpr_modifiers_tbl(i).rltd_modifier_grp_no := FND_API.G_MISS_NUM;
614: gpr_modifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
615:

Line 612: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;

608: gpr_modifiers_tbl(i).list_header_id := FND_API.G_MISS_NUM;
609: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
610: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
611: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
612: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
613: gpr_modifiers_tbl(i).rltd_modifier_grp_no := FND_API.G_MISS_NUM;
614: gpr_modifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
615:
616: IF (gpr_modifiers_tbl(i).automatic_flag IS NULL) THEN

Line 613: gpr_modifiers_tbl(i).rltd_modifier_grp_no := FND_API.G_MISS_NUM;

609: gpr_modifiers_tbl(i).list_line_id := FND_API.G_MISS_NUM;
610: gpr_modifiers_tbl(i).rltd_modifier_id := FND_API.G_MISS_NUM;
611: gpr_modifiers_tbl(i).from_rltd_modifier_id := FND_API.G_MISS_NUM;
612: gpr_modifiers_tbl(i).to_rltd_modifier_id := FND_API.G_MISS_NUM;
613: gpr_modifiers_tbl(i).rltd_modifier_grp_no := FND_API.G_MISS_NUM;
614: gpr_modifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
615:
616: IF (gpr_modifiers_tbl(i).automatic_flag IS NULL) THEN
617: gpr_modifiers_tbl(i).automatic_flag := 'Y';

Line 631: gpr_modifiers_tbl(i).modifier_level_code := FND_API.G_MISS_CHAR;

627: gpr_modifiers_tbl(i).pricing_phase_id := 2;
628: END IF;
629:
630: IF (gpr_modifiers_tbl(i).modifier_level_code IS NULL) THEN
631: gpr_modifiers_tbl(i).modifier_level_code := FND_API.G_MISS_CHAR;
632: END IF;
633:
634: IF (gpr_modifiers_tbl(i).pricing_group_sequence IS NULL) THEN
635: gpr_modifiers_tbl(i).pricing_group_sequence := FND_API.G_MISS_NUM;

Line 635: gpr_modifiers_tbl(i).pricing_group_sequence := FND_API.G_MISS_NUM;

631: gpr_modifiers_tbl(i).modifier_level_code := FND_API.G_MISS_CHAR;
632: END IF;
633:
634: IF (gpr_modifiers_tbl(i).pricing_group_sequence IS NULL) THEN
635: gpr_modifiers_tbl(i).pricing_group_sequence := FND_API.G_MISS_NUM;
636: END IF;
637:
638: -- add this 4/20/2001
639: IF (gpr_modifiers_tbl(i).product_precedence IS NULL) THEN

Line 696: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;

692: gpr_pricing_attr_tbl(i).comparison_operator_code,
693: gpr_pricing_attr_tbl(i).price_list_line_index;
694: EXIT WHEN l_pricing_attribs%NOTFOUND;
695:
696: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
697: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
698: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
699:
700: IF (l_operation = 'C') THEN

Line 697: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;

693: gpr_pricing_attr_tbl(i).price_list_line_index;
694: EXIT WHEN l_pricing_attribs%NOTFOUND;
695:
696: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
697: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
698: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
699:
700: IF (l_operation = 'C') THEN
701: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;

Line 698: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;

694: EXIT WHEN l_pricing_attribs%NOTFOUND;
695:
696: gpr_pricing_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
697: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
698: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
699:
700: IF (l_operation = 'C') THEN
701: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
702: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

Line 701: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;

697: gpr_pricing_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
698: gpr_pricing_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
699:
700: IF (l_operation = 'C') THEN
701: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
702: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
703:
704: IF (gpr_pricing_attr_tbl(i).excluder_flag IS NULL) THEN
705: gpr_pricing_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;

Line 705: gpr_pricing_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;

701: gpr_pricing_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
702: gpr_pricing_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
703:
704: IF (gpr_pricing_attr_tbl(i).excluder_flag IS NULL) THEN
705: gpr_pricing_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;
706: END IF;
707:
708: IF (gpr_pricing_attr_tbl(i).attribute_grouping_no IS NULL) THEN
709: gpr_pricing_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;

Line 709: gpr_pricing_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;

705: gpr_pricing_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;
706: END IF;
707:
708: IF (gpr_pricing_attr_tbl(i).attribute_grouping_no IS NULL) THEN
709: gpr_pricing_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;
710: END IF;
711:
712:
713: IF (gpr_pricing_attr_tbl(i).product_attribute_datatype IS NULL) THEN

Line 714: --gpr_pricing_attr_tbl(i).product_attribute_datatype := FND_API.G_MISS_CHAR;

710: END IF;
711:
712:
713: IF (gpr_pricing_attr_tbl(i).product_attribute_datatype IS NULL) THEN
714: --gpr_pricing_attr_tbl(i).product_attribute_datatype := FND_API.G_MISS_CHAR;
715: gpr_pricing_attr_tbl(i).product_attribute_datatype := 'C';
716: END IF;
717:
718: IF (gpr_pricing_attr_tbl(i).pricing_attribute_datatype IS NULL) THEN

Line 719: gpr_pricing_attr_tbl(i).pricing_attribute_datatype := FND_API.G_MISS_CHAR;

715: gpr_pricing_attr_tbl(i).product_attribute_datatype := 'C';
716: END IF;
717:
718: IF (gpr_pricing_attr_tbl(i).pricing_attribute_datatype IS NULL) THEN
719: gpr_pricing_attr_tbl(i).pricing_attribute_datatype := FND_API.G_MISS_CHAR;
720: --gpr_pricing_attr_tbl(i).pricing_attribute_datatype := 'C';
721: END IF;
722:
723: -- the first pricing attribute (i.e. ALL, Pricingattribute3), comparison_operator_code should be '='

Line 795: gpr_pricing_mod_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;

791: gpr_pricing_mod_attr_tbl(i).comparison_operator_code,
792: gpr_pricing_mod_attr_tbl(i).modifiers_index;
793: EXIT WHEN l_pricing_mod_attribs%NOTFOUND;
794:
795: gpr_pricing_mod_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
796: gpr_pricing_mod_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
797: gpr_pricing_mod_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
798:
799: IF (l_operation = 'C') THEN

Line 796: gpr_pricing_mod_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;

792: gpr_pricing_mod_attr_tbl(i).modifiers_index;
793: EXIT WHEN l_pricing_mod_attribs%NOTFOUND;
794:
795: gpr_pricing_mod_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
796: gpr_pricing_mod_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
797: gpr_pricing_mod_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
798:
799: IF (l_operation = 'C') THEN
800:

Line 797: gpr_pricing_mod_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;

793: EXIT WHEN l_pricing_mod_attribs%NOTFOUND;
794:
795: gpr_pricing_mod_attr_tbl(i).pricing_attribute := FND_API.G_MISS_CHAR;
796: gpr_pricing_mod_attr_tbl(i).pricing_attr_value_from := FND_API.G_MISS_CHAR;
797: gpr_pricing_mod_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
798:
799: IF (l_operation = 'C') THEN
800:
801: gpr_pricing_mod_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;

Line 801: gpr_pricing_mod_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;

797: gpr_pricing_mod_attr_tbl(i).pricing_attr_value_to := FND_API.G_MISS_CHAR;
798:
799: IF (l_operation = 'C') THEN
800:
801: gpr_pricing_mod_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
802: gpr_pricing_mod_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
803:
804: IF (gpr_pricing_mod_attr_tbl(i).excluder_flag IS NULL) THEN
805: --gpr_pricing_mod_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;

Line 805: --gpr_pricing_mod_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;

801: gpr_pricing_mod_attr_tbl(i).list_line_id := FND_API.G_MISS_NUM;
802: gpr_pricing_mod_attr_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
803:
804: IF (gpr_pricing_mod_attr_tbl(i).excluder_flag IS NULL) THEN
805: --gpr_pricing_mod_attr_tbl(i).excluder_flag := FND_API.G_MISS_CHAR;
806: gpr_pricing_mod_attr_tbl(i).excluder_flag := 'N';
807: END IF;
808:
809: IF (gpr_pricing_mod_attr_tbl(i).attribute_grouping_no IS NULL) THEN

Line 810: gpr_pricing_mod_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;

806: gpr_pricing_mod_attr_tbl(i).excluder_flag := 'N';
807: END IF;
808:
809: IF (gpr_pricing_mod_attr_tbl(i).attribute_grouping_no IS NULL) THEN
810: gpr_pricing_mod_attr_tbl(i).attribute_grouping_no := FND_API.G_MISS_NUM;
811: END IF;
812:
813:
814: IF (gpr_pricing_mod_attr_tbl(i).product_attribute_datatype IS NULL) THEN

Line 815: --gpr_pricing_mod_attr_tbl(i).product_attribute_datatype := FND_API.G_MISS_CHAR;

811: END IF;
812:
813:
814: IF (gpr_pricing_mod_attr_tbl(i).product_attribute_datatype IS NULL) THEN
815: --gpr_pricing_mod_attr_tbl(i).product_attribute_datatype := FND_API.G_MISS_CHAR;
816: gpr_pricing_mod_attr_tbl(i).product_attribute_datatype := 'C';
817: END IF;
818:
819: IF (gpr_pricing_mod_attr_tbl(i).pricing_attribute_datatype IS NULL) THEN

Line 820: --gpr_pricing_mod_attr_tbl(i).pricing_attribute_datatype := FND_API.G_MISS_CHAR;

816: gpr_pricing_mod_attr_tbl(i).product_attribute_datatype := 'C';
817: END IF;
818:
819: IF (gpr_pricing_mod_attr_tbl(i).pricing_attribute_datatype IS NULL) THEN
820: --gpr_pricing_mod_attr_tbl(i).pricing_attribute_datatype := FND_API.G_MISS_CHAR;
821: gpr_pricing_mod_attr_tbl(i).pricing_attribute_datatype := 'C';
822: END IF;
823:
824: -- the first pricing attribute for each modifier line, comparison_operator_code should be null

Line 883: , p_init_msg_list => FND_API.G_FALSE

879: -- process price list
880:
881: QP_PRICE_LIST_PUB.Process_Price_List
882: ( p_api_version_number => 1
883: , p_init_msg_list => FND_API.G_FALSE
884: , p_return_values => FND_API.G_FALSE
885: , p_commit => FND_API.G_FALSE
886: , x_return_status => gpr_return_status
887: , x_msg_count => gpr_msg_count

Line 884: , p_return_values => FND_API.G_FALSE

880:
881: QP_PRICE_LIST_PUB.Process_Price_List
882: ( p_api_version_number => 1
883: , p_init_msg_list => FND_API.G_FALSE
884: , p_return_values => FND_API.G_FALSE
885: , p_commit => FND_API.G_FALSE
886: , x_return_status => gpr_return_status
887: , x_msg_count => gpr_msg_count
888: , x_msg_data => gpr_msg_data

Line 885: , p_commit => FND_API.G_FALSE

881: QP_PRICE_LIST_PUB.Process_Price_List
882: ( p_api_version_number => 1
883: , p_init_msg_list => FND_API.G_FALSE
884: , p_return_values => FND_API.G_FALSE
885: , p_commit => FND_API.G_FALSE
886: , x_return_status => gpr_return_status
887: , x_msg_count => gpr_msg_count
888: , x_msg_data => gpr_msg_data
889: , p_PRICE_LIST_rec => gpr_price_list_rec

Line 911: , p_init_msg_list => FND_API.G_FALSE

907: -- process modifier list
908:
909: QP_MODIFIERS_PUB.Process_Modifiers
910: ( p_api_version_number => 1
911: , p_init_msg_list => FND_API.G_FALSE
912: , p_return_values => FND_API.G_FALSE
913: , p_commit => FND_API.G_FALSE
914: , x_return_status => gpr_return_status
915: , x_msg_count => gpr_msg_count

Line 912: , p_return_values => FND_API.G_FALSE

908:
909: QP_MODIFIERS_PUB.Process_Modifiers
910: ( p_api_version_number => 1
911: , p_init_msg_list => FND_API.G_FALSE
912: , p_return_values => FND_API.G_FALSE
913: , p_commit => FND_API.G_FALSE
914: , x_return_status => gpr_return_status
915: , x_msg_count => gpr_msg_count
916: , x_msg_data => gpr_msg_data

Line 913: , p_commit => FND_API.G_FALSE

909: QP_MODIFIERS_PUB.Process_Modifiers
910: ( p_api_version_number => 1
911: , p_init_msg_list => FND_API.G_FALSE
912: , p_return_values => FND_API.G_FALSE
913: , p_commit => FND_API.G_FALSE
914: , x_return_status => gpr_return_status
915: , x_msg_count => gpr_msg_count
916: , x_msg_data => gpr_msg_data
917: , p_MODIFIER_LIST_rec => gpr_modifier_list_rec

Line 948: IF gpr_return_status = FND_API.G_RET_STS_SUCCESS THEN

944: x_errors := x_errors || substr(gpr_msg_data,1,239) || ' , ';
945: -- dbms_output.put_line('Error msg: '|| x_errors);
946: end loop;
947:
948: IF gpr_return_status = FND_API.G_RET_STS_SUCCESS THEN
949: x_status := 'COMPLETED';
950: l_job_status := 0;
951: l_job_completion_date := SYSDATE;
952:

Line 961: IF gpr_return_status <> FND_API.G_RET_STS_SUCCESS THEN

957: */
958: -- dbms_output.put_line('Successfully completed Pricelist BOI');
959: END IF;
960:
961: IF gpr_return_status <> FND_API.G_RET_STS_SUCCESS THEN
962:
963: x_status := 'FAILED';
964: -- dbms_output.put_line('Error in BOI');
965: -- dbms_output.put_line('X_STATUS : ' || x_status);