202: -- then raise error saying mapping already defined
203: begin
204: select 1
205: into l_count
206: from pqp_configuration_values
207: where pcv_information_category = p_pcv_information_category
208: and business_group_id = p_business_group_id
209: and (p_configuration_value_id is null
210: or configuration_value_id <> p_configuration_value_id)
568:
569: begin
570: select pcv_information1
571: into l_mapping_lookup
572: from pqp_configuration_values
573: where business_group_id = p_business_group_id
574: and pcv_information_category = l_mapping_info_category
575: and rownum<2 ;
576: exception
651:
652: begin
653: select pcv_information1
654: into l_source
655: from pqp_configuration_values
656: where business_group_id = p_business_group_id
657: and pcv_information_category = l_source_info_category ;
658: exception
659: when no_data_found then
870: -- then raise error saying mapping already defined
871: begin
872: select 1
873: into l_count
874: from pqp_configuration_values
875: where pcv_information_category = p_pcv_information_category
876: and business_group_id = p_business_group_id
877: and (p_configuration_value_id is null
878: or configuration_value_id <> p_configuration_value_id)