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_QUALIFIER_RULES_PVT SQL Statements

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

Line: 55


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

        l_QUALIFIER_RULES_rec.db_flag := FND_API.G_TRUE;

Line: 95


          l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE OR
          l_QUALIFIER_RULES_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

           --oe_debug_pub.add('executing QP_validate.attributes');

Line: 192


        IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

            QP_Validate_Qualifier_Rules.Entity_Delete
            (   x_return_status               => l_return_status
            ,   p_QUALIFIER_RULES_rec         => l_QUALIFIER_RULES_rec
            );

Line: 223


        IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

            QP_Qualifier_Rules_Util.Delete_Row
            (   p_qualifier_rule_id           => l_QUALIFIER_RULES_rec.qualifier_rule_id
            );

Line: 233


            l_QUALIFIER_RULES_rec.last_update_date := SYSDATE;

Line: 234


            l_QUALIFIER_RULES_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 235


            l_QUALIFIER_RULES_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 237


            IF l_QUALIFIER_RULES_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                QP_Qualifier_Rules_Util.Update_Row (l_QUALIFIER_RULES_rec);

Line: 247


               oe_debug_pub.add('calling insert row');

Line: 248


                QP_Qualifier_Rules_Util.Insert_Row (l_QUALIFIER_RULES_rec);

Line: 277


           qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		(p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES,
		 p_entity_id => l_QUALIFIER_RULES_rec.qualifier_rule_id,
		 x_return_status => l_return_status);

Line: 295


           qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		(p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES,
		 p_entity_id => l_QUALIFIER_RULES_rec.qualifier_rule_id,
		 x_return_status => l_return_status);

Line: 320


           qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
		(p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES,
		 p_entity_id => l_QUALIFIER_RULES_rec.qualifier_rule_id,
		 x_return_status => l_return_status);

Line: 415


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


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


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


                l_QUALIFIERS_rec.last_update_date := SYSDATE;

Line: 593


                l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 594


                l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 596


                IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

                    QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);

Line: 607


                    oe_debug_pub.add('calling  insert for qualifiers');

Line: 609


                    QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);

Line: 636


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


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


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


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


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


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


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


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


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


	IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
	   l_QUALIFIERS_rec.qualifier_context = 'ORDER' AND
	   l_QUALIFIERS_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
	THEN
           qual_count := 1;

Line: 896


              select list_header_id into l_list_header_id
              from qp_qualifiers
              where qualifier_id = l_QUALIFIERS_rec.qualifier_id;

Line: 901


              select count(*) into qual_count
              from qp_qualifiers
              where list_header_id = l_list_header_id
	      and qualifier_context = 'ORDER'
	      and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
              and qualifier_id <> l_QUALIFIERS_rec.qualifier_id;

Line: 912


               update qp_list_headers_b
               set active_flag = 'N'
               where list_header_id = l_list_header_id
	       and list_source_code = 'BSO';

Line: 917


	       select name into l_list_name
	       from qp_list_headers_tl
	       where list_header_id = l_list_header_id;

Line: 968


								  ,p_delete        => FND_API.G_TRUE
								  ,x_return_status => l_return_status
										    );

Line: 991


			--qualification_indicator to be updated for qualifiers
			--created when a qualifierrule is copied in pricelist or modifier
			-- FOR QUALIFICATION_IND
				  QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
						  (
								    x_return_status => l_return_status
										    );

Line: 1679


	elsif p_operation = OE_GLOBALS.G_OPR_UPDATE then
			oe_debug_pub.add('in if update : '||p_operation);

Line: 1684


				delete from qp_qualifiers where
				list_header_id = p_old_list_header_id
				and qualifier_context = 'ORDER'
				and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
				and qualifier_attr_value = p_blanket_id;

Line: 1697


			select count(list_header_id) into l_qual_count
			from qp_qualifiers where
			list_header_id = p_list_header_id
			and qualifier_context = 'ORDER'
			and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
			and qualifier_attr_value = p_blanket_id;

Line: 1744


	elsif p_operation = OE_GLOBALS.G_OPR_DELETE then
		oe_debug_pub.add('in if delete : '||p_operation);

Line: 1749


				delete from qp_qualifiers where
				list_header_id = p_old_list_header_id
				and qualifier_context = 'ORDER'
				and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
				and qualifier_attr_value = p_blanket_id;

Line: 1761


			delete from qp_qualifiers where
			list_header_id = p_old_list_header_id
			and qualifier_context = 'ORDER'
			and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
			and qualifier_attr_value = p_blanket_id;