523:
524: BEGIN
525: SELECT 1
526: INTO l_record_exists
527: FROM DUAL
528: WHERE EXISTS(SELECT 1
529: FROM mtl_replenish_lines
530: WHERE replenishment_header_id = p_replenish_header_id
531: AND count_quantity IS NULL
539:
540: BEGIN
541: SELECT 1
542: INTO l_error_record_exists
543: FROM DUAL
544: WHERE EXISTS(
545: SELECT 1
546: FROM mtl_replenish_lines mrl
547: WHERE replenishment_header_id = p_replenish_header_id
686: END IF;
687:
688: SELECT 2
689: INTO l_count_valid
690: FROM DUAL
691: WHERE EXISTS(
692: SELECT 1
693: FROM mtl_replenish_lines
694: WHERE replenishment_header_id = p_replenish_header_id