615: IF p_layer_provider_code = vea_tpa_util_pvt.g_current_layer_provider_code
616: THEN
617: SELECT NVL( p_id, vea_layer_headers_s.NEXTVAL )
618: INTO l_layer_header_id
619: FROM DUAL;
620: ELSE
621: SELECT vea_layer_headers_s.NEXTVAL
622: INTO l_layer_header_id
623: FROM DUAL;
619: FROM DUAL;
620: ELSE
621: SELECT vea_layer_headers_s.NEXTVAL
622: INTO l_layer_header_id
623: FROM DUAL;
624: END IF;
625: --
626: --
627: l_location := '0130';