DBA Data[Home] [Help]

APPS.QP_MODIFIERS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

  SELECT from_rltd_modifier_id
  FROM   QP_RLTD_MODIFIERS
  WHERE  to_rltd_modifier_id = p_child_list_line_id;
Line: 24

  SELECT list_line_type_code
  FROM   QP_LIST_LINES
  WHERE list_line_id = p_parent_list_line_id;
Line: 105

    if l_MODIFIER_LIST_rec.operation in (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)
    and l_control_rec.called_from_ui = 'N'
    and l_MODIFIER_LIST_rec.list_source_code IS NOT NULL
    --bug14758481
    --and l_MODIFIER_LIST_rec.global_flag = 'N'
     and (NVL(l_MODIFIER_LIST_rec.global_flag,'N') = 'N'
         OR l_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR)
    and nvl(QP_SECURITY.security_on, 'N') = 'N' then
      l_MODIFIER_LIST_rec.global_flag := 'Y';
Line: 134

    ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
    OR    l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE
    THEN
OE_Debug_Pub.add('update on header');
Line: 179

    OR    l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
    OR    l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

    oe_debug_pub.add('in Private 03');
Line: 263

        IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

            QP_Validate_Modifier_List.Entity_Delete
            (   x_return_status               => l_return_status
            ,   p_MODIFIER_LIST_rec           => l_MODIFIER_LIST_rec
            );
Line: 296

        IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

            FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_MODIFIER');
Line: 303

            QP_Modifier_List_Util.Delete_Row
            (   p_list_header_id              => l_MODIFIER_LIST_rec.list_header_id
            );
Line: 311

            l_MODIFIER_LIST_rec.last_update_date := SYSDATE;
Line: 312

            l_MODIFIER_LIST_rec.last_updated_by := FND_GLOBAL.USER_ID;
Line: 313

            l_MODIFIER_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
Line: 315

            IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

OE_Debug_Pub.add('query'||p_modifier_list_rec.version_no);
Line: 318

                QP_Modifier_List_Util.Update_Row (l_MODIFIER_LIST_rec);
Line: 325

                QP_Modifier_List_Util.Insert_Row (l_MODIFIER_LIST_rec);
Line: 333

   END IF; -- For Operation create, update or delete
Line: 351

        oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
Line: 355

           qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		(p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
		 p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
		 x_return_status => l_return_status );
Line: 372

           qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		(p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
		 p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
		 x_return_status => l_return_status );
Line: 397

           qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		(p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
		 p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
		 x_return_status => l_return_status );
Line: 459

          	p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD,
       	  	p_param1 => l_MODIFIERS_rec.pricing_phase_id,
       	  	p_param2 => l_MODIFIERS_rec.list_header_id,
          	x_return_status => l_return_status);
Line: 497

        ELSIF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
Line: 533

    OR    l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
    OR    l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

        IF  l_control_rec.default_attributes
        OR  l_control_rec.change_attributes
        THEN

            IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

                QP_Validate_Modifiers.Attributes
                (   x_return_status               => l_return_status
                ,   p_MODIFIERS_rec               => l_MODIFIERS_rec
                ,   p_old_MODIFIERS_rec           => l_old_MODIFIERS_rec
                );
Line: 609

            IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Modifiers.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_MODIFIERS_rec               => l_MODIFIERS_rec
                );
Line: 689

            IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

    oe_debug_pub.add('from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
Line: 697

                 FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_MODIFIER_LIST');
Line: 703

    oe_debug_pub.add('just before deleteee');
Line: 704

                QP_Modifiers_Util.Delete_Row
                (   p_list_line_id                => l_MODIFIERS_rec.list_line_id
                );
Line: 725

                l_MODIFIERS_rec.last_update_date := SYSDATE;
Line: 726

                l_MODIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
Line: 727

                l_MODIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
Line: 729

                IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Modifiers_Util.Update_Row (l_MODIFIERS_rec);
Line: 741

                    oe_debug_pub.add('just before update');
Line: 743

                                QP_RLTD_MODIFIER_PVT.Update_Row(
                               l_MODIFIERS_rec.RLTD_MODIFIER_ID
						 , l_MODIFIERS_rec.creation_date
                               , l_MODIFIERS_rec.created_by
                               , l_MODIFIERS_rec.last_update_date
                               , l_MODIFIERS_rec.last_updated_by
                               , l_MODIFIERS_rec.last_update_login
                               , l_MODIFIERS_rec.rltd_modifier_grp_no
                               , l_MODIFIERS_rec.from_rltd_modifier_id
						 , l_MODIFIERS_rec.to_rltd_modifier_id
                               , l_MODIFIERS_rec.rltd_modifier_grp_type
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               );
Line: 777

                 p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
                 x_return_status => l_return_status);
Line: 790

                    QP_Modifiers_Util.Insert_Row (l_MODIFIERS_rec);
Line: 840

                oe_debug_pub.add('before insert');
Line: 848

				select QP_RLTD_MODIFIERS_S.nextval
				into   l_rltd_modifiers_s from dual;
Line: 852

                oe_debug_pub.add('just before insert');
Line: 855

                                QP_RLTD_MODIFIER_PVT.Insert_Row(
                                l_rltd_modifiers_s
						 , l_MODIFIERS_rec.creation_date
                               , l_MODIFIERS_rec.created_by
                               , l_MODIFIERS_rec.last_update_date
                               , l_MODIFIERS_rec.last_updated_by
                               , l_MODIFIERS_rec.last_update_login
                               , l_MODIFIERS_rec.rltd_modifier_grp_no
                               , l_MODIFIERS_rec.from_rltd_modifier_id
						 , l_MODIFIERS_rec.to_rltd_modifier_id
                               , l_MODIFIERS_rec.rltd_modifier_grp_type
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               , null
                               );
Line: 889

                 p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
                 x_return_status => l_return_status);
Line: 910

    END IF; -- For Operation Create, Update or Delete
Line: 931

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_MODIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 936

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
			p_entity_id => l_MODIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 941

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
			p_entity_id => l_MODIFIERS_rec.list_header_id,
			x_return_status => l_return_status );
Line: 946

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
			p_entity_id => l_MODIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 964

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_MODIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 969

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
			p_entity_id => l_MODIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 974

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
			p_entity_id => l_MODIFIERS_rec.list_header_id,
			x_return_status => l_return_status );
Line: 979

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
			p_entity_id => l_MODIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1004

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_MODIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1009

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
			p_entity_id => l_MODIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1014

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
			p_entity_id => l_MODIFIERS_rec.list_header_id,
			x_return_status => l_return_status );
Line: 1019

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
			p_entity_id => l_MODIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1124

        ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
Line: 1232

            IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Qualifiers.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_QUALIFIERS_rec              => l_QUALIFIERS_rec
                );
Line: 1276

            IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Qualifiers_Util.Delete_Row
                (   p_qualifier_id                => l_QUALIFIERS_rec.qualifier_id
                );
Line: 1286

                l_QUALIFIERS_rec.last_update_date := SYSDATE;
Line: 1287

                l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
Line: 1288

                l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
Line: 1290

                IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
Line: 1299

    oe_debug_pub.add('util . Insert');
Line: 1300

                    QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
Line: 1327

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_QUALIFIERS_rec.list_header_id,
			x_return_status => l_return_status );
Line: 1332

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_QUALIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1337

               qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_QUALIFIERS_rec.qualifier_id,
			x_return_status => l_return_status );
Line: 1355

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_QUALIFIERS_rec.list_header_id,
			x_return_status => l_return_status );
Line: 1360

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_QUALIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1365

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_QUALIFIERS_rec.qualifier_id,
			x_return_status => l_return_status );
Line: 1390

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_QUALIFIERS_rec.list_header_id,
			x_return_status => l_return_status );
Line: 1395

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_QUALIFIERS_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1400

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_QUALIFIERS_rec.qualifier_id,
			x_return_status => l_return_status );
Line: 1520

        ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
        OR    l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
        THEN

            l_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;
Line: 1559

    OR    l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
    OR    l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN


   --- added by svdeshmu

          oe_debug_pub.add('calling get_parent from apply attribute');
Line: 1584

            select continuous_price_break_flag
            into   l_continuous_price_break_flag
            from   qp_list_lines
            where  list_line_id = l_parent_list_line_id;
Line: 1679

            IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

                QP_Validate_Pricing_Attr.Entity_Delete
                (   x_return_status               => l_return_status
                ,   p_PRICING_ATTR_rec            => l_PRICING_ATTR_rec
                );
Line: 1720

            IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

     --added by svdeshmu


	    --[5069539] Added the check to skip this block when the call is from
	    --UI. The validation for existing break lines is done in the form
	    --itself. This is required because newly inserted break lines must be
	    --allowed for deletion before saving.
	    IF p_control_rec.called_from_ui = 'N' THEN
		-- bug 3563355 start
                Declare

                        x_rltd_modifier_grp_type varchar2(30);
Line: 1737

                        SELECT null INTO x_rltd_modifier_grp_type
                        FROM qp_rltd_modifiers
                        WHERE to_rltd_modifier_id = l_PRICING_ATTR_rec.list_line_id
                        AND rltd_modifier_grp_type = 'PRICE BREAK'
                        AND ROWNUM = 1;
Line: 1743

                        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_DETAIL_LINES');
Line: 1756

           oe_debug_pub.add('calling get_parent from QPXVMLSB while delete');
Line: 1788

                QP_Pricing_Attr_Util.Delete_Row
                (   p_pricing_attribute_id        => l_PRICING_ATTR_rec.pricing_attribute_id
                );
Line: 1796

                l_PRICING_ATTR_rec.last_update_date := SYSDATE;
Line: 1797

                l_PRICING_ATTR_rec.last_updated_by := FND_GLOBAL.USER_ID;
Line: 1798

                l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
Line: 1800

                IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Pricing_Attr_Util.Update_Row (l_PRICING_ATTR_rec);
Line: 1809

                    QP_Pricing_Attr_Util.Insert_Row (l_PRICING_ATTR_rec);
Line: 1817

    END IF; -- For Operation Create, Update or Delete
Line: 1837

        oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
Line: 1842

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
			p_entity_id => l_PRICING_ATTR_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1847

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
			p_entity_id => l_parent_list_line_id,
			x_return_status => l_return_status );
Line: 1852

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
			p_entity_id => l_PRICING_ATTR_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1857

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_PRICING_ATTR_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1875

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
			p_entity_id => l_PRICING_ATTR_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1880

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
			p_entity_id => l_parent_list_line_id,
			x_return_status => l_return_status );
Line: 1885

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
			p_entity_id => l_PRICING_ATTR_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1890

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_PRICING_ATTR_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1915

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
			p_entity_id => l_PRICING_ATTR_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1920

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
			p_entity_id => l_parent_list_line_id,
			x_return_status => l_return_status );
Line: 1925

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
			p_entity_id => l_PRICING_ATTR_rec.list_line_id,
			x_return_status => l_return_status );
Line: 1930

                qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		    (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
			p_entity_id => l_PRICING_ATTR_rec.list_line_id,
			x_return_status => l_return_status );
Line: 2049

NO_UPDATE_PRIVILEGE           EXCEPTION;
Line: 2089

    IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
       -- Check the security privilege
       IF QP_security.check_function( p_function_name => QP_Security.G_FUNCTION_UPDATE,
                                    p_instance_type => QP_Security.G_MODIFIER_OBJECT,
                                    p_instance_pk1  => p_MODIFIER_LIST_rec.list_header_id) = 'F'
       THEN
         fnd_message.set_name('QP', 'QP_NO_PRIVILEGE');
Line: 2099

         RAISE NO_UPDATE_PRIVILEGE;
Line: 2145

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 2206

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 2261

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 2339

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 2508

	  select 'Y' into l_qual_exists
	  from qp_qualifiers
	  where list_header_id = x_MODIFIER_LIST_rec.list_header_id
	   and qualifier_context = 'ORDER'
	   and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
	   and qualifier_attr_value = x_MODIFIER_LIST_rec.orig_system_header_ref;
Line: 2580

    WHEN NO_UPDATE_PRIVILEGE THEN
        x_return_status := FND_API.G_RET_STS_SUCCESS;