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
    and l_MODIFIER_LIST_rec.global_flag = 'N'
    and nvl(QP_SECURITY.security_on, 'N') = 'N' then
      l_MODIFIER_LIST_rec.global_flag := 'Y';
Line: 131

    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: 176

    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: 260

        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: 293

        IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

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

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

            l_MODIFIER_LIST_rec.last_update_date := SYSDATE;
Line: 309

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

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

            IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

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

                QP_Modifier_List_Util.Update_Row (l_MODIFIER_LIST_rec);
Line: 322

                QP_Modifier_List_Util.Insert_Row (l_MODIFIER_LIST_rec);
Line: 330

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

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

           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: 369

           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: 394

           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: 456

          	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: 494

        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: 530

    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: 606

            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: 686

            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: 694

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

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

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

                l_MODIFIERS_rec.last_update_date := SYSDATE;
Line: 723

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

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

                IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Modifiers_Util.Update_Row (l_MODIFIERS_rec);
Line: 738

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

                                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: 774

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

                    QP_Modifiers_Util.Insert_Row (l_MODIFIERS_rec);
Line: 837

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

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

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

                                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: 886

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

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

               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: 933

               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: 938

               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: 943

               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: 961

               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: 966

               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: 971

               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: 976

               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: 1001

                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: 1006

                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: 1011

                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: 1016

                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: 1121

        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: 1229

            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: 1273

            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: 1283

                l_QUALIFIERS_rec.last_update_date := SYSDATE;
Line: 1284

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

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

                IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
Line: 1296

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

                    QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
Line: 1324

               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: 1329

               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: 1334

               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: 1352

                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: 1357

                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: 1362

                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: 1387

                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: 1392

                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: 1397

                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: 1517

        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: 1556

    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: 1581

            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: 1676

            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: 1717

            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: 1734

                        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: 1740

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

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

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

                l_PRICING_ATTR_rec.last_update_date := SYSDATE;
Line: 1794

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

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

                IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Pricing_Attr_Util.Update_Row (l_PRICING_ATTR_rec);
Line: 1806

                    QP_Pricing_Attr_Util.Insert_Row (l_PRICING_ATTR_rec);
Line: 1814

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

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

                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: 1844

                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: 1849

                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: 1854

                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: 1872

                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: 1877

                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: 1882

                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: 1887

                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: 1912

                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: 1917

                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: 1922

                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: 1927

                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: 2046

NO_UPDATE_PRIVILEGE           EXCEPTION;
Line: 2086

    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: 2096

         RAISE NO_UPDATE_PRIVILEGE;
Line: 2142

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

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

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

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

	  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: 2573

    WHEN NO_UPDATE_PRIVILEGE THEN
        x_return_status := FND_API.G_RET_STS_SUCCESS;